ETL Testing
Contact Form
Overview
Students Prerequisites
Course Curriculum
Duration of the Course
Instructor Profile
Overview
Extract, transform, load (ETL) is the general procedure of copying data from one or more sources into a destination system which represents the data differently from the source(s) or in a different context than the source(s). The ETL process became a popular concept in the 1970s and is often used in data warehousing. ETL can transform dissimilar data sets into an unified structure.
Students Prerequisites
Basic knowledge of:
- SQL
- ETL fundamentals
- Data Warehouse concepts
- Query language
Course Curriculum
- Purpose of Data warehouse
- Tools used to Load data into the data warehouse
- About Data warehouse Testing
- Need for ETL Testing
- ETL Testing phases
- Business understanding
- Test plan creation
- Test environment setup
- Test script generations
- Execution
- Reporting
- How is ETL Testing different from normal Testing
- How to ensure no data loss
- Transformation Rules
- Data validation Strategies
- Data file loads
- Data validation with in staging tables to check all Mapping rules
- Data validation with in Target tables to ensure data is present in required format
- Staging Area
- Test approach and procedure in staging area
- SOR Area
- Test approach and procedure in SOR area
- Data marts Area
- Test approach and procedure in Data marts area
- Live project examples of ETL Testing with Data stage ETL Tool
- Most commonly used SQL oracle queries useful in ETL Testing
- Result Analysis
- Mock Interview Sessions.
Duration of the Course
30 Days (also available fast track course with short term
- Flexible Schedules
- Live Online Training
Instructor Profile
- Training by highly experienced and certified professionals
- No slideshow (PPT) training, fully Hand-on training
- Interactive session with interview QA’s
- Real-time projects scenarios & Certification Help
- 24 X 7 Support
