'

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 April 2026
  • 28 - 29 April 2026
  • 12 - 13 May 2026

US & Canada:

  • 7 - 8 April 2026
  • 21 - 22 April 2026
  • 5 - 6 May 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

“The trainer was INCREDIBLE. He was extremely passionate, made sure to consistently ask if anybody needed help, logged on early to answer any questions, and was an overall great human being.”

★★★★★

- Salvatore, Hilton Grand Vacations

The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.

Every one of my employees had tons of positive stuff to say.

★★★★★

- Benjamin G, MXSG Analysis and Integration Chief, US Air Force

“Mahesh was an EXCELLENT trainer. Very gifted instructor. Able to clearly communicate and teach objectives. Very engaging made you want to keep learning, and was so patient and kind to all students. Would love to be taught by him anytime.

★★★★★

- Jackie Calvo, Quality Improvement Manager, Horizon Health Center

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        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.

            To discuss your training requirements or book a class, drop us a line