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
Designer
  • 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