Course Content
Data Warehousing Concepts
- Data Warehouse Concepts, Design.
- Need of Data Warehouse.
- Introduction to OLTP, ETL and OLAP Systems.
- Data Warehousing Architecture.
- Dimensional Modeling.
- Data Marts and ODS.
- Star Schema and Snowflake Schema.
- SCD (slowly changing dimension).
- Types of Fact and Dimension Tables.
SQL Concepts
- Introduction to Oracle.
- Basic Concepts in SQL.
- Data Types.
- Select statement usage.
- Joins.
- Sub Queries.
- Performance Tuning Tips & Tricks.
- ETL Testing - Introduction
- Introduction to ETL.
ETL Architecture.
- What is the use of testing?
- What is quality & standards?
- Responsibilities of ETL Tester.
- Sub Queries.
- Performance Tuning Tips & Tricks.
ETL Testing - Procedure
- Steps in DWH Testing
- Prerequisites of DWH Testing.
- Levels of DWH Testing
- The Data Warehousing process
- Coverage of ETL Testing
- How DWH Testing is Different from Application Testing?
- Challenges in DWH Testing
Testing Methodologies.
- ETL Testing WorkFlow Process.
- How to Prepare the ETL Test Plan.
- How to design the Testcases in ETLTesting.
- How to report the Bugs in ETL Testing.
- ETL Testing Responsibilities.
- How to detect the bugs through database queries.
- ETL Performance Testing
BO and Reports
- Overview
- Reports Testing Process
- Components of BO Testing
Query and tools
- Informatica, Datastage, Cognos etc.
