Data Warehouse / ETL Testing

Have Queries? Ask us +91 72592 22234

Course Overview

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Data Warehouse / ETL Testing which gives you the opportunity to interact with a Data Warehouse / ETL Testing instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content

Data Warehousing Concepts

  • Data Warehouse Concepts, Design.
  • Need of Data Warehouse.
  • Introduction to OLTP, ETL and OLAP Systems.
  • Data Warehousing Architecture.
  • Dimensional Modeling.
  • Data Marts and ODS.
  • Star Schema and Snowflake Schema.
  • SCD (slowly changing dimension).
  • Types of Fact and Dimension Tables.

SQL Concepts

  • Introduction to Oracle.
  • Basic Concepts in SQL.
  • Data Types.
  • Select statement usage.
  • Joins.
  • Sub Queries.
  • Performance Tuning Tips & Tricks.
  • ETL Testing - Introduction
  • Introduction to ETL.

ETL Architecture.

  • What is the use of testing?
  • What is quality & standards?
  • Responsibilities of ETL Tester.
  • Sub Queries.
  • Performance Tuning Tips & Tricks.

ETL Testing - Procedure

  • Steps in DWH Testing
    • Prerequisites of DWH Testing.
    • Levels of DWH Testing
  • The Data Warehousing process
    • Coverage of ETL Testing
    • How DWH Testing is Different from Application Testing?
    • Challenges in DWH Testing

Testing Methodologies.

  • ETL Testing WorkFlow Process.
  • How to Prepare the ETL Test Plan.
  • How to design the Testcases in ETLTesting.
  • How to report the Bugs in ETL Testing.
  • ETL Testing Responsibilities.
  • How to detect the bugs through database queries.
  • ETL Performance Testing

BO and Reports

  • Overview
  • Reports Testing Process
  • Components of BO Testing

Query and tools

  • Informatica, Datastage, Cognos etc.

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

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234