ETL Testing Online Training
ETL Testing Training Course Content:
Data Ware Housing Concepts:
1.What is Data Ware House?
2.Difference between OLTP and DataWare Housing
3.Data Acquisition
4.Data Extraction
5.Data Transformation
6.Data Loading
7.Data Marts
8.Dependent Data Mart
9.Independent Data Mart
10.Data Base Design
11.Star Schema
12.Snow Flake Schema
13.Fact constellation Schema
SCD(slowly changing dimension)
1.Type-1 SCD
2.Type-2 SCD
3.Type-3 SCD
1.Basic Concepts in SQL
2.Overview of ETL Tool Architecture
3.White Box and Black BOX Testing Functionality on Different Transformation Rules
4.Data Ware House Life Cycle
5.Different Types of Testing Techniques in ETL
6.Minus Queing
7.Count Queing
ETL Testing Concepts
Introduction
1.What is use of testing
2.What is quality & standards
3.Responsibilities of a ETL Tester
Software development life cycle
1.Waterfall model
2.V-model
3.Agile model & methodology
4.Prototype model
5.Spiral model
Testing methodologies
1.White box testing
2.Black box testing
3.Grey box testing
4.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