Courses

ETL Testing Course Details

About ETL Testing Training Course

ETL Testing Training involves Extract, Transform & Load process in Data Warehousing. ETL refers to, “Extraction of data from different applications” developed & supported by different vendors, managed & operated by different persons hosted on different technologies “into Staging tables-Transform data from staging tables by applying a series of rules or functions – which may include Joining and Deduplication of data, filter and sort the data using specific attributes, Transposing data, make business calculations etc – to derive the data for loading into the destination system-Loading the data into the destination system, usually the data warehouse, which could further be used for business intelligence & reporting purposes.

ETL Testing Training Curriculum

Data Warehousing Concepts 

• Dataware house architecture 
• Datamart 
• DW Schema – Star Schema – Snow Flake Schema 
• Objects in DWH – Dimension table – Fact table 
• SCD(SLOWLY CHANGING DIMENSIONS) – SCD TYPE 1 – SCD TYPE 2 – SCD TYPE 3 

Differences between OLTP and OLAP SDLC And STLC 

• Agile Methodologies 
• Waterfall Model 

SQL (Structured Query Language) 

– DDL (Data definition language)

 – DML (Data manipulation language) 

– DQL (Data query language) 

Data Ware Housing Life Cycle w.t.r ETL ETL TESTING TYPES 

• Data migration testing 
• Sample testing and Scenario Testing 
• BATCH JOB Testing 

– Inbound Testing

 – OutBound Testing 

ETL TESTING TASKS

• Spec analysis 
• Designing Testcases 
• ETL Test scripts preparation 
• Environment Preparation
• Test Execution
• Peer Reviews of QA deliverables

ETL Testing validations 

• Structure validation
• Count validation
• TRANSFORMATION Logic Check 
• Data validation
• MINUS Query 
• Duplicate Check 
• Error logic Check 
• RI Validation( Referential integrity constraint check)
• Scenario testing
• Derived checks 
• Default values check 
• Data Integrity check 

Basic checks at ETL Phases 

• Extraction phase testing 
• Transformation phase testing 
• Loading phase testing 

Testing for SCD 

• SCD Type1 Testing
• SCD Type2 

Testing Overview of ETL Tool (Data stage) CODE PROMOTION PROCESS 

• Dev to QA 
• QA to UAT
• UAT to Production 

CONTROL M ( Scheduling tool slides) UNIX