Senior Data Engineer; Informatica CDI & Legacy Migration

Senior Data Engineer (Informatica CDI & Legacy Migration)

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 environment 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.

• 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 reconciliation frameworks to ensure data parity between the legacy Ab Initio outputs and the new CDI pipelines.
• API Integration: Develop and maintain connectors using Cloud Integration Hub (CIH) and REST/SOAP transformations.
• Financial Compliance: Ensure all data movement adheres to banking security standards, including encryption at rest/transit and PII masking.

• Primary Expertise: 6+ years in ETL/Data Integration, with at least 3+ years of deep hands‑on experience in Informatica CDI (Cloud).
• Legacy Knowledge: Functional understanding of Ab Initio (ability to navigate GDE, understand components like Reformat, Join, and Rollup, and read DML).
• Cloud Platforms: Strong experience with cloud data warehouses (e.g.,
  Snowflake, Google Big Query, or Azure Synapse
  ).
• Advanced SQL: Ability to write and tune complex analytical queries.
• Scripting: Proficiency in Unix/Linux shell scripting to manage file‑based triggers and automation.

• Migration
  
  Experience:
  
  Proven track record of successfully migrating ETL workloads from on‑premise (Ab Initio, Data Stage, or Power Center) to Informatica Cloud.
• Financial Domain: Understanding of regulatory reporting (GDPR, BCBS 239) or Capital Markets data flow.
• Dev Ops: Experience with version control (Git/Bitbucket) and automated deployment (CI/CD) for Informatica assets.