Senior Quality Assurance Engineer (SQL/ETL Testing)

Ontario Health; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

Ontario Health is seeking a Senior Quality Assurance Engineer to ensure data integrity through manual testing, SQL queries, and ETL validation. The role involves leading testing efforts, collaborating with teams, and adhering to QA standards. Join a mission-driven organization committed to health and wellness.

Benefits

Fully paid medical, dental and vision coverage

Health care spending account

Defined benefit pension plan

Three personal days annually

Three weeks’ vacation to start

Career development opportunities

Collaborative team culture

Wellness program

Qualifications

• 5-7 years in IT, focusing on application development and data validation.
• Experience with ETL and Data Warehousing.

Responsibilities

• Conduct manual testing and debugging using SQL.
• Lead testing efforts for complex projects.
• Create test scenarios and data for testing.

Skills

SQL

Data Analysis

ETL

Quality Assurance

Agile

Education

Bachelor’s or Master’s degree in Computer Science

Tools

MS SQL Server

Oracle

Jira

Job description

Pour obtenir une traduction en français de l’offre d’emploi suivante, veuillez envoyer un courriel à [e-mail]. Les demandes seront traitées dans un délai de trois jours ouvrables et la période de dépôt des demandes sera prolongée de trois jours.

To obtain a French translation of the following job posting, please email [e-mail]. Requests will be addressed within three business days, and the application window will be extended by three business days.

At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value. How we work together is reflected through our five values: integrity, inspiration, tenacity, humility and care.

What Ontario Health offers:

Achieving your career goals is a priority to us. Benefits of working at Ontario Health may include the following based on employment type:

• Fully paid medical, dental and vision coverage from your first day

• a health care spending or wellness spending account

• a p remium defined benefit pension plan

• three personal days and two float days annually

• three weeks’ vacation to start (for individual contributors), increasing to four weeks after two years

• c areer development opportunities

• a collaborative values-based team culture

• a wellness program

• a hybrid working model

• p articipation in Communities of Inclusion

Want to make a difference in your career? Consider this opportunity.

The Senior Quality Assurance Engineer (SQL/ETL Testing) is primarily responsible for manual testing and debugging by writing conducting complex SQL-based manual testing 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.

The Senior Quality Assurance Engineer may lead test engineering efforts for complex projects including assess project requirements, provide estimates for testing tasks and deliverables and conduct a variety of tests to assess the quality and efficacy of a range of applications in preparation of deployment and through operations. Also, coordinate with Project/Product Manager and stakeholders to ensure test asset development is integrated into overall project schedule. Research, set up, manage and maintain testing tools and their execution environment.

Here is what you will be doing:

• Assesses project requirements and provide estimates for testing tasks and deliverables with some assistance.

• Creates test scenarios and data for testing.

• Applying risk-based approach to design and communicate a practical testing strategy to the team, considering testing risks and options for their mitigation within the constraints of the project timeline.

• Tracks test planning and execution in the application lifecycle management tool and provide reporting when requested. Documents results and provides updates to project teams and Management as requested.

• Identifies, documents and monitors test results and enhancements from third party vendors.

• Provides support and guidance to project/product team on test case planning and execution approach for Data Warehousing initiatives.

• Create complex SQL scripts to verify ETL and BI back-end database results

• Perform comprehensive database data analysis using SQL queries to prepare test data

• Develops the best user experiences possible and is jointly accountable for the quality of the products and services that they test for their customers.

• Engages both internal and external clients to gain a deeper understanding of their product domain and to assist their clients in the identification of the root cause of issues.

• Educates members of the team on QA best practices and advocates implementation of such practices within the team to maintain the quality of the product.

• Collaborates with team members (developers, quality assurance and business analysts, project and product managers) to review available documentation and build a common understanding of the target state of the system under test.

• Adhering to the QA Centre of Excellence standards and to practices of the chosen SDLC methodology (Agile, Waterfall) during all phases of the projects.

• Create, implement and refine a comprehensive QA digital marketing plan to drive quality into the heart of the department.

• Motivates other team members to achieve higher goals and improve the impact of technology initiatives.

• Develop testing protocols to minimize errors across all digital marketing channels and ensure the highest standards for all communications.

• Understand campaign requirements and handle large data tests and IT research requests with proficiency to maximize success.

• Works with a high level of autonomy within a defined project/solution/system scope based on direction from a manager or QA Lead.

• Participates in development of test plan with QA Lead and other technical leads and prepares and execute test cases for responsible system.

• Ensures work aligns to broader project plan.

• Stays abreast of evolving technology, architecture, and design, patterns, practices, and platforms.

• Test all assets of digital communication, including website, landing pages, marketing automation workflows, emails, etc.

• Follow complex BRD/User Stories that aligns to the as-is Digital Marketing Cloud solution, and overall system / integration environments.

• Proven capability to design and execute tests based on high-level overviews of the Digital Marketing Cloud architecture and integration capabilities.

• Makes decisions where results have a major impact across the organization requiring sophisticated solutions and long-term correction.

• Writing positive, negative, smoke and regression test cases and creating corresponding test scripts and testing data to verify product functionality.

• Coordinating preparation of the test environment such as deploying code artefacts in testing environments, requesting database refreshes, setting up testing accounts.

• May be required to work outside of regular business hours based on business needs.

Here is what you will need to be successful:

Education and Experience:

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

• QA Certification with ISTQB or QAI, ITIL (or similar substitute) is an asset.

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

• Agile Certification is an asset.

• Executing the ETL Datastage jobs using UNIX shell scripts will be an asset

Knowledge and 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.

• Technical proficiency in Siebel/CRM is an asset.

• Ability to write complex SQL scripts including joins and aggregations to analyze backend data and verify behaviour of ETL processes.

• Basic knowledge of Unix/Linux operations (connectivity, navigation, executing basic commands) is a strong asset.

• AWS and/or Azure Cloud certification is an asset.

• Extensive knowledge of quality assurance/testing processes, best practices, techniques and tools for different types of testing (functional, GUI, API/web service, integration, regression, performance, hardware, deployment, manual and automated testing).

• Solid understanding of how User Stories, Business Requirements Definition (BRD), Data Models, data mappings and design are used to support QA testing.

• Working knowledge of defect management and tracking tools (e.g., Jira, TFS)

• In-depth knowledge to manage and maintain the testing tools and their execution environment.

• In-depth knowledge of source code control and software configuration management.

• Knowledge of data management and data movement ETL and ELT tools.

• Understanding of key cloud concepts for one of the major cloud providers (such as Azure or AWS) is an asset.

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

• Ability to make decisions where results have a major impact across the organization.

• Capacity to be aware of, control, and express one's emotions, and to handle interpersonal relationships judiciously and empathetically within product/project teams, and cross-portfolio and external stakeholder interactions.

Location: Ontario (currently hybrid; subject to change)

Employment Type:

Permanent Full time

Contract Length:

N/A

Salary Band:

Band 6

External Application Deadline Date:

June 3, 2025

All applicants must be a resident of Ontario to be considered for roles at Ontario Health.

Ontario Health encourages applications from candidates who are First Nations, Métis, Inuit, and urban Indigenous; Francophone; members ofBlack and racializedgroups; 2SLGBTQIA+ communities; trans and nonbinary individuals;and people living with disabilities.

Ontario Health is an accessible employer, and we offer accommodation in all aspects of employment, including the recruitment process. If you require a disability related accommodation in order to participate in the recruitment process, please email [e-mail] and a member of the team will connect with you within 48 hours.