I applied online. I interviewed at Tata Consultancy Services
Interview
First round was Apptitude test in which we had questions on Maths, Computer.
Second round was Group Discussion.
Third round was Technical Round
Fourth round was HR Round
Fifth round Manager Round.
All the rounds were completed in one day.
I interviewed at Tata Consultancy Services (Chennai)
Interview
They asked about your ETL tool, SQL, Linux.
1. What is target load order?
2. Write the difference between connected lookup and unconnected lookup.
3. How you identify duplicates and how to find latest duplicate
Interview questions [1]
Question 1
They asked about your ETL tool, SQL, Linux.
1. What is target load order?
2. Write the difference between connected lookup and unconnected lookup.
3. How you identify duplicates and how to find latest duplicate
I applied online. The process took 2 weeks. I interviewed at Tata Consultancy Services (Mumbai) in Sept 2024
Interview
1st Round was telephonic--> Asked basic about router ,lookup and joiner transformation,Lookup Caches,Difference between unconnected Lookup and connected Lookup.
2nd Round Virtual Technical Interview: How would get specific number record to target like 1st and 3rd.
SCD Types
Schema Change Handling
Aggregation
Working on performance tuning in Informatica Powercenter
Interview questions [1]
Question 1
How would get specific number record to target like 1st and 3rd.
SCD Types
Schema Change Handling
Aggregation
Working on performance tuning in Informatica Powercenter