PowerCenter Developer, Level 1

ExistBI is an Informatica Partner

Course Description

This 4-day live instructor-led Informatica PowerCenter: Developer, Level 1 training 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.

Explore Informatica PowerCenter 10 which is comprised of server and client workbench tools used to create, execute, monitor and schedule ETL processes. Work through the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools while performing tasks such as creating source and target definitions, transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data.  Applicable for versions 9.x to 10.x users.

We are a certified and approved Informatica University training partner with the permission to deliver onsite or live instructor-led online Informatica PowerCenter training anywhere around the globe.

Course Outcomes

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

  • Use the PowerCenter Designer interface to design data transformations.
  • Manage a variety of source and target definitions.
  • Filter, join, aggregate, categorize, merge, and apply expression logic to data without writing SQL.
  • Monitor and repair PowerCenter Sessions and Workflows.
  • Troubleshoot mapping problems with the debugger.
  • Leverage object reusability (build-once, use everywhere)
  • Benefit from specific Agile Data Integration best practice techniques.

Course Summary

Next Public Course Dates

UK & Europe:

  • 3 - 6 February 2026
  • 17 - 20 February 2026
  • 3 - 6 March 2026

US & Canada:

  • 10 - 13 February 2026
  • 24 - 27 February 2026
  • 10 - 13 March 2026

More dates

Prerequisites
  • None
Duration
  • 4 Days
  • 60% theoretical, 40% practical
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Data Integration developers with little or no experience of PowerCenter
  • Database Developers and developer Managers new to Informatica PowerCenter

Course Modules

Introduction to PowerCenter

  • How PowerCenter performs data integration
  • Advantages of code-free and SQL-free development
  • Informatica architecture
  • PowerCenter components and applications
  • PowerCenter object types
  • Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor

Command Tasks

  • Running command line statements within a Workflow
  • Lookup caching properties
  • Persistent lookup caches
  • Aliasing a lookup port

Testimonials

“The Informatica Cloud Data Integration for Developers training class was excellent, the teacher was very knowledgeable and the materials were very useful”

★★★★★

- James Martin, Data Engineer, RoyOMartin

“Tomi was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions, so the Informatica materials and lab books are super helpful.”

★★★★★

- Leroy Smith, ETL Developer, US Army

“Our training was great!  The trainer really knew a lot about the Informatica Platform from Data Integration, Data Quality and Data Governance perspective.”

★★★★★

- Patrick White, IoT Manager, Orbus Software

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