ETL Testing Course Content
ETL Testing Overview
Introduction to ETL testing, life cycle of ETL Testing, database concepts, ETL in Business Intelligence, understanding the difference between OLTP and OLAP, data warehousing.
Hands-on Exercise – Create OLTP and OLAP database
Database Testing and Data Warehousing Testing
Introduction to RDBMS, Relational database concepts, distinction between database and data warehousing testing, integrity constraints.
Hands-on Exercise – how to test data warehousing testing, integrity constraints
ETL Testing Scenarios
The data warehouse workflow, ETL Testing scenarios, ETL Mapping, Data Warehouse Testing, Data Mismatch & Data Loss Testing.
Hands-on Exercise – Create a data warehouse workflow, Create ETL Mapping
Correctness, Completeness, Quality, Data Validation
Introduction to various testing scenarios, structure validation, constraint validation, data correctness, completeness, quality, data validation, negative testing.
Hands-on Exercise – Create tests as per testing scenarios, Validate structure of the software, Do constraint validation, Check data correctness and completeness, Validate data, Perform negative testing
Data Checks with SQL
Using SQL for checking data, understanding database structure, working with SQL Scripts
Hands-on Exercise – Write SQL Scripts for checking data
Reports & Cube testing
Reports and Cube Testing, scope of Business Intelligence Testing.
Hands-on Exercise – Identify ETL testing Scope-Generate Reports, Test Cubes
ETL Testing Project
Project – Testing Cube
Data – Sales
This ETL testing project will provide you expertise to learn ETL Testing with hands-on experience in testing of a multidimensional cube of sales data that includes sales for five years for multiple products. Some of the steps you will be performing in the testing of the cube are validating the dimensions and connections, selecting and matching the data, verifying the dimension hierarchies, validating measures in association with dimension attributes, matching with external interface specification file data and so on.