QA Specialist (SQL, ETL)

Position: Systems Testing/QA Specialist - Senior (SQL, ETL, Data Warehouse, Data Migration)

Start Date: 2026-12-07

End Date: 2027-04-13

Location: Toronto

Work Schedule: Hybrid (up to 3 days onsite per week)

MANDATORY SKILLS

• 5-7 years of writing complete SQL scripts
• 3-5 years of testing experience with Informatica ETL tool or equivalent
• Experience working in Data Warehouse /Data Migration projects

Public Sector Experience: nice to have

DIGITAL CORRESPONDENCE PROJECT

Approximately 50% of Ontarians are eligible to participate in at least one of the Agency’s organized cancer screening programs (breast, cervical and colorectal) that involve print/mail letters (invitation, recall, result, reminders).

Implementing digital communication channels for cancer screening correspondence offers an option to Ontarians who prefer digital communication over paper letters and aligns with the long-term vision for digital health in Ontario, and specifically the Digital First for Health Strategy.

The Specialized QA contingent resource will be working on testing of the Monitoring and Evaluation reporting requirements for this project.

RESPONSIBILITIES

• Provides advice on the testing strategy, test plans, the selection of testing tools, and the identification of resources required for testing
• Plans and organize testing efforts for large systems in Graphical User Interface (GUI) and non-Graphical User Interface (GUI) environments, including the execution of systems integration tests, specialized tests, and user acceptance testing (e.g., stress tests)
• Develop test plans, test scripts and test cases and execute these against the various components. Work with the testing lead and IT lead of each project as well as the project team members in the analysis, design, development, implementation and ongoing support of the required systems
• Manual testing and debugging by writing complex SQL queries and ETL validation to ensure the accuracy and integrity of data transformations and extractions. This includes performing Quality Assurance services and executing functional, integration, interface, performance and regression testing, preparing estimates and participating in planning and preparation services along with other testing artifacts in alignment with best practices and OH Quality Assurance standards.

REQUIRED SKILLS

• Excellent database data analysis skills using SQL.
• Expert understanding of database concepts for SQL Server and/or Oracle, such as PL/SQL, procedures, triggers, packages, views.
• Ability to write complex SQL scripts including joins and aggregations to analyze backend data and verify behaviour of ETL processes.
• Solid understanding of how User Stories, Business Requirements Definition (BRD), Data Models, data mappings and design are used to support QA testing. Excellent problem solving and analytical skills to track test planning and execution, ensure the quality of the digital solutions being implemented, assess the quality and efficacy of a range of applications, assess project requirements to provides accurate estimates for testing tasks and deliverables, prepare and execute test cases, query databases to verify data, solve complex technical issues inherent in testing and be able to identify potential defects and enhancements.
• Strong written and oral communication skills to communicate testing strategy, discuss and incorporate stakeholder’s feedback, and communicate issues found during testing clearly, develop testing reports and other related documentation, educate members of the team on QA best practices.
• Interpersonal and communication skills to work efficiently with the team across the Agency, both with clinical leads as well as other technical professionals such as Project Managers, Business Analysts, Business Leads, Development, and IT.
• Ability to work in a fast-paced environment with emphasis on responding to change rather than following the plan.
• Ability to work independently on assigned tasks and ability to meet tight deadlines.
• Ability to work efficiently with other team members to achieve higher goals and improve the impact of technology initiatives.
• Demonstrated ability to understand and discuss technical concepts, manage trade-offs, and evaluate opportunistic innovative ideas with internal and external partners.
• Ability to understand and apply concepts.
• Strong multitasking skills and attention to detail.

DESIRED SKILLS

• Executing the ETL DataStage jobs using UNIX shell scripts will be an asset
• Technical proficiency in Siebel/CRM is an asset.
• Understanding of key cloud concepts for one of the major cloud providers (such as Azure or AWS) is an asset.
• Basic knowledge of Unix/Linux operations (connectivity, navigation, executing basic commands) is a strong asset.

REQUIRED EXPERIENCE

• 5-7 years of writing complete SQL scripts
• 3-5 years of testing experience with Informatica ETL tool or equivalent
• Experience working in Data Warehouse /Data Migration projects

DELIVERABLES INCLUDE (Deliverables resource is responsible for):

• Master Test Plan
• Test Cases in ADO
• SQL test scripts
• Requirements traceability
• QA Test results summary report