Informatica Training in Chennai & Best Informatica Training Institute in Chennai & Informatica Course in Chennai

IICT Chennai provides real-time and placement focused Informatica training in Chennai . Our Informatica ETL course includes basic to advanced level and our Informatica course is designed to get the placement in good MNC companies in Chennai as quickly as once you complete the Informatica certification training course. Our Informatica trainers are Informatica etl certified experts and experienced working professionals with hands on real time multiple Informatica projects knowledge. We have designed our Informatica course content and syllabus based on students requirement to achieve everyone's career goal. In our Informatica training program, you will learn Informatica ETL tool, Informatica designer, mapping, Workflow, workflow Manager Task, Installation, Informatica Administration, Advanced features, Informatica real time project and Informatica ETL placement training.

IICT Chennai offers Informatica training with choice of multiple training locations across Chennai. Our Informatica ETL training centers are equipped with lab facilities and excellent infrastructure. We also provide Informatica ETL certification training path for our students in Chennai. Through our associated Informatica training centers, we have trained more than 500+ Informatica students and provided placement. Our Informatica ETL course fee is value for money and tailor-made course fee based on the each student's training requirements. Informatica training in Chennai conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.

Informatica 9.1 training course content and Syllabus in Chennai



  • Data Warehousing Concepts
  • Dataware housing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions o Metadata and Data marts
  • Data Ware housing Architecture

Repository Manager

  • Creating Folder
  • Granting Rights, Access, Privileges
  • Create user, groups, Roles
  • Managing the folders

PowerCenter Components and User Interface

  • PowerCenter Architecture
  • PowerCenter Client Tools
  • Lab – Using the Designer and Workflow Manager

Power Center Designer

  • Extraction for data from Database and loading into Database
  • Flat file extraction to Database
  • Extraction from Xml file to Database
  • Importing Source metadata
  • Designing the Target warehouse

Source Qualifier and XML Source Qualifier

  • Source Qualifier Transformation
  • Lab Project Overview
  • Lab A – Load  Staging Table
  • Source qualifier Joins
  • Lab B – Load Staging Table
  • Source Pipelines
  • Lab C – Load Customer Staging Table and Real time issues

Expression, Filter, File Lists and Workflow Scheduler

  • Expression Editor
  • Filter Transformation
  • File Lists
  • Workflow Scheduler
  • Lab – Load the Customer Staging Table and Real time issues

Joiner, Features and Techniques

  • Joiner Transformation
  • Lab A – Load Employee Staging Table
  • Lab B – Features and Techniques I and Real time issues

Lookups and Reusable Transformations

  • Lookup Transformation
  • Lab A – Load Employee Staging Table
  • Lab B – Load Date Staging Table and Real time issues


  • Debugging Mappings
  • Lab – Using the Debugger

Sequence Generator

  • Sequence Generator Transformation
  • Lab – Load Date Dimension Table and Real time issues

Lookup Caching, More Features and Techniques

  • Lookup Caching
  • Lab A – Load Customer Dimension Table
  • Lab B – Features and Techniques II
  • Review and more Lab Activities and Real time issues

Router, update Strategy and Overrides

  • Router Transformation
  • Update Strategy Transformation
  • Expression Default Values
  • Source Qualifier Override

Target Override

  • Session Task Mapping Overrides
  • Lab – Load Employee Dimension Table and Real time issues

Dynamic Lookup and Error Logging

  • Dynamic Lookup
  • Error Logging
  • Lab – Load Customer Dimension Table

Connected and Unconnected Lookup, Parameters and Variables

  • Unconnected Lookup Transformation
  • System Variables
  • Mapping Parameters and Variables
  • Lab – Load Sales Fact Table

Sorter, Aggregator  

  • Sorter Transformation
  • Aggregator Transformation
  • Active and Passive Transformations
  • Data Concatenation
  • Lab – Reload the Employee Staging Table and Real time issues

Slowling Changing Dimension- SCD type1 – LAB
Slowling Changing Dimension -SCD type2 – LAB
Slowling Changing Dimension -SCD type3

Transformation Developer

  • Creating Reusable Transformation in Transformation Developer
  • Creating Reusable Objects in Mapplets Designer.

Mapplets Designer

  • Mapplets
  • Lab – Load Table
  • Review and more Lab Activities and Real time issues

Workflow Manager

  • Working with Task Developer
  • Creating Task and assigning to Mapping
  • Creating Workflow and Executing the workflow
  • Session Properties and Realtime Issues
  • Partition Technique

Workflow Variables and Tasks

  • Workflow Variables
  • Assignment Task
  • Decision Task
  • Email Task

More Tasks and Reusability

  • Event Raise Task
  • Event Wait Task
  • Command Task

Worklets and More Tasks

  • Worklets
  • Timer Task
  • Control Task

WorkFlow Monitor

  • Monitoring the session and workflow.
  • Troubleshooting the errors.
  • Checking log property.
  • Checking the output with session log.
  • Checking the Performance statistics.

Informatica training duration in Chennai

Regular Classes( Morning, Day time & Evening)

Duration : 20 days

Weekend Training Classes( Saturday, Sunday & Holidays)

Duration : 6 Weeks

Fast Track Training Program( 5+ hours daily)

Duration : within 5 days

Informatica trainer Profile & Placement

Our Informatica Trainers

More than 8+ Years of experience in Informatica Technologies
Has worked on 10 realtime Informatica projects
Working in a MNC company in Chennai
Trained 500+ Students so far.
Strong Theoretical & Practical Knowledge
Informatica certified Professionals

Informatica (informatica etl) Placement Training in Chennai

More than 500+ students Trained
98% percent Placement Record
100+ Interviews Organized
Placement Supported

Informatica training Locations in Chennai

Our Informatica ETL Training centers

Anna Nagar
Anna Salai
Ashok Nagar
T. Nagar

Informatica training batch size in Chennai

Regular Batch ( Morning, Day time & Evening)

Seats Available : 5 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

Seats Available : 5 (maximum)

Fast Track batch

Seats Available : 5 (maximum)

Informatica Related Training Courses:

ETL Testing Training in Chennai

Hadoop Training in Chennai

Datwarehousing Training in Chennai

Cognos Training in Chennai

Datastage Training in Chennai