0845 450 6120

Informatica PowerCenter Developer - Part 2

This hands-on four day Informatica PowerCenter 9.x/9.5/9.6 course is a continuation of the "PowerCenter Developer – Part 1" with advanced topics and extended Labs.


Learning Objectives

Topics covered include: High Availability, Pipeline Look-up & Dynamic Look-up Expressions, SQL Transformation & Transaction Control Transformations. Additional topics include: Extended Use of Parameter Files, Use of Command Line Utilities and Mapping Architect for Visio. The course also includes an extensive series of Performance Tuning Workshops including: Methodology, Mapping Design & Cache Management with Memory Optimization.


Completion of Informatica PowerCenter Developer - Level 1 course

Course Content

Course topics

  • PowerCenter Overview
  • User-Defined & Advanced Functions
  • Pivoting Data
  • Stored Procedure & SQL Transformations
  • Transaction Processing
  • Transaction Control Transform
  • Workflow & Task Recovery
  • Command Line Utilities
  • Performance Tuning: Methodology
  • Performance Tuning: Mapping Design
  • Performance Tuning: Caching & Memory Optimization
  • Performance Tuning: Partitions
One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include