ETL testing Course


ETL testing Course Overview

ETL- Extract, Load, Transform as the name implies is all the processes and technologies that revolve around finding the data, formatting it as needed and loading it to the relevant database systems for retrieval and usage. Data’s importance and its key role in the current day’s market is no secret. It is extremely important more than before to make sure that the ETL processes around the data are reliable, accurate and productive in order to ensure that the Business intelligence and data warehouse systems are everything they are supposed to be. 

The course includes topics related to the foundation of  Data Warehouse with the concepts, Dimensional Modeling and important aspects of Dimensions, Facts and Slowly Changing Dimensions along with the DW/BI/ETL set up,  Database Testing Vs Data Warehouse Testing, Data Warehouse Workflow and Case Study, Data Checks using SQL, Scope of BI testing and as a bonus you will also get the steps to set up the environment with the most popular ETL tool Informatica to perform all the activities on your personal computer to get first hand practical knowledge. 

ETL testing is done to ensure that the data that has been loaded from a source to the destination after business transformation is accurate. It also involves the verification of data at various middle stages that are being used between source and destination. ETL stands for Extract-Transform-Load.

BI/ETL Developers, Testers who want to get job on ETL Testing, to get more salary and also who want to get job quickly. IT professionals with very basic knowledge on Database concepts

Individuals must have Basic RDBMS Concepts, ETL Fundamentals, and Data Warehouse Concepts to take up the course.

After completion of course you will get jobs as Test analyst, Automation tester in the companies like cognizant, amazon, flipkart, delta technologies, ANZ bank and more.

The main concepts covered in the course are Business understanding, Test plan creation, Test environment setup, Test script generations Purpose of Data warehouse, Tools used to Load data into the data warehouse, About Data warehouse Testing, Need for ETL Testing

ETL testing Course Syllabus

Purpose of Data warehouse

Tools used to Load data into the data warehouse

About Data warehouse Testing

Need for ETL Testing

ETL Testing phases

  • Business understanding
  • Test plan creation
  • Test environment setup
  • Test script generations
  • Execution
  • Reporting

How is ETL Testing different from normal Testing?

How to ensure no data loss

Transformation Rules

Data validation Strategies

  • Data file loads
  • Data validation with in staging tables to check all Mapping rules
  • Data validation with in Target tables to ensure data is present in required format

Staging Area

  • Test approach and procedure in staging area

SOR Area

  • Test approach and procedure in SOR area

Datamarts Area

  • Test approach and procedure in Datamarts area
  • Live project examples of ETL Testing with Data stage ETL Tool
  • Most commonly used SQL oracle queries useful in ETL Testing