Senior EDW QA Engineer — ETL & BigQuery Specialist

S.I. Systems Ltd.; Toronto; Hybrid; CAD 120,000 - 160,000; Full time

Job summary

S.I. Systems Ltd. seeks a Senior EDW Quality Engineer to lead hands-on ETL testing and data validation across GCP/BigQuery for a major Canadian bank project.

You will own end-to-end validation of data pipelines from source to target and ensure data quality across Oracle, SQL Server, and BigQuery. In this hybrid Toronto role, you will collaborate with data engineers, developers, and business analysts to design tests, execute complex SQL queries, manage defects, and sign off on QA artifacts in

Qualifications

• 7+ years hands-on experience in ETL testing, data validation, source to target reconciliation, and end to end validation in Data Warehouse environments.
• Hands on experience with GCP and BigQuery (mandatory), including complex queries for reconciliation and troubleshooting.
• Strong experience with SQL, backend testing, and ETL validation across Oracle and SQL Server.
• Proven ownership of test planning, execution, regression validation, defect management, and testing sign off.
• Bachelor's degree or equivalent experience.

Responsibilities

• Collaborate with developers, business analysts, data engineers, and stakeholders to resolve data quality issues
• Participate in requirements reviews, source to target mapping sessions, and design discussions
• Analyze source to target mappings and create test strategies and test cases
• Execute SQL queries and validate ETL transformations across Oracle, SQL Server, and BigQuery platforms
• Validate end to end ETL workflows, data pipelines, and data movement across source, staging, and target environments
• Support automated data validation, reconciliation, and regression testing where applicable
• Maintain test cases, defect logs, test results, and QA artifacts in Jira and Confluence

Skills

ETL testing

Data validation

Source to target reconciliation

Test planning

Regression testing

Data Warehouse

SQL

Oracle

SQL Server

GCP

BigQuery

Education

Bachelor's degree or equivalent experience

Tools

Git / GitHub

CI/CD tools

Airflow / Cloud Composer

Informatica PowerCenter

Adobe platforms

Job description

S.I. Systems Ltd. seeks a Senior EDW Quality Engineer to lead hands-on ETL testing and data validation across GCP/BigQuery for a major Canadian bank project.

You will own end-to-end validation of data pipelines from source to target and ensure data quality across Oracle, SQL Server, and BigQuery. In this hybrid Toronto role, you will collaborate with data engineers, developers, and business analysts to design tests, execute complex SQL queries, manage defects, and sign off on QA artifacts in