Apply SQL and ETL testing expertise to healthcare digital transformation work in a hybrid Toronto setting, onsite three days weekly. Validate reporting data and transformations across complex systems.
This full time ETL Tester supports modernization of communication and reporting processes. The work centers on quality assurance for data warehouses and migration environments, using SQL Server or Oracle, Informatica, and requirements traceability. You will test reporting and analytics solutions end to end while collaborating with project and testing leads.
Key Responsibilities: Advise on testing strategies, plans, tools, and required resources
Develop test plans, scripts, cases, and QA artifacts
Execute functional, integration, interface, performance, and regression testing
Write complex SQL queries for manual testing and debugging
Prepare traceability records and QA results summary reports
Requirements: Five to seven years writing complete SQL scripts
Three to five years testing Informatica ETL or equivalent
Data warehouse or data migration project experience
Expertise with SQL Server or Oracle database concepts
Knowledge of mappings, data models, and business requirements
Bring SQL validation, Informatica ETL testing, and data quality assurance expertise to Toronto healthcare transformation projects.