Our certified Informatica professionals deliver this custom or classic four-day, instructor-led Informatica PowerCenter 9.x Level 2 Developer training that compliments and extends “PowerCenter 9 Training: Level 1 Developer” with advanced topics and labs. The course is intended for developers with more than three months of PowerCenter project experience. Our experienced trainers can also customize the Informatica training based on your project requirements and teams abilities.

We also offer a special hybrid 5-day PowerCenter 9.x / v10 Level 1 Developer and Level 2 Developer training for more experienced ETL development teams.

Course Duration

  • Four-days of instructor led training
  • 60% lecture, 40% hands-on


  • Data integration / ETL developers


  • PowerCenter 9 Overview
  • Mapping Variables and Parameter Files
  • User-Defined and Advanced Functions
  • Pivoting Data
  • Dynamic Lookups
  • Stored Procedure and the SQL Transformations
  • Error Handling
  • Transaction Processing
  • Transaction Control Transform
  • Workflow and Task Recovery
  • Command Line Utilities
  • Performance Tuning: Methodology
  • Performance Tuning: Mapping Design
  • Performance Tuning: Caching and Memory Optimization
  • Performance Tuning: Partitions