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.

Gallery (11)

+4 more

About the Trainer

5 Avg Rating

29 Reviews

41 Students

5 Courses

Sagar

MCA

13 Years of Experience

---------------Less Theory More Practical-------------

-- 10+ years of Real time working experience in ETL/DWH/BI testing in software industry.
-- Strong experience in working with various ETL projects(Data Centric, Data warehouse, Data Migration, Data Masking, etc) using ETL/BI tools (Informatica, SSIS, OBIEE, SSRS, etc).
-- 7+ years of Classroom/Online Training experience on ETL/DWH/BI testing and trained over 2000+ students with Real time ETL projects.