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 certification designed by top industry practitioners for experienced professionals to demonstrate their technical proficiency in Informatica. This also provides an opportunity for a career in TCS.

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

TCS iON ProCert - Informatica is a proctored online assessment for professionals looking to keep their edge on technology.
Registered candidates can take the assessment from assigned TCS iON centres on the day of assessment.


Informatica Developer

29th March 2020 - 9:00 AM to 11:00 AM

Part A: 90 Minutes | 75 Questions | 75 Marks

Part B: 30 Minutes | 3 Case Studies | 50 Marks

Assessment Topics

Data Warehousing Concepts and Informatica Fundamentals

Mapping Design - Basic and Advanced

Mapping Transformations

Mapping Parameters, Variables and Session Parameterization Concepts

Workflows, Worklets and Session Tasks

Slowly Changing Dimensions (SCD) Concepts and Pushdown Optimization

Performance Tuning and Troubleshooting

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

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 experience and expertise in Informatica
  • Get an Edge - Stand out among your peers by enhancing your industry credibility
  • Get Noticed - Get career opportunities in TCS

Related Products


and more ...

Key Features

Validation of your Technical Proficiency by Industry Practitioners
Well Researched and High Quality Questions
Opportunity for a Career in TCS
Proctored 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


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 generate your hall ticket. This includes your name, email ID, phone number, centre preferences, and other details.
  4. On successful submission of the registration form, you need to proceed to make the payment by clicking on "Click to Proceed". After successful payment, you will get an acknowledgement of your transaction.
  5. You will then be automatically re-directed to the "My Dashboard" page where you can view the purchased product under "My Products" section.
  6. You need to search for "TCS iON ProCert - Informatica" in the search bar to go to the product page and click on "View Details" to view your details.
  7. You will receive a successful registration message on your registered email ID/mobile number.
  8. You will receive your hall ticket two days prior to the scheduled exam date.
  9. You must carry a printout of your hall ticket along with ID proof to the assessment centre allocated to you.