Data Warehouse/Business Intelligence QA Engineer

Posted 10 Days Ago
Be an Early Applicant
Toronto, ON
In-Office
Mid level
Information Technology • Software
The Role
The role involves QA testing in Data Warehousing/Business Intelligence, executing ETL jobs, maintaining SQL queries, and data validation.
Summary Generated by Built In
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.

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.

Top Skills

Cognos
Datastage
ETL
Hpqc
Mainframe Esp
Perl
Shell
SQL
Unix
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Toronto, Ontario
184 Employees
Year Founded: 1994

What We Do

QA Consultants is North America’s largest software quality engineering services firm. An award-winning onshore provider of software testing and quality assurance solutions, we are the trusted engineering services company for business, industry and government supported by leading practitioners and solutions.

For almost 30 years, we have successfully delivered 12,000+ mission-critical projects in the private, public and not-for-profit sectors. We reduce risk and improve time to market with quality engineering, keep applications secure through dedicated application security capabilities, and reduce cost of ownership while enabling applications to scale via performance engineering. We are proud of our vision to help clients achieve flawless technology outcomes.

QA Consultants also operates a robust emerging technologies practice with a focus on quality engineering solutions for connected and autonomous vehicles, artificial intelligence (AI), Internet of Things (IoT) and blockchain.

CAREERS
Please visit the Careers pages on our website to learn more. We just might have the perfect employment opportunity for you.

careers.qaconsultants.com

Similar Jobs

Easy Apply
Remote or Hybrid
6 Locations
4405 Employees
172K-253K Annually

MongoDB Logo MongoDB

Consultant

Big Data • Cloud • Software • Database
Easy Apply
Hybrid
Toronto, ON, CAN
5550 Employees
130K-180K Annually

PagerDuty Logo PagerDuty

Senior Program Manager

Artificial Intelligence • Cloud • Information Technology • Machine Learning • Software • Big Data Analytics • Automation
Easy Apply
Hybrid
Toronto, ON, CAN
1200 Employees
83K-125K Annually

Samsara Logo Samsara

Senior Manager, Recruiting

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
Toronto, ON, CAN
4000 Employees
123K-169K Annually

Similar Companies Hiring

Standard Template Labs Thumbnail
Software • Information Technology • Artificial Intelligence
New York, NY
10 Employees
PRIMA Thumbnail
Travel • Software • Marketing Tech • Hospitality • eCommerce
US
15 Employees
Scotch Thumbnail
Software • Retail • Payments • Fintech • eCommerce • Artificial Intelligence • Analytics
US
25 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account