Tech Mahindra Data Analyst Interview Questions (2026)

1. 1Online Assessment (English + Aptitude + Coding)60 minMedium

   Timed test where English grammar/comprehension and a written email or essay task carry unusual weight, alongside quantitative aptitude and basic coding questions.

2. 2Technical Interview40 minMedium

   Panel covers programming and CS fundamentals, projects, and — for network-aligned roles — telecom basics like the OSI stack and call flows.

3. 3Telecom Domain Round45 minHard

   For experienced OSS/BSS, 5G, or network-engineering hires, a specialist round on charging/billing flows, provisioning, network protocols, or RAN/core architecture.

4. 4Managerial Round30 minMedium

   A delivery manager evaluates client-communication maturity, shift and travel flexibility, and handling of escalations on live telecom accounts.

5. 5HR Round25 minEasy

   Closing discussion on communication, relocation/shift willingness, compensation, and culture fit framed around the Mahindra Rise philosophy.

1. Q1

   Write a SQL query to find duplicate customer records in Tech Mahindra's retail client's daily sales dashboard. How would you decide which record survives?

   MediumSQL roundduplicate detectionTech Mahindra-specific

   Context:

   Tech Mahindra retail client's daily sales dashboard

   How to answer:

   Use GROUP BY/HAVING or ROW_NUMBER over a business key, define survivorship rules, and push the fix upstream. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

2. Q2

   Using window functions, how would you add a 7-day rolling total and a rank within category to Tech Mahindra's telecom client's churn reporting?

   MediumSQL roundwindow functionsTech Mahindra-specific

   Context:

   Tech Mahindra telecom client's churn reporting

   How to answer:

   Contrast aggregate vs window behavior, frame clauses, and partition choices. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

3. Q3

   Your XLOOKUP against the master sheet in Tech Mahindra's retail client's daily sales dashboard returns #N/A for valid IDs. What do you check?

   MediumExcel and BI roundlookupsTech Mahindra-specific

   Context:

   Tech Mahindra retail client's daily sales dashboard

   How to answer:

   Trailing spaces, number-vs-text types, exact match mode, and TRIM/VALUE cleanup. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

4. Q4

   Build a pivot summary for Tech Mahindra's telecom client's churn reporting: what goes in rows, values, and filters, and when does a pivot beat formulas?

   MediumExcel and BI roundpivot tablesTech Mahindra-specific

   Context:

   Tech Mahindra telecom client's churn reporting

   How to answer:

   Structure the source as a flat table, choose aggregations, and know pivot refresh limits. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

5. Q5

   In Power BI, when does Tech Mahindra's e-commerce client's returns analysis need a DAX measure instead of a calculated column?

   HardExcel and BI roundDAX measuresTech Mahindra-specific

   Context:

   Tech Mahindra e-commerce client's returns analysis

   How to answer:

   Row context vs filter context, storage cost, and totals that only measures get right. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

6. Q6

   Design the Power BI model for Tech Mahindra's healthcare client's appointment no-show reporting: which tables are facts, which are dimensions, and why not one flat table?

   MediumExcel and BI rounddata modelingTech Mahindra-specific

   Context:

   Tech Mahindra healthcare client's appointment no-show reporting

   How to answer:

   Star schema, relationship directions, and what breaks when everything is one wide table. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

7. Q7

   The client says the Tech Mahindra dashboard for logistics client's delivery SLA tracking takes a minute to load. How do you make it fast?

   MediumExcel and BI rounddashboard performanceTech Mahindra-specific

   Context:

   Tech Mahindra logistics client's delivery SLA tracking

   How to answer:

   Reduce cardinality, trim visuals, pre-aggregate, and measure before optimizing. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

8. Q8

   Which KPIs go on the first screen of Tech Mahindra's credit-card client's spend-category dashboard, and what do you deliberately leave out?

   MediumExcel and BI rounddashboard designTech Mahindra-specific

   Context:

   Tech Mahindra credit-card client's spend-category dashboard

   How to answer:

   Lead with decisions the client makes weekly; park detail in drill-throughs. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

9. Q9

   Returns are rising in Tech Mahindra's insurance client's claims data mart. Turn the data into a recommendation the client can act on this quarter.

   MediumAnalytics case roundbusiness recommendationTech Mahindra-specific

   Context:

   Tech Mahindra insurance client's claims data mart

   How to answer:

   Segment the problem, size each driver, and attach an owner and expected impact to the fix. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

10. Q10

    For Tech Mahindra's healthcare client's appointment no-show reporting, when would you report the median instead of the mean, and how do you explain the gap to the client?

    MediumStatistics and metrics roundmean vs medianTech Mahindra-specific

    Context:

    Tech Mahindra healthcare client's appointment no-show reporting

    How to answer:

    Skew and outliers; show both when the story depends on the tail. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

11. Q11

    The client can only share a sample of records from Tech Mahindra's credit-card client's spend-category dashboard. What do you check before trusting conclusions?

    MediumStatistics and metrics roundsampling and biasTech Mahindra-specific

    Context:

    Tech Mahindra credit-card client's spend-category dashboard

    How to answer:

    How the sample was drawn, coverage of segments and time, and known exclusions. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

12. Q12

    Growth in Tech Mahindra's retail client's daily sales dashboard is reported as +40%, but the client is suspicious. Which base-rate and mix effects do you check?

    HardStatistics and metrics roundpercentage change pitfallsTech Mahindra-specific

    Context:

    Tech Mahindra retail client's daily sales dashboard

    How to answer:

    Small denominators, mix shift (Simpson's paradox), and period-boundary artifacts. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

13. Q13

    List the validation checks you run before the numbers for Tech Mahindra's telecom client's churn reporting go to the client.

    MediumData quality roundpre-publish validationTech Mahindra-specific

    Context:

    Tech Mahindra telecom client's churn reporting

    How to answer:

    Row counts vs source, totals reconciliation, duplicate and NULL checks, period completeness. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

14. Q14

    A stakeholder on Tech Mahindra's healthcare client's appointment no-show reporting asks for 'a report' with no further detail. What do you do before writing any query?

    EasyBehavioral/project discussionambiguous requirementsTech Mahindra-specific

    Context:

    Tech Mahindra healthcare client's appointment no-show reporting

    How to answer:

    Ask for the decision the report serves, sketch a mock, agree definitions, then build. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

15. Q15

    The client needs numbers from Tech Mahindra's logistics client's delivery SLA tracking today, but you know the data has issues. What do you send?

    EasyBehavioral/project discussiondeadline vs accuracyTech Mahindra-specific

    Context:

    Tech Mahindra logistics client's delivery SLA tracking

    How to answer:

    Ship with explicit caveats and scope, or cut scope — never silently ship known-bad numbers. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

Practice these with instant AI feedback in a live mock interview → Start a Tech Mahindra Data Analyst mock

Clear the aptitude and coding test; revise fundamentals and projects; prepare HR questions

Other roles at Tech Mahindra

Data Analyst interviews at other companies