TCS
Large multinational IT services and consulting enterprise based in India.
3 Rounds
~14 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Scientist
•
Coding
•
medium
Write a SQL query using window functions to find the top 3 highest spending customers in each region for a retail client.
#Window Functions
#DENSE_RANK
#PARTITION BY
Data Scientist
•
Coding
•
easy
Write a SQL query to find the employee who earns more than their direct manager.
#Self Join
#SQL Queries
Data Scientist
•
Coding
•
medium
Write a SQL query to calculate the cumulative sum of revenue per month for the year 2023.
#Window Functions
#Aggregations
Data Scientist
•
Coding
•
hard
Write a SQL query to find the 3rd highest salary from an Employee table without using the LIMIT or TOP keywords.
#Subqueries
#Correlated Subqueries
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.