=====DWH: Data Ware Housing Concepts===
What is Data Warehouse?
Need of Data Warehouse
Introduction to OLTP, ETL and OLAP Systems
Difference between OLTP and OLAP
Data Marts types of Data marts
ODS [Operational Data Store]
Dimensional Modeling & types
Star Schema and Snowflake Schema
What is fact table & types
What is Dimension table & types
Normalization
SCD’s
SCD Type1
SCD Type2 -- Date, Flag and Version
SCD Type3
What is Schema
Data Warehouse Architecture ( BASIC FLOW DIAGRAM)

=====SQL: Structured Query Language=============

(Complete class room execution with tool practice)
DDL, DML, DQL, TCL, DCL
Character Functions
Clauses
Aggregate Functions
Date Functions
Set Operators
Constraints
Joins
Sub-Queries
Analytical Functions
Indexes
Views & Materialized View’s

=======Manual Testing==========

what is software Testing & why it is important
Testing Techniques.
Testing Methodologies
Functional Testing & Types
Non-Functional Testing & Types
SDLC & flow of requirements in details.
STLC & flow of requirements in details.
How to understand Test plan & Test Strategy
How to create Test plan & Test Strategy (Experienced people)
Defect Life Cycle
Agile process and practical Exposure in the classroom

=====PRACTICALS (MANUAL TESTING)==============

How to write Test cases in HP-ALM
How to Execute Test cases
How to log a defect
How to attach the screenshot when raising a defect
How to interact with developers
How to send out emails on EOD status to required people

==================UNIX============
Required commands for ETL

==========ETL CONCEPTS============

What is ETL and importance of ETL testing
ETL Test Strategy
ETL Architecture
INFORMATICA explanation
Types of validation performed in ETL Testing
Challenges in DWH ETL Testing compare to other testing
Incompatible and duplicate data.

Loss of data during ETL process.

Testers have no privileges to execute ETL jobs by their own.

Volume and complexity of data is very huge.

Fault in business process and procedures.

Trouble acquiring and building test data.

Challenges in DWH ETL Testing compare to other testing
Types of ETL Testing
Data completeness.
Data  transformation.
Data quality.
Incremental load testing
Initial Load / Full load testing
Integration testing.
User-Acceptance testing.
=============================================================
How to detect the bugs in the ETL testing
How to report the bugs in the ETL testing
How to co-ordinate with developer team for resolving the defects
==================================================================
Best practices to create quality documentations (Test plans, Test Scripts and Test closure summaries)

=========REATL TIME INFORMATICA EXECUTION==============
Power Center Components
Designer
Repository Manager
Workflow Manager
Workflow Monitor
Power Center Admin Access will be given with installation of Informatica
Informatica Concepts and Overview
=====Sources===
Working with relational Sources
Working with Flat Files
====Targets===
Working with Relational Targets
Working with Flat file Targets
Transformations - Active and Passive Transformations
Expression
Lookup
Sequence Generator
Filter
Joiner
Sorter
Router
Aggregator
Update Strategy
Slowly Changing Dimension
Workflow Manger
Workflows, Worklets  & Sessions
Tasks
Workflow Monitor
Monitoring workflows and debugging errors

==========BI REPORTING=============
what are BI Reports. Why it is important to Business
How to generate reports based on filter conditions
Micro strategy Dashboard Validation
Generating Reports and validating the same data in Database

MOCK INTERVIEWS

RESUME PREPARATION:

Based on the performance in mock interviews resume will be prepared

======REAL TIME PROJECT==========
Project related tables & data will be given and students need to create and practice as per
their requirements given in the documents

Completely Practical project with Real time