Job Description
Role Summary
We are looking for a Senior Data Engineer to lead the migration and development of mission‑critical data pipelines from legacy systems to Informatica Cloud Data Integration (CDI). The primary focus is building high‑performance ETL patterns in a cloud‑native setting while reverse‑engineering existing Ab Initio logic. You will play a key role in ensuring data integrity during the transition of high‑volume financial data assets.
Core Responsibilities
- CDI Development: Design, develop, and unit test complex mappings, task flows, and transformations within Informatica IDMC/CDI.
- Legacy Migration: Analyze existing Ab Initio graphs (GDE/EME) to understand business logic, data transformations, and dependencies for migration to CDI.
- Optimization: Implement Pushdown Optimization (PDO) in Informatica to leverage cloud warehouse processing power (Snowflake, Databricks, or AWS Redshift).
- Data Validation: Build robust reconcil...