Search for Training

ETL Testing Essentials

Course Overview

ETL Testing Essentials course is a mix of case driven, instructor-led, and self paced learning, designed to enable participants learn, experiment and implement the concepts involved in ETL/Data Warehouse Testing. The participants will be presented with ample examples, exercises and case studies to understand and apply the concepts taught.

Course Content

Understanding Data Base Concepts and Online Transaction Processing(OLTP)

  • Introduction OLTP-Databases Modelling Concepts.
  • ERD - Entity Relationship Diagrams
  • Logical and Physical Schema for Database Design
  • Database Constraints - Primary , Foreign Key , Unique Keys,Surrogate Keys
  • Advanced SQL Statements
  • Views and Materialized Views
  • Meta Data and Operational Data
  • Hands on Excises

Understanding Data Warehouse Concepts(OLAP)

  • Need/Business Drivers Data warehouse
  • Data Warehouse - Characteristics
  • Data Modelling - Fact , Dimensions, Star , Snowflake Schemas
  • Design and Building - Fact and Dimensional Modelling - A CASE STUDY

Understanding Extract, Transform and Load(ETL)

  • Introduction to ETL and its Components
  • Landing Zone
  • Data Profiling
  • Data Quality / Reconciliation
  • Transformation Rules
  • Staging Databases
  • Loading to Reporting/Final Data Warehousing

Introduction to Test Case ,Test Design - Different Type of Testing

  • Understanding of Data Transformation, Mapping and Business Rules
  • Understanding of Data Centric Testing
  • Test Case and Test Design Methodology
  • Categorization of Testing based on objectives of testing and reporting
  • Database testing and data Warehouse Testing - A comparision
  • Testing Approach, planning and Strategy

Case Study and Hands On

  • Test case design based on mapping and business rulesdocument
  • Test Execution
  • Test Reporting
  • Summary and Learing


  • Introduction to ETL TOOLS

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 8 + 3? (security question)

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234

Subscribe to our weekly newsletter