Remote IICS Developer: Data Integration & Governance

Apexon; Austin (TX); Remoto; USD 120.000 - 170.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health Insurance, Dental & Vision

401K Plan

Life Insurance, STD & LTD

Paid Vacations & Holidays

Career Development

Descrizione del lavoro

Apexon is hiring Informatica Intelligent Cloud Services Developers to support HHSC with data integration, quality, and governance initiatives. Remote work is available; strong IICS, Snowflake, and data modeling skills are preferred.

You will implement Medallion Architecture and collaborate across teams to ensure data integrity and usable data products. The role emphasizes ETL development, metadata management, and end-to-end data pipeline delivery in a regulated environment.

Competenze

• Hands on experience with Informatica Intelligent Cloud Services (IICS).
• Experience building and maintaining data integration workflows for ingestion, transformation, orchestration, scheduling, monitoring, and error handling.
• Knowledge of data quality profiling, validation, rules, thresholds, and exception handling.
• Experience creating source-to-target mappings, data dictionaries, and technical designs.
• Understanding of data quality controls including completeness, validity, consistency, and timeliness.
• Experience with ETL development, testing, deployment, and production support.
• Ability to document technical and operational metadata.

Mansioni

• Implement and maintain the Medallion Architecture: Bronze, Silver, Gold data layers.
• Design and develop Snowflake databases, schemas, tables, views, and data models.
• Build and operate IICS data integration workflows for ingestion, transformation, orchestration, scheduling, monitoring, and error handling.
• Use IICS data quality features to profile data, define quality rules, validate results, and document exceptions.
• Maintain business glossary, metadata, lineage, and data ownership using governance tools.
• Configure metadata harvesting, catalog scanning, and lineage capture with approved tools.
• Develop source-to-target mappings, transformation specs, data dictionaries, and operational procedures.
• Apply data quality controls for completeness, validity, consistency, and timeliness.
• Support integration with SFTP, Azure Blob Storage, Snowflake, and other agency platforms.
• Execute unit, integration, regression, data quality, reconciliation, and end-to-end validation tests.
• Provide end-user training and knowledge transfer to HHSC staff and data owners.

Conoscenze

IICS

ETL development

Data quality

Snowflake

Medallion Architecture

Data governance

Metadata management

Formazione

Bachelor's degree in CS/IT/Engineering

Information Systems background

Strumenti

Azure Blob Storage

SFTP

Data catalogs

Descrizione del lavoro

Apexon is hiring Informatica Intelligent Cloud Services Developers to support HHSC with data integration, quality, and governance initiatives. Remote work is available; strong IICS, Snowflake, and data modeling skills are preferred.

You will implement Medallion Architecture and collaborate across teams to ensure data integrity and usable data products. The role emphasizes ETL development, metadata management, and end-to-end data pipeline delivery in a regulated environment.