Data Warehouse QA Engineer - BI/ETL & SQL Specialist

QA Consultants; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading QA solutions provider in Toronto is looking for a Data Warehouse/Business Intelligence QA Engineer. In this contract role, you will not only design complex SQL queries but also execute ETL jobs and ensure data accuracy through rigorous source-to-target testing. The successful candidate should have hands-on experience with Data Warehousing concepts and ETL processes. This position offers a chance to work with industry leaders and contribute to critical projects in a dynamic environment.

Qualifications

• In-depth understanding of Data Warehousing/Business Intelligence concepts from a QA perspective.
• Create and maintain complex SQL queries.
• Experience in running the scheduler (Mainframe ESP).

Responsibilities

• Execute ETL Datastage jobs using UNIX shell scripts.
• Data transformation/manipulation testing (SQL scripting).
• EDW source to target testing (SQL scripting).

Skills

Data Warehousing concepts

SQL scripting

ETL testing

Job description

A leading QA solutions provider in Toronto is looking for a Data Warehouse/Business Intelligence QA Engineer. In this contract role, you will not only design complex SQL queries but also execute ETL jobs and ensure data accuracy through rigorous source-to-target testing. The successful candidate should have hands-on experience with Data Warehousing concepts and ETL processes. This position offers a chance to work with industry leaders and contribute to critical projects in a dynamic environment.