Informatica PowerCenter Certification Training

Informatica PowerCenter Certification Training

Informatica power centre is widely used extraction, transformation and loading tool implemented in developing enterprise data warehouses. PowerCenter provides a solid infrastructure to develop applications on a reusable and flexible platform, meanwhile implanting resiliency, recovery, and failover capabilities. During the training phase, trainees will learn few key skills in Informatica Powercentre like creating transformations, mappings, reusable objects, sessions and workflows to retrieve, alter and load data. Attain expert level knowledge in topics like FTL, Troubleshooting, and Debugger usage tools.
Start Date Duration Time (CST) Type Mode of Training Enroll
17-Mar-2019 55 Hrs 09:00 PM Online INSTRUCTOR LED TRAINING Enquiry Now


Informatica is riding the wave of Data Integration currently in vogue to present its Certifications in Data Integration tools, with PowerCenter leading the pack. Special applications in ERP, manufacturing and HR alike have led to generation of data streams which need consolidation. This rising need in Data Integration and Data Warehousing is addressed by Informatica PowerCenter. PowerCenter offers continuous data processing with a zero-latency engine enabling business users to make timely decisions. It supports customer’s plans like data warehousing project, integrating or migrating applications, or evolving to a hybrid architecture and keeps their business agile.

Did you know?

  1.  Informatica has released Informatica cloud in 2016, to assist businesses in harnessing the exploding volume of data in their cloud applications and unifying data across traditional and hybrid data sources. Informatica cloud is mainly focused on delivering end-to-end cloud data integration and data management
  2.  Informatica being a 23-year-old company provides cloud based data management tools to their customers like General Electric GE and Amazon. It has a 22 percent share of the market for “integrated platform-as-a-service,” a cloud computing model that assists customers in developing applications and managing data over the internet
  3.  The key features of Informatica PowerCenter deals with partitioned data, caching techniques, parallel processing and quality bulk extraction or loading without any data loss. These key features has led Informatica PowerCentre as a market leader in data integration
  4. Informatica follows mainstream marketing strategy where it leverages paperwork, press release, web forums and network community. This provides Informatica the leading edge in ETL space

Why learn and get Certified in Informatica PowerCenter (Developer)?

  1.  Based on 2015 market share revenue, gartner’s report announced Informatica as the #1 global Integration Platform as a Service (iPaaS) solution vendor for the 11th consecutive year. Its wide market share has raised ample of job opportunities for skilled professionals
  2.  In 2015, Informatica has generated over $1 billion in revenue. Now, it has plans to invest in startups, beef up its hiring capacity, and invest further in research and development to boost growth
  3.  It reports record of Quarterly Revenues of $303.7 Million and Annual Revenues of $1.05 Billion. Thus these revenue outcomes indicates the huge demand of Informatica Power Centre in the IT market
  4. As per the latest job trends, the market of Informatica PowerCenter is highly profitable. It is an enduring technology and will be continuing progress with an exponential rate in the future as well

Course Objective

After the completion of this course, Trainee will:
  1.  Knowledge on Usage of PowerCenter 10 Designer to develop mappings that extract data from a source to a target, transforming it as per requirement
  2.  Ability to deploy PowerCenter transformations to format, cleanse, join, segregate and route data to appropriate targets
  3.  Potentiality to perform error handling or trapping by implementing PowerCenter mappings
  4.  Capability to develop and execute workflows which execute sessions paired with a mapping and to control data transformation processes by implementing PowerCenter, 10 workflow manager
  5.  Ability to plan and build basic mappings and workflows based on essential business needs
  6.  Complete knowledge on basic troubleshooting with help of PowerCenter debugger and logs


  1.  Basic knowledge of SQL and basic Unix development.
  2.  Good knowledge of ETL, and Data Warehousing Concepts.
  3. Pre-requisites Materials provided: ETL OverviewSQL TutorialData Modeling and DW concepts

Who should attend this Training?

This comprehensive course is ideal and best suited for the following professionals, who are interested in mastering skills and upgrading their knowledge:
  1.  Individual Contributors in the field of Enterprise Business Intelligence
  2.  Analytics Professionals
  3.  DW/BI/ETL/ Professionals
  4.  Software Developers
  5.  Mainframe Architects and developers

Prepare for Certification

Informatica PowerCenter Role Based Training Program by ZaranTech will prepare you for all the broad topics covered in the Informatica PowerCenter Developer Certification. ZaranTech’s unique blended learning approach to its courses will give you an edge with a combination of online training augmented by market leading instructor-led training sessions for enhanced learning retention and query resolution.

How will I perform the practical sessions in Online training?

We use the Oracle version of Informatica. Students will have to register themselves on the Oracle Site ( Oracle provides the development license for all the Informatica PowerCenter Products. Software for training purpose will be made available to the candidates during the training. The detailed installation guides are provided in the LMS. In case you come across any doubt, the 24×7 support team will promptly assist you.



Unit 1. Informatica Introduction

  1. Overview
  2. Basic Definitions
  3. Informatica products
  4. Informatica Architecture
  5. Folders-Sub folders
  6. ETL Tools and their roles
  7. ETL information power center / Power mart

Unit 2. Introduction to Data Warehousing

  1. Data warehousing (what is Data warehousing /Why Data warehousing/How Data warehousing)
  2. Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  3. Metadata
  4. Dimensional Table
  5. Types Of Dim Tables
  6. Fact Table
  7. Types of Fact Tables
  8. OLTP (Online Transaction Processing)
  9. OLAP (Online Analysis And Processing)
  10. OLTP Vs OLAP
  11. Advantages of OLAP
  12. Different Methodologies of DWH

Unit 3. Configuration

  1. Informatica configuration
  2. Instigation Services
  3. ETL Folder
  4. ETL Job Filz

Unit 4. Introduction to Informatica Designer

  1. Introduction to Designer
  2. Logon to Designer
  3. Designer interfaces
  4. Designer Tools
  5. Defining Sources
  6. Database as a source
  7. Flat File sources
  8. Defining Targets
  9. Importing from database
  10. Creating a new target
  11. Creating target database objects

Unit 5. Transformation

  1. Aggregate Transformation
  2. Shorter Transformation
  3. Active and Passive Transformations
  4. How Sequencer work and Uses of Sequencer Transformation
  5. Filter Transformation
  6. Lookup transformation
  7. Connected lookup
  8. Unconnected lookup
  9. Joiner Transformation
  10. Filter Transformation
  11. Ranking Transformation
  12. Router Transformation
  13. Expression Transformation
  14. Sequence Generator Transformation
  15. Rank Transformation
  16. Stored Procedure Transformation(Connected and Unconnected)
  17. Union Transformation
  18. XML Transformation

Unit 6. Mapping

  1. Mapping Introduction
  2. Ports
  3. Mapping – Table to Table
  4. Mapping Flat File to Table
  5. Mapping Wizards
  6. Implementing Type-I, Type-II, Type-III Mappings

Unit 7. Qualifier

  1. Source Qualifier Transformation
  2. SQL override in source qualifier transformation
  3. Source qualifier transformation joins concept
  4. Source qualifier transformation on Relational Databases
  5. Source qualifier transformation on File systems
  6. Source qualifier transformation filter concepts
  7. Difference Between SQL Override, Other Options
  8. Source Qualifier to join Data
  9. Source Qualifier Transformation Performance Tunning
  10. Pre SQL and Post in Source Qualifier Transformation

Unit 8. Workflow Manager

  1. Workflow Introduction
  2. Tasks
  3. Workflow tools
  4. Connections
  5. Defining tasks
  6. Command Tasks
  7. Email Task
  8. Session Task
  9. Link Conditions
  10. Event Wait & Event Raise
  11. Setting Properties of Session Task
  12. Creating Workflow
  13. Starting Workflow
  14. Monitoring Workflow

Unit 9. Informatica Advanced Features

  1. Incremental Aggregation
  2. Mapplet Implementation
  3. Target Load Plan
  4. Constraint Based Loading
  5. Mapping Variable
  6. Session Parameters
  7. Link Conditions
  8. Reusable Transformation
  9. Task and Types of Tasks
  10. Work let and Types of work lets
  11. Scheduling Workflow
  12. Control flow using Command task and event wait task
  13. Incremental Loading

About Informatica PowerCenter Certification

Informatica PowerCenter is the base for entire enterprise data Integration. Certification exams gauges knowledge, real-time deployment skills, ensures that Informatica Certified Professionals (ICP) knows exactly how to deliver an outstanding project. Earning ICP certification helps an IT professional to achieve credibility with both employer and other IT industries.

PowerCenter Data Integration 9.x: Developer, Specialist Certification

Informatica University assists professional in gaining knowledge and required skills to leverage and optimize Informatica software and the certification offered by them for Informatica Powercenter Developer is:

  1.  There are no such prerequisites to register this exam
  2. This exam aim on product core functionality inside the realm of a standard project implementation
Exam Details  
  1.  Registration Fee - USD 240
  2.  Exam Time Duration - 90 minutes
  3.  Exam Pattern - Multiple choice questions, true or false, multiple response
  4.  Number of question - 70
  5.  Passing Score - 70%
+From where I can start learning Informatica?
Informatica PowerCenter FAQs Collect more information on Informatica PowerCenter. Join our reputed institute to upgrade your skills and start your career in Informatica PowerCenter.
+What is the difference between Informatica PowerCenter and Developer tool?

PowerCenter is a Windows only client. Informatica has seen the competition (Talend, Pentaho, etc.) being platform independent by using an Eclipse IDE. With big-data platforms primarily focusing on Linux, they are now slowly moving towards being platform independent on the client side too. They also introduced an express edition that was Eclipse-based which only uses the Informatica Developer client. Developer tool is a lighter mode of Informatica PowerCenter.

+What is a derived table in Data Warehousing?
A derived table is mainly used for restricting the data, it is similar to views.
+What is Active Data Warehousing?
Active Data Warehousing delivers information that enables decision-makers of an organization to manage customer relationships efficiently.