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
• 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

 

Skills:

• 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