Facebook Pixel
E-learning
flash sale
Up to 15% off e-learning
Use offer code: ONLINE20SA
LIVE OFFERS END IN
Up to 15% off e-learning - Use offer code: ONLINE20SA
Informatica Powercenter training Gain the skills needed to step into the field of ETL and data warehousing
From {% configuredPrice() | ilxCurrency:currentCurrency %} Was {% configuredPrice() | ilxCurrency:currentCurrency %}
From {% configuredOfferPrice() | ilxCurrency:currentCurrency %}
Without exams
Request a quote
Course type: E-learning
Delivery: Online

Informatica Powercenter E-learning

Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used for data integration. 

The Informatica PowerCenter course trains you on various aspects of the Informatica administrator console and transformations. You will understand slowly changing dimension problems to sharpen your data warehousing skills.

About the course

This Informatica training course by ILX equips you with all the skills required to step into the field of ETL and data warehousing using the most in-demand tool - Informatica PowerCenter. You will build your ability in developing beginner to intermediate level of PowerCenter objects, gain expertise in the practical use of the Designer, Workflow Manager, Workflow Monitor tools, and master advanced transformations concepts.

Pre-requisites

There are no prerequisites for this training but some good to know topics are SQL, databases and some scripting language.

Learning objectives

By the end of the course you will be able to:

  • Understand basic mapping design including the use of Informatica PowerCenter Designer, Workflow manager, and workflow monitor tool
  • Master source qualifier, expression, aggregator, lookup, filter, joiner and other kinds of transformations
  • Add transformations using input and output ports
  • Work with transformation functions and expression syntax
  • Implement SCD1, SCD2, and SCD3 mappings

Informatica PowerCenter is offered by Simplilearn, a partner of ILX Group.

Duration of access

12 months online access to accredited e-learning

What's covered?

The course will cover the following topics:

  • Lesson 1 - Downloading Informatica PowerCenter 9.x 
  • Lesson 2 - Installing and configuring PowerCenter 
  • Lesson 3 - Getting familiar with the admin console 
  • Lesson 4 - Setting up security, permissions, and client configuration 
  • Lesson 5 - Using the designer screen 
  • Lesson 6 - Creating mappings
  • Lesson 7 - Adding transformation using input and output ports 
  • Lesson 8 - Setting up a path and connection 
  • Lesson 9 - Getting accustomed to the workflow monitor screen 
  • Lesson 10 - Working with the repository manager screen 
  • Implementing Informatica PowerCenter 9

Target audience

This course is perfect for taking your initial steps into the field of ETL and data warehousing. It's suitable for:

  • ETL and data-warehousing professionals
  • SQL and database developers
  • Business intelligence professionals
  • Mainframe professionals
  • Project managers

There is no exam available, but you must complete 85% of the course to obtain a certificate.

Why Choose ILX Group?

customer satisfaction
96%
customer satisfaction
World class trainers

World-class,
experienced trainers
Training globally

One of the largest providers
of PRINCE2 training globally