Senior DataStage Developer

Capco; Toronto; On-site; CAD 118,000 - 152,000; Full time

Benefits offered by this job

Health insurance

RRSP with matching employer

Virtual Health Care

EFAP

Job summary

Capco in Canada is seeking a Senior IBM InfoSphere DataStage Developer to lead a major credit card platform migration from Hogan to Fiserv Optis. You will design, build and optimise enterprise ETL solutions for a high-stakes financial services program.

You will collaborate with QA, business and technology teams, automate deployments, tune performance and mentor engineers while upholding best practices in data governance.

Qualifications

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

Responsibilities

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

Skills

ETL development

SQL scripting

Performance tuning

Agile collaboration

Automation deployments

Tools

IBM InfoSphere DataStage

Hogan

Fiserv Optis

Job description

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.

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

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.

$118,000 - $152,000 CAD