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 Engineer
•
Coding
•
medium
Write a SQL query to find the second highest salary in each department without using the MAX() function.
#SQL
#Window Functions
#Aggregations
Data Engineer
•
Coding
•
medium
How do you delete duplicate records from a massive table in SQL while keeping exactly one instance of each duplicate?
#SQL
#Data Cleansing
#CTEs
Data Engineer
•
Technical
•
medium
Explain the difference between a CTE and a Temporary Table. In a scenario where you are processing 50 million rows for a client report, which one would you choose and why?
#SQL
#Performance Tuning
#Database Architecture
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.