I applied online. I interviewed at Tata Consultancy Services (Chennai) in May 2022
Interview
Interview experience at TCS was professional and structured, focusing on fundamentals, problem-solving, and communication. Panel was supportive, questions practical, and overall process transparent, calm, and confidence-building with clear expectations shared.
Interview questions [1]
Question 1
SQL & Database
What is the difference between INNER JOIN and LEFT JOIN?
How do you find duplicate records in a table?
Explain window functions with an example.
Difference between DELETE, TRUNCATE, and DROP.
How do you optimize a slow-running SQL query?
What is normalization vs denormalization?
🔹 Data Warehousing
What is a fact table and dimension table?
Explain SCD Type 1 vs Type 2 with example.
What is a star schema?
What is ETL and how is it different from ELT?
What is data granularity?
I had 2-3 phone interviews with hiring manager and team members. It was pretty decent. Asked about solarwinds tool and how a few stuff works in the software. What I exactly did at my previous company.
Two rounds will be there
Technical round
Manager round
Both rounds happened on same day
So the process is one day only.
I got offer on same day.
8 to 10 technical questions and only one question in mg round
Interview questions [1]
Question 1
What is fork join?
What us configure and configure services?
3 rounds . First one being mostly technical. 2nd with team lead and manager mostly asking for preferred location and wfo policy. Last one is salary negotiations with HR. Offer letter is rolled out few days/weeks post interview process.
Interview questions [1]
Question 1
Technical questions about the technology I applied for
