New Course Enquiry: +1 805 200 4058 (USA) +1 302 360 8582 (USA)
Follow Us:
Informatica Live online

Informatica PowerCenter Certification Training Course

CertOcean's Informatica PowerCenter Certification training is a live, instructor-led online course. You learn in 16 live sessions (42 hours in total) with an expert instructor, work through 9 curriculum modules with hands-on assignments and keep lifetime access to the class recordings.

4.9Rated Excellent on Trustpilot
  • 42 hoursLive training
  • 16 sessionsWith an instructor
  • 9 modules60 topics
  • Mon, Oct 26Next batch
INFA InformaticaLive instructor-led training
$350 $400 One-time · USD
You save$5013% off
Enroll now
Not sure yet? Talk to a course advisor
  • Pass or full refund, in writing
  • Secure checkout
Course overview

About the Informatica PowerCenter Certification training

Informatica training teaches you to extract, transform and load data with Informatica PowerCenter, one of the most widely used enterprise ETL tools.

Why learn Informatica PowerCenter?

  • Large enterprises in banking, retail, healthcare and logistics run PowerCenter for their data integration.
  • Experienced Informatica developers are well paid, which shows the demand for the skill.
  • PowerCenter skills carry over to Informatica's cloud platform (IDMC) as companies modernize.

This course includes

  • Instructor-led live classes42 hours of live online classes. Weekend batch: 12 sessions of 3.5 hours each. Weekday batch: 21 sessions of 2 hours each.
  • Real-life case studiesToward the end of the course, you build a sales data warehouse and analyze retail data.
  • AssignmentsEvery class is followed by practical assignments, adding up to at least 40 hours of practice.
  • Lifetime accessKeep lifetime access to all course material, including presentations, quizzes, installation guides and class recordings.
  • 24/7 expert supportOur support team is available 24x7 to answer technical questions.
  • CertificationComplete the final project to receive CertOcean's Informatica PowerCenter certificate.

What you'll learn in this course

  • Understand data integration and data warehousing basics
  • Use the Informatica PowerCenter tools and architecture
  • Build mappings with common and advanced transformations
  • Create tasks, sessions and workflows
  • Solve real ETL scenarios and reuse components
  • Administer PowerCenter, tune performance and manage the repository

What is Informatica certification training?

Informatica certification training is a course that teaches you to build and manage ETL processes with Informatica PowerCenter, and to work with Informatica's cloud platform, IDMC. CertOcean's course starts with an overview of PowerCenter, its installation and the basics of data integration and data warehousing. You then use PowerCenter's development tools to build mappings, and move on to advanced transformations and ETL scenarios. You also learn how to debug, troubleshoot and handle errors, follow recommended practices for ETL performance and repository management, work with the PowerCenter Administrator console, explain Integration Service and Repository Service properties, and use PowerCenter's command-line tools.

Standard support for PowerCenter 10.5 ended on March 31, 2026, and many companies are moving their PowerCenter jobs to Cloud Data Integration in IDMC. The final module shows you how that move works, so you can support both.

What are the objectives of Informatica training?

This course prepares you for Informatica developer and administrator roles. You will:

  • Understand Informatica PowerCenter, its architecture and environment
  • Use the Administrator console, Repository Manager, Designer and Workflow Manager
  • Load dimension tables
  • Use advanced transformations
  • Find and fix connection and network errors
  • Schedule workflows and sessions
  • Create users and groups
  • Plan error-handling strategies
  • Build mappings and taskflows in IDMC Cloud Data Integration

Who should take Informatica training?

Informatica is a leading tool in the ETL and data integration market, and learning it can open well-paid career options. This course suits:

  • Data integration developers
  • Informatica PowerCenter administrators
  • BI, ETL and data warehouse professionals
  • Administrators with some experience managing PowerCenter or Informatica Data Quality

What are the prerequisites for Informatica training?

There are no prerequisites. The course is designed for people from different backgrounds, whether you already work in IT or are just starting with Informatica.

What are the system requirements for Informatica training?

You need a computer with a reliable internet connection.

How do the hands-on Informatica practicals work?

You do all the projects in a lab environment set up for this course.

Curriculum

Informatica PowerCenter Certification course syllabus

9 modules · 60 topics · 42 hours of live training

Introduction to Informatica PowerCenter 7 topics
  • Learning goal: Get an overview of Informatica's products and PowerCenter's architecture, terminology and tools, and install PowerCenter.
  • The Informatica product suite, now part of Salesforce
  • PowerCenter as an ETL tool
  • PowerCenter architecture and terminology
  • Mappings, sessions, workflows and the Workflow Monitor
  • Component-based development
  • Installing Informatica PowerCenter 10.5
Data Integration and Data Warehousing Fundamentals 5 topics
  • Learning goal: Learn the core concepts of data integration, data quality, ETL and data warehousing.
  • Data integration concepts
  • Data profiling and data quality management
  • ETL and ETL architecture
  • Data warehousing overview
Informatica PowerCenter Transformations 5 topics
  • Learning goal: Use PowerCenter's development tools to build mappings with transformations.
  • PowerCenter client tools
  • Data flow
  • Creating and running mappings
  • Transformations and how to use them
PowerCenter Tasks and Workflows 6 topics
  • Learning goal: Create tasks and workflows with Workflow Manager and track them in Workflow Monitor.
  • PowerCenter Workflow Manager
  • Flow within a workflow
  • Reusability and scheduling
  • Workflow Monitor components
  • Workflow tasks and job handling
Advanced Transformations, Techniques and Reusability 6 topics
  • Learning goal: Use advanced transformations such as Java and XML, plus error handling, transaction processing and reusable objects.
  • Advanced transformations
  • XML file processing and transaction processing
  • Error handling features
  • Data cleansing
  • Reusability features
ETL Scenarios with Informatica 8 topics
  • Learning goal: Solve advanced ETL scenarios and run data warehouse loads.
  • Error handling and partitioning
  • Pushdown optimization
  • Change data capture (CDC)
  • Incremental aggregation
  • Constraint-based loading and target load order groups
  • Slowly changing dimensions (SCD), and fact and dimension loading
  • Advanced techniques for flat files and XML files
Administering and Supporting the PowerCenter Environment 9 topics
  • Learning goal: Troubleshoot PowerCenter, handle errors, plan recovery and follow best practices for operations.
  • PowerCenter errors
  • Basic troubleshooting methods
  • The Debugger
  • Using workflow and session logs to diagnose errors
  • Connection and network errors
  • Recovery options for tasks and workflows
  • High availability
  • The PowerCenter environment
Performance Tuning, Design Principles and Caches 6 topics
  • Learning goal: Tune PowerCenter components and apply Informatica's recommended practices for ETL performance.
  • Performance tuning methods
  • Mapping design tips
  • Caching and memory optimization
  • Partitioning and pushdown optimization
  • Design principles and best practices
Repository Management and Moving to IDMC Cloud Data Integration 8 topics
  • Learning goal: Maintain and migrate the PowerCenter repository, and learn how PowerCenter work moves to Informatica's cloud platform.
  • Repository Manager components
  • Repository maintenance
  • Migrating repository objects
  • Informatica Intelligent Data Management Cloud (IDMC) overview
  • Cloud Data Integration mappings, mapping tasks and taskflows
  • The Secure Agent and connections
  • Modernizing PowerCenter jobs for Cloud Data Integration

Get the detailed syllabus

Receive the full module plan, batch timings and a call with an advisor who can answer your exam questions.

Request syllabus
Upcoming batches

Next Informatica PowerCenter Certification batches

Live online classes with an instructor, 9:00 AM to 5:00 PM Eastern Time (ET).

Weekday batch

Starts Monday, October 26

Starts in 2 days · Live online

Enroll
Weekend batch

Starts Saturday, October 31

Starts in 7 days · Live online

Enroll
Flexible

Need another date or time?

Ask for a private or custom schedule.

Ask us
Sample certificate
Certification

Earn your Informatica PowerCenter Certification certificate

  • Certificate of completionIssued by CertOcean when you finish the training and assignments.
  • Show it to employersAdd it to your LinkedIn profile and resume.
Start your certification
Learner reviews

Why learners choose CertOcean

Rated Excellent · 4.9 out of 5 on Trustpilot
The training curriculum was great. CertOcean provided me everything required to obtain my CISM. They're excellent!
Laxmi Haya Vadan KaramcheduUnited States · CISMVerified
Very resourceful company, I passed my PMP exam at first attempt, highly recommended.
IjeomaCanada · PMPVerified
Great training support! Helped me pass several certifications.
Cozumel TyUnited StatesVerified
  • US, Canada and UK hoursClasses set around your working day
  • Expert instructorsWorking professionals in your field
  • Career supportResume and interview help
FAQ

Informatica PowerCenter Certification course FAQs

Can't find your answer? A course advisor can help with the syllabus, batch dates and exam questions.

Chat on WhatsApp Request a callback
How much does the Informatica PowerCenter Certification course cost?

The Informatica PowerCenter Certification training costs $350, down from the regular $400 (you save 13%). It is a one-time payment in US dollars, and you can pay securely by card or PayPal.

How long is the Informatica PowerCenter Certification course, and when does it start?

The course runs for 42 hours of live, instructor-led online training across 16 sessions. Weekend and weekday batches are available, and the next batch starts on Monday, October 26, 2026.

What if I miss an Informatica class?

You can watch the class recording in your LMS, or attend the same session in the next live batch.

Who can I contact if I have a problem during the course?

Contact our support team, available 24x7. Ask any question about the course and we will resolve it as quickly as possible.

Who are the instructors for CertOcean's Informatica course?

Our instructors are Informatica practitioners with more than 10 years of experience, chosen through a careful selection and training process.

Do you offer placement support?

Your LMS includes a resume builder tool with unlimited access to templates for different roles. Log in to your LMS and click "Create your resume".

Can I get help after completing the course?

Yes. Our support continues after your course ends, so you can keep asking functional and technical questions.

Why take an online Informatica course instead of an offline one?

Online classes give you flexibility: you join live sessions from anywhere, watch recordings when you need to, and keep lifetime access to the material. You still get guidance from an instructor throughout the course.

Will I get a certificate after the Informatica PowerCenter Certification training?

Yes. You receive a CertOcean certificate of completion when you finish the training.

Free course consultation

Talk to an Informatica PowerCenter Certification advisor

Share your details and we will send the syllabus, the next batch dates and the best plan for your exam date.

  1. 1Tell us your goal and exam date
  2. 2Get the syllabus and batch options
  3. 3Enroll when you are ready
+1 805 200 4058 WhatsApp us support@certocean.com

Get the syllabus and batch dates

Takes under a minute. No payment needed.

Course

Informatica PowerCenter Certification

By sending this form you agree to our Terms of Use and Privacy Policy. We never share your details.

More Data Warehousing & ETL courses

View all
Save 13%TALENDTalendLive training Talend for Data Integration and Big Data Next batch Oct 26 $314$360View course Save 12%DWData WarehousingSelf-paced training Data Warehousing Certification Self-paced · start today $149$170View course Save 45%DWBIData Warehousing · BILive training Data Warehousing and BI Next batch Oct 26 $99$179View course