ETL Testing Course Overview

An ETL Testing tool extracts the information from various information sources, transforms the information (like applying calculations, linking fields, keys, and eliminating incorrect information fields, etc.), and loads it into an Information Warehouse. That is an introductory tutorial which explains all of the essentials of ETL testing.

Extracts the information from the transactional system that may be an Oracle, Microsoft, or some other relational database,

Transforms the information by performing data cleanup operations, and then

batch the data in the OLAP information Warehouse.

ETL Process

Extracting the Data

It entails extracting the information from different heterogeneous information sources. Data extraction in a transactional system change as per the requirement along with the ETL tool being used. It’s normally achieved by running scheduled tasks at off-business hours such as running tasks during the night or on the weekend.

Changing the Information

It entails altering the information into a suitable format which will be readily loaded to a DW program. Data conversion entails applying calculations, combines, and specifying primary and foreign keys to the information. By way of instance, if you would like percent of overall earnings that isn’t in database, you also may apply % formulation in conversion and load the information. In the same way, if you’ve got the first title and the last name of consumers in different columns, then you are able to employ a concatenate operation prior to loading the information. Some information does not require any conversion; such information is called direct transfer or even pass via info.

Data conversion also entails data correction and cleanup of information, eliminating incorrect information, incomplete data creation, and repairing data errors. Additionally, it includes data formatting and integrity unsuitable data prior to loading it in a DW program.

It entails loading the information into a DW platform for analytic reporting and information. The target system may be a straightforward delimited flat file or a data program.


Course Objectives

ETL Tool Function

A normal ETL tool-based information warehouse utilizes staging area, information integration, and accessibility layers to perform its purposes. It is generally a 3-layer structure.

  • Data Integration Layer − The integration coating transforms the data in the staging coating and transfers the information into a database, in which the information is organized into hierarchical groups, frequently referred to as measurements, and to data along with aggregate details. The combination of dimensions and facts tables at a DW process is referred to as a schema.
  • Access Extension − The access layer is utilized by end-users to recover the information for analytic reporting and information.

ETL testing is completed prior to data is transferred to some production data warehouse program. It’s different from database analyzing concerning its scope and also the measures to be taken to finish this.

The most important aim of all ETL testing will be to identify and mitigate info defects and overall mistakes which happen before processing of information for analytical coverage.


  • Introduction
  • Tasks
  • ETL vs Database Testing
  • Categories
  • Challenges
  • ETL – Tester’s Roles
  • Techniques
  • Process
  • Scenarios(Test Cases)
  • Performance
  • Scalability
  • Data Accuracy
  • Metadata
  • Data Transformations
  • Data Quality
  • Data Completeness
  • Backup Recovery
  • Automation