Informatica Training in Chennai

informatica training in chennai

We are providing best Informatica training in Chennai with experienced professionals. Our Informatica Power Center syllabus very depth and carrier oriented. Using this course you can learn complete Data Warehousing technology from experienced professionals.

Informatica is one of the best integration tool, it is market leader in data integration and data quality services. This tool widely used to extract, transform and load business data.

Orange techno mind provides real-time and placement focused Informatica training in Chennai, this course syllabus covers basic to advanced level, it helps to get the placement in any MNC companies. Our trainers are experienced professional who has working in complex data warehousing projects. We designed Informatica PowerCenter training syllabus based on industry standard.

You will learn Data warehouse concept, server architecture, different kind transformation, mapping, work flow, power centre and also how to improve the performance. This course intention to covering almost all the features which is required for companies.

We are providing best Informatica Training in Chennai, our trainers are more industry experiences and handled many complex projects.


This course is designed for technical professionals who wants to learn Informatica at fast track and very depth for their careers. As it is job oriented training, fresher can learn this course and anybody want to switch their jobs to Middleware development using Informatica.

Informatica Training Syllabus

Informatica Training in Chennai Data warehouse Concepts

  • What is Data Warehouse?
  • Data Mart
  • Data Warehouse Architecture (Basic)
  • Data Warehouse Architecture (with a Staging Area)
  • Dimensional Modelling
  • Star Schema
  • Snowflake Schema
  • Dimension
  • Fact
  • Slowly Changing Dimension

Informatica Training in Chennai Introduction to informatica PowerCenter

  • PowerCenter 9 architecture
  • Extraction, Transformation and loading process
  • PowerCenter tools: Designer, Workflow manager
  • Workflow Monitor, Repository Manager
  • Informatica Administration Console
  • Repository Server and agent
  • Repository maintenance
  • Repository Server Administration Console
  • Security, Repository, privileges and folder permissions
  • Metadata extensions

Informatica Training in Chennai PowerCenter Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor

Informatica Training in Chennai Informatica Concepts and Overview

  • Informatica Architecture
  • Source Qualifier
  • Transformations
  • Active and Passive Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks

Informatica Training in Chennai Sources

  • Relational Tables (Oracle)
  • Flat Files (fixeD width, Delimiter Files)
  • Xml Files

Informatica Training in Chennai Targets

  • Working with Relational Targets
  • Working with Flat file Targets

Informatica Training in Chennai Transformations

  • Expression
  • Lookup
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Stored Procedure
  • Union
  • Router
  • Aggregator
  • Update Strategy
  • Expression

Informatica Training in Chennai Debugging Mappings

Informatica Training in Chennai Mappings & Mapplets

  • Mapping Variables & Parameters
  • Working with Mapping Wizards

Informatica Training in Chennai Workflow Manger

  • Server Architecture
  • Workflows, Worklets & Sessions
  • Tasks, Assignments, Events, Command etc

Informatica Training in Chennai Performance Tuning

  • Informatica Tuning (Source, target, mapping & Session)

Informatica Training in Chennai Project - Case Study

Informatica Training in Chennai Project - Review and Assignment


    Orange TechnoMind Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.

Course Enquiry