India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Call Me Back

training courses

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 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

If you want to know more about ETL Testing Training do not hesitate to call +91-9393 002 123 or mail us on