Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
0 0 PR Digital Marketing Intern Delivery Driver Paid Healthy Trial Participant Paid Clinical Trial Participant Paid Research Participant BairesWash Incorpora Personal Para Software Developer Bread Baker Dental Receptionist-Full Time Driller Delivery Driver Carpenter Bud Tender Hiring Mortgage Agents and Brokers Marketing Assistant Amazon Picker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Immediate Amazon Order Packer Seasonal Full-Time Warehouse Team Member Amazon Picker Amazon Warehouse Associate Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Picker Amazon Warehouse Associate - Immediate Amazon Picker Full-Time Warehouse Team Member Amazon Picker Amazon Picker Amazon Warehouse Worker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Free Amazon Warehouse Worker Amazon Warehouse Worker Amazon Warehouse Associate Amazon Order Packer Amazon Warehouse Associate - Free Seasonal Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Warehouse Worker Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Picker Packer - Earn up to Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Exact Media Two Sigma Aerotek Aecom Peel Regional Police AsteroidX Akira Jane Street Borrowell Insight Global WeWork Shopify First Convenience Bank American Income Life Doordash Amazon Flex Square Microsoft AT&T Instacart Vector Marketing Scotiabank Clickworker Creative Circle Walgreens Hatchways UnitedHealth Group Recovhub LowCostWebDesignFirm.com Desjardins CI&T mappedin 51talk Top Hat Paylocity Checkout 51 Mobeewave TD Bank The Youth Connection Hootsuite SnapTravel ScribbleLive autoTRADER.ca GoParkr Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Senior Data Warehouse SQA Analyst At LeverageTek

Location: Ottawa, Ontario

Job Description

LeverageTek is actively seeking a Senior Data Warehouse SQA Analyst for its Ottawa based client.

Qualifications

  • Minimum 7 years of experience in Software Quality Assurance on heavy data warehouse projects
  • Expert-level SQL knowledge and relational database design
  • Extensive prior experience with data transformation ETL testing from source to target
  • Minimum 2 years’ experience leading testing activities and communicating progress, issues and risks to multiple stakeholders
  • Exposure to data warehousing concepts through hands-on experience in testing multiple data marts, metadata models, integration of legacy and future state data, analyzing client/server logs and business intelligence reports
  • Knowledge and experience with the following tools are mandatory: DataStage, IBM Cognos Analytics; and RedGate SQL Data Compare

Responsibilities

  • Participate in creating the following data warehouse testing project deliverables: test strategy, cost estimation, test plan, test cases, test results summary, defect management tracking
  • Assess data warehouse testing requirements and perform gap analysis between technical design specifications and business requirements
  • Design data warehouse test cases to ensure that functional, non-functional and technical requirements of a system are captured during the product design phase; execute test plans and create test reports to define testing and quality outcomes
  • Develop a broad understanding of various applications, data marts and systems throughout the organization
  • Provide feedback in the review of development code and unit tests
  • Assist developers in recreating data warehouse issues/defects
  • Execute manual test cases according to test strategy/plan and project schedule
  • Consult with product development team and business analyst to evaluate system interfaces, operational requirements, and performance requirements of overall system
  • Maintain effective communication with the software developers, other testers and business analysts on project risks, impacts from testing outcomes