Back to jobs

Data Engineer – Informatica IDMC & ETL Development

Pay
CAD 118,000–152,000/yearAnnual period assumed — pay source
Canada Pay Transparency $118,000—$152,000 CAD
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design, develop and maintain ETL/ELT processes and pipelines in Informatica IDMC

  • Build and optimize data transformation workflows for quality and reliability

  • Extract, transform and load data from multiple sources into cloud and enterprise environments

  • Translate business requirements into technical designs with architects and analysts

  • Troubleshoot integration issues and add testing, monitoring and data validation

From the employer’s posting
Design, develop and maintain scalable ETL/ELT processes and data pipelines using Informatica IDMC
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
Troubleshoot data integration issues, optimize pipeline performance and implement testing, monitoring and data validation processes

Benefits in the posting

Full benefits wording
  • 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.
  • Parental Leave Top-Up: Enhanced parental leave benefits available from Day 1 of employment.
  • Wellness Support: Fitness reimbursement benefit to promote health and well-being.
  • Inclusion at Capco
  • Use of Artificial Intelligence in Talent Acquisition
  • AI is used as a support tool only. All hiring decisions are made by talent acquisition and hiring teams.
  • Why This Role Is Open
  • We are currently hiring for this role due to an existing or newly created vacancy within our organization. This position is open as part of our ongoing business needs, and we are actively reviewing applications to fill this role with a qualified candidate who can make an immediate impact.
  • Pay Transparency
  • The salary range for this position is listed below. Additionally, this position may also be eligible to receive an annual discretionary/variable bonus payment.
  • Capco is committed to providing fair and equitable compensation to our people. Our compensation policies and salary ranges are designed to allow our people to progress through the salary range as they demonstrate strong performance and develop in their role over time. The base pay offered to selected candidates will be within the salary range and the placement will vary based upon a variety of factors, including, but not limited to job-related knowledge, skills, experience and internal equity.
  • Canada Pay Transparency

From the employer’s posting.

Apply at Capco

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 19, 202630 days ago
Recorded sightings
137
Last seen by us
Nov 18, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 30

Similar jobs usually come down between day 6 and day 56.

At Capco, jobs usually come down by about day 40.

From 14,186 similar postings that came down, and 233 of Capco’s. Coming down is not always a hire.

Capco is hiring

105 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring is steady
  • Takes jobs down at a usual pace
  • 2% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • AWS
  • Azure
  • Informatica
  • GCP
Where the posting names them
- 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.
- 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.
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.
- 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.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Job description

View original posting ↗

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

We offer a competitive, people-first benefits package designed to support every aspect of your life:

  • 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 artificial intelligence (AI) tools to support and enhance several parts of talent acquisition. This includes using AI-enabled features within LinkedIn to help source potential candidates, speeding up routine recruitment communications such as emails and creating compelling and brand-aligned job postings that accurately reflect role requirements, and AI-scheduling applications to improve the efficiency of interview coordination.

AI is used as a support tool only. All hiring decisions are made by talent acquisition and hiring teams.

Why This Role Is Open

We are currently hiring for this role due to an existing or newly created vacancy within our organization. This position is open as part of our ongoing business needs, and we are actively reviewing applications to fill this role with a qualified candidate who can make an immediate impact.

 

Pay Transparency

The salary range for this position is listed below. Additionally, this position may also be eligible to receive an annual discretionary/variable bonus payment.

 

Capco is committed to providing fair and equitable compensation to our people. Our compensation policies and salary ranges are designed to allow our people to progress through the salary range as they demonstrate strong performance and develop in their role over time. The base pay offered to selected candidates will be within the salary range and the placement will vary based upon a variety of factors, including, but not limited to job-related knowledge, skills, experience and internal equity.                                                                                                   

Canada Pay Transparency
$118,000—$152,000 CAD

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Canada Pay Transparency $118,000—$152,000 CAD
Location & working pattern

Canada - Toronto

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.