course detail


Best Informatica Training in Chennai

Are you in search for Best Informatica Training in Chennai?. BITA Academy is the best Informatica Training Institute in Chennai.Call 9566004616 for more details.

About Informatica Course in Chennai

Informatica Course Syllabus that we have structured is of 30-40 hours duration. You shall take this Informatica Course either in weekdays or over weekends up on your convenience.

Anyone who has constraints related to classroom training shall opt for Informatica Online Training. You will see no difference as these online interactive sessions will happen real time and you have the feature to record these sessions. You can make use of these recorded sessions whenever required.

Informatica Job Opportunities

Informatica is a solution Provider for integration of data with large volumes, complex structures which was one vital issue faced by the enterprises these days. So Informatica Developers are in huge demand nowadays who should be able to analyze and integrate the data using the tool.

On Completing the Informatica Training in Chennai, you will be able to perform all sort of data operations and enrich your career as Data Scientist and Data Analyst. So Join BITA Academy if want to get the Best Informatica Training in Chennai.

Who should take up this Informatica Training?

  • ETL, SQL Developers and Business Intelligence Professionals
  • Database, Mainframe Professionals and Project Managers.
  • Should have basic understanding of Data warehousing through ETL.

Informatica Course Syllabus

Data Warehouse Introduction

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

Informatica Power Center Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console

Informatica Concepts and Overview

  • Informatica Architecture


  • Working with relational Sources
  • Working with Flat Files


  • Working with Relational Targets
  • Working with Flat file Targets

Transformations – Active and Passive Transformations

  • Expression
  • Lookup –Different types of lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Source Qualifier
  • Update Strategy
  • Normaliser
  • Union
  • Stored Procedure
  • Slowly Changing Dimension
  • What is SCD Type1
  • SCD Type2 – Date, Flag, and Version
  • SCD Type3

Workflow Manager

  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
  • Session
  • Decision task
  • Control Task
  • Event wait task
  • Timer task
  • Monitoring workflows and debugging errors
  • Indirect Loading
  • Constraint-based load ordering
  • Target Load plan
  • Worklet, Mapplet, Reusable transformation
  • Migration–XML migration and Folder Copy.
  • Scheduling Workflow
  • Parameter and variables
  • XML Source, Target, and Transformations
  • Performance Tuning
  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization

Who should enroll for Informatica ETL Training in Chennai?

  • Anyone who is interested on doing research with large volumes of data.
  • Anyone who is interested to draw patterns from data analysis.
  • Software Professionals
  • BI/ETL/DW Professionals
  • Anyone who has basic knowledge in Linux and Database.
  • ETL and SQL Developers
  • Any programmer who would like to switch over their career as Data Scientist and Data Analyst.
  • Anyone who doesn’t have any experience in Programming.
  • Analytics Professionals

Have you found out the Best Informatica Training in Chennai?

  • Choose the right place to learn and BITA Academy is one of the best Informatica Training Center in Chennai as per the google reviews received from our clients.
  • We offer Informatica Training in Chennai by industry experts who is an experienced professional.
  • You shall take the Informatica Training either in week days or over weekends batch as per your convenience.
  • Ranked as the best Informatica Training Institute in Chennai Ramapuram.
  • Our real time projects that you will work on during Informatica Course Period will ensure that you become a perfect Data Analyst.
  • We provide Informatica Training with Placement assistance.
  • So You shall also make use of Informatica Interview Questions that will be helpful for Informatica Interview Preparation.

Free Demo Classes