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.

We are looking for an experienced QA Tester with strong ETL testing expertise to support the testing of a DataStage-based data integration application. The ideal candidate will bring extensive hands‑on experience in data validation, ETL testing, Oracle databases, and end‑to‑end testing practices, along with excellent stakeholder communication skills. This role involves close collaboration with development teams, business stakeholders, and leadership to ensure high‑quality data delivery.

Your future duties and responsibilities

ETL & Application Testing

• Perform ETL testing on IBM DataStage (or equivalent ETL tools) to validate data extraction, transformation, and loading processes.
• Validate data accuracy, completeness, and consistency between source systems, staging layers, and target databases.
• Execute end to end data testing, including smoke, system, integration, and regression testing.
• Perform data reconciliation and transformation logic validation using SQL queries.

Test Planning & Execution

• Create and maintain test plans, test scenarios, and detailed test cases based on business and technical requirements.
• Plan and manage test execution cycles, including functional, regression, and data validation testing.
• Maintain and execute regression test suites to ensure existing functionality remains unaffected by changes.
• Ensure defects are logged clearly with sufficient evidence and reproducible steps.

Database & SQL Validation

• Perform testing and validation using Oracle databases.
• Write and execute complex SQL queries to validate ETL logic, data integrity, and business rules.
• Analyze data issues and work with development teams to identify root causes.

Defect Management & Reporting

• Manage the defect lifecycle, including logging, tracking, retesting, and closure.
• Facilitate and drive defect triage meetings with development, business, and leadership stakeholders.
• Publish daily and weekly status reports, highlighting testing progress, risks, and blockers.

Stakeholder Collaboration

• Work closely with development teams, business analysts, product owners, and leadership to clarify requirements and expectations.
• Provide clear testing feedback and quality insights to support release decisions.
• Participate in project meetings and provide testing updates and risk assessments.

Required qualifications to be successful in this role

• 5–7 years of hands on application testing experience
• 5–7 years of ETL testing experience, specifically with:
• IBM DataStage or other ETL tools (Informatica, Ab Initio, SSIS, etc.)

Technical Skills

• Strong experience with Oracle databases
• Advanced SQL skills for data validation and analysis
• Proven expertise in ETL / data warehouse testing concepts
• Experience testing complex data transformations and large datasets

QA & Testing Skills

• Hands on experience creating and executing:
• Test plans
• Test cases
• Test scenarios
• Strong experience managing and maintaining regression test suites
• Thorough understanding of defect management processes

Tools & Methodologies

• Familiarity with test management and defect tracking tools (e.g., Jira or equivalent)
• Experience working in Agile or hybrid delivery environments

Soft Skills

• Strong communication and stakeholder management skills
• Ability to interact effectively with development, business, and leadership teams
• Strong analytical, problem solving, and attention to detail skills
• Ability to work independently and in a fast paced, deadline driven environment

Nice to Have

• Experience in banking or financial services environments

• Exposure to data governance or reporting validation

• Experience testing large enterprise data platforms

"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 $55,000–$105,000. This role is an existing vacancy."

#LI-GS!

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll 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.

You’ll shape your career by joining a company built to grow and last. You’ll 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 team—one of the largest IT and business consulting services firms in the world.