RQ08919 - Systems TestingQA Specialist - Senior

Responsibilities:

• Perform functional and nonfunctional system testing of the Health Data Utility (HDU)
• Provide ongoing testing for the routine and incident management of HDU
• Test bug fixes in reporting as per defects found by business and as per HDU IRC project
• Create complete system testing documentation and artefacts including test plans test cases test scripts automated test scripts test results reports defect logs
• Transform functional business and system knowledge into effective test case planning and .
• Create test data according to the test plan; analyze testing results and retesting until expected results are obtained; perform reviews with users and ensures client acceptability levels are met (e.g. participating in walk throughs); recommend changes to ensure acceptable testing results; retest all criteria in a live environment and recommend user sign off for implementation.
• Work closely with developers architects product owners and others in establishing effective test plans based on feature documentation.
• Apply QA and technical expertise and engage other expertise to track and resolve testing and production issues and other IT related problems with quality deficiencies and maintain client service integrity.

SkillsExperience and Skill Set Requirements

Public Sector Experience

5 years of experience working with federal/provincial/broader publicsector healthcare providers

Knowledge of Public Sector Enterprise Architecture artifacts (or similar) processes and practices and ability to produce technical documentation that comply with industry standard practices

Indepth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.

Knowledge and experience with Public Sector Health related projects

Knowledge and understanding of Ministry policy and IT project approval processes and requirements Public Sector Experience adopting and adhering to Public Sector Unified I&IT Project Methodology Public Sector Enterprise Architecture and Public Sector Gating process and OPS Standard Systems Development Methodologies

Experience with large complex IT Healthrelated projects.

5 points

QA and Systems Testing Knowledge and Experience

7 years of experience in the following:

As a lead Systems Testing/QA Specialist for various streams of work providing guidance and oversight to junior testers and planning organizing and implementing testing efforts (includes preparation of test plans and coordination of test

Knowledge and understanding of testing methods in an objectoriented environment

All stages of system testing including strategy selection of testing tools test planning preparing test cases and test data manual and automated test and defect logging and tracking

Experience with a variety of testing systems including clinical systems testing mission critical systems testing and testing high volume transactional systems in highly available environments

Knowledge and experience of structured methodologies for the development design implementation maintenance of applications

Performing functional and nonfunctional system testing of the following: Commercial OfftheShelf (COTS) solutions including testing of patches new releases acceptance testing of enhancement request functionality for modules of the product and other enhancements and regression testing for implementation; in house web applications; HL7FHIR based webservices (RESTFUL/JSON/XML); Application Programming Interfaces (API); reporting solutions; integration components extensions and enhancements

Creating complete system testing documentation and artefacts such as: test strategies test plans test use cases test scripts

Develop automated test scripts (using tools such as Selenium framework)

API testing tools to query and test interfaces at the messaging layer

Web service queries using tools such as Rational ClearQuest SOAPUI POSTMAN or via Programming Languages

Knowledge and experience with information retrieval packages and data queries and adhoc queries (using SQL) and other query languages

Performing Accessibility testing to websites web content and mobile applications to conform to the World Wide Web Consortium Web Content Accessibility Guidelines (WCAG) 2.0

Tools to support Web Accessibility testing in support of AODA legislation

Test results reports including performance and security testing results for use in Defect Reviews with clients partners and project team

Business Intelligence (BI) solution to plan prepare and execute testing of BI solution including data setup/integration and validating data in the BI solution accessed through predefined analytical reports adhoc reporting tools and dashboards to ensure accuracy completeness and data integrity of the solution

Validating successful deployment of releases in production environments preparing reports on testing results

Performing business scenarios and crosssystem integration testing

Reviewing and providing input to technical and business requirements from a testing perspective including business intelligence solutions

Executing automated tests scripts

Knowledge and experience working in traditional and agile teams using standard and DevOps processes and tools

Knowledge and experience using at least one programming language

Knowledge and experience with all phases of the Systems Development Life Cycle (SDLC)

Reviewing business and technical documentation from a testing perspective to identify issues early in the SDLC

Knowledge and understanding of Information Management principles concepts policies and practices.

5 Years demonstrated experience in performing systems testing and quality assurance on:

Scalable Medallion Data Lakehouse architectures.

Data ingestion transformation and curation using Delta Lake and Databricks.

Integrating structured and unstructured data sources into star/snowflake schemas.

Complex ETL/ELT pipelines using Azure Data Factory (ADF) Databricks (PySpark SQL Delta Live Tables) and dbt.

Orchestrated workflows and job scheduling in Azure environments.

Relational (SQL Server Synapse PostgreSQL) and dimensional modeling.

Advanced SQL query optimization indexing partitioning and data replication strategies.

Apache Spark Delta Lake and distributed computing frameworks in Azure Databricks.

Parquet ORC and JSON formats for optimized storage and retrieval.

Azure Data Lake Storage (ADLS) Azure Synapse Analytics Azure SQL Event Hubs and Azure Functions.

Strong understanding of cloud security RBAC and data governance.

Python (PySpark) SQL and PowerShell for data engineering workflows.

CI/CD automation (Azure DevOps GitHub Actions) for data pipelines.

Data lineage cataloging metadata management and data quality frameworks.

Unity Catalog for managing permissions in Databricks environments.

Power BI (DAX data modeling performance tuning).

Integrating Power BI with Azure Synapse and Databricks SQL Warehouses.

Familiarity with MLflow AutoML and embedding AIdriven insights into data pipelines.

60 points

Logging Tracking and Defect Reporting

10 years of experience with:

Identifying and documenting issues and risks

Creating and maintaining defect logs and defect summary reports (using tools such as Azure DevOps Jira or Confluence Test rail)

Updating tasks and project status

Participating in QA and cross functional team meetings

Prioritizing test based on business priority defect patterns and available testing time

Dealing creatively with problems stemming from shared resources such as test environments and test data

Actively participating in walkthroughs and triage sessions.

25 points

General Skills

Proven technical leadership skills with ability to identify areas for improvement and recommend solutions

Exceptional analytical problem solving and decisionmaking skills

Demonstrated strong interpersonal verbal and written communication and presentation skills

Proven troubleshooting and critical thinking experience

Demonstrated ability to apply strong listening skills to facilitate issue resolution

Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships

Excellent customer service skills including tact and diplomacy to ensure client needs are managed effectively

A motivated flexible detailoriented and creative team player with perseverance excellent organization and multitasking abilities and a proven track record for meeting strict deadlines.

10 points

MUST HAVES

7 years of experience in the following:

All stages of system testing including strategy selection of testing tools test planning preparing test cases and test data manual and automated test and defect logging and tracking

Creating complete system testing documentation and artefacts such as: test strategies test plans test use cases test scripts

Develop automated test scripts (using tools such as Selenium framework)

Performing Accessibility testing to conform to (WCAG) 2.0

Test results reports including performance and security testing results

Validating successful deployment of releases in production environments preparing reports on testing results

Data ingestion transformation and curation using Delta Lake and Databricks.

Complex ETL/ELT pipelines using Azure Data Factory (ADF) Databricks (PySpark SQL Delta Live Tables) and dbt.

Apache Spark Delta Lake and distributed computing frameworks in Azure Databricks.

Azure Data Lake Storage (ADLS) Azure Synapse Analytics Azure SQL Event Hubs and Azure Functions.

CI/CD automation (Azure DevOps GitHub Actions) for data pipelines.

Data lineage cataloging metadata management and data quality frameworks.