ETL Testing Online Training

ETL Online Training Course Content

Data Warehousing Concepts:

  • What is Data ware House?
  • Data warehouse Architecture
  • Characteristics of Data warehouse What is OLTP & OLAP
  • Different between OLTP&OLAP

Data Acquisition

  • Data Extraction
  • Data Transformation
  • Data Loading

Data Marts

  • What is Data Mart ?
  • How it is different from a Data warehouse
  • Types of Data Mart

Data Base Design

  • Star Schema
  • Snow Flake Schema
  • Fact constellation Schema

SCD (Slowly Changing Dimension)

  • What is SCD ?
  • Type-1_SCD
  • Type-2_SCD
  • Type-3_SCD

Basic Concepts in SQL

  • Overview of ETL Tool Architecture
  • White Box and Black BOX Testing
  • Functionality on Different Transformation

Difference between Database and Data warehouse Testing

Data Ware House Testing Life Cycle

Different Types of Testing Techniques in ETL

  • Unit testing
  • Integration testing
  • System testing
  • Regression testing
  • Acceptance testing
  • Performance testing

ETL Testing Concepts :


  • What is Extraction
  • How to do extraction from different sources
  • How to transform the data according to business rules
  • How to load the data in target database What is use of testing
  • What is quality & standard
  • Responsibility of a ETL Tester

ETL Test Plan Preparation

  • How to Prepare ETL Test Plan
  • Preparation of test plan Format
  • ETL testing plan

Test Execution Process

  • ETL test case Format
  • Test case
  • Execution

ETP Process Steps

  • Define Requirement
  • Create Physical Design
  • Walkthrough ETL process
  • Coordinate move to QA Test process
  • User validates Data

Bug Tracking

  • ETL bug Reporting and Tracking
  • Bug format and test results

ETL Testing Types

  • Database testing
  • Batch job testing inbound & outbound Data Migration testing
  • Report testing

ETL Testing Challenges

List of ETL tools

Report Testing

Software development life cycle

Waterfall, Spiral, Prototype, RAD, Iterative and incremental and Agile

Enroll for Online Training