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 Scientist
•
Coding
•
medium
Write a SQL query to find the second highest salary of employees within each department.
#Window Functions
#DENSE_RANK
#Subqueries
Data Scientist
•
Coding
•
medium
Write a SQL query to calculate the 7-day rolling average of daily active users (DAU).
#Window Functions
#Rolling Average
#Date Functions
Data Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 customers by revenue in each region.
#Window Functions
#RANK
#CTEs
Data Scientist
•
Coding
•
easy
Write a SQL query to find all employees who joined in the last 30 days and have the job title 'Data Scientist'.
#Date Functions
#Filtering
#WHERE Clause
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.