Find work in Canada.

327,336 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 16 mins ago
Solutions Designer – Senior - RQ11310
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Software Developer – CRM – Senior - RQ11661
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Solutions Designer – Senior - RQ11310
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Software Developer – CRM – Senior - RQ11661
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Software Developer – CRM – Senior - RQ11660
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Software Developer – CRM – Senior - RQ11661
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Network Architect
Alquemy Search & Consulting
Winnipeg, MB
Full-time
Added 16 mins ago
Software Developer – CRM – Senior - RQ11660
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Software Developer – CRM – Senior - RQ11660
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Application Architect – EHealth - RQ00386
S M Software Solutions Inc
Fredericton, NB
Internship
Added 16 mins ago
CA Gen Programmer - RQ00387
S M Software Solutions Inc
Fredericton, NB
Internship
…higher, Java/C++, Struts Framework, SSRS, UNIX/Linux, Oracle, SQL Server, Visual Studio, and public sector healthcare applications. The successful candidate will support the maintenance,…
Added 16 mins ago
Software Developer – Senior - RQ11691
S M Software Solutions Inc
Toronto, ON
Full-time
Added 16 mins ago
Solutions Designer – Senior - RQ11310
S M Software Solutions Inc
Toronto, ON
Internship
Added 16 mins ago
Application Architect – EHealth - RQ00386
S M Software Solutions Inc
Fredericton, NB
Internship
Added 16 mins ago
CA Gen Programmer - RQ00387
S M Software Solutions Inc
Fredericton, NB
Internship
…higher, Java/C++, Struts Framework, SSRS, UNIX/Linux, Oracle, SQL Server, Visual Studio, and public sector healthcare applications. The successful candidate will support the maintenance,…
Added 16 mins ago
Application Architect – EHealth - RQ00386
S M Software Solutions Inc
Fredericton, NB
Internship
Added 16 mins ago
Software Developer – Full Stack – Senior - RQ00788
S M Software Solutions Inc
Toronto, ON
Internship
…Core, ASP.NET Core, Angular, REST APIs, Microsoft Azure, SQL Server, Azure DevOps, CI/CD, and enterprise application modernization. The ideal candidate will have extensive hands-on…
Added 16 mins ago
Software Developer – Full Stack – Senior - RQ00788
S M Software Solutions Inc
Toronto, ON
Internship
…Core, ASP.NET Core, Angular, REST APIs, Microsoft Azure, SQL Server, Azure DevOps, CI/CD, and enterprise application modernization. The ideal candidate will have extensive hands-on…
Added 16 mins ago
CA Gen Programmer - RQ00387
S M Software Solutions Inc
Fredericton, NB
Internship
…higher, Java/C++, Struts Framework, SSRS, UNIX/Linux, Oracle, SQL Server, Visual Studio, and public sector healthcare applications. The successful candidate will support the maintenance,…
Added 16 mins ago
Software Developer – Senior - RQ11691
S M Software Solutions Inc
Toronto, ON
Full-time
Added 16 mins ago
Software Developer – Senior - RQ11691
S M Software Solutions Inc
Toronto, ON
Full-time
Added 16 mins ago
Software Developer – Full Stack – Senior - RQ00788
S M Software Solutions Inc
Toronto, ON
Internship
…Core, ASP.NET Core, Angular, REST APIs, Microsoft Azure, SQL Server, Azure DevOps, CI/CD, and enterprise application modernization. The ideal candidate will have extensive hands-on…
Added 16 mins ago
Director - Enterprise Data Warehouse and Data Platforms
CGI
Ottawa, ON
Full-time
Added 46 mins ago
Banquet Server | Part-Time | TD Coliseum
Oak View Group
Hamilton, ON
$20 CAD / hour
Part-time
Added 1 hour ago
Overnight Maintenance
McDonald's
Winnipeg, MB

Hays

ETL Tester

Toronto, ON, Canada

Job type: Contract
Apply by: Oct 28, 2026
Posting language: English
Posted: Sep 28, 2026

Apply About employer

Applications open in a new tab.

Original job description

Job Title: ETL Tester

Location: Toronto, ON (Hybrid)

Duration: Contract

Rate: $55-60/hr INC

Required Qualifications

• 5+ years of hands-on experience in ETL testing, data validation, source-to-target reconciliation, data transformation testing, and end-to-end validation of data pipelines in Data Warehouse environments.

Strong experience with SQL, backend testing, ETL validation, and complex Big-Query queries for data validation, reconciliation, and troubleshooting.

Strong understanding of Data Warehousing concepts, ETL processes, data-modeling, and data quality principles.

Hands-on experience with Oracle, SQL Server, Big-Query, Informatica PowerCenter, Airflow/Cloud Composer, and GCP data services.

Experience validating data across source, staging, and target systems, including structured, semi-structured, and JSON data.

Experience developing and maintaining ETL test automation solutions using Python, SQL, or similar technologies for automated data validation, reconciliation, and regression testing.

Proven ability to own test planning, test execution, regression validation, defect management, and testing sign-off activities for EDW initiatives.

Roles and Responsibilities

Collaborate with developers, business analysts, data engineers, and other stakeholders to identify, troubleshoot, and resolve data quality issues.

Participate in requirements reviews, source-to-target mapping sessions, and design discussions to ensure testability, completeness, and data quality.

Analyze source-to-target mappings, define test strategies, create comprehensive test cases, and perform rigorous data validation.

Validate data accuracy, completeness, and integrity through source-to-target reconciliation and transformation testing.

Execute complex SQL queries, perform backend testing, and validate ETL transformations across Oracle, SQL Server, and Big-Query platforms.

Validate end-to-end ETL workflows, data pipelines, and data movement across source, staging, and target environments.

Work with multiple source systems containing structured, semi-structured, and JSON data.

Develop and maintain automated data validation, reconciliation, and regression tests using Python, SQL, and other automation utilities.

Support continuous improvement of ETL testing processes through automation and reusable testing frameworks.

Own test planning, test execution, defect management, regression validation, test reporting, and testing sign-off for assigned EDW initiatives.

Collaborate with project teams to support release readiness activities and ensure delivery quality.

Maintain test cases, test results, defect logs, and other QA artifacts in Jira, Confluence, and related project repositories.

Technology Stack

Cloud & Data Platform : Google Cloud Platform (GCP): Big-Query, Cloud Composer

ETL & Data Integration : Informatica PowerCenter

Databases : Oracle, SQL Server

Testing & Automation : SQL, Python, ETL Test Automation

Tools : Jira, Confluence

Nice to Have : Git / GitHub, CI/CD Tools, Adobe Platforms, ISTQB certificate.

Apply About employer

More about this job

Responsibilities

Plan and execute ETL testing, including source-to-target reconciliation, transformation validation, end-to-end pipeline testing, regression testing, and defect management across data warehouse initiatives. Develop automated validation tests, collaborate with project stakeholders to resolve data quality issues, and maintain QA artifacts and release readiness.

Requirements

Requires 5+ years of hands-on ETL testing experience, strong SQL and backend testing skills, and knowledge of data warehousing, data modeling, and data quality. Candidates should have experience with Oracle, SQL Server, BigQuery, Informatica PowerCenter, Airflow or Cloud Composer, GCP data services, and test automation using Python or SQL.

Skills

ETL Testing
SQL
Python
Data Validation
Data Transformation Testing
Data Warehousing
Oracle
SQL Server
BigQuery
Informatica PowerCenter
Airflow
Google Cloud Platform
Test Automation
Defect Management
Jira

Visa sponsorship

Not detected in the job text

Keywords

ETL Testing
Data Validation
Source-to-Target Mapping
Data Transformation Testing
End-to-End Testing
Data Warehousing
Data Modeling
Data Quality
SQL
Python
Oracle
SQL Server
BigQuery
Google Cloud Platform
Cloud Composer
Airflow
Informatica PowerCenter
ETL Test Automation
Regression Testing
Backend Testing
Structured Data
Semi-Structured Data
JSON
Jira
Confluence
Git
GitHub
CI/CD
Adobe Platforms

Report this job