Data Engineer - Informatica IDMC & ETL Development

capco; Toronto; Presencial; CAD 90.000 - 130.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health & life insurance

RRSP matching

Virtual health care

EFAP

Parental leave top-up

New parent gift

Wellness reimbursement

Career coaching

Descripción de la vacante

Capco is seeking an experienced Data Engineer to join our Technology & Engineering practice in Toronto. You will design, develop and optimize data integration solutions for enterprise-scale financial services environments, leveraging Informatica IDMC and robust ETL/ELT workflows.

You will collaborate with data architects and business stakeholders to translate complex requirements into scalable designs, implement testing and monitoring, and ensure data quality across cloud and on-premise

Formación

• 5-6 years of experience in Data Engineering / ETL development / data integration.
• Hands-on experience with Informatica IDMC and data pipeline development.

Responsabilidades

• Design, develop and maintain scalable ETL/ELT data pipelines using Informatica IDMC.
• Build and optimize data transformation workflows and ensure data quality across platforms.
• Develop pipelines to load data from multiple sources into cloud and enterprise environments.
• Collaborate with data architects, analysts and tech teams to translate business requirements into designs.
• Troubleshoot data integration issues and monitor pipeline performance.

Conocimientos

Data engineering

ETL development

Data integration

SQL

Relational databases

Python scripting

DevOps CI/CD

Cloud platforms

Herramientas

Informatica IDMC

Descripción del empleo

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

Why Join Capco

Deliver high-impact technology solutions for Tier 1 financial institutions.

Work in a collaborative, flat, and entrepreneurial consulting culture.

Access continuous learning, training, and industry certifications.

Be part of a team shaping the future of digital financial services.

Help shape the future of digital transformation across FS & Energy.

Benefits

• Comprehensive Benefits Coverage: 100% company-paid health, life, and disability insurance effective from Day 1 of employment.
• Retirement Savings Program: 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.
• Wellness Support: Fitness reimbursement benefit to promote health and well-being.
• Business Coach from Day 1: Personalized one-on-one coaching to support career growth, accelerate development, and help achieve your professional goals at Capco.

Inclusion at Capco

We're committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know - we'll be happy to help. We value each person's unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration - a mindset that shapes how we work with clients and each other every day.

Use of Artificial Intelligence in Talent Acquisition

At Capco, we use artific