Back to jobs

Data Warehouse/Business Intelligence QA Engineer

Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Contract — employment source
Employment type in the employer’s posting: Contract
From the employer’s posting

What you’ll work on

Full posting
  • Create and maintain complex SQL queries for data warehouse testing

  • Execute ETL DataStage jobs using UNIX shell scripts

  • Validate EDW source-to-target mappings and data transformations

  • Validate data quality and completeness

  • Test Cognos reports, dashboards, cubes and packages

From the employer’s posting
Create and maintain complex SQL queries
Executing the ETL Datastage jobs using UNIX shell scripts
EDW source to target testing (SQL scripting)
Data quality/ completeness validation (SQL scripting)
Cognos QA Experience – Reports, Dashboards ,Cubes and Packages

What you’ll bring

All qualifications

Core experience

  • Hands-on EDW source-to-target testing with SQL
  • Working knowledge of ETL testing
  • Experience running schedulers such as Mainframe ESP
  • Cognos QA experience
  • Experience with HPQC test management tool

Preferred experience

  • Automation experience with SHELL or PERL scripting
Qualification wording
Hands-on experience with: EDW source to target testing (SQL scripting)
Working knowledge and testing experience of ETL
Experience in running the scheduler (Mainframe ESP)
Cognos QA Experience – Reports, Dashboards ,Cubes and Packages
Experience with HPQC (Test Management Tool)
Automation experience with SHELL/ PERL scripting is beneficial
Apply at QA Consultants

Posting record

Report an error

Open 4 monthsWe first saw this posting 141 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jul 3, 2026141 days ago
Recorded sightings
42
Last seen by us
Nov 21, 2026
Employer says posted
Feb 4, 2014

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 141

Up longer than most. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

QA Consultants is hiring

1 open job

  • No new data jobs since July
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Perl
  • Shell
  • SQL
  • Cognos
  • DataStage
Where the posting names them
- Experience with creation of Test Plan/ completion documents - Automation experience with SHELL/ PERL scripting is beneficial Additional Information
- Create and maintain complex SQL queries such as type 2 triggers, all types of joins, aggregations, groupings etc... - Executing the ETL Datastage jobs using UNIX shell scripts Qualifications
- In-depth understanding with Data Warehousing/ Business Intelligence concepts from QA perspective - Create and maintain complex SQL queries such as type 2 triggers, all types of joins, aggregations, groupings etc... - Executing the ETL Datastage jobs using UNIX shell scripts
Hands-on experience with: - EDW source to target testing (SQL scripting) - Data transformation/ manipulation testing (SQL scripting)
- EDW source to target testing (SQL scripting) - Data transformation/ manipulation testing (SQL scripting) - Data quality/ completeness validation (SQL scripting)
- Data transformation/ manipulation testing (SQL scripting) - Data quality/ completeness validation (SQL scripting) - Working knowledge and testing experience of ETL
- Experience in running the scheduler (Mainframe ESP) - Cognos QA Experience – Reports, Dashboards ,Cubes and Packages -Data mapping validation

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

  • In-depth understanding with Data Warehousing/ Business Intelligence concepts from QA perspective
  • Create and maintain complex SQL queries such as type 2 triggers, all types of joins, aggregations, groupings etc...
  • Executing the ETL Datastage jobs using UNIX shell scripts

Qualifications

Hands-on experience with:

  • EDW source to target testing (SQL scripting)
  • Data transformation/ manipulation testing (SQL scripting)
  • Data quality/ completeness validation (SQL scripting)
  • Working knowledge and testing experience of ETL
  • Experience in running the scheduler (Mainframe ESP)
  • Cognos QA Experience – Reports, Dashboards ,Cubes and Packages

                             -Data mapping validation

                             -Data reasonability testing

  • Experience with HPQC (Test Management Tool)
  • Experience with creation of Test Plan/ completion documents
  • Automation experience with SHELL/ PERL scripting is beneficial

Additional Information

All your information will be kept confidential according to legislative guidelines.

 

We are only accepting applications from Greater Toronto residents at this time.

 

QA Consutlants is an equal opportunity employer.

Company Description

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Toronto, Canada

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.