Senior Data Engineer (Informatica CDI&Legacy Migration), Toronto

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.

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

Requirements Technical Skills Required

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 BigQuery, 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.

Preferred Qualifications

Migration Experience:

Proven track record of successfully migrating ETL workloads from on‑premise (Ab Initio, DataStage, or PowerCenter) to Informatica Cloud.

Financial Domain:

Understanding of regulatory reporting (GDPR, BCBS 239) or Capital Markets data flow.

DevOps:

Experience with version control (Git/Bitbucket) and automated deployment (CI/CD) for Informatica assets.

#J-18808-Ljbffr