Data Engineer – Informatica IDMC & ETL Development

Canada - Toronto · CAD 118,000-152,000 · 5-6 years experience · Posted Oct 19, 2026

At a glance

Capco is looking for an experienced Data Engineer to join the Technology & Engineering practice in Toronto.
You will work with leading financial services clients to design, develop, and optimize data integration solutions.
You will use hands-on expertise in Informatica Intelligent Data Management Cloud (IDMC) and ETL development to modernize data environments.

Design, develop and maintain scalable ETL/ELT processes and data pipelines using Informatica IDMC to support enterprise data integration requirements.
Build and optimize data transformation workflows, ensuring efficient data processing, reliable integration and consistent data quality across platforms.
Develop and enhance data pipelines that extract, transform and load data from multiple sources into cloud-based and enterprise data environments.
Collaborate with data architects, business analysts and technology teams to translate business requirements into effective technical designs and engineering solutions.
Troubleshoot data integration issues, optimize pipeline performance and implement testing, monitoring and data validation processes to support reliable delivery.

Relevant experience in Data Engineering, ETL development or data integration, typically gained over 5–6 years, with demonstrated experience delivering enterprise data solutions.
Hands-on expertise with Informatica IDMC, including developing, configuring and maintaining data integration workflows and pipelines.
Comprehensive understanding of ETL/ELT concepts, data transformation techniques, data mapping and end-to-end data pipeline development.
Proficiency in SQL, relational databases and data processing techniques, with experience optimizing queries and managing complex data transformations.
Experience working with cross-functional teams to design, implement, test and support reliable, scalable data engineering solutions.

Experience with DevOps practices, including CI/CD pipelines, version control, automated testing and deployment processes.
Familiarity with cloud platforms such as AWS, Azure or Google Cloud and their associated data services.
Experience with Python, scripting or automation to support data engineering and pipeline orchestration.
Understanding of Data Governance, Data Quality and Data Lineage principles within enterprise data environments.
Experience delivering data integration solutions within banking, capital markets or other financial services environments.

100% company-paid health, life, and disability insurance effective from Day 1 of employment
Registered Retirement Savings Plan (RRSP) with the option of receiving a matching employer contribution
Virtual Health Care company-paid program available to all employees and their dependents/partners
Employee & Family Assistance Program (EFAP) company-paid support services for employees and their dependents/partners
Parental Leave Top-Up enhanced parental leave benefits available from Day 1 of employment
New Parent Gift a company-sponsored gift to celebrate the arrival of a new child
Fitness reimbursement benefit to promote health and well-being
Personalized one-on-one coaching with a Business Coach from Day 1