Drive enterprise-scale data transformation by delivering high-performance ETL solutions for a major financial services platform migration.
The Role
We are seeking an experienced Senior IBM InfoSphere DataStage Developer to join a large-scale credit card platform migration programme from a legacy Hogan environment to Fiserv's Optis platform. This is an excellent opportunity for a senior ETL specialist with deep IBM InfoSphere DataStage expertise to design, build and optimise enterprise-grade data integration solutions within a complex financial services environment.
This opportunity is open to both permanent employees and experienced contractors. You'll work as part of a collaborative delivery team, partnering with business stakeholders, QA and technology teams to deliver robust, scalable and high-performing data integration solutions. The role is based in Toronto (Hybrid).
What You'll Do
- Design, develop and optimise IBM InfoSphere DataStage ETL/ELT jobs, reusable frameworks and SQL scripts to support enterprise data migration.
- Deliver scalable, high-performance data integration solutions that ensure data accuracy, integrity and operational excellence.
- Automate deployments, improve monitoring capabilities and troubleshoot ETL pipeline issues across complex enterprise environments.
- Collaborate with QA, business and technology teams to validate data, resolve defects and support successful programme delivery.
- Contribute to technical best practices, solution design and continuous improvement across the data engineering function.
What We're Looking For
- Minimum 5+ years' experience developing enterprise ETL solutions using IBM InfoSphere DataStage (mandatory).
- Strong expertise in ETL/ELT development, SQL scripting, performance tuning and enterprise data integration.
- Experience delivering complex data migration programmes within financial services, banking or insurance environments.
- Proven ability to automate deployments, troubleshoot production issues and collaborate effectively within Agile delivery teams.
- IBM Certified DataStage Developer certification or equivalent enterprise experience.
Bonus Points For
- Experience with Hogan and/or Fiserv Optis platforms.
- Knowledge of credit card, payments or core banking data models.
- French language proficiency (written and spoken) is considered an asset.
- Experience supporting large-scale platform or application migrations.
- Exposure to enterprise data warehousing and modern data engineering practices.
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 Financial Services.
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 and Employee & Family Assistance Program (EFAP) available to employees and their dependants.
- Enhanced parental leave benefits, wellness reimbursement and new parent gift.
- Business Coach from Day 1 to support your career growth and professional development.
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
- Minimum 5+ years experience developing enterprise ETL solutions using IBM InfoSphere DataStage
- Strong expertise in ETL/ELT development, SQL scripting, performance tuning and enterprise data integration
- Experience delivering complex data migration programmes within financial services, banking or insurance
- Proven ability to automate deployments, troubleshoot production issues and collaborate within Agile delivery teams
- IBM Certified DataStage Developer certification or equivalent enterprise experience
- Experience with Hogan and/or Fiserv Optis platforms
- Knowledge of credit card, payments or core banking data models
- French language proficiency (written and spoken)
- Experience supporting large-scale platform or application migrations
- Exposure to enterprise data warehousing and modern data engineering practices
What the Team is Saying
Capco Compensation & Benefits Highlights
-
Healthcare Strength — Health, dental, and vision coverage are described as solid with low copays and a good variety of choices, complemented by mental‑health resources, an EAP, and wellbeing events. Company materials emphasize global availability of these supports.
-
Parental & Family Support — Enhanced maternity, paternity, adoption, and shared parental leave are highlighted, with several months of maternity leave noted in the U.S. in some accounts. Additional paid leave is called out for life events such as pregnancy loss, fertility treatment, menopause, and bereavement.
-
Wellbeing & Lifestyle Benefits — A global wellbeing program, coaching/mentoring, mental‑health initiatives, and wellness reimbursements (e.g., gym, fitness) are positioned as core parts of the offering. Flexible working is emphasized alongside regionally tailored wellbeing events.
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.
