ETL Testing Online Training

DataWare Housing Concepts

  • What is Data Ware House?
  • Difference between OLTP and DataWare Housing

Data Acquisition

  • Data Extraction
  • Data Transformation
  • Data Loading

Data Marts

  • Dependent Data Mart
  • Independent Data Mart

Data Base Design

  • Star Schema
  • Snow Flake Schema
  • Fact constellation Schema

SCD(slowly changing dimension)

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

Basic Concepts in SQL

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

Data Ware House Life Cycle

Different Types of Testing Techniques in ETL

  • Minus Queing
  • Count Queing

ETL Testing course Concepts


  • What is use of testing
  • What is quality & standards
  • Responsibilities of a ETL Tester

2.Software development life cycle

  • Waterfall model
  • V-model
  • Agile model & methodology
  • Prototype model
  • Spiral model

3.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 DataStage, Informatica, Abinitio etc;
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning


  • Projects on Different Domains(Banking , Health Care, Telecom , Insurance)