Informatica PowerCenter Certification Training

  • (25 REVIEWS )

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.

Description

Informatica is one of the widely used ETL Tool for extracting the source data and loading it into the target after applying the required transformation. It provides a single enterprise data integration platform to help organization access, transform, and integrate data from a large variety of systems and deliver information to other transactional systems. 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

Informatica Supports the activity Process of the Business Integration Competency Center (ICC) and other integration experts by Serving as the foundation for data warehousing, data consolidation, migration, “single-view,” metadata management and synchronization. The Course we provide will give you Advance skills and Advance development knowledge to developers. In addition students shall be exposed to “Performance Oriented tuning techniques”, and some special features of the Tool.

Pre-requisites

1. Basic knowledge of PL/SQL and basic Unix development.
2. Students must be familiar with Concepts in Oracle database and its functionality.
3. Good knowledge of ETL, and Data Warehousing 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 US GlobalSoft will prepare you for all the broad topics covered in the Informatica PowerCenter Developer Certification. US GlobalSoft’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 (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 24×7 support team will promptly assist you.

Informatica Power Center Course Syllabus

INTRODUCTION TO DATAWAREHOUSING

  • Data Warehousing Concepts
  • Dataware housing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions
  • Metadata

PowerCenter Components and User Interface

  • PowerCenter Architecture
  • PowerCenter Client Tools
  • Lab – Using the Designer and Workflow Manager

Introduction to Informatica Power Center Designer

  • Source Analyzer
  • Target Designer
  • Mapping Designer

Informatica Power Center Workflow Designer

  • Workflow Designer
  • Task developer
  • Work let Designer

Informatica Power Center Workflow Monitor

  • Job status
  • Job session logs

Loading Strategy

  • Flat  file to flat file load
  • Flat file  to database load
  • Database to database load
  • Database to flat file load
  • Xml file to database load
  • Xml file to flat file load

Different Transformations

  • Source Qualifier
  • Source Qualifier Join
  • Source Qualifier Filter
  • Expression
  • Connected Stored Procedure
  • Unconnected Stored Procedure
  • Sequence Generator
  • Aggregator
  • Filter
  • Lookup
  • Joiner
  • Router
  • Rank
  • Sorter
  • Union Transformation
  • Xml Source Qualifier
  • Using Flat Files as Sources
  • Using Flat Files as Source and Target
  • Using XML Files as Source
  • Reading Data From Multiple Data Bases
  • Update Strategy
  • Target Load Plan

Informatica Administration

  • Installation of Informatica
  • Installation of Oracle Database
  • Installation of SQL Server
  • Creation Repository
  • Creation of Users
  • Assigning Privileges to users
  • Creation of Groups
  • Adding the Repository to Informatica Repository Manager
  • Creating Data source Connections
  • Configuration of Sql server and Oracle Database with Informatica
  • Scheduling the Workflow

Source Qualifier

  • Source Qualifier Transformation
  • Source Pipelines
  • Source Qualifier  Filter and Real time issues
  • Source Qualifier SQL over query

Expression, Filter, File Lists and Workflow Scheduler

  • Expression Editor
  • Filter Transformation
  • File Lists
  • Workflow Scheduler
  • Lab – Load the Customer Staging Table and Real time issues

Joins, Features and Techniques

  • Joiner Transformation
  • Shortcuts
  • Lab – Features and Techniques I and Real time issues

Lookups and Reusable Transformations

  • Lookup Transformation
  • Reusable Transformations
  • Lab A – Load Employee Staging Table
  • Lab B – Load Date Staging Table and Real time issues

Debugger

  • Debugging Mappings
  • Lab – Using the Debugger

Sequence Generator

  • Sequence Generator Transformation
  • Lab – Load Date Dimension Table and Real time issues

Router, update Strategy and Overrides

  • Router Transformation
  • Update Strategy Transformation
  • Expression Def ault Values
  • Source Qualifier Override
  • Target Override Session Task Mapping Overrides
  • Lab – Load Employee Dimension Table and Real time issues

Unconnected Lookup, Parameters and Variables

  • Unconnected Lookup Transformation
  • System Variables
  • Mapping Parameters and Variables
  • Lab – Load Sales Fact Table

Sorter, Aggregator and Self-Join

  • Sorter Transformation
  • Aggregator Transformation
  • Active and Passive Transformations   Data Concatenation    Self -Join
  • Lab – Reload the Employee Staging Table and Real time issues

SCD type1
SCD type2
SCD type3

Mapplets

  • Mapplets
  • Review and more Activities and Real time issues

Worklets and More Tasks

  • Worklets
  • linkTask
  • Lab – Load Inventory Fact Tabl

 

Certification

Certification assistance provided with proper guidance and certification notes.