ETL Tester (Contract)

@ CoreFactor Inc.

Toutes ses offres

Ontario

Temps plein5+ ans d’expérience

Postuler

SIGNAUX

En bref

CoreFactor Inc. is hiring a contract ETL Tester for a financial services client in the GTA. The role owns test planning, execution and sign-off for data warehouse initiatives, validating ETL pipelines across Oracle, SQL Server and BigQuery. The posting requires hybrid work with office attendance four days per week.

Responsabilités :

Valider la qualité des données et les transformations ETL
Exécuter des requêtes SQL complexes sur Oracle, SQL Server et BigQuery
Développer des tests automatisés en Python et SQL
Gérer la planification, l'exécution et la signature des tests EDW
Maintenir les artefacts QA dans Jira et Confluence

Résumé des exigences :

5+ ans d'expérience en tests ETL et validation de données
Solides compétences en SQL et BigQuery
Connaissance de l'entrepôt de données et de la modélisation
Expérience avec Informatica PowerCenter, Airflow et GCP
Expérience avec les données JSON et semi-structurées

Outils et compétences

Oracle SQL Server BigQuery Informatica PowerCenter Airflow Cloud Composer GCP Python Jira Confluence

Source et dates

Type de source non vérifié · zoho

Date publiée par l’employeur: 2026-09-26
Première détection par notre source: 2026-10-09
Mise à jour du dossier source: 2026-10-10

Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.

Détails du poste

Niveau	Senior
Domaine	Développement logiciel
Expérience	5 an(s) et plus
Heures par semaine	40 (estimé)
Déplacements	avion : aucun · route : aucun
Milieu de travail	Bureau
Position	Surtout assis
Exigences physiques	physique faible · ordinateur élevé
Langues	English

Résumé et détails rédigés par l’IA à partir de l’offre; l’offre de l’employeur fait foi.

Postuler

CoreFactor Inc.

Toutes ses offres

Champ	Valeur
Offres sur Jobsy	19

Description

CoreFactor is searching for an ETL Tester on a contract basis for a Financial Services client in the GTA .

This position is hybrid and will require the successful incumbent to go into the office four (4) days per week.

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 BigQuery 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.

Requirements

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 BigQuery 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, BigQuery, 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.