Tata Consultancy Services Limited (TCSL) interview experience Real time questions & tips from candidates to crack your interview

Assistant System Engineer

Tata Consultancy Services Limited (TCSL)
upvote
share-icon
3 rounds | 4 Coding problems

Interview preparation journey

expand-icon
Journey
My journey began with confusion and self-doubt while learning the basics of Python and SQL. Many times, my code didn’t run, queries failed, and I questioned whether I was capable enough. But instead of giving up, I chose to stay consistent and focus on understanding concepts clearly rather than rushing through them. I practiced daily, worked on small projects, and kept improving step by step. Gradually, my confidence grew. Along with technical skills, I worked on communication, problem-solving, and professional behaviour. This journey taught me that growth comes from patience, discipline, and believing in yourself even on difficult days.
Application story
I applied for this opportunity through the on-campus placement drive conducted by my college. After the company announcement, I registered through the placement portal and carefully followed all the instructions shared by the placement team. The entire process was well-organized and smooth. I stayed prepared at each step, regularly checked updates, and attended the scheduled assessments and interview rounds as part of the campus recruitment process.
Why selected/rejected for the role?
I believe I was selected because I stayed consistent with my preparation and trusted my basics. I tried to be genuine in my answers and communicated my thoughts clearly instead of overcomplicating them. Whenever I didn’t know something, I was honest about it. I also showed a positive attitude and eagerness to learn. I think this combination of confidence, clarity, and willingness to grow made the difference.
Preparation
Duration: 8 months
Topics: Python, SQL, Power BI, Artificial Intelligence, Machine Learning
Tip
Tip

Tip 1: Focus on your basics and build a strong foundation.
Tip 2: Stay consistent with your preparation.
Tip 3: Take one step at a time and keep improving.

Application process
Where: Campus
Eligibility: NA, (Salary package: 3.45 LPA)
Resume Tip
Resume tip

Tip 1: Put only those things on your resume that you are confident about.
Tip 2: Keep your resume minimal and to the point.

Interview rounds

01
Round
Medium
Online Coding Interview
Duration180 minutes
Interview date22 Nov 2024
Coding problem2

It included aptitude, reasoning, and two coding questions. My assessment was in the first slot from 9 AM to 12 PM on the ION Digital platform. The environment was a bit difficult to understand at first, but I got familiar with it afterwards.

1. Check Weather

Write a program that takes the temperature (in Celsius) as input and determines whether the weather is Cold or Not Cold.
• If the temperature is below 15°C, print “Cold”.
• Otherwise, print “Not Cold”.

Problem approach

1. Understand the problem
We need to check the temperature and decide the weather condition.
• If temperature < 15°C → Cold
• Otherwise → Not Cold
2. Take input
Ask the user to enter the temperature value (in Celsius).
3. Store the value
Save the entered temperature in a variable (for example, temp).
4. Apply condition
Use an if-else statement:
• Check if temp < 15
• If true → weather is Cold
• Else → weather is Not Cold
5. Display the result
Print the appropriate message based on the condition.

2. Count of Subsequences with Given Sum

Moderate
0/80

You are given an array A of N non-negative integers and a target sum S. Your task is to find the total number of subsequences of the array whose elements sum up to S.

A subsequence is a sequence that can be derived from the array by deleting some or no elements without changing the order of the remaining elements.

Problem approach

1. Start from index 0 with:
• Empty subsequence
• Sum = 0
2. For every element in the array, do two things:
• Include the element
• Exclude the element
3. After choosing, move to the next index.
4. When you reach the end of the array:
• If sum == K → print/store the subsequence
• If sum ≠ K → ignore it
5. After exploring one choice, remove the element (backtrack) and try the other choice.
6. Repeat until all possibilities are checked.

Try solving now
02
Round
Medium
Face to Face
Duration15 minutes
Interview date23 Dec 2024
Coding problem1

For this round, my slot was the second one, scheduled at 12:30 PM.

1. SQL query

The ask me to solve a sql query:
You are given three tables:

1. Students
• student_id
• student_name
• department_id

2. Departments
• department_id
• department_name


3. Marks
• student_id
• subject
• score
⸻
Task:

Write a SQL query to display:
• student_name
• department_name
• subject
• score
Only for students who scored more than 75 marks.

Problem approach

Tip 1: Search for given data in tables.
Tip 2: Identify which joins to be used.
Tip 3: Focus on syntax.

03
Round
Hard
HR Round
Duration40 minutes
Interview date23 Dec 2024
Coding problem1

1. HR Questions

  • Are you comfortable with relocation?
  • What if you are not placed in your desired team or project?
  • How do you handle failure?
  • What is your weakness?
  • Do you have any questions for us?
Problem approach

Tip 1: Focus on what they are asking.
Tip 2: Give them the answer they want you to give.
Tip 3: Never give a negative statement.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

How do you remove whitespace from the start of a string?

Choose another skill to practice
Similar interview experiences
company logo
SDE - 1
3 rounds | 7 problems
Interviewed by OYO
4898 views
0 comments
0 upvotes
company logo
SDE - Intern
2 rounds | 3 problems
Interviewed by Amazon
1043 views
0 comments
0 upvotes
company logo
SDE - 1
2 rounds | 5 problems
Interviewed by Meesho
6638 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
3639 views
0 comments
0 upvotes