CGI is one of the largest IT and business consulting services firms in the world, and they are seeking a detail-oriented Junior ETL Test Coordinator to support data validation and quality assurance activities. The role involves performing validation and quality assurance testing of ETL pipelines, executing SQL queries, and monitoring ETL jobs in Databricks.
Responsibilities
- Perform validation and quality assurance testing of ETL pipelines and data workflows
- Execute and monitor ETL jobs in Databricks and related data platforms
- Develop and execute SQL queries to validate data accuracy, completeness, and consistency
- Identify, document, and track data defects and inconsistencies
- Perform source-to-target data validation and reconciliation
- Support regression, integration, and system testing for data pipelines
- Assist in maintaining test cases, test documentation, and QA artifacts
Skills
- Bachelor's degree in Computer Science, Information Technology, or related field
- 1–3 years of experience in ETL testing or data quality assurance
- Strong SQL skills (joins, aggregations, subqueries, data validation queries)
- Good understanding of ETL concepts, data warehousing
- Exposure to Databricks
- Experience in ETL pipeline execution and monitoring
- Understanding of data validation techniques and data reconciliation methods
- Experience with tools such as Data Bricks
- Basic knowledge of Python or PySpark
- Familiarity with Agile/Scrum methodologies
- Exposure to data quality tools and automation frameworks
Company Overview
CGI is an IT and business consulting services firm that offers consulting, cyber security, cloud, and IT services. It was founded in 1976, and is headquartered in Montréal, Quebec, CAN, with a workforce of 10001+ employees. Its website is https://www.cgi.com.