Testing Tools

ETL Testing Training

ETL is the process of extracting data from heterogeneous sources, transforming it in order to make it fit for operational needs and finally loading it into the end target. ETL testing is different from conventional training as it involves handling of incompatible, duplicate, complex & voluminous data.

ETL testing online training

is primarily aimed at identifying and mitigating existing data defects and general errors occurring prior to the processing of data for analytics and reporting.

We all know that data plays a very important role in helping business for making the critical business decisions. ETL testing plays a significant role in validating and ensuring that the business information is exact, consistent and reliable. It also minimizes hazard of data loss in production. Let’s have a look at the ETL training course offered by BestOnlineTrainers.

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile

ETL Testing Training Course Details

Dataware Housing Concepts

  • What is Data Ware House
  • Difference between OLTP and DataWare Housing

Data Acquisition

  • Data Extraction
  • Data Transformation
  • Data Loading

Data Marts

  • Dependent Data Mart
  • Independent Data Mart

Data Base Design

  • Star Schema
  • Snow Flake Schema
  • Fact constellation Schema

SCD (slowly changing dimension)

  • 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

Data Ware House Life Cycle

Overview of ETL Tool Architecture

Components in ETL Tool

Different Types of Testing Techniques in ETL

  • Minus Querying
  • Count Querying

SCD (slowly changing dimension)

  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD

Testing Introduction

  • QA&QC
  • Verification & Validation
  • Software development life cycle
  • Quality standards
  • Testing Types

Testing Levels

Software Development Life Cycle

  • SDLC Proces
  • SDLC models analysis
  • Software Testing Life Cycle (STLC)
  • Testing Vs SDLC
  • Web Development Life Cycle
  • Manual Defects Analysis
  • BUGS Life Cycle
  • Severity and Priority of BUGS
  • BUG report
  • Types of BUGS
  • Manual Testing Documents

Test Plan Preparation Content

  • Master Test Plan Content
  • Test Strategy and Methodology
  • Rules
  • Designing Test Cases Techniques
  • Manual Testing FAQ's
  • ETL Testing Concepts


  • What is use of ETL TESTING?
  • Responsibilities of a ETL Tester

Software development life cycle

  • Waterfall model
  • Agile model & methodology
  • Prototype model
  • Spiral model

Testing methodologies

  • White box testing
  • Black box testing
  • Grey box testing
  • ETL Testing Work Flow Process
  • How to Prepare the ETL Test Plan
  • How to design the Test cases in ETL Testing.
  • How to reporting the Bugs in ETL Testing?
  • ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning

Documentation for ETL Testing Projects

Work procedure with Automation Tools for ETL Testing

White Box and Block Box testing functionality in different transformation rules:

  • SAMPLE Loading from source to target
  • SORTER Transformation
  • FILTER Transformation
  • ROUTER Transformation
  • EXPRESSION Transformation
  • JOINER Transformation
  • UNION Transformation
  • AGGREAGATOR Transformation
  • RANK Transformation
  • STORED PROCEDURE Transformation
  • SEQUENCE GENERATOR Transformation
  • Flat File
  • SQL Transformation
  • Look up Transformation
  • SCD type 1
  • SCD Type 2
  • SCD Type 3
  • Update Strategy
  • XML Source Qualifier
  • Types of load (Full, incremental, Refresh)

Project Explanation

  • Projects on Different Domains (Banking, Health Care, Telecom, Insurance)


Resume Preparation

ETL testing training is intended for:

  • IT professionals who are looking to advance their career in ETL testing or looking for a change in career path or want to learn a new skill set
  • Students who want to make their career in Software Quality Assurance/Testing

We guarantee learning at your convenience & pace.

  • Instant Access:
    Get instant access to self-paced training after signup.
  • Streaming video recording:
    Watch lessons any time at your schedule, free recording.
  • Exercises:
    Practical exercises help you test what you are learning as you go.
  • Free Demo:
    Sign up for free demo to check whether the course is right for you and interact with the faculty live.
  • Experienced Trainers:
    We only hire the industry’s best trainers
  • Live free interactive web sessions:
    Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
  • Structured Curriculum Schedule:
    Progress with your complete daily interactive lessons and assignments.
  • Faculty Mentoring:
    Turn in daily and weekly homework for personalized feedback from faculty.
  • Virtual Office Hours:
    Live interaction with the faculty and other students around the world.
  • Hands on Live Projects:
    Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.


You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:


Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K