Tech Mahindra

Tech Mahindra

Multinational IT services and consulting company.

4 Rounds ~21 Days Medium
Start Mock Interview

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

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
Practice
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
Practice
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
Practice
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
Practice
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
Practice
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
Practice
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
Practice
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
Practice
Data Scientist • Coding • medium

Write a SQL query to find the top 3 customers by revenue in each region.

#Window Functions #RANK #CTEs
Practice
Data Scientist • Coding • medium

Write a SQL query to find the second highest salary of employees within each department.

#Window Functions #DENSE_RANK #Subqueries
Practice
Full Stack Engineer • Coding • medium

Write a SQL query to find the nth highest salary from an Employee table.

#Database #SQL Queries
Practice
Machine Learning Engineer • Coding • easy

Write a SQL query to find the second highest salary from an Employee table.

#SQL #Aggregations #Subqueries
Practice
Product Manager • Coding • medium

Write a SQL query to calculate the month-over-month churn rate for a B2B subscription service.

#Data Analysis #Churn #Business Metrics
Practice
Product Manager • Coding • easy

Write a SQL query to identify enterprise customers who have not logged into the portal for 90 days but still have an active billing status.

#Data Analysis #User Engagement #Retention
Practice
Product Manager • Coding • medium

Write a SQL query to find the average time spent per session for users, grouped by device type (iOS, Android, Web).

#Data Analysis #Engagement #Aggregation
Practice
Product Manager • Coding • medium

Write a SQL query to find the top 10% of enterprise users by API call volume in the last 30 days.

#Data Analysis #API Metrics #Window Functions
Practice
Software Engineer • Technical • medium

Write a SQL query to fetch all duplicate records from a table.

#Database #Queries #Aggregation
Practice
Software Engineer • Technical • easy

Explain the difference between TRUNCATE, DELETE, and DROP in SQL.

#Database #DDL #DML
Practice
Software Engineer • Technical • medium

What are clustered and non-clustered indexes in SQL?

#Database #Indexing #Performance
Practice
Software Engineer • Technical • medium

Write a SQL query to find the nth highest salary of an employee from the Employee table.

#Database #Queries #Window Functions
Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now