f

Informatica Training & Certification

  • Home
  • Informatica Training & Certification

Certpine 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.

  • 128K + satisfied learners. Reviews
Weekend $350
Weekdays

Training Features

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 


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 


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

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


Assignments

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


Course Description

About the training

Certpines Informatica Online training will train you on how to administer the tool efficiently; and to upgrade your skills to the latest version. This course extends the skills and knowledge of experienced PowerCenter developers. It will provide you the necessary skills to manage services on this platform. 

The 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 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 practises 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 course will also deal with command line aspect of Informatica PowerCenter 10.

Training objectives

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

  • Describe the Informatica PowerCenter architecture
  • Explain Data Integration concepts
  • Explain different Transformations & their usage
  • Describe Reusability & Scheduling in Workflow Manager
  • Understand the use of advanced transformations
  • Design error handling strategies appropriate for the intended purpose of a workflow
  • Describe the effect of mapping design on performance
  • Monitoring the PowerCenter Environment
  • Understand design principles and best practices
  • Explain repository manager tool
  • Illustrate how to create users and groups
  • Describe the application services related to PowerCenter and their related processes
  • Configure the Informatica Administrator tool
  • Implement techniques for loading Dimensional Tables
  • Recognize & repair Connection Errors & Network errors
  • Configure Workflow & sessions for recovery
  • Understand the Performance Tuning Methodology
  • Learn PowerCenter Repository Maintenance and explain the integration and repository service properties
  • Illustrate how to create users and groups
  • Explain command line of Informatica PowerCenter

Why learn 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.fg

Who should go for this Informatica training?

The following professionals can go for this Informatica Training by Certpine

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

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.

Project

What are the System requirements for this course ?

RAM – 6GB ( Preferred) , 4GB will also do. Disk Space – 15GB OS – Windows Server Versions. Windows Client versions like Windows 7, 8, 10 can also be used but we may face some issues during installation. Linux can also be used as installation of Informatica Server but the client software need to be installed in Windows only. Database – Oracle 10g/11g/12c, MS SQL Server.

 

How will I execute the Practicals?

  • Option 1:  
    We will help you install the software in you system. The installation manual for installation into Windows system will be provided with step by step execution along with screen shot.
  •  
  • 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 then installation will be shown in a document. You can access the machine from your desktop/laptop as and when required.
  • Note: - Google offers trial version of cloud some specific days. Please read the conditions before using the services.

Which Case-Studies will be part of the course?

Towards the end of this training, you will be working on a live project using Informatica
 
Project #1 : 
Bank of Baroda is currently having a series of banks throughout the country. The Bank managing 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 the process of decision support system they want some banking report on daily, weekly, monthly basis. The Bank already has managed their database in Oracle. The vendor need to use their database to give an automatic reporting application for present and future requirements.
 
Some of the main limitations of the existing structure are 
•    Currently report development system is time consuming
•    Lots of manual effort is required to create a report
•    Reports are not advanced in terms of proper selection at run time
•    Chances of error are more.
•    Company is using many product for their applications
 
Project #2 : 
Target Mega Mart was established in 2003. For last 5 years, it is a leading Wholesale & Retail dealer for Consumer goods. Presently they have well established branches running in three major states of US, Texas, Virginia and Pennsylvania. 
Furthermore Target Mart is looking forward towards the Exports as well as the International Business for Wholesale, Retail & Export.
 
The client has been suffering during many years of not having a computerized system for their day to day processing. With many shops spread across many states, each shop created its own system for their day to day activities. It was more and more difficult to follow this method as the accounting was not tracked properly. Hence the company has set out to build a system for tracking the sales data.
 
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 in a daily, monthly, yearly and on-demand basis.
 
Project #3 : 
Bank of New York, wants to market new set of credit cards and related products. The customers of the bank, seeking one of these products offered, would be able to submit their application through a website. The application is sent to various products for approval. If the applicant fulfills the eligibility criteria, he/she will be offered the product. If the applicant accepts the product, the information will be sent to the product so that the application can be fulfilled.
You have been given the job to create a set of consolidated files from the source data the bank is having for the consumption of Banks Analytics system.
Create a set of ETL processes as per the rules mentioned in the mapping document as handed over to you by your team lead.

Final Project #4 : 

With more than 100 locations spread across the country, Gander Mountain operates the largest retail network of electronic products and accessory stores across the world. Headquartered in Texas, our client operates 1,700+ stores in throughout the world. The retail chain acquired many brands as part of expansion in US and Canada.
Multiple brand acquisitions in the long term 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). 
Costs of maintaining multiple data marts and costs of training multiple teams were growing out of control. 
The systems and analysis tools were limited in volume, sophistication and rate of change of data they can handle. 
Significant amount of data was replicated across multiple data marts. 
Getting a single source of truth for data was becoming more and more challenging as the technical landscape was becoming more and more complex with the introduction of multi-vendor Database, ETL and Reporting platforms. Integrating ongoing acquired business’ data into heterogeneous platforms was challenging and uphill task. 
A study was carried out with input from various stakeholders and the key outcome from this study was to consolidate all the data marts into one single Integrated Data Warehouse (IDW). 

Results:
• Single version of truth
• Information Accuracy
• Analytics-Ready Data Warehouse Platform
• Reduced batch time
• Earlier availability of information
• Improvement in business continuity (ability to access critical reports in the event of production data warehouse failure)
• Significant cost savings (licensing cost elimination, Database Administration cost reduction, Reduced network resource usage, reduction in Data 
• Warehouse and ETL operational costs)
• Enable faster integration of new brands and realize related benefits sooner
• One small and efficient team supporting all brands and business units
 
Informatica PowerCenter 10.X has been chosen as the ETL tool for the implementation of the ETL processes in the project.

Curriculum

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

Data Integration and Data Warehousing Fundamentals

Goal : In this module, we will discuss about different Data Integration Concepts. You will be introduced to the concepts - Data Profiling, Data Quality Management, ETL and ETL architecture, and Data Warehousing.

Objectives :

 

  •  
  • Explain Data Integration concepts
  • Understand Data Profile and Data Quality  
  • Describe ETL Architecture & Process flow
  • Describe different ETL methods & Tools
  • Explain Data Warehouse Concepts & Architecture

 

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.

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

 

Hands On/Demo :

  •  
  • Use of advanced transformations like XML Processing, Union etc.
  • Use of inbuilt and custom functions to fulfil the data transformation needs.
  • Reusable transformations, Sessions, Mapplets, etc.

ETL Scenarios using Informatica

Goal : 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

 

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)

Service & Support of PowerCenter Environment

Goal : 
This module will help you 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 practises to the operations process.
 
Objectives :

 

  •  
  • Describe basic PowerCenter Error
  • Follow a basic troubleshooting methodology
  • Use the debugger
  • Use Workflow and Session logs to diagnose errors
  • Recognize & repair Connection Errors & Network errors
  • Understand the recovery scenarios & mechanisms
  • Configure Workflow & sessions for recovery
  • Understand the purpose of High Availability
  • Monitor the PowerCenter Environment

 

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

Performance Tuning, Design Principles & Caches

Goal : This module will highlight the performance aspects of Informatica PowerCenter components and the efficient usage of them. We will also discuss about the best practises suggested by Informatica for optimum performance of your ETL process.
 
Objectives :

 

  •  
  • Understand the Performance Tuning Methodology
  • Learn Mapping design tips & tricks
  • Explain Caching & Memory Optimization
  • Learn Partition & Pushdown Optimization
  • Explain Design Principles & Best Practices

 

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

PowerCenter Repository Management

Goal : This module will introduce you to the usage and components of PowerCenter repository manager and managing the repository effectively. 
 
Objectives :

 

  •  
  • 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
  • Learn PowerCenter Repository Maintenance

 

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

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

 

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

Command Line Utilities

Goal : This module will deal with command line part of Informatica PowerCenter.
 
Objectives :

 

  •  
  • Apply infacmd to domain objects and security
  • Apply infasetup to domain objects
  • Apply pmcmd to execute and control workflows
  • Apply pmrep to manage the PowerCenter Repository
  • Explain Automate tasks via command-line programs: why you need these skills/why you need to know

 

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

Informatica 10 - Technical Architecture

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

FAQ's

What if I miss a class?

You will never miss a lecture at Certpine! 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.

Will I get placement assistance?

Certpine 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.f

Can I attend a Demo Session?

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.

Who are the Instructors?

All instructors at  Certpine  are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by Certpine to provide impeccable learning experience to all our global users.

Certification

Certpine is a high end IT services, training & consulting organization providing IT services, training & consulting in the field of Cloud Coumputing...Read More

Useful Links

Quick Contact

CertPine

© 2018 ARVINE Infotech Pvt. Ltd. Developed By Code Diffusion.