Position Description:
This role is hybrid and requires you to be at our downtown Client office at a minimum 2 days per week - subject to change at any time.
We are seeking a detail-oriented Junior ETL QA Engineer to support data validation, ETL pipeline testing, and quality assurance activities.
The ideal candidate will have foundational knowledge of ETL processes, hands-on experience with SQL, and exposure to Databricks.
Your future duties and 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.
Required qualifications to be successful in this role:
. 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.
Preferred Qualifications
. 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.
Nice to have
. Banking experience
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,–$,. This role is an existing vacancy.
Skills:
- ETL
- MySQL
- Python
- Financial Services
- SCRUM