QA Consultants Logo

QA Consultants

Data Warehouse/Business Intelligence QA Engineer

Reposted 3 Days Ago
Be an Early Applicant
In-Office
Toronto, ON
Mid level
In-Office
Toronto, ON
Mid level
The role involves QA testing in Data Warehousing/Business Intelligence, executing ETL jobs, maintaining SQL queries, and data validation.
The summary above was generated by AI
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
HQ

QA Consultants Toronto, Ontario, CAN Office

2 Sheppard Ave E, Suite 1500, Toronto, Ontario, Canada, M2N 5Y7

Similar Jobs

18 Minutes Ago
Hybrid
2 Locations
Senior level
Senior level
Cloud • Information Technology • Security • Software • Cybersecurity
The Senior Named Account Executive will drive sales and maintain relationships with large Canadian accounts, develop strategies, and manage contract negotiations.
Top Skills: IaasNetworkingPaasSecurity
Yesterday
Remote or Hybrid
ON, CAN
Expert/Leader
Expert/Leader
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Principal Engineer at CrowdStrike, you will lead cloud security initiatives, architect scalable data systems, and mentor engineering teams while driving technical vision and strategy for the xspm product.
Top Skills: AWSAzureCassandraETLGCPGoKafkaOpensearchPostgressPythonRedisRestful Apis
Yesterday
Remote or Hybrid
5 Locations
Mid level
Mid level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Join CrowdStrike as a UI engineer to build an advanced data visualization framework, collaborating with interdisciplinary teams and enhancing user experiences in cybersecurity.
Top Skills: AmchartsAngularCi/CdCSSD3.JsEmberEmber CliGraphQLHighchartsHTMLJavaScriptLitNode/NpmReactResponsive UiRestful ApiTailwindTypescriptWebpack

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account