Systems Testing QA Specialist 0492-1917
Share
Job Location:
Monthly Salary:
Posted on:
2 hours ago
Vacancies:
1 Vacancy
Job Summary
Background Information
Approximately 50% of Ontarians are eligible to participate in at least one of Ontario Healths (OHs) organized cancer screening programs (breast cervical and colorectal) that involve print/mail letters (invitation recall result reminders). and nbsp;
The yearly volumes of these letters have increased from 2.8 million in 2013 to 8.3 million in 2022. and nbsp;
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:
Bachelors or masters 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 Definition (BRD) Data Models data mappings and design are used to support QA testing. and nbsp;
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 stakeholders 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 as a team member across OH 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 motivate 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.
Evaluation Criteria: and nbsp; and nbsp;
5-7 years of writing complete SQL scripts - 40 points
3-5 years of testing experience with Informatica ETL tool or equivalent - 30 points
Experience working in Data Warehouse /Data Migration projects - 30 points
Total evaluation criteria: 100 points
Deliverables Include but are not limited to:
Master Test Plan
Test Cases in Azure DevOps (ADO)
SQL test scripts
Requirements traceability
QA Test results summary report
Knowledge Transfer Details:
The resource will ensure full knowledge transfer is provided to the Ontario Health team before end of engagement. Some of this might occur at the end of the engagement but will also be shared as information is obtained/consolidated. Key deliverables will be shared with team.
The resource must provide all related documentation as part of knowledge transfer protocol. Documents will be reviewed by the appropriate leads and signed off by manager/director.
The resource will work collaboratively with the Ontario Health team throughout the assignment and ensure key deliverables milestones and documentation are shared.
A walkthrough of any demos development etc. will be required before the end of the engagement.
Must Haves: and nbsp;
7 years Experience with EDW source to target testing Data transformation/ manipulation testing Data quality/completeness validation (SQL scripting)
7 years Experience Advanced working knowledge and testing experience of ETL
7 years Experience Create and maintain complex SQL queries such as type 2 triggers all types of joins aggregations groupings etc.
7 years Experience Strong experience in reviewing architecting and defining test data test environments to accommodate parallel testing for large integrated applications.
Deliverables Include but are not limited to:
Master Test Plan
Test Cases in Azure DevOps (ADO)
SQL test scripts
Requirements traceability
QA Test results summary report
Company Industry
IT Services and IT Consulting
Key Skills
- Invoicing
- Information Technology Sales
- IT Support
- Audio Visual
- Database Administration
