Professional Traning on Datawarehousing - ETL Testing

Duration: 40 Hours
Prerequisites
Basic knowledge of Software Testing.
Course Content

1. Module I (Database/SQL)
Database Overview
DBMS, RDBMS, ORDBMS
Why Database Required
SQL Overview
DDL, DML, DCL, TCL
Data types
SELECT Statement
Restricting and Sorting Data
Aggregating Data using Group Functions
Creating and managing Tables
Manipulating Data
Sub queries
Important Functions
Joins and different types
Views
Index
Synonym
Constraints
Set Operator
2. Module II (UNIX/LINUX)
Overview of UNIX Operating System
Basic commands and concepts
Command Manuals
Regular Expressions
Input/Output Redirection
Piping
Filter
Details explanation of File Attributes
Job Scheduling
Archive/Compress File
Environment variables
Basic of Editor : vi, sed
Quoting and Escape Mechanism
Types of Variables
Operator
Shell Arithmatic
How to to write, execute and debug Shell Script Program

3. Module III (Datawarehousing Concepts)
What is Datawarehouse ?
Why Datawarehouse require ?
DWH Architecture
DWH Characteristics
Data Mart and types
DM vs DWH
Common Datawarehouse tasks
Data cleansing
Partitioning
Staging area
Metadata
OLTP, OLAP, ROLAP, MOLAP
Surrogate Key
Dimension Modeling
Facts and Dimensions
DWH Schema designing
Advantages of Datawarehouse
Star Schema, Snow-flake Schema, Galaxy Schema
OBIEE/BI Overview
Overview of Reports
4. Module IV (ETL Concepts)
Types of Source Files
Data Extraction
Different types of Transformations
Data Loading
Slowly Changing Dimension
SCD (Type-1, Type-2 and Type-3)
Introduction of ETL Tool
Overview of ETL Tool Architecture
ETL Tool Environment
5. Module V (Informatica Power Center Tool)
How developers work on Power Center
Different components of Power Center and uses
Tasks developed in different components
Mapping, Session, Worklet, Workflow, Mapplet