Business Intelligence Specialist - Toronto, Canada - Cleo Consulting

Cleo Consulting

Verified Company

Toronto, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Assignment:
RQ Business Intelligence Specialist - Senior

Start Date:

End Date:

Office Location: 315 Front St. West

Organization:
Children, Youth & Social Services Cluster

Ministry:
Ministry of Children, Community and Social Services

# Business Days:
plus Extension # of Days: 202.00

Title:
Business Intelligence Specialist - ETL Tester

Must haves:

7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have)

-
2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have):

2+ years Python (Must Have)

Description

Skills

Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 3 days per week at the Office Location.

Experience:

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
Identification and Test Data Preparation Techniques.
Review and understand Business Requirements/Source-ToTarget 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

Evaluation Criteria

Design Documentation and Analysis Skills (45%)

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 (45%)

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 predefined and adhoc reports testing
Demonstrated experience with Oracle and Microsoft interfaces
Proficient in SQL and Azure DevOps
Implementing logical and physical data models

Knowledge Transfer (10%)

The ETL tester must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using reviewwatchdo methodology & demonstrate the ability to prepare and present.
Development of documentation and materials as part of a review and knowledge transfer to other members
Development and facilitation of classroom based, or virtual instructor demo led sessions for Developers
Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed