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.
Skills Required
- 5–6 years of experience in data engineering, ETL development, or data integration
- Hands-on experience with Informatica Intelligent Data Management Cloud (IDMC)
- Understanding of ETL/ELT concepts, data transformation, data mapping, and end-to-end pipeline development
- Proficiency in SQL, relational databases, and data processing techniques
- Experience optimizing queries and managing complex data transformations
- Experience collaborating with cross-functional teams to design, implement, test, and support data engineering solutions
- Experience with DevOps practices, CI/CD, version control, automated testing, and deployment
- Familiarity with AWS, Azure, or Google Cloud and related data services
- Experience with Python, scripting, or automation
- Understanding of data governance, data quality, and data lineage principles
- Experience delivering data integration solutions in banking, capital markets, or financial services
What the Team is Saying
Capco Compensation & Benefits Highlights
-
Healthcare Strength — Health coverage is considered strong, with medical, dental, and vision commonly provided alongside mental-health resources and wellbeing programs. Multiple plan options and generally good coverage quality are highlighted.
-
Leave & Time Off Breadth — Vacation/PTO is a standout, with generous allotments and, in some cases, unlimited sick leave, plus programs intended to help employees recharge. Flexible work arrangements are also emphasized, supporting work-life balance.
-
Retirement Support — Retirement offerings include a 401(k) with company matching in the U.S., alongside life and disability insurance in many regions. These elements round out a solid financial benefits package.
Capco Insights
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent. TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients. DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success. DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions. ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
