Senior ETL Quality Engineer

4 days ago

Toronto, ON, Canada Tangerine Full-time $90,000 - $130,000 Contract

Lead ETL testing at Tangerine using SQL, Python, and rigorous data validation across Data Warehouse environments. This senior role supports reliable data pipelines.

As a Senior Quality Engineer, you will test ETL workflows, validate transformations, and reconcile source-to-target data. You will collaborate with developers, business analysts, data engineers, and stakeholders to resolve quality issues. The work covers Oracle, SQL Server, BigQuery, and structured, semi-structured, and JSON data.

Key Responsibilities:

  • Analyze mappings and define comprehensive ETL test strategies
  • Validate data accuracy, completeness, integrity, and transformations
  • Execute complex SQL queries and backend testing
  • Automate validation, reconciliation, and regression tests
  • Own planning, execution, defects, reporting, and testing sign-off

Requirements:

  • Five-plus years of hands-on ETL testing experience
  • Strong SQL, BigQuery, backend testing, and reconciliation experience
  • Understanding of data warehousing, modeling, ETL, and quality principles
  • Experience with Oracle, SQL Server, Informatica PowerCenter, and Airflow
  • Python experience developing ETL test automation solutions

Apply senior ETL quality engineering expertise across SQL, Python, reconciliation, and end-to-end data pipeline validation at Tangerine.