Trainer's Profile :

Data Warehousing and Informatica training is delivered by a real time working software professional
having more than 10 Years of experience. The trainer has also been onsite in the United States
and Canada for 3 years. 100% percent of the students got jobs on informatica. Attend the free
classes and talk to the previous batch students to know about the quality of our training and
placement assistance programs.

Training Approach :

  • The Trainer explains the concept from the basics.
  • After ensuring that every trainee has well understood the concept, the trainer will move on to explaining how to
    apply the same concept to a realtime project.
  • The trainer will then discuss all the possible interview questions related to the concept in general as well as
    relating to a real time project.

Data Warehousing Course Contents

Data Ware Housing Concepts:

  • Introduction to Data Warehousing
  • Introduction to OLTP, ETL and OLAP Systems
  • Life Cycle
  • Data Modeling
  • Normalization Forms
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Types of Fact and Dimension Tables

Oracle Concepts:

  • Introduction to Oracle
  • Data Types
  • Constraints
  • SELECT statement usage
  • Joins
  • Sub Queries
  • Performance Tuning Tips & Tricks

Informatica Course Contents

Introduction to ETL

Enterprises of ETL Architecture

Introduction to Informatica

Installation & Configuration of Informatica

Repository Creation & Management


  • Source Analyzer
  • Warehouse Designer
  • Transformation Developer
  • Mapplet Designer
  • Mapping Designer
  • Different Kinds of Transformations
  • Simple Mapping
  • Mapping Involving Multiple Sources
  • Multiple Targets
  • Complex logic Mapping
  • Slowly Changing Dimension
  • Example of each Transformation available
  • Mapping Parameters & Variables
  • Performance Tuning Tips & Tricks
  • Debugging

Workflow Manager:

  • Task Developer
  • Worklet Designer
  • Workflow Designer
  • Different Kinds of Tasks and Usage
  • Control Tasks
  • Workflow Control and Monitoring
  • Performance Tuning
  • Session and Workflow Parameters

Project Related:

  • Real time Project Scenarios
  • Complete Real Time Project Exposure
  • Professional Resume Preparation
  • Mock Interviews
  • FAQ’s
  • Complete Job Assistance

About Instructor


Software Architect, Trainer, Author and Speaker in Pragim Technologies.



Average Rating


1 ratings

5 1


5 Stars
4 Stars
3 Stars
2 Stars
1 Stars
  • Vinay
    1 year ago★★★★★
    5 5 1


    Hi Kamesh Sir, Thank you for the wonderful Informatica training. I am completely satisfied with the training and was able to start work or productive in the project from Day1. The real-time scenarios you taught us helping to build mappings very easily and quickly and also able to optimize the code for good performance.


Review Title
Review Content

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on, you can subscribe by providing your valid email.