IICS Data Integration Engineer - Snowflake & ETL

Intellibee; United States; Remoto; USD 120.000 - 180.000; Tempo pieno

Vantaggi offerti da questo lavoro

Long-Term Stability

Health Coverage

401(k) Plan

Green Card assistance

Descrizione del lavoro

Intellibee is seeking a data integration and governance specialist to implement and maintain the Medallion Architecture using Snowflake and Informatica Intelligent Cloud Services. You will design Snowflake databases, develop data pipelines, and operate data ingestion, transformation, scheduling, and monitoring with IICS.

You will ensure data quality, maintain business glossary terms, metadata lineage, and supporting governance processes, while collaborating in sprint planning and deployment

Mansioni

• Implement and maintain the Medallion Architecture (Bronze/Silver/Gold) and design Snowflake databases, schemas, tables, views, and data models.
• Use IICS to build and operate data ingestion, transformation, orchestration, scheduling, monitoring and error handling.
• Leverage IICS data-quality capabilities to profile data, define quality rules, validate results, and document remediation.
• Maintain business glossary terms, metadata, classifications, data domains, lineage, ownership, and stewardship.
• Configure and support metadata harvesting, catalog scanning, lineage capture, and metadata completeness monitoring.
• Develop source-to-target mappings, transformations, data dictionaries, and technical designs.
• Apply data-quality controls for completeness, validity, consistency, uniqueness, timeliness, referential integrity, and reconciliation.
• Support integration with SFTP, Azure Blob Storage, Snowflake, and other Agency platforms.
• Execute unit, integration, regression, data-quality, reconciliation, and end-to-end validation testing.
• Document technical and operational metadata to support enterprise data catalog and governance.
• Participate in sprint planning, backlog refinement, daily coordination, sprint reviews, retrospectives, and quality-gate activities.
• Support production deployment, cutover, hypercare, troubleshooting, and transition to operations with end-user training and knowledge transfer to HHSC staff.

Conoscenze

Informatica Intelligent Cloud Services

Strumenti

Snowflake

Descrizione del lavoro

Intellibee is seeking a data integration and governance specialist to implement and maintain the Medallion Architecture using Snowflake and Informatica Intelligent Cloud Services. You will design Snowflake databases, develop data pipelines, and operate data ingestion, transformation, scheduling, and monitoring with IICS.

You will ensure data quality, maintain business glossary terms, metadata lineage, and supporting governance processes, while collaborating in sprint planning and deployment