Etl testing

ETL TESTING COURSE CONTENT

Data Ware Housing Concepts:

What is Data Ware House?

Difference between OLTP and Data Ware Housing

Data Extraction

Data Transformation

Data Loading

Data Marts

Dependent Data Mart

Independent Data Mart

Data ware housing Approaches

Top Down Approach

bottom up Approach

Data Base Design

Star Schema

Snow Flake Schema

SCD(slowly changing dimension)

Type-1 SCD

Type-2 SCD

Type-3 SCD

Basic Concepts in SQL

SQL Concepts

Overview of ETL Tool Architecture

Testing Functionality on Different Transformation Rules

Data Ware House Life Cycle

Different Types of Testing Techniques in ETL

ETL Testing Introduction

What is use of testing

What is quality & standards

Responsibilities of a ETL Tester

Software development life cycle

Understanding various documents such as Business Requirement Document,

Design Documents, Mapping sheets

Testing methodologies

Types of 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