Top 39
Prep plan
Updated weekly · Last refresh Aug 30

Tech Mahindra Data Analyst Interview Questions

The questions to prepare for a Tech Mahindra Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

39questions
~5htotal time
Track your progressSign up free to work through all 39 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 28 questions + 2 drills · ~253 min
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingTech Mahindra
Difference Between WHERE and HAVING ClausesEasy

Explain the differences between WHERE and HAVING clauses in SQL and when to use each.

JoinsData WranglingAggregationsTech Mahindra
Group By vs Having in ReportingEasy

Explain how GROUP BY forms aggregates and HAVING filters aggregated results in a reporting scenario.

Group ByHavingAggregationsTech Mahindra
Basic DAX vs SQL MeasuresEasy

Explain basic DAX in Power BI by comparing measures, calculated columns, and common aggregation patterns to familiar SQL logic.

Data WranglingCase WhenAggregationsTech Mahindra
Second Highest Salary SQLEasy
Practice
Practice drill

Find every active UST Global employee earning the second-highest distinct salary using a CTE, DENSE_RANK, and a LEFT JOIN.

sqlAggregationsTech MahindraUST GlobalHexaware Technologies
Rank Rows With SQL Window FunctionsEasy
Practice
Practice drill

Rank active Tech Mahindra employees by salary within each department using RANK and a department join.

Window FunctionsRankingTech Mahindra
More SQL & Data Manipulation questions with a free account
2
Pipelines8 questions · ~66 min
Star Schema and RelationshipsHard

Tests dimensional modeling skills and your approach to integrating multiple sources into a usable model.

ETLDependenciesData ModelingTech Mahindra
Spark DataFrames at ScaleMedium

Tests your ability to use Spark DataFrames effectively for scalable data transformations.

InfrastructureBatch ProcessingData ModelingTech Mahindra
Data Migration Project ExperienceMedium

Tests experience planning and executing data migrations with attention to data quality and risk management.

ETLBatch ProcessingDependenciesTech Mahindra
More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership3 questions · ~25 min
Handling Conflicting OpinionsMedium

Tests your conflict resolution approach and collaboration skills.

Conflict ResolutionTech Mahindra
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 39 questions plus 2 hands-on drills to finish this plan.