Courses × Browse Corporate Training All Courses

Informatica PowerExchange Certification Training

4.8 507 Ratings 2,612 Learners

Intellipaat’s Informatica PowerExchange training is an online training program led by experts from top MNCs who have 12+ years of experience. Our trainers will help you master MySQL CDC, the use of PWX, data logging, and other modules of Informatica PowerExchange through online sessions and the project work to make you a certified Informatica professional.

Key Features

50 Hrs Instructor-led Training
45 Hrs Self-paced Videos
100 Hrs Project Work & Exercises
Flexible Schedule
24 x 7 Lifetime Support & Access
Certification and Job Assistance

Career Transitions

Kalyani Umare
Kalyani Umare
Consultant to Developer
Consultant intellipaat-image
ETL Developer intellipaat-image
Mitali Dhar
Mitali Dhar
Sr. Engg to Project Lead
Senior Software Engineer intellipaat-image
Project Lead intellipaat-image
Er. Sushil Kuvind
Er. Sushil Kuvind
Database Developer to Programmer
Software Database Developer intellipaat-image
Developer intellipaat-image
Sawal Jain
Sawal Jain
Developer to Consultant
Software Developer intellipaat-image
Associate Consultant intellipaat-image
Akhil Desai
Akhil Desai
Fresher to Consultant
Project Trainee intellipaat-image
SCM Procurement Functional Excellence intellipaat-image
Poojitha Pastham
Poojitha Pastham
Non Tech to Tech
Assistant Manager intellipaat-image
Sr. Software Engineer intellipaat-image
Anish Nayan
Anish Nayan
Non Tech to Tech
Product Analyst (Analytics) intellipaat-image
Senior Software Engineer intellipaat-image

Course Benefits

4.8/5 Student Satisfaction Rating
Students Transitioned for Higher Positions
Started a New Career After Completing Our Courses
Got Better Salary Hike and Promotion
intellipaat-image intellipaat-image
intellipaat-image intellipaat-image
And 1,000+ Global Companies

Informatica PowerExchange Online Training Overview

Intellipaat’s Informatica PowerExchange training is curated to make you an expert in PowerExchange by teaching you the use of SQL syntax, the VSAM process, creating data maps, integrating PowerCenter and PowerExchange, etc.

What will you learn from Intellipaat’s Informatica PowerExchange training?

You will learn the following topics in our Informatica PowerExchange online training:

  • PowerExchange and its navigator
  • Data maps and flat files
  • SQL syntax
  • VSAM data maps
  • Integration of PowerCenter
  • Integration of PowerExchange Oracle CDC
  • Field sensitive change capture
  • PowerExchange Oracle, MySQL, and i5/OS CDC

To enroll in this Informatica PowerExchange course, you must clear the PowerCenter: Data Integration for Developers or PowerCenter: Developer, Level 1 certification.

Those professionals who have a zeal to learn and pursue a career in Informatica can enroll in this training program.

You must register for this Informatica PowerExchange online training for the reasons mentioned below:

  • In the United States alone, there are 2,800+ jobs available for Informatica professionals – Indeed
  • Informatica-certified professionals earn an average of US$100,400 per annum – PayScale
  • Top MNCs, such as JPMorgan Chase, CSG, Nokia, Deloitte, etc., are looking to hire professionals skilled in Informatica – LinkedIn
View More

Talk to Us

Informatica PowerExchange Course Content

Module 1 - Introduction to PowerExchange

1.1 PowerExchange functionality
1.2 Architecture and components of PowerExchange
1.3 Features and advantages
1.4 Configuration file of DBMOVER

Module 2 - PowerExchange Navigator

2.1 Navigator functions and objects
2.2 Copybooks and data maps
2.3 Personal metadata
2.4 Navigator object management
2.5 Data map creation using an EBCDIC file

3.1 Developing a data map
3.2 Records in a file
3.3 Processing of the field level
3.4 Expression fields
3.5 Table definitions
3.6 Processing of arrays
3.7 Manual data maps
3.8 Using COBOL Copybook Array processing

4.1 SQL WHERE Clause
4.3 Personal metadata: Creating and testing
4.4 Filter records
4.5 Array handling

5.1 File and field data formats
5.2 Binary data variable length
5.3 Decoding complex flat files

6.1 VSAM
6.2 VSAM datasets
6.3 Access methods
6.4 Creating data maps
6.5 Performing row tests
6.6 Creating a data map using a VSAM file
6.7 Creating a data map using a multi-layout file

7.1 Using PowerExchange Client for PowerCenter (PWXPC)
7.2 Advantages of PWXPC
7.3 Sources and targets of PWXPC
7.4 Integrating with PowerCenter

8.1 Architecture of PowerExchange Oracle RT CDC
8.2 Application characteristics to extract changes
8.3 PWX Oracle CDC
8.4 Using PWX to register Oracle Source for CDC
8.5 Creating a registration group

9.1 Creating PowerCenter workflows and mappings with PowerExchange Client
9.2 PowerCenter (PWXPC)
9.3 Restart/recovery session features using PWXPC
9.4 Remote data logging
9.5 PowerExchange CDC Publisher
9.6 Materializing target using workflow integration and PowerExchange mapping

10.1 Concepts of Field Sensitive Change Capture
10.2 CI (Change Indicator) vs BI (Before Image)
10.3 Filtering unwanted change records from extraction

11.1 Architecture of PowerExchange SQL Server CDC
11.2 PWX SQL Server CDC
11.3 Configuring the parameters of Consumer API (CAPI)
11.4 Enabling distribution with the console of SQL Server Management
11.5 Registering the source of SQL Server for CDC with PWX
11.6 Managing schema changes

12.1 MySQL CDC
12.2 Configuration of MySQL for CDC
12.3 Configuration of PowerExchange for MySQL CDC
12.4 Building the MySQL registration group
12.5 Performing the row test
12.6 Setting up MySQL

13.1 i5/OS CDC
13.2 Architecture of i5/OS PowerExchange CDC
13.3 Extraction maps
13.4 DB2 for i5/OS CDC
13.5 Task flow to extract the change data
13.6 Setting up AS400 DB2 for CDC

14.1 Data map utility (DTLURDMO)
14.2 Remote program utility (DTLREXE)
14.3 Utilities of reporting
14.4 Executing, managing, and monitoring utilities

15.1 Monitoring CDC processes
15.2 Heartbeat tables
15.3 PowerExchange service failover
15.4 Opportunities for performance enhancement in the PWX Oracle CDC environment

View More

Informatica PowerExchange Projects

Data Map Creation

You need to create data maps for your company using VSAM and multi-layout files.


Creating a Registration Group

In your company, you need to build registration groups to perform DB2 AS/400 and DB2 I series/zOS CDC.


Informatica PowerExchange Certification

Informatica PowerExchange Certification

How to be an Informatica professional?

To become a professional skilled in Informatica, you must enroll in our Informatica PowerExchange training course and learn all the concepts and skills in this technology. Further, you will have to work on numerous industry-based projects that will allow you to put your skills to test. Upon the completion of the course, you will receive a course completion certificate from us.

To unlock your Informatica PowerExchange certificate, you must complete the training program and successfully execute all projects and assignments included in the program.

Yes. As part of our Informatica PowerExchange training, we offer one practice test that lets you understand the types of questions that may be asked in the actual exam and the pattern of the same.

You will be able to execute all the projects included as part of Intellipaat’s PowerExchange online training under the guidance of the trainers.

View More

Informatica PowerExchange Training Reviews


Mr Yoga


John Chioles




Dileep & Ajay





Ramyasri Mandepudi

Recruiter at Goodwill Technologies

The online training sessions conducted by the trainers of this Informatica PowerExchange course were among the best. They taught all the modules well, which made it easy for me to grasp the concepts and put them to practical use.

Prateek Sareen

IT Analyst at Tata Consultancy Services

One of the best things about this Informatica PowerExchange: Mainframe Data Extraction and Change Data Capture classses is its projects and case studies. These were industry-specific projects that let me put the skills that I had learned to use. They helped me gain experience in working with this technology.

Narasimha Prasad

CTO & Architect

The job assistance team of this Informatica PowerExchange training course helped me land a lucrative job in this field much easier. They prepped me via mock interviews, resume preparation, etc., and helped me gain the confidence to crack the job interview. Thank you, Intellipaat!

Arpit Sharma

Sr. Software Engineer at Conduent

I had enrolled in the Informatica course and had a great learning experience. The trainer was kind and knowledgeable. The support team is also very responsive. Overall, I would like to recommend Intellipaat to all the learners.

Anant Dubey

Assistant Manager at MetLIFE

I had taken up the Informatica course and I was really happy with the quality of the training. The trainer was very experienced and the support team was also very cooperative. My experience with them was awesome. The training material that was provided to us was also of high quality. Overall, my experience was above expectations.

Informatica PowerExchange Online Training FAQs

Why enroll in Intellipaat’s Informatica PowerExchange training?

Informatica PowerExchange online training at Intellipaat aims to make you an Informatica professional with expert-level knowledge and skills in this domain. This is an online instructor-led training that covers all the core concepts and techniques of Informatica PowerExchange.

You will get numerous benefits through this online training program, including 24 hours of online support, lifelong free course upgrades, access to the courseware for a lifetime, and much more. During the course, you will work on real-time assignments, projects, and case studies that will help you gain hands-on experience in the domain. The placement team at Intellipaat will conduct demo interviews, prepare your resume, and more to help you land a lucrative job. Also, you will receive an industry-recognized Informatica PowerExchange training course completion certificate from us that will add value to your resume further.

Other popular courses are SalesforceSeleniumSQLPower BIMSBITableau, etc.

Intellipaat offers various Informatica courses such as Informatica Training, Informatica MDM, Informatica Big Data Management, and Informatica Cloud.

At Intellipaat, you can enroll in either the instructor-led online training or self-paced training. Apart from this, Intellipaat also offers corporate training for organizations to upskill their workforce. All trainers at Intellipaat have 12+ years of relevant industry experience, and they have been actively working as consultants in the same domain, which has made them subject matter experts. Go through the sample videos to check the quality of our trainers.

Intellipaat is offering the 24/7 query resolution, and you can raise a ticket with the dedicated support team at anytime. You can avail of the email support for all your queries. If your query does not get resolved through email, we can also arrange one-on-one sessions with our trainers.

You would be glad to know that you can contact Intellipaat support even after the completion of the training. We also do not put a limit on the number of tickets you can raise for query resolution and doubt clearance.

Intellipaat is offering you the most updated, relevant, and high-value real-world projects as part of the training program. This way, you can implement the learning that you have acquired in real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, making you completely industry-ready.

You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. After completing the projects successfully, your skills will be equal to 6 months of rigorous industry experience.

Intellipaat actively provides placement assistance to all learners who have successfully completed the training. For this, we are exclusively tied-up with over 80 top MNCs from around the world. This way, you can be placed in outstanding organizations such as Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, and Cisco, among other equally great enterprises. We also help you with the job interview and résumé preparation as well.

You can definitely make the switch from self-paced training to online instructor-led training by simply paying the extra amount. You can join the very next batch, which will be duly notified to you.

Once you complete Intellipaat’s training program, working on real-world projects, quizzes, and assignments and scoring at least 60 percent marks in the qualifying exam, you will be awarded Intellipaat’s course completion certificate. This certificate is very well recognized in Intellipaat-affiliated organizations, including over 80 top MNCs from around the world and some of the Fortune 500companies.

Apparently, no. Our job assistance program is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and find a well-paid job, matching your profile. The final decision on hiring will always be based on your performance in the interview and the requirements of the recruiter.

View More

Talk to us

Select Currency