Data Engineer – Informatica IDMC & ETL Development
Data Engineer in Capco's Toronto Technology & Engineering consulting practice, designing and maintaining ETL/ELT pipelines and data integration solutions for Tier 1 financial services clients. Core stack is Informatica IDMC plus SQL and relational databases, with Python, cloud (AWS/Azure/GCP), and DevOps as pluses.
- Compensation
- CA$118K–CA$152K / yr
- Location
- Canada - Toronto
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 5–6 years of experience in Data Engineering, ETL development or data integration, with enterprise data solutions delivered
- 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 pipeline development
- Proficiency in SQL, relational databases and data processing, including query optimization and complex data transformations
- Experience working with cross-functional teams to design, implement, test and support scalable data engineering solutions
Nice to have
- DevOps practices: CI/CD pipelines, version control, automated testing and deployment processes
- Familiarity with cloud platforms such as AWS, Azure or Google Cloud and their data services
- Experience with Python, scripting or automation for data engineering and pipeline orchestration
- Understanding of Data Governance, Data Quality and Data Lineage principles
- Experience delivering data integration solutions in banking, capital markets or other financial services environments
Full description
Build the data pipelines and integration solutions powering the future of financial services.
The Role
At Capco, we’re looking for an experienced Data Engineer to join our Technology & Engineering practice in Toronto. You’ll work with leading financial services clients to design, develop and optimize data integration solutions that enable reliable, scalable and efficient data processing.
With hands-on expertise in Informatica Intelligent Data Management Cloud (IDMC), ETL development and data pipeline engineering, you’ll help organizations modernize their data environments and improve how data is integrated, transformed and delivered across enterprise platforms.
As part of a collaborative consulting team, you’ll work closely with data architects, engineers and business stakeholders to translate complex data requirements into practical engineering solutions that support business objectives.
What You’ll Do
- 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.
What We’re Looking For
- 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.
Bonus Points For
- Experience with DevOps practices, including CI/CD pipelines, version control, automated testing and deployment processes.