Best Informatica 9.5 Training Institute in Chennai, 100% Job Oriented Training in Data Warehousing ETL Tool Course

We offer best INFORMATICA Training in Chennai, our Informatica Training aims to teach the concepts of comprehensive data storage in an easier way.

Informatica is one of the leading data integration software on the market today. Every day that passes, more and more companies are joining the bandwagon of Informatica to achieve data storage through ETL.This is the tool that offers a solution DW over 70% of all projects DWBI today. Informatica is emerging in the market and overcome all challenges DWBI compared to any of its competitors.

Trainer Information - Best informatica trainer in chennai

A technology oriented professional Over 12+ years of experience in Data Warehousing DWH – Informatica domain across various projects Worked in different roles like Technical Lead, Team Leader, ETL Tool Consultant and On-site Coordinator in various business verticals like Banking, Telecom, and Insurance across India and Abroad like USA, UK, Canada.

  • Informatica Certified Professional
  • Successfully completed 50+ classroom batches
  • Successfully completed 20+ Online batches
  • Expert in corporate trainings handled training in HP, Hexaware,mindtree, IMSHealth & in Many Software Companies
  • Technical Support and technical forum access even after course completion
  • Supports Students for Resume Preparation and Interview Preparations

Timings & Schedules:

  •   Both on Weekdays / Weekends

Mode of Training:

  • Classroom
  • Online
  • Corporate


  • Graduate/Fresher/Software Developer/Working Professional with Basic SQL

Treesoft technologies highlights :

  • Informatica training in chennai offered by real time work experience Trainer with 12+ Years in IT Industry.
  • Treesoft Help you to change your current technology to Informatica and to find a Dream JOB
  • Real time informatica training with case studies and live examples with Project Explanation
  • Hands on & Practical Classes after the completion of every major topic of the module by Informatica Instructor
  • our Informatica students provided with Informatica software for practice.
  • At Treesoft, ETL Tool Training Course is very economical and best suits the Informatica industry
  • Our trainers provide specially made Latest material Books for Informatica ETL training
  • We Provide Informatica tests and FAQ s from interviews point of view.

Informatica Certified Professional Program

In today’s competitive environment, you need to differentiate yourself. You must prove that you have the knowledge and skills necessary to meet the complex challenges of data integration today. You must establish your professional credibility with your employer and the largest computer industry. Informatica Certification training in chennai offers new opportunities to help improve your productivity, improve your skills and increase your career success regardless of your job title.

  • Informatica Certified Associate
  • Informatica Certified Professional
  • Informatica Certified Expert

 Informatica course Contents

Data warehousing Concepts

  • What is DWH?
  • Characteristics of Data warehouse
  • Difference between OLTP and DWH
  • Architecture of DWH
  • Various BI tools
  • Types of DWH
  • Types of Dimensional Data Modelling
  • Surrogate key
  • Types of Dimension


  • Power Center Client Tools
  • Repository Manager
  • Manage Folders
  • Designer
  • Source Analyzer
  • Target Designer
  • Mapping Designer
  • Workflow Manager
  • Task Developer
  • Workflow Designer
  • Workflow Monitor
  • Workflow Log
  • Session Log
  • Types of View

Transformation Basics

  • Classification
  • Types of Ports
  • Data Types

Types of Transformations

  • Source Qualifier Transformation
  • Creating Simple Pass through Mapping
  • Apply Various Filter Conditions
  • Specify sorted ports
  • Eliminate Duplicate Values
  • Creating Custom SQL Query
  • Joining two or more tables

Filter Transformation

  • Compare with Source Filter
  • Types of Tracing Level
  • Types of Flat files
  • File Import Wizard
  • Load data from Flat File to Database
  • Load data from Database to Flat File

Sorter Transformation

  • Types of Ports
  • Multiple Sorting
  • Joiner Transformation
  • Joining two heterogeneous sources
  • Types of Joins
  • Sorted input option
  • Rank Transformation
  • Types of Ports
  • Rank Index
  • Rank and Dense rank

Sequence Generator

  • cycle option
  • Usage of Reset
  • Expression Transformation
  • Use of Expression
  • Usage of Variable Port
  • IIF and Decode functions

Aggregator Transformation

  • Informatica aggregate functions
  • Sorted input option
  • Router Transformation
  • Types of Groups
  • Group Conditions

Union Transformation

  • Types of Groups
  • Normalizer Transformation
  • Types of Normalizer
  • Transpose Columns to Rows
  • Default Output Ports

Lookup Transformation

  • Connected Vs Unconnected Lookups
  • Unconnected Procedure
  • Lookup Caches

Stored Procedure Transformation

  • Create a Sample Procedure
  • DBA Script

Update Strategy Transformation

  • Database operations
  • Data Driven

Transaction control Transformation

  • Dynamic File Generation
  • Slowly Growing Dimension
  • Slowly changing Dimension
  • Type 1
  • Type 2
  • Type 3

Transformation Developer

  • Create a Reusable Transformation
  • Promoting Transformations
  • Mapplet Designer
  • Create a reusable Mappings
  • Mapping Parameters
  • Design Parameter File
  • Mapping Variables
  • Set variables function
  • Session variables
  • Setting Connections
  • Workflow variables

File Repository Concepts

  • Indirect loading
  • Target Load Plan
  • Types of scheduling
  • Time-based schedule
  • Event -based schedule
  • Mapping Migration Process
  • Copy from Folder
  • Import and Export

       Feel & Decide after a free Demo class with our Real time Experts

                           Contact @ 91-8939794629