Senior Quality Assurance Engineer (SQL/ETL Testing)
Senior Quality Assurance Engineer (SQL/ETL Testing)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Pour obtenir une traduction en franais de loffre demploi suivante veuillez envoyer un courriel . Les demandes seront traites dans un dlai de trois jours ouvrables et la priode de dpt des demandes sera prolonge de trois jours.
To obtain a French translation of the following job posting please email . 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 premium 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
career development opportunities
a collaborative valuesbased team culture
a wellness program
a hybrid working model
participation 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 SQLbased 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 riskbased 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 backend 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 asis Digital Marketing Cloud solution and overall system / integration environments.
Proven capability to design and execute tests based on highlevel 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 longterm 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:
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 backend 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)
Indepth knowledge to manage and maintain the testing tools and their execution environment.
Indepth 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 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 fastpaced 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 tradeoffs 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 ones emotions and to handle interpersonal relationships judiciously and empathetically within product/project teams and crossportfolio and external stakeholder interactions.
Location:Ontario (currently hybrid; subject to change)
Employment Type:
Permanent Full timeContract Length:
N/ASalary Band:
Band 6External Application Deadline Date:
June 3 2025All 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 Mtis 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 and a member of the team will connect with you within 48 hours.
Required Experience:
Senior IC
Employment Type
Full-Time
