ETL Testing Training

Module 1 – Introduction to Data
Warehousing

Database management and tools

How to implement data warehousing?

Why data warehousing is important?

OLTP and OLAP database

Introduction to OLTP, ETL and OLAP
Systems

Data Warehouse Architecture

ODS [Operational Data Store]

Star Schema and Snowflake Schema

What is fact table

What is Dimension table

Normalization and De-Normalization

Module 2 – Overview of ETL

Data Acquisition

Data extraction

Data transformation

Data Loading

Data mart

Data Modeling

Module 3 – Database management
System

Bid Data (Hadoop)

Oracle

SQL in RDBMS

DDL, DML and working with SQL
Queries

Hadoop Distributed file system

Hbase

Apache Pig

Sqoopsss

Microsoft Excel and VBA

Module 4 – ETL Testing

ETL architecture.

What is ETL and importance of ETL
testing

Incompatible and duplicate data.

Loss of data during ETL process.

Fault in business process and
procedures.

ETL Testing Work flow activities
involved

Execute system testing and
integration testing.

Best practices to Create quality
documentations (Test plans, Test Scripts and Test closure summaries)

How to detect the bugs in the ETL
testing

How to co-ordinate with developer
team for resolving the defects

Module 5 – Types of ETL Testing

Production validation testing

Metadata testing

Data completeness testing

Data accuracy testing

Data transformation testing

Data quality testing

GUI/Navigation Testing

Module 6 – Data completeness

Data transformation and Data
quality.

Performance and scalability.

Integration testing.

User-acceptance testing.

SQL Queries for ETL Testing

Incremental load testing

Initial Load / Full load testing

Different ETL tools available in
the market

Duplicate check

Date validation

ETL Bugs

Difference between ETL Testing and
Database testing

Module 7 – Responsibilities of
an ETL Tester

Business transformation logic

ETL software

Test components of ETL warehousing

Create, design and execute test
cases

Identify problems and provide
solutions

Write SQL queries for different
scenarios