View all jobs

Business Intelligence Specialist - Senior-RQ06097

Toronto, ON


  • Design & develop the test plan & test cases for Data warehouse, Datamart & Data Lake projects
  • Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes (e.g.,ETL).
  • Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e, data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered.
  • An understanding of Azure Data Factory Pipelines & Databricks Notes testing, Cloud data/Data Lake testing
  • Understanding of information governance principles and how they could apply in a testing capacity.
  • Identification and Test Data Preparation Techniques.
  • Review and understand Business Requirements/Source-To-Target mapping.
  • Ability to transform complex Business logic into SQL or PL/SQL queries
  • Ability to run, read from, debug batch processes
  • Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc



  • 7+ years in testing ETL projects & Data validation (test plan creation, writing test cases and executing back end testing of ETL pipelines) (Must Have)
  • 2+ years of experience in testing Azure Data Lake and Data Warehouse, and Datamart (Must Have)
  • 2+ years Python/PySpark (nice to have)
  • Databricks
  • Synapse (nice to have)
  • SQL Server
  • Oracle
  • Ability to present technical requirements to the business

Design Documentation and Analysis Skills 

  • Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
  • Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.
  • Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
  • Work with the Client & Developer(s) assigned to refine/confirm Business Requirements
  • Participate in defect fixing, testing support and development activities for ETL tool. Assist with defect fixing and testing support for Power BI reports.
  • Analyze and document solution complexity and interdependencies by function including providing support for data validation.


Development, Database and ETL experience 

  • Demonstrated experience in test case life cycle development and a number of years of practical experience (minimum 7+ years)
  • Proven experience in developing in test plan, test cases for ETL projects
  • Experience in testing data vault and dimensional data mart schemas
  • Demonstrated experience in testing Extract, Transform & Load and development and a number of years of practical experience (minimum 7+ years)
  • Experience in providing ongoing support on defect retest and regression testing
  • Experience in testing data ingesting and change data capture using Golden Gate (an asset but not mandatory)
  • Assist in the development of the pre-defined and adhoc reports testing
  • Demonstrated experience with Oracle and Microsoft interfaces
  • Proficient in SQL and Azure DevOps
  • Implementing logical and physical data models

Share This Job

Powered by