Tech Mahindra
Multinational IT services and consulting company.
4 Rounds
~21 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 3rd highest salary from an Employee table without using the LIMIT keyword.
#Subqueries
#Correlated Queries
#Window Functions
Data Engineer
•
Coding
•
medium
Given a table of Telecom Call Detail Records (CDRs), write a SQL query to calculate the rolling 7-day cumulative data usage for each specific user.
#Window Functions
#Time Series
#Data Aggregation
Data Engineer
•
Coding
•
medium
How do you find and delete duplicate records in a massive SQL table without creating a temporary table?
#Data Cleansing
#CTEs
#DELETE Statements
Data Engineer
•
Coding
•
medium
Write a SQL query to pivot a table containing 'Year', 'Month', and 'Revenue' so that each Month becomes a column with the corresponding Revenue.
#Pivot
#Data Transformation
Data Engineer
•
Technical
•
easy
Explain the difference between ROW_NUMBER(), RANK(), and DENSE_RANK(). Provide a scenario where you would specifically choose DENSE_RANK() over RANK().
#Window Functions
#Data Ranking
Data Engineer
•
Technical
•
hard
A client complains that a critical reporting query taking data from a 50-million row table is running too slow. Walk me through your step-by-step approach to optimize it.
#Query Optimization
#Indexing
#Execution Plans
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.