Job Description

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 professio