Informatica Online Training | Informatica Certification Course | Edureka

Informatica Training & Certification


Watch the demo class

Why should you take Informatica 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
  • 12K + satisfied learners. Reviews
About the Course

Edureka's Informatica 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 of Informatica PowerCenter. Throughout our Informatica Training Course, you will be working on real-life industry-based use cases. 

Instructor-led Informatica live online classes

27

Jul
Fri - Sat ( 6 Weeks )
09:30 PM - 01:00 AM ( EDT )
19995
Select This Batch

13

Aug
Mon - Fri ( 21 Days )
10:30 AM - 01:00 PM ( EDT )
19995
Select This Batch

Early Bird Offer

08

Sep
Sat - Sun ( 6 Weeks )
10:30 AM - 02:00 PM ( EDT )
10% Off
19995
17995
Select This Batch
10% Off Valid till 22nd Jul'18

28

Sep
Fri - Sat ( 6 Weeks )
09:30 PM - 01:00 AM ( EDT )
10% Off
19995
17995
Select This Batch
10% Off Valid till 22nd Jul'18
EMI Option availableCall us: +91 98702 76459
100% Satisfaction guaranteed

Edureka For Business

Train your employees with exclusive batches and offers and track your employee's progress with our weekly progress report.
Learning Objectives: In this module of Informatica Training, 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. 

Topics:
  • Informatica & Informatica Product Suite
  • Informatica PowerCenter as ETL Tool
  • Informatica 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 to the server
Learning Objectives: In this module of Informatica Certification Training, we will discuss different Data Integration Concepts. You will be introduced to the concepts - Data Profiling, Data Quality Management, ETL and ETL architecture, and Data Warehousing. 

Topics:
  • Data Integration Concepts
  • Data Profile and Data Quality Management
  • ETL and ETL architecture
  • Brief on Data Warehousing

Hands-On/Demo:
  • Look through the properties of the services required
  • Shutdown and start-up of the services from the Administration Console
  • Creation and execution of a simple pass-through mapping.
Learning Objectives: In this module of Informatica Certification Training, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping and transformations. 

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
Learning Objectives: In this module of Informatica Certification Training, you will learn about development units of Informatica PowerCenter (workflow manager & monitor) and how are they are used to create different tasks and workflow. 

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
Learning Objectives: Through this module of Informatica Certification Training, you will learn about Advanced Transformation techniques which will equip you to deal with advanced concepts of PowerCenter transformations like Java, XML etc. We will also discuss various Error Handling, Transaction Processing & Reusability features available in Informatica. 

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

Hands-On/Demo:
  • Use of advanced transformations like XML Processing, Union etc.
  • Use of inbuilt and custom functions to fulfill the data transformation needs.
  • Reusable transformations, Sessions, Mapplets, etc.
Learning Objectives: In this module of Informatica Training, we will discuss 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 creating Data Warehouses related processes like SCD, Fact and Dimension Loading. 

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)

Hands-On/Demo:
  • Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
  • Advanced techniques - Flat File, XML File
  • Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
Learning Objectives: In this module of Informatica Training, you will understand the features provided by Informatica to debug, troubleshoot & handle error to understand the inner workings and responsibilities of the operational role. Various PowerCenter recovery options and for tasks and workflows will be discussed along with the recommended best practices to the operations process. 

Topics:
  • PowerCenter Error
  • Basic troubleshooting methodology
  • Debugger
  • Workflow and Session logs to diagnose errors
  • Connection Errors & Network errors
  • Recovery scenarios & mechanisms
  • Configure workflow & sessions for recovery
  • High Availability
  • PowerCenter Environment

Hands-On/Demo:
  • Perform troubleshooting of Informatica errors
  • Use of Debugger to debus a mapping
  • Perform workflow and session recovery and related configuration needed for that
Learning Objectives: This module of Informatica Certification Training, highlights the performance aspects of Informatica PowerCenter components and the efficient use of them. We will also discuss about the best practices suggested by Informatica for optimum performance of your ETL process. 

Topics:
  • Performance Tuning Methodology
  • Mapping design tips & tricks
  • Caching & Memory Optimization
  • Partition & Pushdown Optimization
  • Design Principles & Best Practices

Hands-On/Demo:
  • Identify the bottlenecks
  • Different configurations needed to resolve the bottlenecks
  • Learn tips and tricks to code efficient mappings
  • Cache and DTM buffer memory configuration
Learning Objectives: This module of Informatica Training will introduce you to the usage and components of PowerCenter repository manager. You will also learn to migrate and manage the repository effectively. 

 Topics:
  • Repository Manager tool (functionalities, create and delete, migrate components)
  • PowerCenter Repository Maintenance

Hands-On/Demo:
  • Get acquainted with the repository manager tool and its functionalities
  • Creation and editing of a Folder
  • Copy Informatica objects
  • Historical view of session and workflow statistics
Learning Objectives: This module of Informatica Certification Training, 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. 

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

Hands-On/Demo:
  • Learn details of different components of Informatica Administration tool
  • Create user, group, assign privileges to the users and groups
  • Create Roles
  • Looking at the service logs, taking export of the service logs
  • Service maintenance from Administration console
Learning Objectives: This module of Informatica Certification Course deals with command line part of Informatica PowerCenter. You will learn to automate the tasks from the command line as well. 

Topics:
  • Infacmd, infasetup, pmcmd, pmrep
  • Automate tasks via command-line programs

Hands-On/Demo:
  • Use Infacmd, infasetup, pmcmd, pmrep to automate tasks via command-line programs
Learning Objectives: This module of Informatica Certification Training will give you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular. 

Topics:
  • Informatica 10 Architecture
  • Application services
  • Buffer memory
  • Connectivity among the tolls
  • Connection Pooling
. Call a Course Advisor for discussing Curriculum Details . 1844 230 6365
Edureka's Informatica Training will train you on how to administer the tool efficiently, and to upgrade your skills to the latest version. This Informatica Certification course provides you the overview of Informatica PowerCenter Product and its installation, the concepts of data integration and data warehousing. You will learn how different development units of PowerCenter can be used to create a simple mapping. The Informatica Certification Course introduces you to advanced transformation techniques, and ETL scenarios using Informatica 10. You will understand the features provided by Informatica to debug, troubleshoot and handle errors. You will learn the best practices for optimum performance of your ETL process & to manage the repository effectively. An overview of the PowerCenter administration console is given, and you will recognize and be able to explain integration and repository service properties. The Informatica Training Course will also deal with command line aspect of Informatica PowerCenter 10.
Edureka’s Informatica Training is designed by industry experts to make you a Certified Informatica Developer & Informatica Administrator. This Informatica Certification course offers:
  • In-depth knowledge of the Informatica PowerCenter, its Architecture, and Environment
  • Comprehensive knowledge of various tools like Informatica Administrator Suite, Repository Manager, Designer and Workflow Manager
  • Capability to load Dimension Tables, use Advanced Transformation, recognize and repair Connection & Network Errors, configure Workflows & Sessions, create Users and Group and design Error Handling strategies
  • Hands-on knowledge of Informatica PowerCenter command line tools
  • The exposure to many real-life industry-based Business Intelligence Projects
  • Rigorous involvement of an SME throughout the Informatica Training to learn industry standards and best practices

"Informatica provides the market's leading data integration platform"

Tested on nearly 500,000 combinations of platforms and applications, the data integration platform interoperates 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 for the large enterprises is that 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


Informatica Certification Training will help you to become an Informatica expert. It will polish your skills by offering you comprehensive knowledge of ETL Processes, and the required hands-on experience for solving real-time industry-based data integration and big data projects. 
 During Informatica Certification Training Course at Edureka, you will be trained by our expert instructors so you can:
  • Master the ETL and Data Integration concepts
  • Understand the Informatica PowerCenter Architecture
  • Understand Repository Manager and Informatica Administrator Tools
  • Load Dimension Tables
  • Implement various transformations and error handling strategies
  • Learn to recognize the Connection & Network Errors
  • Implement Workflow & Sessions for Recovery
  • Work with the Application Services related to PowerCenter
  • Learn to create Users & Groups
  • Monitor the PowerCenter Environment
  • Work with command line of Informatica

Informatica is a highly favored tool in the ETL and Data Integration market. Learning Informatica can open up lucrative and various growth opportunities. Our Informatica Certification Course will help you to grab this opportunity and accelerate your career. It is best suited for:

1. Data Integration developers

2. Informatica PowerCenter Administrators 

3. BI/ETL/DW Professionals

4. Administrators with some experience managing either PowerCenter or Data Quality

5. Individual Contributors in the field of Enterprise Business Intelligence

6. Database developers and developer Managers new to Informatica PowerCenter

7. Informatica Administrators with some considerable experience in using PowerCenter or maintaining Data Quality


There are no prerequisites for learning Informatica Course in general. However, having knowledge of SQL will be beneficial, but certainly not a mandate.

Towards the end of Edureka Informatica Certification Training, you will be working on a live project using Informatica

Project #1: Build Decision Support System for A Bank
Domain: Banking
Problem statement: A Bank's management committee wants to understand their business needs, customer’s requirement in detail and more accurate manner. They want to build up one Decision support system in which they want some banking report on daily, weekly, monthly basis. The vendor needs to use their database to give an automatic reporting application for present and future requirements. Using Informatica PowerCenter you have to fulfill all the requirements.

Project #2: Create an ETL Process to Load Data for Target Mega Mart
Domain: Retail
Problem statement: Target Mega Mart is planning to build a data warehouse of sales, to enhance their decision support. The business requires a centralized data access for generating various reports to forecast and value their product sales across the branches. Your company has won the proposal for the creating ETL Processes to load data into their data warehouse on a daily, monthly, yearly and on-demand basis.

Project #3: Create an ETL Process for Bank's Analytics System
Domain: Banking
Problem statement: A bank wants to market the new set of credit cards and related products. The customers of the bank, seeking one of these products would be able to submit their application through a website. If the applicant fulfills the eligibility criteria, he/she will be offered the product. You have been given the job to create a set of consolidated files from the source data. Using Informatica PowerCenter, create a set of ETL processes as per the rules.

Final Project: Retrieve and Synchronize Data From FTP
Domain: Retail
Problem statement: Gander Mountain operates the largest retail network of electronic products and accessory stores across the world. Multiple brand acquisitions in the long term have led to information challenges (functional silos, data redundancy, multiple data marts, multiple reporting tools, no common “enterprise” data model, integration and delivery issues, data quality issues, and coordination issues with multiple teams). A study was carried out with input from various stakeholders and the key outcome of this study was to consolidate all the data marts into one single Integrated Data Warehouse (IDW). You must use the Informatica PowerCenter for the implementation of the ETL processes in the project.

Basic system configurations required to execute the practicals involved in Edureka's Informatica Certification are given below: 

Hardware:
  • RAM: 4 GB or more
  • HDD: 15 GB or more
  • Processor: Core i3 or higher

Software:
  • Windows Server Versions, Windows Client Versions (7, 8, 10), Linux
  • Oracle 10g/11g/12c or MS SQL Server

NOTE:
Linux can be used for the installation of Informatica Server but the client software must be installed in Windows only.

  • Option 1:  
    We will help you install the software on your system. The installation manual for installation into Windows system will be provided with step by step execution along with screenshots.

  • Option 2:
    Set up a compute engine in Google Cloud and set up your own Informatica environment there. Step by step method for creating the compute engine and the installation will be shown in a document. You can access the machine from your desktop/laptop as and when required.
  • Note: - Google offers a trial version of cloud some specific days. Please read the conditions before using the services.

The below predictions will help you in understanding the current position and future growth of Informatica:
  • Informatica: A Leader in Enterprise ETL - Forrester Research
  • GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica
  • Informatica professionals earn up to $130,000 per year - Indeed.com

More than 7,000 organizations around the world turn to Informatica that leverages their efforts in business, education, government, healthcare, logistics, manufacturing, and transportation etc. So, to land a worthy job in this field you need to get Informatica Training where you can work on a real-life project and excel in it.

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 10 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.
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.
To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the "create your resume" option.
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 98702 76457 /1844 230 6362 ( US Tollfree ) OR Email us at sales@edureka.co . We shall be glad to assist you. 
You no longer need a credit history or a credit card to purchase this course. Using ZestMoney, we allow you to complete your payment with a EMI plan that best suits you. It's a simple 3 step procedure:
  • Fill your profile: Complete your profile with Aadhaar, PAN and employment details.
  • Verify your account: Get your account verified using netbanking, ekyc or uploading documents
  • Activate your loan: Setup automatic repayment using NACH to activate your loan

Edureka’s Informatica PowerCenter Developer Certificate Holders work at 1000s of companies like

5000 Total number of reviews
4.57 Aggregate review score
80% Course completion rate
No data found
STILL HAVE QUESTIONS. CALL US 1844 230 6365
READ MORE TESTIMONIALS