Informatica Intelligent Cloud Services Developer

Apexon; Pennsylvania; Remoto; USD 120.000 - 150.000; Tempo pieno

Descrizione del lavoro

Apexon is seeking a data engineer in a remote-capable role based in the United States, focusing on Snowflake-based architectures. You will implement the Medallion architecture, build data models, and ensure high-quality data pipelines across ingestion, transformation, and governance layers.

You will work with IICS to orchestrate workflows, maintain metadata, and validate data through end-to-end testing, contributing to scalable, trusted data products for enterprise use.

Mansioni

• 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 IICS to build data integration workflows for ingestion, transformation, orchestration, scheduling, monitoring, and error handling; profile data quality and document remediation.
• Maintain metadata: glossary terms, classifications, data domains, lineage, ownership, and stewardship using governance tools.
• Develop source-to-target mappings, transformation specifications, data dictionaries, and operational procedures; ensure data quality and referential integrity.
• Document technical and operational metadata to support future data catalog and governance implementations.

Descrizione del lavoro

Location_ Remote

Duration: Full-time with Apexon

Required Skills :

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.