Top 28
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

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

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

SubqueriesRankingSortingTech 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
Group By vs Having in ReportingEasy

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

Group ByHavingAggregationsTech Mahindra
Ranking Trial Results with Window FunctionsEasy

Explain how RANK(), DENSE_RANK(), and ROW_NUMBER() differ when ordering tied clinical trial results.

Window FunctionsRankingData WranglingTech 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.

sqlAggregationsUST GlobalHexaware TechnologiesTech Mahindra
Running Total With Window FunctionsEasy
Practice
Practice drill

Calculate each user's running order total over time using a window function.

Window FunctionsDate FunctionsRunning TotalsBayerSparksoftWestern Digital
More SQL & Data Manipulation questions with a free account
2
Pipelines7 questions · ~59 min
Data Warehousing, Modeling, CDCHard

Evaluates your understanding of data warehousing, data modeling, and change data capture.

Data ModelingTech Mahindra
Spark DataFrames at ScaleMedium

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

InfrastructureBatch ProcessingData ModelingTech Mahindra
Responsive Power BI at ScaleMedium

Tests your performance optimization approach for Power BI when working with large datasets.

InfrastructureData ModelingQualityTech 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
More topics2 questions · ~17 min
Handling Conflicting OpinionsMedium

Tests your conflict resolution approach and collaboration skills.

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