Section A : Data warehouse and ETL Concepts

• Database Concepts and SQL

• Queries:Joins, Simple, Complex and Co-related queries

• What is Dataware House

• Characteristics of the Dataware House

• OLTP Vs OLAP

• Dimension Table Vs Fact Table

• Types of Source Files

• Advantages of Dataware House

• Meta Data

• Dataware House Vs Data Mart

• Data Extraction

• Data Transformation(Different Transformation rules)

• Data Loading

• SCD (Type-1,Type-2 and Type-3)

• Introduction of ETL Tool

• Overview of ETL Tool Architecture

• ETL Tool Environment

• Approaches of DW or ETL

• Database Designs(Star Schema, Snowflake Schema etc)

Section B : DatawareHouse (ETL) Testing Process

• Software development life cycle and Testing Life Cycle

• Data Ware House(ETL) Test or Work Flow Process

• ETL Testing Work Flow Process

• ETL Testing Introduction

• What is use of testing?

• What is quality & standards?

• Responsibilities of a ETL Tester

• Risks and Challenges of ETL Testing

• Resume Preparation and Interview Tips

• Q & A

Section C: Data warehouse (ETL) Test Preparation

• Understanding of Source files and Target

• ELT Testing methodologies and Test Techinques

• ETL Test approach

• Types of Testing

• ETL Testing Work Flow Process

• How to Prepare ETL Test Plan

• How to design Test cases in ETL Testing.

• DW(ETL) Test Environment Setup

Section D: Data warehouse (ETL) Test Execution and Results and Report

• How to perform DW (ETL) Testing.

• Testing the Requirements and Functional Design

• Different phases in DW(ETL) Testing

• Data validation in Source and Target

• How to apply Transformation rules in ETL Test execution.

• How to reporting the Bugs in ETL Testing

• How to detect the bugs through database queries

• ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;

• Automation for ETL Test Execution.

• Tools: SQL and TOAD

• How to Report DW(ETL) Test Execution Status: Daily Vs Weekly