Professional Training on Datawarehousing ETL Testing

Duration: 7-8 Weekend
Prerequisites
Knowledge of Manual Testing
Knowledge of DBMS/SQL basics is advantageous.
Course Content

I. Database/SQL
RDBMS Concepts
o Data Models
o Entity Relationship Model
o Normalization
o DBMS, RDBMS, ORDBMS
SQL Overview
o Introduction to SQL
o Data types
o SELECT Statement
o Operators
o Pseduo Column
SQL Statements
o Data Definition Language (DDL)
o Data Manipulation Language (DML)
o Transaction Control Language (TCL)
o Data Control language (DCL)
Join
o Inner/Equi Join
o Non-Equi/Cross Join
o Self Join
o Outer Join
Constraints
o Primary Key Constraint
o Foreign Key Constraint
o Unique Key Constraint
o Not Null Constraint
o Check Constraint
Set Operator
o Union
o Union All
o Intersection
o Minus
Sub Query
o Sub/Inner Query
o Correlated Sub Query
Object
o Index
o Synonym
o View
Built-in Functions
o Aggregate Functions
o Character Function
o String Functions
o Case Manipulation Functions
o Date Functions
o Analytical Functions

II. Datawarehouse/ETL
Datawarehouse Fundamental
o Datawarehouse Overview
o DWH Characteristics
o Types of Datawarehouse
o Data Mart
o Database vs Data Warehouse
o Data Mart vs Data Warehouse
o Data Warehouse benefits
o DWH Architecture
Datawarehouse Terminologies
o Data Cleansing, Partitioning
o Staging area, Metadata
o OLTP, OLAP, ROLAP, MOLAP
o Surrogate Key
o Snapshot, View and Materialized View
o Meta Data, Data Mining & Data Cube
Dimension Modeling
o Facts and Dimensions
o Hierarchies and Levels
o Measures & DWH Schema
o Star, Snow-flake and Galaxy Schema
o Additive, Semi Additive, Non Additive Fact/Measure
ETL Overview
o Process Flow of ETL
o Types of Sources and Target
o ETL Data Load types
o Active vs Passive transformation
o Extraction Methods in ETL
o Tracing Level
o Types of Data used for ETL Process
Slowly Changing Dimension
o What is Slowly Changing Dimension?
o SCD Types : Type-1, Type-2, Type-3
ETL Testing Process
o Categories of ETL Testing
o Types of ETL Testing
o How to create ETL Test Case
o ETL Test Scenarios and Test Cases
o Types of ETL Bugs/Defects
o Responsibly of ETL Tester
OBIEE/BI Overview
o Introduction to OBIEE
o Business Intelligence Basics
o Overview of Reports
o Slice and Dice
o Roll-up and Drill-down & Pivot
III. Informatica Power Center Tool
Informatica Tool Overview
o Introduction to Informatica
o How developers work on Power Center
o Different components of Power Center and uses
o Tasks performed in different Components
o Mapping, Session, Worklet, Workflow, Mapplet
o Naming Conventions
Designer Component
o Working with Sources
o Working with Flat Files
o Working with Targets
o Data Transformation Source and Target
o Mapping Parameters and Variables
o Uses of Mapping Wizards
Workflow Manager Component
o Workflow Manager Overview
o Workflow Designer
o Task Developer
o Worklet Designer
o Using Workflow Wizard
o Creating a Task
o Configuring Task
o Workflow links
o Validating Tasks,Workflows
o Scheduling and Running Workflows
Workflow Monitor Component
o Workflow Monitor Overview
o Using Workflow Monitor
o Working with Tasks and Workflows
o Workflow and Task Status
o Using Gantt Chart and Task Views
o Session and Workflow Logs
Transformation
o How to use Transformations
o Aggregator Transformation
o Expression Transformation
o Filter Transformation
o Router Transformation
o Union Transformation
o Rank Transformation
o Sorter Transformation
o Joiner Transformation

IV. UNIX/LINUX
Basics of Unix/Linux
o Overview of UNIX Operating System
o Useful Commands
o Command Manuals
o Regular Expressions
o Filter
o File Attributes
o Job Scheduling
o Archive/Compress File
o Editor : vi, sed
o Processes
o File copy/transfer in UNIX