Informatica PowerCenter: Developer, Level 1 Training

ExistBI is an Informatica Partner

Course Description

We deliver the 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.

Exist Management LLC (ExistBI) is a Certified and Approved Informatica University training partner in the United States, Canada, United Kingdom and Europe 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:

  • 2 - 5 December 2025
  • 16 - 19 December 2025
  • 6 - 9 January 2026

US & Canada:

  • 9 - 12 December 2025
  • 13 - 16 January 2026
  • 27 - 30 January 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

“Great Tableau Course.  Lots of information packed into short period.”

★★★★★

- Matt, Data Analyst, Fortune Brands

“Hands-down the best technical training I have taken! The methods of progressively building reports, adding complexity and features as time goes on, was fantastic.”

★★★★★

- Chris, Cirrus Aircraft

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

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