Your SEO optimized title page contents

Informatica Training & Certification

Informatica Training & Certification

About the Course

TraiMeHub’s Training will help you master data integration concepts such as ETL and data mining using Informatica PowerCenter. It will also make you proficient in advanced transformations, Informatica Architecture, data migration, performance tuning, installation & configuration.


Learning Plan

  •  Informatica PowerCenter 10 – An Overview|

    Goal : In this module, we will talk about the different Informatica Products available along with understanding the overview of Informatica PowerCenter Product, Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor. We will also discuss the installation of Informatica in this module.

    Objectives :
    Explain Informatica & Informatica Product Suite
    Explain the purpose of PowerCenter as ETL Tool
    Describe PowerCenter Architecture
    Explain component-based development techniques in PowerCenter
    Explain the new features of Informatica 10.X over 9.X

    Topics :

    Informatica & Informatica Product Suite
    PowerCenter as ETL Tool
    PowerCenter Architecture
    Component-based development techniques
    Hands On/Demo :

    Installation of the Product in Windows and using Oracle as Database
    Creation of the services and connecting the client with the server

  • PowerCenter Transformations 

    Goal : In this module, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping.

    Objectives :
    Describe & Visualize PowerCenter Client Tools
    Understand basics of Data Flow
    Explain how to create & Execute mapping
    Explain different Transformations & their usage
    Topics :

    Visualize PowerCenter client tools
    Data Flow
    Create & execute mapping
    Transformations & their usage
    Hands On/Demo :

    Use multiple transformations inside the mapping to resolve different use cases
    Look at the properties of the transformations to customize them

  • PowerCenter Tasks & Workflows  


    Goal : In this module, you will learn about development units of Informatica PowerCenter (workflow manager & monitor) and how are they are used to create different tasks and workflow.

    Objectives :
    Explain PowerCenter Workflow Manager
    Describe Flow within a Workflow
    Describe Reusability & Scheduling in Workflow Manager
    Understand components of Workflow Monitor
    Explain Workflow Task and job handling
    Topics :

    PowerCenter Workflow Manager
    Flow within a Workflow
    Reusability & Scheduling in Workflow Manager
    Components of Workflow Monitor
    Workflow Task and job handling
    Hands On/Demo :

    Create tasks, workflow
    Configure workflow properties
    Schedule a workflow

  • .
  •   Advanced Transformations, Techniques & Reusability Features

    Goal : Advanced Transformation techniques will equip you to deal with advanced concepts of PowerCenter transformations like, Java, XML etc. of PowerCenter. We will also discuss about transaction processing & reusability features available in Informatica.

    Objectives :
    Understand the uses of advanced transformations like Java, SQL, Normalizer
    Explain the XML File Processing & Transaction Processing
    Use different error handling features
    Use Advanced Functions, Regular Expressions to cleanse the data
    Learn about the reusability features
    Topics :

    Advanced transformations (Java, SQL, Normalizer)
    XML File Processing & Transaction Processing
    Error handling features
    Cleaning the data (Advanced Functions, Regular Expressions)
    Reusability features

  • .
  • ETL Scenarios using Informatica

    We will discuss about advanced ETL scenarios using Informatica. You will be introduced to the concepts – Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint Based Loading, Target Load Order Group, CDC (Change data Capture) etc. We will also discuss about creating Data Warehouse related processes like SCD, Fact and Dimension Loading.

    Objectives :
    Implement advanced concepts like Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
    Implement advanced techniques using Flat File, XML File
    Implement techniques for loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
    Implement other advanced concepts using Informatica PowerCenter
    Topics :

    Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
    Advanced techniques – Flat File, XML File
    Loading Dimensional Tables (SCD-1, SCD-2, SCD-3

  • .
  • Informatica 10 – Technical Architecture

    Learning Objectives – In this modules, you will learn about additional database objects such as views, Macros, Stored Procedure and Join Index. You will also explore common performance tuning options.

    Topics – Views, Macros, Stored Procedure, Join Index, Performance Tuning tips.

  • .
  • Teradata Utilities – FastLoad, MultiLoad, BTEQ


    Goal : This module gives you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular.

    Objectives :
    Describe Informatica 10 Architecture
    Explain the application services related to PowerCenter and their related processes
    Understand buffer memory
    Describe Connectivity among the tolls
    Describe Connection pooling used in PowerCenter
    Topics :

    Informatica 10 Architecture
    Application services
    Buffer memory
    Connectivity among the tolls
    Connection pooling

  • .
  •  Informatica Administration & Security

    Goal : This module will give you an overview of the PowerCenter administration console, recognize and explain integration and repository service properties. We will also discuss about the command line utilities and use them to manage the domain and repository, start and control workflows.

    Objectives :
    Explain the new features of PowerCenter 10
    Explain an overview of the PowerCenter Administration Console
    Recognize and explain the integration and repository service properties
    Identify how to handle services in the Administration Console
    Explain how to handle locks through the Administration Console
    Illustrate how to create users and groups
    Topics :

    Features of PowerCenter 10
    Overview of the PowerCenter Administration Console
    Integration and repository service properties
    Services in the Administration Console (services, handle locks)
    Users and groups

  • .

    Class Venue

     This is an online course. Student can join from anywhere in the world. Every student will get dedicated Trainer. Live, Hands on Classes via Remote Instructor

    Watch our Demo Classes

    I have become more aware of Digital Marketing Techniques and it’s importance. With the advice and Guidance of the course leaders I was able to expand my connections within the Digital Marketing industry and to create a professional presence online which enhances my employ-ability. As a result of the course, I have also applied for a variety of work experience placements in the practical Digital Marketing experience and to improve my understanding of a Digital Marketing environment.  Thank You Leaders from Trainmehub.

    The IT course from Trainmehub gave me an opportunity to take risks, explore my potential and develop my self paced strategy. I feel incredibly privileged to have taken part and to be part of the training legacy. Thank you course trainer.

    faculty and staff teaching courses and discussing topics online

    Vinay Kumar