Who Should Learn ETL Testing Training?

Following are the required skills for ETL testing

PL/SQL Skills

Manual Testing Skills

ETL/Data Warehousing Knowledge

ETL Testing Training course is beneficial to 

Professionals that want to become Business Object Professionals

Project Managers

Database Professionals

Mainframe Professionals

SQL Developers

Skills you will gain from our  course

• Thorough understanding of ETL and its concepts.
• Training in DDL,DML,DQL language.
• Hand on experience with ETL testing types.
• Preparing and executing test scripts.
• Implement workflows.

Career opportunities after taking the course

• ETL Automation test engineer
• ETL Testing quality engineer
• Data quality analyst
• ETL Tester
• ETL testing Application leda
• ETL Developer

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