Senior Quality Assurance Engineer

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 Hiring | Senior Quality Assurance Specialist – SQL & ETL Testing-Hybrid in Ontario

Location: Ontario, Canada (Hybrid - Up to 3 days onsite, at the Hiring Manager's discretion)

Contract: December 7th, 2026 - April 13th, 2027

Extension: Possible for unused business days

Compensation: $60-$75/hour, depending on engagement type and experience

Industry: Public Sector | Digital Health & Data Analytics

About the Role :

StafinGo is seeking an experienced Senior Quality Assurance (QA) Specialist to support a digital health initiative focused on modernizing cancer screening communications across Ontario.

The successful candidate will play a key role in testing monitoring, and evaluation reporting requirements, validating data transformations, and ensuring the accuracy and integrity of data across systems. This position requires strong SQL expertise, hands-on ETL testing experience, and a solid background in data warehouse or data migration projects.

Key Responsibilities

• Develop and execute test plans, test cases, and complex SQL scripts to validate backend data and ETL processes.
• Perform manual, functional, integration, interface, performance, and regression testing.
• Validate data extraction, transformation, migration, and reporting results using SQL queries.
• Prepare and maintain test documentation, requirements traceability, and QA results reports.
• Collaborate with QA leads, project managers, business analysts, developers, and business stakeholders.
• Identify, investigate, document, and communicate defects and recommend improvements.
• Support testing strategy, effort estimation, test planning, and quality assurance best practices.
• Ensure proper documentation and knowledge transfer to the project team.

Required Qualifications :

• 5-7 years of experience writing complete SQL scripts, including complex joins, aggregations, and data validation queries.
• 3-5 years of experience testing ETL processes using Informatica or an equivalent ETL tool.
• Hands-on experience with data warehouse and/or data migration projects.
• Strong knowledge of SQL Server and/or Oracle database concepts, including stored procedures, triggers, packages, and views.
• Experience using business requirements, user stories, data models, and data mappings to design and execute test cases.
• Strong analytical, problem-solving, communication, and documentation skills.
• Ability to work independently, manage competing priorities, and deliver within tight deadlines.

Nice-to-Have Skills :

• IBM DataStage ETL testing and execution using UNIX shell scripts.
• Siebel or CRM technical experience.
• Familiarity with Azure, AWS, or other major cloud platforms.
• Basic Unix/Linux knowledge, including navigation, connectivity, and command execution.
• Master Test Plan
• SQL Test Scripts
• Requirements Traceability Documentation
• QA Test Results Summary Report