ETL Testing Online Training Content

Data WareHousing 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 Concepts

1.Introduction

       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
Projects on Different Domains(Banking , Health Care, Telecom , Insurance)