Movojobs
Back to results

Added

Closed listing

Hays

ETL Tester

  • Toronto, ON, Canada

Contract

This opening has closed.

The original listing is kept below for reference.

Find open jobsMore jobs with this employer
About employer

Job details

Job type
Contract
Closing date
Posting language
English
Posted

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

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.

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

Categories

  • Data & Analytics
  • Technology
  • Software

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