Data Engineer – Informatica IDMC & ETL Development

About the role

Capco is hiring an experienced Data Engineer for its Technology & Engineering practice in Toronto. You will work with leading financial services clients to design, develop and optimize data integration solutions that deliver reliable, scalable and efficient data processing. The role sits within a consulting team working alongside data architects, engineers and business stakeholders.

Key responsibilities

• Design, develop and maintain scalable ETL/ELT processes and data pipelines using Informatica IDMC.
• Build and optimize data transformation workflows with consistent data quality across platforms.
• Develop pipelines that extract, transform and load data from multiple sources into cloud-based and enterprise environments.
• Translate business requirements into technical designs with data architects, business analysts and technology teams.
• Troubleshoot integration issues, optimize pipeline performance and set up testing, monitoring and data validation.

Required profile

• 5-6 years of experience in data engineering, ETL development or data integration, with enterprise data solutions delivered.
• Hands-on Informatica IDMC experience building, configuring and maintaining integration workflows and pipelines.
• Experience working with cross-functional teams on scalable data engineering solutions.

Required skills

• ETL/ELT concepts, data mapping and end-to-end pipeline development.
• SQL, relational databases and query optimization.
• Bonus: DevOps (CI/CD, version control, automated testing), cloud platforms (AWS, Azure, Google Cloud), Python or scripting, and data governance, quality and lineage.

What we offer

• Salary range of $118,000-$152,000 CAD, with possible annual discretionary bonus.
• Company-paid health, life and disability insurance from Day 1.
• Registered RRSP with possible employer match, virtual health care and EFAP.
• Enhanced parental leave, wellness fitness reimbursement and a business coach from Day 1.