ETL Testing Training

Share course

PSN Trainings is the Best ETL Testing Online Training institute in Hyderabad,Bangalore,india

Course Description

Data warehouse and ETL Concepts

  • Database Concepts and SQL
  • Queries:Joins, Simple, Complex and Co-related queries
  • What is Dataware House
  • Characteristics of the Dataware House
  • Dimension Table Vs Fact Table
  • Types of Source Files
  • Advantages of Dataware House
  • Meta Data
  • Dataware House Vs Data Mart
  • Data Extraction
  • Data Transformation(Different Transformation rules)
  • Data Loading
  • SCD (Type-1,Type-2 and Type-3)
  • Introduction of ETL Tool
  • Overview of ETL Tool Architecture
  • ETL Tool Environment
  • Approaches of DW or ETL
  • Database Designs(Star Schema, Snowflake Schema etc)

DatawareHouse (ETL) Testing Process

  • Software development life cycle and Testing Life Cycle
  • Data Ware House(ETL) Test or Work Flow Process
  • ETL Testing Work Flow Process
  • ETL Testing Introduction
  • What is use of testing?
  • What is quality & standards?
  • Responsibilities of a ETL Tester
  • Risks and Challenges of ETL Testing
  • Resume Preparation and Interview Tips
  • Q & A

Data warehouse (ETL) Test Preparation

  • Understanding of Source files and Target
  • ELT Testing methodologies and Test Techinques
  • ETL Test approach
  • Types of Testing
  • ETL Testing Work Flow Process
  • How to Prepare ETL Test Plan
  • How to design Test cases in ETL Testing.
  • DW(ETL) Test Environment Setup

Data warehouse (ETL) Test Execution and Results and Report

  • How to perform DW (ETL) Testing.
  • Testing the Requirements and Functional Design
  • Different phases in DW(ETL) Testing
  • Data validation in Source and Target
  • How to apply Transformation rules in ETL Test execution.
  • How to reporting the Bugs in ETL Testing
  • How to detect the bugs through database queries
  • ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
  • Automation for ETL Test Execution.
  • Tools: SQL and TOAD
  • How to Report DW(ETL) Test Execution Status: Daily Vs Weekly

Key Highlights


  • PSN Trainings is a leading online training provider across the globe. Our online training team is highly qualified, experienced and skilled with real time      industry experience.

PSN Trainings Highlights:


  • Instructor Led Online Courses  with 24x7 On-Demand Support
  • World Class Trainers with +12 years Industry Experience. Instructors are not just trainers they are Consultants
  • We provide  24/7 Server access to help our trainees practice exercises
  • Teaching Material Prepared by Experts from PSN Trainings who have real time experience
  • Hands on Lab Assignments
  • 100% Placement Assistance
  • Project Based learning to get hands-on experience on a real life application!
  • Providing high quality interactive and cost effective online Training
  • Live Interactive classes by industry experts.

Trainer Information:

  • Having 10  years of  IT Industry Experience
  • 6  years  of ETL Testing Real Time  Experience
  • Having  4 years experience  as an online trainer for ETL Testing
  • Held up to 50+ batches in past 4 years
  • Trainer has an excellent practical & industrial knowledge