DataStage Developer

Position Description:

This role is hybrid and requires you to be at our downtown Toronto and/or client office at a minimum 2 days per week - subject to change at any time.

The successful candidate will be responsible for the design development enhancement and support of complex data integration solutions with a strong focus on interest rate data Expected Credit Loss (ECL) processing and IFRS 9 metrics. The role requires close collaboration with risk finance and technology teams to ensure data accuracy regulatory compliance and operational stability.

Your future duties and responsibilities:

Application Development & Data Integration
Design develop and enhance booking system loaders to ingest transform and validate interest raterelated data points
Modify and extend existing ECL back-feed processes to support new IFRS 9 LGD (Loss Given Default) and EAD (Exposure at Default) measures
Build new end-to-end ETL processes to load corporate and commercial customer address data from certified and approved data sources
Ensure data lineage consistency and reconciliation across upstream and downstream systems
DataStage & ETL Development
Develop and maintain IBM DataStage jobs sequences and parameter sets in complex high-volume environments
Optimize ETL performance error handling and restartability
Implement robust data validation exception handling and audit controls
Support environment migrations and deployment across development test and production environments
Production Support & Problem Resolution
Provide application and data support for production issues including root cause analysis and permanent fixes
Monitor batch processing investigate data anomalies and resolve job failures within defined SLAs
Participate in incident problem and change management processes
Document solutions operational procedures and known issues
Regulatory & Risk Support
Support regulatory reporting and risk analytics initiatives related to IFRS 9 and ECL
Ensure data solutions comply with internal governance standards and external regulatory requirements
Work closely with Risk Finance and Compliance teams to interpret requirements and translate them into technical solutions
Collaboration & Delivery
Collaborate with business analysts data modelers QA teams and infrastructure partners
Participate in design reviews code reviews and deployment activities
Contribute to continuous improvement initiatives including standardization and automation
Communicate clearly with both technical and non-technical stakeholders

Required qualifications to be successful in this role:

57 years of experience in application development and production support
57 years of hands-on experience with IBM DataStage in enterprise-scale environments
Proven experience working with ETL data warehousing and batch processing systems
Experience supporting mission-critical financial applications
Technical Skills
Strong expertise in IBM DataStage
Good working knowledge of SQL and relational databases
Experience with data reconciliation controls and audit frameworks
Familiarity with scheduling tools and batch processing concepts
Analytical & Problem-Solving Skills
Strong analytical skills with the ability to troubleshoot complex data and application issues
Ability to perform root cause analysis and recommend long-term solutions
Attention to detail and a strong focus on data quality and accuracy
Soft Skills
Strong communication and stakeholder engagement skills
Ability to work independently and as part of a cross-functional team
Comfortable working in a hybrid client-facing environment
Able to adapt quickly to changing priorities and requirements

Preferred / Nice-to-Have Qualifications
Experience in banking or financial services
Exposure to IFRS 9 ECL LGD EAD or credit risk frameworks
Experience working with regulatory reporting or risk platforms
Knowledge of data governance and metadata management practices

CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level geographic market experience and training and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $80000$130000. This role is an existing vacancy.

#LI-GS!

Skills:

• DataStage
• Financial Services
• Linux
• Oracle
• Software Architecture

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer being able to perform your best during the recruitment process is important to us. If you require an accommodation please inform your recruiter.

To learn more about accessibility at CGI contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our teamone of the largest IT and business consulting services firms in the world.