Home All Courses Informatica Training & Certification

Informatica Training & Certification

Edureka's Informatica Online 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.


Watch the demo class

Why this course ?

  • Informatica : A Leader in Entreprise ETL - Forrester Research
  • GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica.
  • Informatica professionals earn upto $130,000 per year - Indeed.com salary data
  • More than 7K satisfied learners. Know about their learning experience Reviews

Instructor-led live online classes

31

Mar
Fri - Sat ( 6 Weeks )
09:30 PM - 01:00 AM ( EDT )
10% Off
19995
17995

09

Apr
Sun - Thu ( 21 Days )
09:30 PM - 11:30 PM ( EDT )
10% Off
19995
17995

06

May
Sat - Sun ( 6 Weeks )
10:30 AM - 02:00 PM ( EDT )
10% Off
19995
17995

07

May
Sun - Thu ( 21 Days )
09:30 PM - 11:30 PM ( EDT )
10% Off
19995
17995

Instructor-led Sessions

42 Hours of Online Live Instructor-led Classes. Weekend class : 12 sessions of 3.5 hours each and Weekday class : 21 sessions of 2 hours each.

Real-life Case Studies

Towards the end of the training, you will be working on a project where you will create a Sales Data Warehouse and Analyze Retail Transaction Information using Informatica.

Assignments

Every class will be followed by practical assignments which aggregates to minimum 40 hours.

Lifetime Access

Lifetime access to Learning Management System (LMS) which has class presentations, quizzes, installation guide & class recordings.

24 x 7 Expert Support

Lifetime access to our 24x7 online support team who will resolve all your technical queries, through ticket based tracking system.

Certification

edureka! certifies you as 'Informatica Expert' based on your project performance, reviewed by our expert panel.

Forum

Access to global community forum for all our users that further facilitates learning through peer interaction and knowledge sharing.

This Informatica training will enable the participants to work with Informatica PowerCenter tool. 

Developers can use Informatica to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations. 

The training will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the end of the training.

Edureka’s training is designed to help you become an Informatica Developer & Informatica Administrator . During this course, our Informatica instructors will help you:

  • Understand and identify different Informatica Products.
  • Describe Informatica PowerCenter architecture & its different components
  • Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
  • Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
  • Understand Workflow Task and job handling
  • Describe Mapping Parameter and Variables
  • Perform debugging, troubleshooting, error handling and recovery
  • Learn to calculate cache requirement and implement session cache
  • Execute performance tuning and Optimization
  • Recognize and explain the functionalities of the Repository Manager tool.
  • Identify how to handle services in the Administration Console
  • Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
  • Gain insights on ETL best practices using Informatica.

Informatica provides the market's leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range of disparate standards, systems, and applications.This unbiased and universal view makes Informatica unique in today's market as a leader in the data integration platform.

Informatica PowerCenter is a premium data integration solution available today. The reason it provides the best solution in large enterprises is because its

  1. Database is neutral and hence can communicate with any database
  2. It is the most powerful data transformations tool and converts one application’s data to another’s format.

Read more on

Why you need to learn Informatica?

The following professionals can go for this Informatica Training by edureka :

1. Software Developers

2. Analytics Professionals 

3. BI/ETL/DW Professionals

4. Mainframe developers and Architects

5. Individual Contributors in the field of Enterprise Business Intelligence

Read all about Career progression with Informatica

Informatica in the ETL space is the market buzz. Having Data Visualisation skill is highly preferred learning path after the Informatica training. Check out our courses such as Data Visualisation with Tableau  and BI & Data Visualisation with Qlikview 

The pre-requisite for this Informatica training at edureka includes basic knowledge of SQL.

Towards the end of this training, you will be working on a live project using Informatica
 
Project #1 : Creation of Sales Data Warehouse 
Industry : Retail 
Data : NorthWind/AdventureWorks dataset. 
Problem Statement : Creation of ETL jobs to build Sales Data Mart using Informatica. 

Project #2 : Transaction Analysis for Retail
Industry : Retail 
Data : Sales data from Real time retail project. ( Data will be masked) 
Problem Statement : Analyzing Retail Transaction Information using Informatica.
You require a computer with 4 GB RAM and 10GB Disk Space  with Dual core CPU .
  • We use the Oracle version of Informatica. Students will have to register themselves on the Oracle Site (edelivery.oracle.com). 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 24x7 support team will promptly assist you.

Learning Objectives - In this, you will understand overview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor. 

Topics - Identify different Informatica Products, Describe PowerCenter as a tool to perform Extract transform and load, Interpret PowerCenter Architecture, its different components and their functionalities, Explain the advantages of component based development techniques in PowerCenter.

Learning Objectives - In this module, you will learn about the ETL and the need behind it. You will also learn how to use Informatica PowerCenter tools to create simple ETL jobs. 

Topics - ETL and ETL Architecture, Flat file and relational Sources using the Source Analyzer, Flat file and relational Targets using the Target Developer, Mappings using the Mapping Designer, Workflows using the Workflow Designer, Monitor the workflow using the Workflow Monitor, Preview Target Data using the PowerCenter Designer.

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

Topics - Describe & Visualize PowerCenter Designer, Explain how to create mapping in Designer, Explain different Transformations & their usage.

Learning Objectives - In this module, you will learn about two more development units of Informatica PowerCenter namely Workflow manager & monitor and how are they used to create different tasks and workflow. 

Topics - Understand PowerCenter Workflow Manager, Describe Flow within a Workflow, Describe Re-usability & Scheduling in Workflow Manager, Understand components of Workflow Monitor, Understand Workflow Task and job handling.

Learning Objectives - In this module, you will understand Advanced Transformation techniques that will equip you to deal with advanced concepts of PowerCenter transformations like, Java, XML etc as well as the re-usability features of PowerCenter.

Topics - Understand the advanced features & functions of Transformations, Learn about Java Transformation, XML File handling, Learn to use Normalizer Transformation, Learn some advanced concepts of ETL, Learn about reusable objects in Informatica.

Learning Objectives - In this module,you will learn that parameters and variables are a way to achieve re-usability from PowerCenter. This module will deal with the scope and use of Parameters & Variables.

Topics - Understand different Parameters and Variables used in PowerCenter, Describe Mapping Parameter & Variables, Learn to use Session Parameters, Learn to use Workflow Variables.

Learning Objectives - In this module, you will understand the operational part of the PowerCenter. This module will help you understand the features provided by Informatica to debug, troubleshoot & handle errors. The concepts of recovery will also be discussed.

Topics - Describe basic PowerCenter Error, Follow a basic troubleshooting methodology, Using the debugger, Use Workflow and Session logs to diagnose errors, Recognize & repair, Connection Errors & Network errors, Design Error Handling Strategies for intended purpose, Understand the recovery scenarios & mechanisms, Properly Configure Workflow & sessions for recovery, Understand the purpose of High Availability, Monitoring the PowerCenter Environment.

Learning Objectives - Caches play important part of any application. This module will help you understand the implementation of Cache by Informatica and how can they be used to accomplish performance efficient ETL jobs. The pros & cons will be covered.

Topics -  Understand the session cache, Describe when and why cache is created, Implement session cache, Learn to calculate cache requirement.

Learning Objectives - The most important concept for any application. Superior performance wins the race everywhere.This module will enlighten the performance aspects of Informatica PowerCenter components and the efficient usage of them.

Topics - Control how PowerCenter uses memory, Control how PowerCenter uses CPUs, Understand the performance counters, Isolate source, target and engine bottlenecks, Tune different types of bottlenecks, Configure Workflow and Session on Grid.

Learning Objectives - More of a Administrators job. This module will tell you about the usage and components of PowerCenter Repository Manager.

Topics - Recognize and explain the functionalities of the Repository Manager tool, Describe how to create and delete folders using the Repository Manager tool, Illustrate how to migrate components using Repository Manager tool.

Learning Objectives - At the completion of this module, you should be able to:

Put in your own words an overview of the PowerCenter Administration Console, Recognize and explain integration and repository service properties. Identify how to handle services In the Administration Console, Explain how to handle locks through the Administration Console, and Illustrate how to create users and groups.

Topics - Put in your own words 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.

Learning Objectives - The technical architecture module has been carefully knitted to give you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular.

Topics - Understand Informatica 9.X Architecture, Describe the Application services related to PowerCenter and their related processes, Understand buffer memory, Describe Connectivity among the tolls, Describe Connection pooling used in PowerCenter.

Learning Objectives - The installation and configuration process along with regular Administration and Operational jobs. The module is most suited for the persons interested into the architectural components of Informatica.

Topics - Step by step installation process, Configuration of different Informatica PC components and their set up, Backup and recovery, Operational procedures.

Learning Objectives - This module will deal with Command line part of Informatica PC. The usage of most frequently used command line tools and their benefits will be discussed

Topics - Informatica frequently used commands, pmrep, pmcmd, infacmd, infasetup.

Learning Objectives - This module will deal with different day to day ETL scenarios and their implementation in Informatica PC.

Topics - SCD, XML Processing, Flat file handling, Different Transformations, For loop implementations in PC, Partitioning, Pushdown optimization, Constraint based loading, Incremental Aggregation.

Learning Objectives - The excerpt from best practices from Informatica Velocity methodologies will help you understand the efficient way of using different Informatica PC components effectively and efficiently. 

Topics - ETL best practices using Informatica, Development Techniques, Error Handling, Data Migration, Performance Tuning.

You will never miss a lecture at Edureka! You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session, in any other live batch.
edureka is committed to provide you an awesome learning experience through world-class content and best-in-class instructors. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. 
We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
All instructors at edureka are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by edureka to provide impeccable learning experience to all our global users.
You can Call us at +91 90660 20867 /1844 230 6362 ( US Tollfree ) OR Email us at sales@edureka.co . We shall be glad to assist you. 

  • Once you are successfully through the project (Reviewed by a edureka expert), you will be awarded with edureka’s Informatica Expert certificate.
  • edureka certification has industry recognition and we are the preferred training partner for many MNCs e.g.Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc. Please be assured.