Worthwhile Inputs for preparing for the Informatica Certification

Category: General, Informatica Posted:Jul 05, 2016 By: Alvera Anto


Informatica in PowerCenter space offers two different certification courses. One for the Developers and the other one for the Admin.

Part 1: The Syllabus and the Materials that cover the Syllabus

The Certification aims at providing you with good insights on PowerCenter Installation, Configuration, Transformations, and proven best practices in Project Implementation. This Certificate prepares you to successfully use Informatica to import sources, targets, and lookups, for creating slowly changing dimension mappings as best practices, and to create reusable transformations and Mapplets. You will also need to show your ability to execute reusability through shortcuts, for successfully using the debugger to debug a mapping either with or without a prebuilt session, flow of work, incorporation and supervision of the session.

When you are attempting the test, you will be tested on the following parameters:

  • Mapping Design Basic
  • Mapping Design Advanced
  • Parameters and Variables
  • Transformation Language
  • Troubleshooting
  • Workflows and Worklets
  • Architecture & Administration

The skills and knowledge, which will be scaled during this exam include execution of project based on the core product functionality. The course includes training materials, support documentation, and practical hands on.

Part 2: Pre-requisite for taking up the course

In order to make the most out of the course, to the best of your knowledge, skills, and ability, the following pre-requisites, which are also the courses on Informatica, needs to be completed.  

  • Informatica 9.x PowerCenter Developer Level 1.
  • Informatica 9.x PowerCenter Developer Level 2.

Part 3: The Informatica Certified Professional Program

In order to harness the knowledge, skills, and capabilities you already possess, for taking up data integration and data quality projects, you will need to update the certification, on a timely basis. Only then you will be realizing the return on your investment towards the certification, in a faster and a better manner. Also, it will help you to stand out in the cutthroat competitive crowd in the job market.

Levels of Certification

The Informatica Professional Certification Program requires completion of three levels of certification, which includes,

  1. Specialist
  2. Expert
  3. Master

A candidate shall get certified based on his/her knowledge about the product, experience in the respective field, and ability to follow the best practices for velocity implementation methodology. Completion of test and getting certified as the Informatica Professional provides enormous benefits to the candidate. It is a proctored, cost effective, lab-based exam that can be taken anywhere and anytime.

In summary

  • The test comprises of 70 multiple choice/multiple response/true-false based questions.
  • The questions are thrown on 7 broad topics of Informatica PowerCenter product.
  • The minimum requirement to get certified as Informatica PowerCenter Data Integration 9.X: Developer of Specialist status is 70%.

The following are the broad topics of Informatica Power Center Product, on which the questions will be asked. The table also shows the weight age for each of the broad topics covered in the exam.


The main point to be noted is, there is no alternate for practical hands on experience, and thus, it is highly recommended that you thoroughly get used to different transformations and concepts on the PowerCenter tools.

Setting the complete introduction aside, let us now straight away look into the actual topic.

The main question which arises in a candidate’s mind is which are the materials I should be referring to are and what are the topics which I have to prepare?

Part 4: The reading materials that need to be downloaded

The product guides, which come along with the product installation package is the primary source of reading material.

The access to this site can be got if you own an email ID of a corporation, which is an official partner of Informatica.

If you are unable to get access, then, you may try looking out for pdf files separately on Google for download from their links as displayed by the Google. The links will be only from the Informatica Community website. Any 9.x.x version guide will be sufficient for a thorough preparation.

 The following are the 7 guides, which are mandatory for preparation:


If you do not have access to Informatica portal, or if you are not in a position to get an access, then, see that you search for them on Google and download them separately.

Part 5:-Which are the required chapters to study?

Vowing to the reason that the syllabus is vast, and it is highly difficult for you to be thorough on every topic equally, for your convenience, the following tables’ throw insights on the weight age for each topic from the syllabus. It also includes the chapters from the guides that you are required to study.

Mapping Design Basics: – 45%


Mapping Design Advanced: – 20%


Others: – 35%


The aforesaid ones are the actual reading materials and chapters that need to be covered in your study, in order to pass the test and obtain the Certification.

Hope we have done a good job in giving you enough information, for helping you become a Pro in Informatica in PowerCenter.

For further details on the fee for the exam and scheduling an appointment for the exam, you may visit here.


24 X 7 Customer Support X

  • us flag 99999999 (Toll Free)
  • india flag +91 9999999