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.
Basic knowledge of:
- SQL
- ETL fundamentals
- Data Warehouse concepts
- Query language
- 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.
40 Days (also available fast track course with short term duration)
- Flexible Schedules
- Live Online Training
- 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
Call now
for free consultation
for free consultation
: 8895-444-6858
Mail now
free consultation
free consultation
: info@ennares.com