Informatica PowerCenter Operations and Support Training

ExistBI is an Informatica Partner

Course Description

This two day PowerCenter Operations and Support instructor-led training course provides basic skills and knowledge to people working in a PowerCenter support role. This course will prepare you for that challenge by giving you a through overview Informatica’s development suite of tools, that you may better understand how to troubleshoot oddities and processes that generate errors or process failures.The labs in this course take you from learning the basics of mapping design all the way through operator level processing. In all of this, you will be guided by Informatica’s Velocity methodology.

Course Outcomes

At the end of the course, learners will be able to:

  • Use PowerCenter software to create and understand basic mappings that move data from sources to targets, basic sessions and workflows, and observe the load process and analyze results for successful and failed processes.
  • Understand PowerCenter’s technical connectivity requirements to source or load data from various sources of data.
  • Learn the various ways a PowerCenter session or workflow can be started.
  • Understand and work with the PowerCenter scheduler.
  • Examine the properties of the PowerCenter High Availability option.
  • Learn the command line syntax to schedule a PowerCenter process from the command line via a 3rd party scheduler or script.
  • Learn the primary troubleshooting processes to diagnose errors related to a failed load.
  • Learn the various PowerCenter recovery options for tasks and workflows including how to recover a failed session.
  • Apply Informatica recommended Best Practices to the Operations process transformations

Course Summary

Next Public Course Dates

UK & Europe:

  • 14 - 15 July 2026
  • 28 - 29 July 2026
  • 11 - 12 August 2026

US & Canada:

  • 7 - 8 July 2026
  • 21 - 22 July 2026
  • 4 - 5 August 2026

More dates

Prerequisites
  • Experience in operations environment of assigned area
  • General knowledge of client/server computing environment technologies
  • Understanding of server operating systems
  • Administrator experience
  • Basic problem solving skills
  • Some familiarity with database
  • Connectivity requirements and locations of source / target objects used for ETL processing
Duration
  • 2 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • PowerCenter operational support
  • ETL project managers
  • Team Leads

Course Modules

PowerCenter Functionality & Architecture

  • PowerCenter 8.x Architecture
  • PowerCenter Application services
  • The relationships between the major types of PowerCenter Services
  • How each PowerCenter client application is used
  • PowerCenter 8.x Architecture

Testimonials

“ExistBI, Thank you again for the great Microsoft Power BI, PowerApps and Power Automate courses, our team was very happy”

★★★★★

- Kerry Urofsky, Systems Manager, Service, Avantik

“Mike was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions to remember, so just have to practice with the materials and labs to get acquainted with all of them.”

★★★★★

- Ariel, Analyst, US Military

“Our Informatica Axon and Enterprise Data Catalog training classes were all excellent for our needs.  The trainer really knew a lot about data governance strategy, frameworks, stewardship and actual implementation. As a senior consultant, he had implemented many projects, this really helped in Q&A. Highly recommended.”

★★★★★

- Susan Charles, IT Director, SoFi Bank

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To book this course, please fill in your details and submit the form.

      To book this course, please fill in your details and submit the form.