TCS iON ProCert - Informatica

Get Certified on Your Technology Proficiency

Registration Closes

Assessment Date

About TCS iON ProCert - Informatica

TCS iON ProCert - Informatica is a 2-Stage certification designed by top industry practitioners for experienced professionals to demonstrate their technical proficiency in Informatica. The proctored remote assessment will be conducted online allowing candidates to take the test from home using their laptop or desktop, without having to visit the test centre.

Who can Apply?

Possess 3 to 15 years of experience

Age group of 22 to 42 years

Minimum 50% in 10th, 12th and Graduation

Cannot be currently employed with TCS

Part Time/Distance Education/Correspondence qualifications will not be eligible

Not have more than 2 years break in career/academics

Assessment Details

Minutes Questions Marks

Proctored Remote Assessment covering key areas in Informatica, conducted online

Minutes Questions Marks

Scenario-based questions to test application of applied Informatica knowledge

01_Data Warehousing Concepts and Informatica Fundamentals

Data Warehousing Concepts and Informatica Fundamentals

02_Mapping Design - Basic and Advanced

Mapping Design - Basic and Advanced

03_Mapping Transformations

Mapping Transformations

04_Mapping Parameters, Variables and Session Parameterization Concepts

Mapping Parameters, Variables and Session Parameterization Concepts

05_Workflows, Worklets and Session Tasks

Workflows, Worklets and Session Tasks

06_Slowly Changing Dimensions (SCD) Concepts and Pushdown Optimization

Slowly Changing Dimensions (SCD) Concepts, Partitioning and Pushdown Optimization

07_Performance Tuning and Troubleshooting

Performance Tuning and Troubleshooting

08_Restartability, Error Handling and Debugging Concepts

Restartability, Error Handling and Debugging Concepts

Please click here for detailed sub-topics under each topic.

Assessment Topics

+ Expand All - Collapse All

Data Warehousing Concepts and Informatica Fundamentals (Number of Questions - 5)

  • Informatica architecture and domain configuration
  • PowerCenter components and applications
  • Repository organization and data model
  • Workflow configuration and database connections

Mapping Design - Basic and Advanced (Number of Questions - 15)

  • Designer configuration and mapping development
  • Transformation ports, source, target definitions and different file handling techniques
  • Reusable transformations and mapplets configuration
  • Pre SQL and Post SQL concepts

Mapping Transformations (Number of Questions - 25)

  • Active and passive transformations
  • Connected and unconnected transformations
  • Advanced transformations and evaluation for different functions
  • Incremental aggregation concepts, cache configuration and Change Data Capture (CDC)

Mapping Parameters, Variables and Session Parameterization Concepts (Number of Questions - 5)

  • Mapping parameters, variables and persistent value concepts
  • Session parameters, workflow parameters and types
  • Parameterization concepts and dynamic relational connection change

Workflows, Worklets and Session Tasks (Number of Questions - 10)

  • Types of session tasks and properties
  • Advanced workflow concepts, load manager and Data Transformation Manager (DTM) process
  • Workflow properties, session properties and scheduler concept
  • Pre-session and post-session commands

Slowly Changing Dimensions (SCD) Concepts, Partitioning and Pushdown Optimization (Number of Questions - 5)

  • SCD concepts and different types
  • Partitioning concepts and various types
  • Pushdown optimization techniques and types

Performance Tuning and Troubleshooting (Number of Questions - 5)

  • Different types of bottlenecks
  • Evaluate the batch run timing and results
  • Optimizing sources, targets, mappings and transformations

Restartability, Error Handling and Debugging Concepts (Number of Questions - 5)

  • Restartability on job failure
  • Error logging mechanism
  • Debug process and breakpoint set process
View More View Less

Advantages of TCS iON ProCert - Informatica

  • Get Recognised - Gain recognition for your Informatica experience and expertise
  • Get an Edge - Stand out among your peers by enhancing your industry credibility
  • Get Noticed - Get career opportunities in Informatica with top recruiters

Related Products

Our Corporate Partners

and more ...

Key Features

Validation of Practical Expertise in Informatica by Industry Practitioners
Well Researched and High Quality Questions
Gain Access to Top Corporates Looking for Informatica Talent
Scheduled and Proctored Online Remote Assessments on the TCS iON Secured Digital Platform


Available Assessment Centre(s)

View list of all available assessment centres within India

Available Assessment Centres

Andhra Pradesh

  • Chirala
  • Guntur
  • Kakinada
  • Kurnool
  • Nellore
  • Rajahmundry
  • Tirupathi
  • Vijayawada
  • Visakhapatnam
  • Vizianagaram


  • Dibrugarh
  • Guwahati
  • Jorhat
  • Silchar
  • Tezpur


  • Arrah
  • Darbhanga
  • Muzaffarpur
  • Patna


  • Chandigarh


  • Bhilai Nagar
  • Bilaspur
  • Raipur


  • New Delhi


  • Panaji


  • Ahmedabad
  • Anand
  • Gandhinagar
  • Mehsana
  • Rajkot
  • Surat
  • Vadodara


  • Ambala
  • Gurugram
  • Hisar
  • Karnal
  • Kurukshetra

Himachal Pradesh

  • Hamirpur

Jammu and Kashmir

  • Jammu
  • Samba


  • Bokaro Steel City
  • Dhanbad
  • Hazaribagh
  • Jamshedpur
  • Ranchi


  • Bengaluru
  • Hubballi (Hubli)
  • Kalaburagi (Gulbarga)
  • Mangaluru (Mangalore)
  • Mysuru (Mysore)
  • Shivamogga (Shimoga)
  • Udupi


  • Kannur
  • Kozhikode
  • Thiruvananthapuram
  • Thrissur

Madhya Pradesh

  • Bhopal
  • Gwalior
  • Indore
  • Jabalpur
  • Sagar
  • Satna
  • Ujjain


  • Amravati
  • Aurangabad
  • Jalgaon
  • Kolhapur
  • Mumbai
  • Nagpur
  • Nanded
  • Nashik
  • Navi Mumbai
  • Pune


  • Shillong


  • Aizawl


  • Kohima


  • Balasore
  • Berhampur-Ganjam
  • Bhubaneswar
  • Cuttack
  • Dhenkanal
  • Rourkela
  • Sambalpur


  • Amritsar
  • Bhatinda
  • Jalandhar
  • Ludhiana
  • Mohali
  • Patiala


  • Ajmer
  • Bikaner
  • Jaipur
  • Jodhpur
  • Kota
  • Sikar
  • Udaipur

Tamil Nadu

  • Chennai
  • Coimbatore
  • Madurai
  • Salem
  • Tiruchirappalli
  • Tirunelveli


  • Hyderabad
  • Karimnagar
  • Warangal

Uttar Pradesh

  • Agra
  • Aligarh
  • Allahabad
  • Bareilly
  • Ghaziabad
  • Gorakhpur
  • Greater Noida
  • Jhansi
  • Kanpur
  • Lucknow
  • Meerut
  • Moradabad
  • Muzaffarnagar
  • Noida
  • Varanasi


  • Dehradun
  • Haldwani
  • Roorkee

West Bengal

  • Asansol
  • Hooghly
  • Kolkata
  • Siliguri

Candidate Testimonials

Have a Question?

If you want to know more about our products, pricing or anything else


1.How do I register and take TCS iON ProCert - Informatica certification assessment?+
  1. Click on "Buy Now" on the "TCS iON ProCert - Informatica" product page.
  2. Login with your TCS iON Digital Learning Hub credentials or sign up as a new user.
  3. After login/sign up, you will be asked to share your details required to complete your registration process. This includes your name, email ID, phone number and other details.
  4. In case of Buy Now: On successful submission of the registration form, you need to proceed to make the payment by clicking on "Click to Proceed".
  5. In case of Activate Now: A pop-up window will open, where you need to enter the Licence Code and click on the "Activate Now" button. Once you click on the "Close" button, you will be automatically redirected to "My Dashboard".
  6. You will receive a successful registration message on your registered email ID/mobile number.
  7. Since this is an online assessment, you will not receive any hall ticket. However, you will receive the link to download TCS iON Assessment Launcher along with login credentials on your registered email ID four days prior to the scheduled assessment date.