Senior QA Engineer: SQL & ETL Testing (Hybrid, Ontario)

StafinGo; Toronto; Hybrid; CAD 83,000 - 103,000; Full time

Job summary

StafinGo is seeking a Senior Quality Assurance Specialist to support a Ontario-based digital health initiative. You will lead SQL-driven ETL testing, validate data integrity, and work across data warehouse projects with a hybrid work model in Ontario.

Key responsibilities include designing and executing test plans, validating ETL migrations, and delivering clear QA reports. The role requires strong SQL, data validation, and testing experience in public-sector data environments.

Qualifications

• 5-7 years of experience writing complete SQL scripts with joins, aggregations and data validation.
• 3-5 years testing ETL processes with Informatica or equivalent tool.
• Hands-on with data warehouse and/or data migration projects.
• Strong SQL Server and/or Oracle concepts including stored procedures and views.
• Experience transforming requirements into test cases and documenting results.

Responsibilities

• Develop and execute test plans, SQL scripts, and ETL validation scripts.
• Perform manual, functional, integration, and regression testing.
• Validate data extraction, transformation, migration and reporting results.
• Maintain QA documentation, traceability, and results reports.
• Collaborate with QA leads, PMs, analysts, developers and stakeholders.
• Identify defects, investigate, document, and suggest improvements.
• Support testing strategy, planning and quality assurance best practices.

Skills

SQL scripting

ETL testing

Data warehouse

Data validation

Independent work

Tools

Informatica

IBM DataStage

Siebel

Azure

AWS

Unix/Linux

Job description

StafinGo is seeking a Senior Quality Assurance Specialist to support a Ontario-based digital health initiative. You will lead SQL-driven ETL testing, validate data integrity, and work across data warehouse projects with a hybrid work model in Ontario.

Key responsibilities include designing and executing test plans, validating ETL migrations, and delivering clear QA reports. The role requires strong SQL, data validation, and testing experience in public-sector data environments.