I applied in-person. The process took 4 weeks. I interviewed at Tata Consultancy Services (Noida) in June 2024
Interview
The interview process for the Assistant Systems Engineer Trainee role was structured and smooth. It began with an online aptitude and technical test, followed by a technical interview focusing on coding, databases, and basic problem-solving skills. Then came the managerial and HR rounds, which assessed communication skills, teamwork, and adaptability. Overall, it was a friendly and professional experience.
Interview questions [1]
Question 1
Explain the basics of Object-Oriented Programming (OOP).
What is normalization in databases?
Write a SQL query to find the second highest salary.
Explain the difference between clustered and non-clustered indexes.
What are joins? Explain different types of joins.
What is the difference between C and C++
It started of easy with some questions about my projects and then to writing the code of my projects. knowing your basics of things that you put on your resume would help so much.
I interviewed at Tata Consultancy Services (Chennai)
Interview
It was pretty easy. They were focused only based on the resume . So, kindly ensure to know everything mentioned in the resume . They asked me to explain about my project and asked me to write an SQL query on inner and outer joins
Interview questions [1]
Question 1
They asked if I am available for night shifts and relocation
I applied through university. I interviewed at Tata Consultancy Services (Calcutta) in Jan 2026
Interview
The interview process involved a long waiting queue, but the management was well organized. The steps were clearly explained, and the overall process was structured and smooth despite the waiting time.