J'ai postulé en ligne. J'ai passé un entretien chez Tata Consultancy Services (Chennai) en mai 2022
Entretien
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.
Questions d'entretien [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?
J'ai passé un entretien chez Tata Consultancy Services (Pune)
Entretien
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.
J'ai passé un entretien chez Tata Consultancy Services (Pune)
Entretien
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
Questions d'entretien [1]
Question 1
What is fork join?
What us configure and configure services?
J'ai passé un entretien chez Tata Consultancy Services
Entretien
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.
Questions d'entretien [1]
Question 1
Technical questions about the technology I applied for