IICT Chromepet

                                 Facebook Linked In Twitter Google Plus Pinterest Blogspot Youtube   Phone

90038 53466

Informatica Training in Chennai & Informatica Training Institutes in Chennai & Informatica Training Institute in Chennai & Informatica Training Centers in Chennai

Informatica Training in Chennai Reviews

Informatica Training in Chennai Reviews

Informatica Training in Chennai
5/5 stars
Great time i had at IICT for informatica training my trainer Jayaraman very helpful and he thought me all the trasistions in practical and live basis thank to IICT for quality informatica training. One word to say money worth it thanks to sathik sir for his great support.


Informatica Training in Chennai , Informatica Training Institute in Chennai

Informatica Training Institute in Chennai & Informatica Training in Chennai with Placement & Informatica Training Center in Chennai & Informatica Training with Placement in Chennai

Recommended as Best Informatica Training Institutes in Chennai

IICT Computer Education, 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 trainer are informatica etl certified expert 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.

Our informatica etl training center is equipped with lab facilities and excellent infrastructure. We also provide informatica etl certification training path for our students in chennai. Through our informatica training center, we have trained more than 50+ 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.

Best Informatica training institute in Chennai offers hands-on Informatica training in Chennai with Placement by well experienced Informatica professionals having 12+ years of Datawarehouse experience.

We provide Informatica Training, Datawarehouse Training, ETL Testing training based on current industry standards. All our sessions are completely practical and interactive paired with Realtime Methodologies, Project Scenarios and Interview Guidance exclusively on Informatica.

Informatica is one of the widely used Data integration software available in the market today. Most of the fortune 500 companies is using Informatica as ETL Data warehousing tool.

IICT Computer Education, Chennai has been awarded as the best Informatica training institute in chennai

We teach Data Warehousing Informatica Training courses with real time scenarios and give interview guidance.

Informatica Course benefits: We are committed to provide Complete PRACTICAL Training and Complete REALTIME Training exclusively on Informatica, Cognos and Data Modelling. Study Material and Practice Material included during the course. We are proud to mention that we are the best institutes to provide Informatica COMPLETE PRACTICAL REALTIME TRAINING and hence, closely working with various companies in India amd in overseas. Most of the trainees are references from our previous students. You will get complete Hand On training for your Informatca Trainings.

Informatica Certification Tracks

  • Informatica Certified Associate

  • Informatica Certified Professional

  • Informatica Certified Expert

  • Eligibility for Informatica Training @ IICT, Chennai

  • Must have computer science Background

  • Informatica Demo Class has been conducted on every Saturday @ 5 pm by MNC Expert.

  • Preferable Oracle SQL background students

  • Informatica Workshop has been conducted once in a month by MNC Informatica Expert MNC Expertan who have 12+ years of domain experience in Informatica and Vast Training Experience.

  • Admission Procedure for Informatica Training @ IICT, Chennai

  • Needed Students only with Computer Science Background

  • Passport size photograph for life time support ID

  • Address proof & ID Proof

  • Emergency Contact Number

  • Informatica Training - Course Fees @IICT, Chennai

    Rs.10,000 with easy Installments

    Informatica Training Course Syllabus in Chennai

    Informatica syllabus covered by MNC Expert is completely in real time and industry based syllabus which are used in real time.

    100% Real Time Informatica Course Content Designed by MNC Expert who is Certified in Informatica.

    Data Warehouse Concepts:

    Introduction to Data warehouse

    What is Data warehouse and why we need Data warehouse

    OLTP vsData warehouse

    Dimensional modelling

    Star schema/Snowflake schema

    Dimensions / Facts tables.

    Slowly Changing Dimensions and its types.

    Different types of Dimensions and Facts.

    Data Mart vs. Data warehouse

    DWH Approaches: Ralph Kimball's vs. Bill Inmon's

    E T L Informatica PowerCenter 9.x:

    Introduction to Informatica PowerCenter

    Informatica Architecture

    PowerCenter Components


    Repository Manager

    Workflow Manager

    Workflow Monitor

    Informatica Concepts and Overview

    Source Qualifier

    Target Analyzer







    Working with relational Sources

    Working with Flat Files


    Working with relational Sources

    Working with Flat Files


    Source qualifier transformation

    Joiner Transformation

    Filter Transformation

    Lookup Transformation

    Aggregator Transformation

    Expression Transformation

    Normalizer Transformation

    Rank Transformation

    Router Transformation

    Union Transformation

    Sequence Generator Transformation

    Stored Procedure Transformation

    Sorter Transformation

    Update Strategy Transformation

    Reusable mapplets and transformations

    Mapping Variables & Parameters

    Workflow Manger-Workflows & Sessions


    Unit Testing

    Interview Questions

    Informatica Server and Client installation

    Oracle Server installation

    Case study and real time scenarios

    Administrator Module

    Understanding Domains


    Application Services

    Using Administration Console

    Managing the Domain

    Managing Alerts

    Managing Folders

    Managing Permissions

    Managing Application Services

    Managing the Nodes

    Managing Users and Groups

    Managing Privileges and Roles

    Domain Privileges

    Repository Services Privileges

    Reporting Service Privileges

    Managing Roles - Assigning Privileges and Roles to Users and Groups

    Creating and Configuring the Repository Services

    Managing the Repository

    Creating and Configuring Integration Services

    Enabling and Disabling the Integration Services

    Running in Normal and Safe Mode

    Configuring the Integration Services Processes

    Integration Services Architecture

    Creating the Reporting Services

    Managing the Reporting Services

    Configuring the Reporting Services

    Managing License

    Advanced Workflow Module

    Understanding Pipeline Partitioning

    Partitioning Attributes

    Dynamic Partitioning

    Partitioning Rules

    Configuring Partitioning

    Partitioning Points

    Adding and Deleting Partitioning points

    Partitioning Relational Sources

    Partitioning File Targets

    Partitioning transformations

    Partitioning Types

    Real Time Processing

    Commit Points

    Workflow Recovery

    Stopping and Aborting

    Error Handling

    Stopping and Aborting Workflows

    Concurrent Workflows

    Load Balancer

    Workflow Variables

    Predefined Workflow Variables

    User- Defined Workflow Variables

    Using Worklet Variables

    Assigning Variable Values in a Worklet

    Parameter and variables in Sessions

    Working with Session Parameters

    Assigning Parameter and Variables in a Session

    Parameter File

    Session Caches

    Incremental Aggregation

    Session Log Interface

    Command Reference:

    Using Command Line Programs





    Designer Module

    Using the Designer

    Configuring Designer Options

    Using Toolbars

    Navigating the Workspace

    Designer Tasks

    Viewing Mapplet and Mapplet Reports

    Working with Sources

    Working with Relational Sources

    Working with COBOL Sources

    Working with Cobol Source Files

    Working with Flat Files

    Importing Flat Files

    Editing Flat Files Definition

    Formatting Flat Files Column

    Working with Targets

    Importing Target Definition

    Creating Target Definition from Source Definition

    Creating Target Definition from Transformations

    Creating Target tables


    Working with Mappings

    Connecting Mapping ObjeMNC

    Linking Ports

    Propagating Port Attributes

    Working with Targets in a Mapping

    Working with Relational Targets in a Mapping

    Validating a Mapping

    Using Workflow Generation Wizard Mapplets

    Understanding Mapplets Input and Output

    Using Mapplet Designer

    Using Mapplets in Mapping

    Mapping Parameters and Variables

    Working with User-Defined Functions

    Using the Debugger

    Creating Breakpoints

    Configuring the Debugger

    Monitoring the Debugger

    Evaluating Expression

    Creating Cubes and Dimensions

    Using Mapping Wizard

    Naming Conventions

    Performance Tuning Module

    Performance Tuning Overview


    Using Thread Statistics

    Target Bottlenecks

    Source Bottlenecks

    Mapping Bottlenecks

    Session Bottlenecks

    System Bottlenecks

    Optimizing the Targets

    Optimizing the Source

    Optimizing the Mapping

    Optimizing the Transformations

    Optimizing the Sessions

    Optimizing thePowerCenter Components

    Optimizing the System

    Using Pipeline Partitions

    Performance Counters

    Repository Module

    Understanding the Repository

    Using Repository Manager


    Managing Object Permissions

    Working with Versioned Object

    Exporting and Importing Object

    Copying Object

    Transformation Module

    Working with Transformations

    Configuring Transformations

    Working with Ports

    Working with Expressions

    Reusable Transformations

    Aggregator Transformation

    Custom Transformation

    Expression Transformation

    External Transformation

    Filter Transformation

    Joiner Transformation

    Java Transformation

    Lookup Transformation

    Lookup Caches

    Normalizer Transformation

    Rank Transformation

    Router Transformation

    Sequence Generator Transformation

    Sorter Transformation

    Source Qualifier Transformation

    SQL Transformation

    Stored Procedure Transformation

    Transaction Control Transformation

    Union Transformation

    Update Strategy Transformation

    Transformation Language Reference:

    The Transformation Language






    Creating Custom Function

    Workflow Basics Module

    Workflow Manager

    Workflow Manager Options

    Navigating the Workspace

    Working with Repository ObjeMNC

    Copying Repository ObjeMNC

    Comparing Repository ObjeMNC

    Workflow and Worklets

    Creating a Workflow

    Using Workflow Wizard

    Assigning an Integration Service

    Working with Worklets

    Working with Links


    Creating a Session Task

    Editing a Session

    Pre- and Post- Session Commands

    Session Configuration ObjeMNC


    Creating a Task

    Configuring Tasks

    Working with Command Task

    Working with Decision Task

    Working with Event Task

    Working Timer Task

    Working with Assignment Task


    Configuring Sources in a Session

    Working with Relational Sources

    Working with Flat Sources


    Configuring Targets in a Session

    Working with Relational Targets

    Working with File Targets

    Reject Files


    Validating Tasks

    Validating Worklets

    Validating Session

    Validating Workflows

    Scheduling and Running Workflows

    Scheduling a Workflow

    Manually Starting a Workflow

    Sending Email

    Working with Email Tasks

    Working with Post-Session Email

    Workflow Monitor

    Using Workflow Monitor

    Customizing Workflow Monitor Options

    Working with Tasks and Workflows

    Using Gantt Chart View and Task View

    Workflow Monitor Details

    Integration Services Properties

    Workflow Run Properties

    Worklet Run Properties

    Session Task Run Properties

    Performance Details

    Session and Workflow Logs

    Log Events

    Log Events Window

    Working with Log Files

    Workflow Logs

    Note: Lab sessions for all the points mentioned above will be taken.


    Evolution of Datawarehousing - History

    The need of Datawarehousing

    Why Datawarehousing

    What is Datawarehousing - The Definition

    Subject -Oriented


    Non - Volatile

    Time Varying

    Datawarehousing Architecture

    Data Source Layer

    Data Extraction Layer

    Staging Layer

    ETL Layer

    Data Storage Layer

    Data Logic Layer

    Data Presentation Layer

    Metadata Layer

    System Operation Layer

    Dimension table

    Fact table

    Additive FaMNC

    Semi Additive FaMNC

    Non - Additive Fact





    Types of Schema

    Star Schema

    Snow Flake Schema

    Fact Constellation Schema

    Slow Changing Dimension

    SCD1 - Advantages/ Disadvantages

    SCD2 - Advantages/ Disadvantages

    SCD3 - Advantages/ Disadvantages

    OLAP and OLTP

    Difference between OLAP and OLTP

    Types Of OLAP

    Multi-Dimentional (MOLAP)



    Informatica Trainer profile at IICT, Chennai

  • More than 12 Years of experience in Informatica domain

  • Has worked on various realtime Informatica projeMNC

  • Working in a MNC company in Chennai

  • Trained 50+ Students so far.

  • Strong Theoretical & Practical Knowledge

  • Informatica certified Professionals

  • Informatica Training in Chennai Benefits

  • Real Time Trainers

  • 100% Placement Assistance

  • Small Training Batch

  • Flexible Timings

  • Practical Guidance

  • Excellent Lab Facility

  • Informatica Resume Preparation

  • Hands on Experience

  • Informatica Certification Support

  • Life Time Support will be provided

  • Implementation Support will be provided for Informatica Real Time ProjeMNC

  • Materials will be provided and Informatica software will be provided

  • Informatica course materails and interview question will be provided

  • After regular Class hours 24/7 support provided for Practice

  • Regular assignments and Informatica real time tasks will be provided

  • Informatica training batch size in Chennai

    Regular Batch ( Morning, Day time & Evening)

  • Seats Available : 4 (maximum)

  • Weekend Training Batch( Saturday, Sunday & Holidays)

  • Seats Available : 4 (maximum)

  • Fast Track Batch (4+ Hours daily)

  • Seats Available : 4 (maximum)

  • Informatica training duration in Chennai

    Regular Classes( Morning, Day time & Evening)

  • Duration : 40 days

  • Weekend Training Classes( Saturday, Sunday & Holidays)

  • Duration : 8 Weeks

  • Fast Track Training Program( 5+ hours daily)

  • Duration : within 20 days

  • Informatica training Location in Chennai

    Our Informatica Training center

    Contact Us

    No.14/22, Third Floor,
    First Cross Street, Newcolony,
    Chrompet, Chennai- 600 044.

    Land Mark: Near Chrompet Railway Station and Bus Stop,
    Behind Sri Krishna Sweets.

    Mobile: 90038 53466

    Informatica Corporate Training in Chennai

    Our Corporate training programs feature:

  • Customized training programs

  • Flexible Training Schedule - courses can be delivered at your chosen convenient time.

  • Hands-on training

  • Flexible group size

  • Affordable Price

  • Most advanced Training Resources - structured course material, learning CDs, highly experienced and certified faculty members.

  • Video Tutorials will be provided and Informatica software will be provided

  • Informatica Online Training in Chennai

  • Custom lessons with specific terminology and examples from your business

  • Designed and developed from scratch with your employees in mind

  • Simulations are based on your Informatica system, mirroring your exact system version, configuration and business processes

  • Courses can be organized by business process or job role and include any functionality that you desire.

  • Informatica Training in Chennai Support

  • Mobile : 90038 53466

  • Informatica Placement Training in Chennai

  • More than 50+ students Trained

  • 90% percent Placement Record

  • 8 Interviews Organized

  • Informatica Recruiting Companies in Chennai

  • Cognizant

  • Wipro

  • TCS and Many More Companies

  • Why IICT is the best Informatica Training Institute in Chennai?

  • We provide 100% practical and real time Training

  • Our Trainer is working as an ETL Architect in an IT MNC and has over 12+ Years of Data warehousing Experience

  • Customized Course contents based on company needs

  • FREE Demo Sessions on saturdays @ 5 pm

  • Flexible timings, we are open from 6 AM to 9 PM on all days

  • Flexible Payment options

  • Informatica Training in Chennai Reviews

    Informatica Training in Chennai Reviews

    Informatica Related Training in Courses

    Informatica Training in Chennai

    Cognos Training in Chennai

    Datastage Training in Chennai

    ETL Testing Training in Chennai

    Datawarehousing Training in Chennai

    Qlikview Training in Chennai

    Microstrategy Training in Chennai

    OBIEE Training in Chennai

    Business Objects Training in Chennai

    Cognos TM1 Training in Chennai

    Big Data Analytics Training in Chennai

    Informatica Data Quality Training in Chennai

    Hadoop Training in Chennai

    Ab Initio Training in Chennai

    Microsoft BI Training in Chennai

    Tableau Training in Chennai

    R-Programming Training in Chennai

    Tibco Spotfire Training in Chennai

    Jaspersoft Training in Chennai

    Webfocus Training in Chennai

    Pentaho Training in Chennai

    Apache Spark Training in Chennai


    Latest Reviews of IICT- " Students Are Brand Ambassadors "

    Road Map of IICT

    IICT Chromepet Address, IICT Contact, IICT Location, IICT Chrompet address, IICT Chennai Address, IICT

    Click Here For Google Map

    Websites of IICT

    IICT Academy
    IICT - Training in Chennai


    Are you located in any of these areas - Adyar, Ambattur, Aminjikarai, Adambakkam, Anna Nagar, Anna Salai, Ashok Nagar, Ashok Pillar, Besant Nagar, Choolaimedu, Chromepet, Egmore, Ekkattuthangal, George Town, Guindy, Guduvanchery, K.K.Nagar, Kilpauk, Kodambakkam, Koyambedu, Madipakkam, Medavakkam, Meenambakkam, Mudichur, Mylapore, Nandanam, Nanganallur, Navallur, Nungambakkam, OMR, Pallikaranai, Pammal, Perungudi, Perungalathur, Porur, Potheri, Pozhichalur, Puzhal, Saidapet, Sholinganallur, St. Thomas Mount, T.Nagar, Tambaram, Teynampet, Thiruvanmiyur, Thiruvattriyur, Thoraipakkam, Urappakkam, Vadapalani, Vandalur, Velachery, Villivakkam, Virugambakkam and West Mambalam.

    Our Chrompet office is just few kilometers away from your location. If you need the best training in Chennai, driving couple of extra kilometers is worth it.

    RSS Sitemap   |   Sitemap  ©IICT, CHENNAI , TN. All rights reserved.