ETL Testing Course Content
(Manual Testing + SQL Server Programming + PowerBI)
Eligibility:
 IT or Non-IT Background
 Manual Testers
Pre-Requisites:
 Manual Testing (Knowledge)
 SQL Programming (Basic)
 Passion in Data Analysis
ETL Overview:
 What is ETL?
o Extraction
o Transformation
o Validation
o Load
o ETL Developer vs ETL Tester roles
 Data warehouse vs Data Mart vs Data Lake
o Data Lake characteristics
o Data Warehouse characteristics
o Data Mart characteristics
o OLTP vs OLAP
o Storage of Data in each form
o Star and Snowflake schema
o SCD Types implementation on DWH
 What is ETL Testing
o Data accuracy check
o Data completeness check
o Data transformation check
o Data correctness check
 ETL Testing vs Database Testing**

o What is Database Testing
o How data quality is maintained with ETL testing
o How data quality is maintained with Database testing
o Skill set needed for Database testing and ETL testing.
ETL Testing – Deep Dive IN:
 Manual Testing
o Fundamentals of Software Testing
o Test process and Methodologies
o Test case design and documentation
o Functional vs Non-Functional vs Regression
o Defect Management
o Test Data management
o Test Management Tools
o Test environment setup
o Test reports
 SQL Programming**
o MS SQL Server Installation
o Datatypes and Functions (String function, Date Time function etc.)
o Filtering, Sorting, Aggregate functions, and Grouping
o Insert, Update, Delete
o Creating and Modifying tables
o Constraints
o Joins & Views
o Stored procedures and its importance
o SSIS & SSRS basic understanding
 ETL Testing**
o ETL Testing objectives and goals.
o Test case preparation & ETL Testing Techniques
o Types of ETL Testing (Migration & Validation)
o Challenges in ETL Testing
o ETL Test environment setup
o Data Extraction Testing (Source Data verification, Data
completeness testing, Data accuracy and Data quality testing,
Handling incremental data extraction)

o Data Transformation Testing (Data cleaning, Data consolidation,
Business rules and Data validation, Error handling & exception
handling)
o Data validation and Data Loading (Loading data into Target/DWH,
Data consistency and Integrity checks)
o Performance Testing (ETL Job scheduling and Monitoring,
Indexing)
o Regression Testing in ETL
o ETL Security Testing
o Defect Management
 Tools for ETL testing
o SSIS, Talend, Informatica Power Center and SQL SPs
Other Testing Concepts:
 API Testing
o API Types
o API Terminology
o API Testing tools
o API Response validation
 Performance Testing (ETL Point of view)
o ETL Performance Test Scripting
o Load Testing in ETL
o Stress Testing in ETL
 Unix Basics
o File handling
o Text processing
o Job scheduling
Real Time Projects:
 Project 1**
 Project 2**
Reporting Tool:
 Power BI

o How to connect to multiple Data sources in PowerBI and generate
a report.
o Create a Basic Power BI dashboard with Data validation and
Analysis.