Job Search and Career Advice Platform

Enable job alerts via email!

Data Warehouse/Business Intelligence QA Engineer

QA Consultants

Toronto

On-site

CAD 70,000 - 90,000

Full time

Today
Be an early applicant

Generate a tailored resume in minutes

Land an interview and earn more. Learn more

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
Data Warehouse/Business Intelligence QA Engineer

Contract

QA Consultants is North America’s largest dedicated provider of software testing and quality assurance solutions. We have over 600 IT professionals supporting Fortune 500 organizations in the financial services, retail, manufacturing, internet services and government sectors. Since 1994, we have successfully delivered over 5000 mission critical projects on time and on budget. We offer the industry’s most comprehensive suite of high-value testing solutions ranging from staff augmentation and managed services to the market’s only Canadian-based, on-demand Test Factory centre of excellence. QA Consultants is headquartered in Markham, Ontario in a 33,000 square foot facility, with offices across Canada.

Responsibilities
  • In-depth understanding of Data Warehousing/Business Intelligence concepts from a QA perspective.
  • Create and maintain complex SQL queries such as type 2 triggers, all types of joins, aggregations, groupings, etc.
  • Execute ETL Datastage jobs using UNIX shell scripts.
Hands‑On Experience
  • EDW source to target testing (SQL scripting).
  • Data transformation/manipulation testing (SQL scripting).
  • Working knowledge and testing experience of ETL.
  • Experience in running the scheduler (Mainframe ESP).
Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.