Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.
Any graduation or related field or higher with minimum 3 years of relevant experience.
Position Description:
We are seeking an experienced ETL/SQL/Python Testing Engineer to design, develop, and execute test cases for data pipelines, ETL processes, and database systems. The ideal candidate will have robust expertise in SQL querying, ETL validation, Python scripting, and test automation to ensure data accuracy, completeness, and optimal performance.
Your future duties and responsibilities
Develop and execute ETL test cases to validate data extraction, transformation, and loading processes.
Perform ETL pipeline testing in Azure Databricks (ADB) environments.
Write complex SQL queries to verify data integrity, consistency, and correctness across source and target systems.
Automate ETL testing workflows using Python, PyTest, or similar frameworks.
Conduct data reconciliation, schema validation, and comprehensive data quality checks.
Identify and report data anomalies, pe