ETL testing Online for freshers by Acharya IT

ETL Testing Concepts by Dinesh

DataWareHousing 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

SCD(slowly changing dimension)

Type-1 SCD

Type-2 SCD

Type-3 SCD
Informatica tool
Transformations

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
. Informatica Transformations and their functionality

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

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

Basic Unix concepts