Systems Testing QA Specialist

Background Information

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

The yearly volumes of these letters have increased from 2.8 million in 2013 to 8.3 million in 2022.

The growth in correspondence letter volumes is due to factors including population growth, letter type expansion and increased screening post-pandemic program pause.

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 Systems Testing/QA Specialist contingent resource will be working on testing of the monitoring and evaluation reporting requirements for this project.

Must haves:

Bachelor’s or master’s degree in computer science or related technical discipline, or equivalent experience.

5 – 7 years of experience in the information technology field particularly in the area of application development, data analysis, data architecture, systems analysis with significant with ETL, Data Warehouse, and back-end data validation.

Strong experience with MS SQL Server, Oracle or some other database management.

Experience with EDW source to target testing, Data transformation/ manipulation testing, Data quality/completeness validation (SQL scripting)

Advanced working knowledge and testing experience of ETL

Create and maintain complex SQL queries such as type 2 triggers, all types of joins, aggregations, groupings etc.

Strong experience in working independently on reading, modifying existing scripts/programs for which documentation may not be available.

Experience designing, building and maintaining automation test frameworks/scripts for UI, non UI and web services.

Experience in all phases of the Software Development Life Cycle and related methodologies such as Agile, Iterative, etc.

Strong experience in reviewing, architecting and defining test data, test environments to accommodate parallel testing for large integrated applications.

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.

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