ETL Testing

ETL Testing Training 

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
  • OLTP Vs OLAP
  • 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)

Data warehouse (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

Comments are closed