Informatica Certification Training

Informatica Certification Training

Informatica is strategically capitalizing on the current surge in Data Integration demand by introducing its certifications in Data Integration tools, with PowerCenter emerging as the frontrunner. The prevalence of specialized applications in areas such as ERP, manufacturing, and HR has resulted in the generation of diverse data streams that require efficient consolidation.

Informatica PowerCenter, a flagship product, aptly addresses the escalating need for Data Integration and Data Warehousing. It stands out by offering robust solutions for continuous data processing with a zero-latency engine, empowering business users to make timely decisions. Whether clients are embarking on a data warehousing project, integrating or migrating applications, or transitioning to a hybrid architecture, PowerCenter is adept at keeping their business operations agile.


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 PowerCenter 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


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


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 Overview, SQL Tutorial, Data Modeling and DW concepts


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


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.


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.

  • Overview
  • Basic Definitions
  • Informatica products
  • Informatica Architecture
  • Folders-Sub folders
  • ETL Tools and their roles
  • ETL information power center / Power mart
  • Data warehousing (what is Data warehousing /Why Data warehousing/How Data warehousing)
  • Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  • Metadata
  • Dimensional Table
  • Types Of Dim Tables
  • Fact Table
  • Types of Fact Tables
  • OLTP (Online Transaction Processing)
  • OLAP (Online Analysis And Processing)
  • Advantages of OLAP
  • Different Methodologies of DWH
  • Informatica configuration
  • Instigation Services
  • ETL Folder
  • ETL Job Filz
  • Introduction to Designer
  • Logon to Designer
  • Designer interfaces
  • Designer Tools
  • Defining Sources
  • Database as a source
  • Flat File sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects
  • Aggregate Transformation
  • Shorter Transformation
  • Active and Passive Transformations
  • How Sequencer work and Uses of Sequencer Transformation
  • Filter Transformation
  • Lookup transformation
  • Connected lookup
  • Unconnected lookup
  • Joiner Transformation
  • Filter Transformation
  • Ranking Transformation
  • Router Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Stored Procedure Transformation(Connected and Unconnected)
  • Union Transformation
  • XML Transformation
  • Mapping Introduction
  • Ports
  • Mapping – Table to Table
  • Mapping Flat File to Table
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III Mappings
  • Source Qualifier Transformation
  • SQL override in source qualifier transformation
  • Source qualifier transformation joins concept
  • Source qualifier transformation on Relational Databases
  • Source qualifier transformation on File systems
  • Source qualifier transformation filter concepts
  • Difference Between SQL Override, Other Options
  • Source Qualifier to join Data
  • Source Qualifier Transformation Performance Tunning
  • Pre SQL and Post in Source Qualifier Transformation
  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connections
  • Defining tasks
  • Command Tasks
  • Email Task
  • Session Task
  • Link Conditions
  • Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint Based Loading
  • Mapping Variable
  • Session Parameters
  • Link Conditions
  • Reusable Transformation
  • Task and Types of Tasks
  • Work let and Types of work lets
  • Scheduling Workflow
  • Control flow using Command task and event wait task
  • Incremental Loading