DATA WAREHOUSE FUNDAMENTALS

• An Introduction of Data warehousing
• Purpose of Data warehouse
• Data ware Architecture
• OLTP Vs Data warehouse Applications
• Data Marts
• Data warehouse Lifecycle
• SDLC
   

DATA MODELING

• Introduction of Data Modeling
• Entity Relationship Model
• Dimensions and Fact Tables
• Logical Modeling
• Physical Modeling
• Schemas Like Star Schema & Snowflake Schemas
• Fact less Fact Tables

SCD TYPES

• Type 1 SCD
• Type 2 SCD
• Type 3 SCD

PROCESS OF ETL 

• Introduction of Extraction , Transformation and Loading
• Types of ETL tools
• Key tools in the market

ETL TESTING CONCEPTS

• Purpose of testing
• How to maintain quality & standards
• Responsibilities of a ETL Tester

UNDERSTANDING 

• Analysing the Business Requirement Documents
• Understanding Mapping sheets
• Following Job Dependency

SQL CONCEPTS AND CREATING QUERIES

• Basic Select Statements
• Creating Sub queries
• Using Different type of Joins

TESTING METHODOLOGIES

• ETL Testing Work Flow Process
• How to Prepare the ETL Test Plan
• How to design the Test cases in ETL Testing.
• How to reporting the Bugs in ETL Testing?
• ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
• How to detect the bugs through database queries
• ETL Testing & Performance Tuning
   

UNIX BASICS

• What is UNIX?
• How to Create, List Files and directories
• Displaying or searching the contents of a file
• Moving files from one directory to another