Senior Quality Engineer (ETL testing)

Tangerine

Toronto

On-site

CAD 90,000 - 130,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Career development courses
Pension & benefits programs

Job summary

Tangerine is seeking a Senior Quality Engineer to lead ETL testing, data validation, and end-to-end validation of data pipelines in Data Warehouse environments. You will collaborate with cross-functional teams including developers, data engineers, and analysts to ensure data quality and testability.

The role involves executing complex SQL queries, validating transformations across Oracle, SQL Server, and BigQuery, and owning test planning, execution, and sign-off for EDW initiatives.

Qualifications

  • 5+ years hands-on experience in ETL testing and data validation in Data Warehouse environments.
  • Strong SQL, backend testing, and ETL validation for data quality and reconciliation.
  • Experience with Oracle, SQL Server, BigQuery and data integration tools.

Responsibilities

  • Collaborate with developers, data engineers, and analysts to identify and resolve data quality issues.
  • Review requirements and mapping sessions to ensure testability and data quality.
  • Define test strategies, create comprehensive test cases, and perform data validation.

Skills

ETL testing
Data validation
SQL
Python
Data warehousing concepts

Tools

Oracle
SQL Server
BigQuery
Informatica PowerCenter
Airflow/Cloud Composer
GCP data services
Jira
Confluence

Job description

Select how often (in days) to receive an alert:

Title: Senior Quality Engineer (ETL testing)

Requisition ID: 275896

At Tangerine,we’reredefining banking. As Canada’s leading digital bank, we thrive on innovation, agility, and bold thinking, tackling every challenge head-on with leading technology and the unstoppable power of collaboration.

Our client-obsessed teams deliver flexible, accessible banking solutions, breakthrough products, and award-winning service. Beyond banking,we’recommitted to making an impact in the communities we serve and across our organization. We foster a culture built on integrity, inclusion, and fearless ambition – where diverse perspectives are valued, and people are empowered to do their best work.

Are you ready to disrupt the status quo? Do you crave challenges that push boundaries? Ifyou’rea high performer looking to accelerate your career and reimagine the banking landscape, this is your moment.

Let’sshape the future of banking together!

Do you like new challenges? Are you ready to reach new heights in your career and become part of an established disruptor? If so, come join us and help redefine the Canadian banking landscape!

We are looking for a Senior Quality Engineer to join our Quality Engineering team. This person will be responsible for ETL testing, data validation, source-to-target reconciliation, data transformation testing, and end-to-end validation of data pipelines in Data Warehouse environments.

Is this role right for you? In this role, you will:

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

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

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

ETL & Data Integration

Databases

  • Oracle, SQL Server

Testing & Automation

  • SQL, Python, ETL Test Automation

Tools

  • Jira, Confluence

Nice to Have

What's in it for you?

  • You will be part of a diverse and inclusive team of Client-focused go-getters looking to learn from each other in an environment that celebrates and recognizes success!
  • You will have access to thousands of online and in person courses so you can shape your career growth with the support from diverse industry leaders.
  • You will get our help to save for your future and to invest in your total wellbeing through our Tangerine benefits*.
  • You belong here, we are equal and un-complicated. Bring your true self to work, dress codes don’t apply here.
  • You will enjoy workspace flexibility and all the excitement that comes from working at the official Bank of the Toronto Raptors.

*Tangerine employees participate in Scotiabank’s pension & benefits programs (available to permanent employees)

At Tangerine we value the unique skills and experiences each individual brings to the team, and are committed to creating and maintaining an inclusive and accessible environment. If you require accommodation during the recruitment and selection process, please let our Recruitment team know.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer (Data Modeling/Data Governance)
Data Engineer (Data Modeling/Data Governance)

Scotiabank • Toronto

Hybrid
CAD 120,000 - 150,000
Data Engineer (Data Modeling/Data Governance)
Data Engineer (Data Modeling/Data Governance)

Vector Institute • Toronto

On-site
CAD 90,000 - 130,000
Diverse and inclusive team
Extensive learning through courses (in
Benefits program for wellbeing
+1
Senior Full Stack Developer (12 Months Maternity Contract)
Senior Full Stack Developer (12 Months Maternity Contract)

Scotiabank • Toronto

On-site
CAD 110,000 - 140,000
Online courses access
Benefits package
Workspace flexibility
+1
Lead Quality Engineer - Automation (Data)
Lead Quality Engineer - Automation (Data)

RBC • Toronto

On-site
CAD 120,000 - 180,000
Total Rewards Program including bonus/
Coaching & development opportunities
World-class training program in金融服务
+1
Senior AI Engineer - Tangerine
Senior AI Engineer - Tangerine

Scotiabank • Toronto

On-site
CAD 120,000 - 180,000
Professional development
Comprehensive benefits
Flexible workspace
+1
Senior Director, Wealth Platform Engineering
Senior Director, Wealth Platform Engineering

Scotiabank • Toronto

On-site
CAD 180,000 - 260,000
Courses and training
Comprehensive benefits
Flexible workspace
Senior Director, Wealth Platform Engineering
Senior Director, Wealth Platform Engineering

Tangerine • Toronto

On-site
CAD 180,000 - 240,000
Online courses
Benefits package
Workspace flexibility
+1
Staff Engineer - iOS
Staff Engineer - iOS

Scotiabank • Toronto

On-site
CAD 140,000 - 200,000
Diversity and inclusion focus
Access to thousands of courses (online
In-person courses
+3
Senior Manager, Wealth Strategy and Research - Tangerine
Senior Manager, Wealth Strategy and Research - Tangerine

Scotiabank • Toronto

On-site
CAD 140,000 - 200,000
Learning & development programs
Competitive benefits
Pension & benefits programs
QE Portfolio Specialist
QE Portfolio Specialist

Scotia • Toronto

On-site
CAD 110,000 - 160,000