TCS iON ProCert - Informatica
Registration Closes
Assessment Date
About TCS iON ProCert - Informatica
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
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, Partitioning 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 AllData 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
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
Key Features
Available Assessment Centres
Andhra Pradesh
- Chirala
- Guntur
- Kakinada
- Kurnool
- Nellore
- Rajahmundry
- Tirupathi
- Vijayawada
- Visakhapatnam
- Vizianagaram
Assam
- Dibrugarh
- Guwahati
- Jorhat
- Silchar
- Tezpur
Bihar
- Arrah
- Darbhanga
- Muzaffarpur
- Patna
Chandigarh
- Chandigarh
Chhattisgarh
- Bhilai Nagar
- Bilaspur
- Raipur
Delhi
- New Delhi
Goa
- Panaji
Gujarat
- Ahmedabad
- Anand
- Gandhinagar
- Mehsana
- Rajkot
- Surat
- Vadodara
Haryana
- Ambala
- Gurugram
- Hisar
- Karnal
- Kurukshetra
Himachal Pradesh
- Hamirpur
Jammu and Kashmir
- Jammu
- Samba
Jharkhand
- Bokaro Steel City
- Dhanbad
- Hazaribagh
- Jamshedpur
- Ranchi
Karnataka
- Bengaluru
- Hubballi (Hubli)
- Kalaburagi (Gulbarga)
- Mangaluru (Mangalore)
- Mysuru (Mysore)
- Shivamogga (Shimoga)
- Udupi
Kerala
- Kannur
- Kozhikode
- Thiruvananthapuram
- Thrissur
Madhya Pradesh
- Bhopal
- Gwalior
- Indore
- Jabalpur
- Sagar
- Satna
- Ujjain
Maharashtra
- Amravati
- Aurangabad
- Jalgaon
- Kolhapur
- Mumbai
- Nagpur
- Nanded
- Nashik
- Navi Mumbai
- Pune
Meghalaya
- Shillong
Mizoram
- Aizawl
Nagaland
- Kohima
Odisha
- Balasore
- Berhampur-Ganjam
- Bhubaneswar
- Cuttack
- Dhenkanal
- Rourkela
- Sambalpur
Punjab
- Amritsar
- Bhatinda
- Jalandhar
- Ludhiana
- Mohali
- Patiala
Rajasthan
- Ajmer
- Bikaner
- Jaipur
- Jodhpur
- Kota
- Sikar
- Udaipur
Tamil Nadu
- Chennai
- Coimbatore
- Madurai
- Salem
- Tiruchirappalli
- Tirunelveli
Telangana
- Hyderabad
- Karimnagar
- Warangal
Uttar Pradesh
- Agra
- Aligarh
- Allahabad
- Bareilly
- Ghaziabad
- Gorakhpur
- Greater Noida
- Jhansi
- Kanpur
- Lucknow
- Meerut
- Moradabad
- Muzaffarnagar
- Noida
- Varanasi
Uttarakhand
- 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