Assignment: RQ00826 - Systems Testing/QA Specialist - Senior

Requisition: RQ00826

Job Title: Sr. Systems Testing/QA Specialist for Digital Correspondence Project

Client: Ontario Health

Start Date: 2026-12-07

End Date: 2027-04-13

Department: Digital Excellence in Health

Office Location: 525 University Avenue, Toronto

Business Days: 125.00

Location: Hybrid up to 3 days onsite (at the HM's discretion)

Public Sector Experience: nice to have

Must Haves:

- 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

Description

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

- Deliverables Include (Deliverables resource is responsible for):
- Master Test Plan
- Test Cases in ADO
- SQL test scripts
- Requirements traceability
- QA Test results summary report

Additional Terms

- The term of this Engagement Assignment is for 125 Business Days, The Engagement Assignment may be extended for unused Business Days at the Agency's discretion.
- The resource will comply with the Agency's policies and procedures.
- The resource will be issued an Agency laptop and is expected to provide at least one additional monitor, an external keyboard and a mouse at their own expense. In addition, when the resource is working from their home location they must have a private office space and are not permitted to work in an open communal space. Internet connection must be hard-wired and suitable bandwidth to support the IT requirements of this role. If these conditions cannot be met within their home office space, the resource will transition to full time in office, and the hybrid option will no longer be available.
- The Agency systems cannot be accessed from outside the province of Ontario, and Agency assets including laptops and related equipment cannot be removed from the province of Ontario, without prior written approval from the Agency.
- Assignment Type: This position is currently listed as "Hybrid". The resource under this request will be required to work onsite as per Hiring Manager sole discretion.

📌 Sr. Systems Testing/QA Specialist (Toronto)
🏢 Cleo Consulting
📍 Toronto