Informatica Intelligent Cloud Services Developer, Remote, , US

Intellibee Inc; 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

Required Skills: Informatica Intelligent Cloud Services

Preferred Skills: Snowflake

Responsibilities:

• Implement and maintain the approved Medallion Architecture, including Bronze, Silver, and Gold data layers. Design and develop Snowflake databases, schemas, tables, views, data models, and curated data products. Use Informatica Intelligent Cloud Services (IICS) to build and operate data-integration workflows for ingestion, transformation, orchestration, scheduling, monitoring, and error handling.
• Use IICS data-quality capabilities to profile data, define quality rules and thresholds, validate results, and document exceptions and remediation.
• Maintain business glossary terms, metadata, classifications, data domains, lineage, ownership, and stewardship assignments using approved governance and catalog tools or processes.
• Configure and support metadata harvesting, catalog scanning, lineage capture, and metadata-completeness monitoring using approved tools and connectors.
• Develop source-to-target mappings, transformation specifications, data dictionaries, technical designs, and operational procedures.
• Apply data-quality controls for completeness, validity, consistency, uniqueness, timeliness, referential integrity, and reconciliation, as applicable.
• Support integration with SFTP, Azure Blob Storage, Snowflake, and other approved Agency platforms.
• Execute unit, integration, regression, data-quality, reconciliation, and end-to-end validation testing.
• Document technical and operational metadata to support future enterprise data catalog and governance implementations.
• 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. Provide end-user training, demonstrations, knowledge transfer, and support to HHSC staff and data owners.
• Comply with HHSC security, privacy, accessibility, documentation, change-control, and operational requirements.

Expected Deliverable(s): ETL Code, Test results , release document

Benefits at IntelliBee

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.