Exist Management LLC (ExistBI) are a Certified and Authorised Informatica training partner in the United States, Canada, United Kingdom and Europe with the permission to deliver live virtual training services anywhere around the globe.

We deliver the official four-day live instructor-led Informatica PowerCenter training course that introduces delegates to PowerCenter through lecture and hands-on labs. This course is designed for ETL Developers who have no or little experience using this comprehensive PowerCenter tool. The software is used by Developers to create, execute, monitor and schedule ETL processes.


After successfully completing this 9.x/10.x PowerCenter course, you will be able to:

  • Utilize PowerCenter Designer to build mappings that extract data from a source to a target, transforming it as necessary
  • Deploy PowerCenter transformations to cleanse, format, join, aggregate and route data to appropriate targets
  • Perform error handling/trapping using PowerCenter mappings
  • Use PowerCenter Workflow Manager to build and run workflows which execute sessions associated with a mapping and to control data transformation processes.
  • Design and build simple mappings and workflows based on essential business needs
  • Complete basic troubleshooting using PowerCenter logs and debugger

Course Duration

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


  • SQL knowledge
  • Understanding of data warehouse fundamentals


  • Data integration / ETL developers


  • Informatica PowerCenter Overview
  • ETL Essentials: How to use Source Analyzer, Target Developer, Mapping Designer, Workflow Designer, Workflow Monitor and PowerCenter Designer
  • Trouble Shooting: PowerCenter Log files
  • PowerCenter Transformations & Tasks
  • Apply formatting logic with Reusability Designer
  • How to Join and Link Conditions
  • Caching & Lookups
  • Sequence Generators
  • Update Strategies, Routers and Overrides
  • How to use the Debugger
  • Sorter, Aggregator, Unconnected Lookups
  • Mapping Parameter & Variables
  • Maples & Worklets
  • Hands-On Case study: Mapping Design & Velocity Methodology Best Practices
  • Hands-On Case study: Workflow Design & Velocity Methodology Best Practices

Previous PowerCenter 9.x version agenda

Print Friendly, PDF & Email