ETL Testing Course Content

 ETL Testing Online Training Course Content:

1. Data Ware Housing Concepts:

  • What is Data Ware Housing
  • Difference between OLTP and Data Ware Housing 
2.Data Acquistion:
  • Data Extraction
  • Data Transormation
  • Data Loading

 3. Data Marts:

  Dependent Data Mart

 4. Data Base Design:

  • Star Schema
  •  Snow Flake Schema
  •  Fact constellation Schema
  • Advanced calculations explanation 

 5. SCD(slowly changing dimension):

  •  Type-1 SCD
  • Type-2SCD  
  • Type-3 SCD.

6 Basic Concepts in SQL:

  • Overview of ETL Tool Architetecture
  • White Box and Black BOX Testing Functionality on Different Transformation Rules

 7.  Data Ware House Life Cycle Different Types of Testing Techniques in ETL:

  •  Minus Queuing
  •   Count Queuing

8.  ETL Testing Concepts  and Introduction:

  •   Minus Queuing :What is use of testing
  •   What is quality & standard Responsibilities of a ETL Tester


9.   Software development life cycle

  •   Waterfall model
  •  Agile model & methodology
  • Prototype model
  •  XSpiral model 
10.Testing methodologies:
  • White box testing
  • Black box testing
  • Grey box testing
  • ETL Testing Work Flow Process
  • How to Prepare the  ETL Test Plan
  • How to design the Test cases in ETL Testing
  • How to reporting the Bugs in ETL Testing ?
  • ETL Testing Responsibilities in Data Stage, Informatica, Abinitio etc;
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning

11.   Projects Projects on Different Domains(Banking , Health Care, Telecom , Insurance):

·         Projects on Different Domains(Banking , Health Care, Telecom ,