This role is hybrid and requires you to be at our downtown Toronto (250 Yonge St, Toronto) and/or Client office at a minimum 3 days per week - subject to change at any time.
We are seeking an experienced ETL Tester to join our QE team. The ideal candidate will have a strong background in data validation, backend testing, and data warehousing concepts, with the ability to work across diverse data sources and systems. This role requires a detail-oriented professional who can design and execute effective test strategies in a fast-paced, collaborative environment.
Your future duties and responsibilities
- Perform ETL testing across various data sources including databases, text files, XML files, etc.
- Analyze testing scope and develop accurate work estimates.
- Design test approaches, develop test strategies and plans, and align test cases with requirements and user stories.
- Conduct backend/database testing by writing and validating complex SQL and PL/SQL queries.
- Create and validate stored procedures and functions as part of the testing process.
- Understand data flow between systems and interpret data models effectively.
- Collaborate with cross-functional teams to ensure data integrity and quality across systems.
- Document test results, defects, and provide clear communication to stakeholders.
Required qualifications to be successful in this role
- 5–6+ years of ETL testing experience in a Quality Engineering capacity.
- Strong understanding of database systems and data warehousing concepts.
- Proficiency in SQL and PL/SQL, including writing and validating medium to high complexity queries.
- Experience with data modeling and understanding data flow across systems.
- Familiarity with Agile methodologies and test management tools.
- Excellent analytical and problem-solving skills.
- Strong communication and documentation abilities.
- Wealth Management or Banking domain experience is a strong advantage.
#LI-JP
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.