Systems Testing/QA Specialist - Senior

LanceSoft; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a Senior Systems Testing/QA Specialist to lead testing efforts for critical systems. In this hybrid role, you will guide junior testers, develop test strategies, and execute both manual and automated tests across various platforms. The ideal candidate will have extensive experience in systems testing, particularly in data ingestion and ETL processes, and will be adept at using modern testing tools. Join a dynamic team dedicated to delivering high-quality solutions and ensuring the integrity of complex systems. This is a fantastic opportunity to make a significant impact in a collaborative environment.

Qualifications

• 7+ years in Systems Testing and QA with a focus on automated and manual testing.
• Experience with testing tools and methodologies in various environments.
• Strong background in data ingestion and ETL processes.

Responsibilities

• Lead testing efforts, ensuring thorough test planning and execution.
• Develop automated test scripts and perform accessibility testing.
• Validate successful deployment of releases and prepare testing reports.

Skills

Systems Testing

Quality Assurance

Test Planning

Automated Testing

Accessibility Testing

Data Ingestion

ETL/ELT Pipelines

SQL

Python

Agile Methodologies

Education

Bachelor's Degree in Computer Science

Relevant Certifications in QA

Tools

Selenium

Azure DevOps

Jira

Confluence

Postman

SOAP-UI

Rational ClearQuest

Delta Lake

Databricks

Power BI

Job description

Position: Systems Testing/QA Specialist - Senior

Location: Toronto, ON (Hybrid)

Duration: 248 Days Contract +250 Possible Extension

Job Description:

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 execution)
• Knowledge and understanding of testing methods in an object-oriented environment
• All stages of system testing, including strategy, selection of testing tools, test planning, preparing test cases and test data, manual and automated test execution 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 non-functional system testing of the following: Commercial Off-the-Shelf (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; HL7-FHIR 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, SOAP-UI, POSTMAN or via Programming Languages
• Knowledge and experience with information retrieval packages, and data queries and ad-hoc 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, ad-hoc 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 cross-system 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 AI-driven insights into data pipelines.

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 execution 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.

Must have:

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