- 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)
- Synapse (nice to have)
- SQL Server
- 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