Training Enquiry

ETL Testing Training


Course Name : ETL Testing                                                                    24*7 Technical Support
Duration         : 35 hours
Faculty            : Realtime experience

           Sun trainings is a best online center in Hyderabad. We are providing very best online training on ETL Testing.

Highlights in our training:

*  Very in depth course material with real time scenarios.
*  We are providing class with highly qualified trainer.
*  We will provide class and demo session at student flexible timings.
*  In training case studies and real time scenarios covered.
*  We will give 24*7 technical supports.
*  Each topic coverage with real time solutions.
*  We are providing normal track,weekend,fast track classes.
*  We will give every recorded session for play later.
*  We are giving placement support by multiple consultancies in INDIA, USA, Australia, UK etc.
*  We are providing certification oriented trainings with 100% pass guarantee.
*  We will give full support while attending the interviews and contact me any time after completion of the course.

Course Content:

Introduction and Overview of ETL Testing

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