ETL/DWH/BI TESTING COURSE CONTENT
SQL - MS SQL SERVER - Hand's on |
- Introduction to SQL
- SQL Server Installation & High level overview
- Hands on Exercises on below topics (200 SQL Queries)
- DDL & DML Statements
- SQL Operators, Union, Intersect & Except
- Integrity Constraints & Built in Functions
- Case Statements & Sub Queries
- Group By, Having & Order by Clauses
- Joins (Inner Join, Outer Joins & Self Join)
- Views, Stored Procedures & Functions
Data Warehousing Concepts |
- Introduction to Data Warehouse
- Difference between Database & DWH
- What is Dimensional Modeling and how it is different from ER Modeling
- What is Dimension & Fact table
- Star Schema Model vs. Snow Flake Schema Model
DWH: Hands on DIM & FACT tables |
- How to Design/Create DIM & FACT tables based on Source system
- Hand's on Dimension & Fact tables data loading (Multiple exercises)
SCD (Slowly Changing Dimension |
- What is SCD (Slowly Changing Dimension?
- Hands on Exercise (Real time Scenario's)
- SCD Type 1
- SCD Type 2
- SCD Type 3
ETL Testing: Introduction & Hand's on |
- Different types of ETL Testing Projects in Real world & Popular ETL tools
- ETL Testing Architecture and how it differs from DB Testing
- What is Data Mapping Document
- Test Scenario's/Test Case/ Test Data Preparation using Data Mapping Document
- How to validate Initial & Delta loads with examples.
- How to report the Defects in ETL Testing?
ETL Tool : Informatica Hand's on |
- Introduction to Informatica PowerCenter
- Informatica PowerCenter Client Tools
Repository Manager
Designer
Workflow Manager
Workflow Monitor
- Informatica Terminologies(Mapping, Task, Transformations & Workflow
- Different types of Transformations in Informatica
Aggregator, Expression, Filter & Joiner Transformation
Lookup, Rank, Router, Sorter Transformation
Source Qualifier Transformation, etc
- Informatica Hand's on
How to Create & Run Mapping/Workflow
How to Establish Connections to Databases
How to Debug issues using Session/Workflow Logs
Real Time Project's - Hands on |
- ETL validations when Source & Target DB are Same
- ETL validations when Source & Target DB are Different
- ETL validations when working on Flat files
- ETL validations when working on DWH(DIM & Fact tables)
ADD on’s |
- Resume Preparation & 100 + Real time Interview Questions
- Reporting/BI Tool : Microsoft Power BI
- Introduction to DATA SCIENCE
Duration: 45 Hrs.