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

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 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 Power

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

Technology Stack Cloud & Data Platform Google Cloud Platform (GCP): Big

Query, Cloud Composer ETL & Data Integration Informatica Power

Center Databases Oracle, SQL Server Testing & Automation SQL, Python, ETL Test Automation Tools Jira, Confluence Nice to Have Git / Git

Hub, CI/CD Tools, Adobe Platforms, ISTQB certificate.

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 growth opportunities 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)

📌 Senior Quality Engineer (Toronto)
🏢 Scotiabank
📍 Toronto