Start Date Location Course Type Duration Fee
25 July 2015 Chicago,Illinois In Class 6 Days $1,200

Pay Now

Register Workshop


ETL testing tool is identified to create an efficient data warehouse. ETL tool works for extraction, transformation and leverage of data and can enhance your abilities to manage data efficiently and effectively.

USITplus offers an exclusive certification program designed to familiarize business professionals in the Data warehouse and ETL space with the basics of testing and validating.  This course focuses on getting professionals the knowledge required in order to successfully test and validate data warehouses and ETL processes. USITplus offers advance trainings with real time exercises.


The course is designed to:

  • Describe the purpose of a data warehouse and the ETL process
  • Determine an appropriate testing strategy
  • Understand a source-target mapping document
  • Recognize the different testing methods
  • Determine appropriate sample sizes and data permutations
  • Explain the different data error types
  • Have knowledge of the different testing tools
  • Understand the importance automated testing







Module 1

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

Module 2

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

Module 3

ETL Testing Concepts

  • 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

Module 4

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


 * Full Tution fee is due and is non-refunded after attending 2nd class*

Submit a review