Agile Tester - Intermediate

Position: Agile Tester - Intermediate
Location: Ottawa, Ontario Canada
Position Type: Contract - 7 Months
Language: English

We are looking for an Intermediate ETL Tester


  • Participate in creating the following data warehouse testing project deliverables: test strategy, test plan, test cases, traceability matrix, 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;
  • Assist developers in recreating data warehouse issues/defects;
  • Execute manual and automated test cases according to test strategy/plan and project schedule;
  • Maintain effective communication with the software developers, other testers and data architect on project risks, impacts from testing outcomes.


  • Minimum 2 years of experience in Software Quality Assurance on heavy data warehouse projects
  • Minimum 2 years of experience leading testing activities and communicating progress, issues and risks to multiple stakeholders
  • Minimum 2 years of writing advance SQL and advance knowledge on relational database design.
  • Extensive prior experience with data transformation ETL testing from source to target
  • Excellent written and verbal communication skills
  • Exposure to data warehousing concepts through hands-on experience in testing multiple data marts, metadata models, integration of legacy and future state data and business intelligence reports
  • Knowledge and experience with the following technology are mandatory: Defect management tool: HPQC/JIRA, RDB: Teradata/Oracle 

Nice to Have:

  • Knowledge of Agile/Scrum and SDLC process
  • ETL Tool, preferably IBM Data Stage
  • Tableau

If interested, please contact Kevin Ireland at or 613-914-5994