ETL Testing Online Training

ETL Testing Online Training By IT Professionals

Prime Online Training offers ETL Testing Online Training. Our ETL Testing trainers are Highly talented and have Excellent Teaching skills. They are well experienced trainers in their relative field. Our online training is one of the Best online training in India For any technology. All our students were happy With our online training and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. online training is your one stop & Best solution to learn ETL Testing at your home with flexible Timings.

Prime Online Training offers the ETL Testing Online Training Course in a true global setting.

What is ETL Testing ?

ETL basically stands for Extract Transform Load – which simply implies the process where you extract data from Source Tables, transform them in to the desired format based on certain rules and finally load them onto Target tables. There are numerous tools that help you with ETL process – Informatica, Control-M being a few notable ones.

So ETL Testing implies – Testing this entire process using a tool or at table level with the help of test cases and Rules Mapping document.

ETL Testing Online Training Course Outline

DataWare Housing Concepts:
1.What is Data Ware House?
2.Differences Between OLTP and DataWare Housing
3.Data Acquisition & Extraction
4.Data Transformation
5.Data Loading
6.Data Marts
7.Dependent Data Mart & Independent Data Mart
8.Data Base Design
9.Star Schema Introduction
10.Snow Flake Schema
11.Fact constellation Schema

SCD(slowly changing dimension)

1.Type-1 SCD
2.Type-2 SCD
3.Type-3 SCD

1.SQL Basic Concepts
2. ETL Tool Architecture Overview
3.White Box and Black BOX Testing Functionality on Different Transformation Rules
4.Life Cycle Of Data Ware House
5.Different Types of Testing Techniques in ETL
6.Minus Queing
7.Count Queing

ETL Testing Concepts

1.What is use of testing ?
2.What is quality & standards
3.Responsibilities of a ETL Tester

Software development life cycle (SDLC)
1.Waterfall model
2.Spiral model
3.Agile model & methodology
4.Prototype model

Testing methodologies
1.White box testing & Black box testing
2.Grey box testing
3.ETL Testing Work Flow Process
5.How to Prepare the ETL Test Plan
6.How to design the Test cases in ETL Testing.
7.How to reporting the Bugs in ETL Testing ?
8.ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
9.How to detect the bugs through database queries
10.ETL Performing Testing & Performing Tuning

Our ETL Testing Online Training batches start every week and we accommodate your flexible timings.


PrimeTrainings provides online training for various courses like  Selenium,Loadrunner,QTP & QC  Testing, winrunner, Manual testing,..

Comments are closed.