ETL Testing Online Training

ETL Testing Online Training

Attain Technologies providing excellent ETL Testing Online Training Classes by real time IT Professionals Our trainers has more then 10 years of work experience. we also provide corporate training for multiple countries like USA, UK SINGAPORE, CANADA, DUBAI, SOUTH AFRICA. Our training methodology is very unique we have 1 to 1 classes batch classes and we provide online classes according to the students requirements we also provide interview support as part of it we conduct mock interviews and we provide interview questions so that you will be able to clear your interview in very less attempts we also offering job or technical support with our experts. Here complete environment would be in real time, so that once after the training you will be able to work on any project after the training. we will give you placement assistance in USA for required candidates.

ETL Testing Course Content :

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

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