Tech Mahindra Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Tech Mahindra hiring for Business Analytics roles
Tech Mahindra is an Indian IT services and consulting company and part of the Mahindra Group. It is known for its strong telecom and communications practice and also serves banking, manufacturing and healthcare clients. In India it hires for software engineers, test engineers, network engineers, data analysts and data engineers.
For Business Analytics roles, this Tech Mahindra practice set focuses most on UAT and BA Documentation (6), Requirements and Agile (6), Case Studies and Guesstimates (5), SQL for Business Analysis (5). It has 20 easy, 19 medium, 1 hard questions, so you can start easy and work up to the harder ones.
Company type
IT services
Headquarters
Pune, India
Main India offices
Pune, Hyderabad, Bengaluru, Noida, Chennai
Tech Mahindra Business Analytics interview process
Online assessment (aptitude + English essay)
Coding test
Technical interview
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Tech MahindraStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
A defect is logged as New with steps, expected and actual results, and evidence. It is reviewed in triage and moves to Open or Assigned, or to Rejected, Duplicate or Deferred. The developer fixes it and marks it Fixed or Ready for retest. The tester retests: if it passes it moves to Closed, and if not it is Reopened. Tracking status and age helps the UAT lead report readiness and spot defects stuck too long.
Value chain analysis breaks a business into the activities that create value: primary activities such as inbound logistics, operations, outbound logistics, marketing and sales, and service, plus support activities like procurement, technology, HR and infrastructure. For each activity you look at cost and differentiation. In cases it helps locate where costs are rising or where a competitive advantage can be built, for example in last-mile delivery.
03
What steps do you follow to plan and run a UAT cycle?
Plan: agree scope, entry and exit criteria, testers and schedule with the business owner. Prepare: write scenarios and test cases from requirements, set up the environment and test data, and brief testers. Execute: run test cases in daily sessions, log defects with evidence and hold a daily triage. Monitor: report progress, pass rate and open defects by severity. Close: check exit criteria, get the business sign-off with known issues documented, and hold a short lessons-learned review.
04
Tell me about a time careful listening helped you uncover a hidden requirement.
Situation: during interviews for a new order system, a warehouse supervisor kept mentioning that Friday evenings were chaotic. Task: understand whether this mattered for the requirements. Action: instead of moving on, I asked what happened on Fridays and learned that bulk orders were split manually because of truck capacity limits. Result: we added an automatic order-splitting rule that nobody had listed, which saved the team about four hours a week and avoided a likely UAT failure.
05
How is a product owner's role different from a business analyst's role?
The product owner owns the product vision and the backlog order, makes final priority decisions and accepts completed work on behalf of the business. The business analyst works on understanding problems in depth: eliciting and analysing requirements, modelling processes and data, writing detailed stories and acceptance criteria and supporting the team and testers. In smaller teams one person may do both, but the PO decides what, while the BA clarifies how it should work.
06
What Power Query steps would you use to clean a messy monthly sales file?
Promote the first row to headers and remove blank or total rows. Set correct data types for dates and amounts, and use locale settings for Indian date formats. Trim and clean text columns, replace errors and nulls, split combined fields like 'City-State', and unpivot month columns into rows. Remove duplicates on the order ID, then merge with the product master. Rename steps clearly so others can follow the logic.
07
Which chart would you choose for trend, part-to-whole, comparison and distribution?
For a trend over time use a line chart. For part-to-whole use a stacked bar or a 100 percent bar; a pie or donut only works with two to four slices. For comparing categories use a sorted horizontal bar chart. For distribution use a histogram or box plot. For correlation between two measures use a scatter plot. Choosing by the question being answered, not by looks, keeps dashboards readable.
Go back to the requirement and acceptance criteria. If the system matches the agreed requirement, the developer is right, and the business need is a change request. If the requirement is unclear or the design misread it, it is a defect, and the requirement wording should be fixed. Discuss it in triage with both parties, using examples. Either way, close the loop with the tester so they understand the outcome and keep trusting the process.
A/B testing is a controlled experiment where users are randomly split into a control group that sees the current version and a treatment group that sees a change, such as a new checkout button. You compare a pre-decided primary metric, like conversion rate, between groups. Because assignment is random, a significant difference can be attributed to the change rather than to seasonality, marketing or user mix.
11
Explain exclusive, parallel and inclusive gateways in BPMN.
An exclusive gateway (diamond with X) sends the flow down exactly one path based on a condition, for example approved or rejected. A parallel gateway (diamond with +) splits into all paths at once and, when joining, waits for every path to finish. An inclusive gateway (diamond with O) activates one or more paths whose conditions are true and joins only those that were activated. Choosing the wrong one causes deadlocks or duplicated work in automated processes.
12
What is a SIPOC diagram and when do you use it before detailed process mapping?
SIPOC stands for Suppliers, Inputs, Process, Outputs and Customers. It is a one-page, high-level table that lists 4 to 7 main process steps along with who supplies what and who receives the outputs. A BA uses it at the start of a process improvement project to agree on scope and boundaries with stakeholders before spending time on a detailed BPMN map. It prevents arguments later about where the process starts and ends.
13
What is a KPI and give examples for an e-commerce business?
// Profit Ratio (aggregate so it works at any level)
SUM([Profit]) / SUM([Sales])
// Loss Flag (row level)
IF [Profit] < 0 THEN "Loss" ELSE "Profit" END
// Put Loss Flag on Color to highlight loss-making orders
17
Tell me about a time you had to learn a new analytics tool quickly for a project.
Situation: my team moved reporting from Excel to Power BI, and I had two weeks to rebuild the weekly sales report. Task: deliver it on time without errors. Action: I took a short online course, practised data modelling on a copy of our data, and asked a colleague to review my DAX measures. I reconciled every number with the old Excel report before launch. Result: the report went live on schedule, and refresh time dropped from half a day to minutes.
Decide whether and how to enter a market by evaluating attractiveness, competition, capabilities and entry mode (build, buy, partner), then risks and next steps.
The BCG matrix classifies business units or products by market growth rate and relative market share. Stars have high share in high-growth markets and need investment. Cash cows have high share in slow markets and fund the rest. Question marks have low share in fast markets and need a decision to invest or exit. Dogs have low share in slow markets and are candidates to divest. It guides portfolio resource allocation.
Agile delivers value in small increments with feedback. Scrum organises work in sprints with planning, daily stand-ups, review and retrospective, led by a Scrum Master and Product Owner.
22
What is the difference between alpha testing and beta testing?
Alpha testing is done internally, by employees or a selected group, in a controlled environment before the product is released to outsiders, and aims to catch major issues early. Beta testing releases the product to a limited group of real external users in real conditions to gather feedback on usability, performance and missing features before general release. For a mobile app, beta often uses store testing tracks, and feedback is fed into the final release backlog.
SELECT c.customer_id, c.name
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.customer_id
WHERE o.order_id IS NULL;
-- alternative
SELECT customer_id, name FROM customers c
WHERE NOT EXISTS (
SELECT 1 FROM orders o WHERE o.customer_id = c.customer_id
);
Population about 20 million, adult tea drinkers about 50%, cups bought outside per person around 1 on average. This gives roughly 10 million cups, then adjust for offices and stalls.
Cohort analysis groups users by a shared starting point, usually their sign-up or first purchase month, and tracks their behaviour over time, such as the percentage still active in month 1, 2 and 3. It separates the effect of growth from the effect of retention, so you can see whether newer cohorts retain better after a product change. It is typically shown as a triangle table or retention curves.
28
Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?
Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.
29
Developers and testers interpret the same user story differently. How do you fix this?
The story is ambiguous, so bring the three amigos together: BA or product owner, a developer and a tester. Walk through concrete examples, including edge cases and error cases, and write them as acceptance criteria, ideally in Given-When-Then format. Add business rules, sample data and mock-ups where needed. Update the story and use the same practice in refinement for future stories, so gaps are found before coding starts.
30
What is a data dictionary and why does a business analyst maintain one?
A data dictionary is a catalogue of data elements used in a system or report: field name, business definition, data type, length, allowed values, mandatory or optional, source system, owner and example values. A BA maintains it so business users, developers and testers use one definition, for example what counts as an active customer. It prevents mapping errors in integrations and migrations, speeds up testing and reduces disputes about why reports do not match.
31
What are Excel Tables (Ctrl+T) and why should analysts use them?
An Excel Table turns a range into a named, structured object. It expands automatically when rows are added, so formulas, charts, PivotTables and Power Query sources pick up new data without range edits. It supports structured references like =SUM(Sales[Amount]), calculated columns that fill down automatically, built-in filters, banded formatting and a total row. Tables make reports far less error-prone than fixed ranges like A2:F5000.
32
Tell me about a time you misunderstood a requirement. What did you learn?
Situation: I was asked for 'monthly active customers' and built it on login data. Task: deliver the report for a review. Action: in the demo, the stakeholder said active meant customers who purchased, not logged in. I owned the mistake, rebuilt the measure in two days and wrote down the definition for sign-off. Result: the report was accepted, and now I always confirm definitions and sample outputs with stakeholders before building anything.
The p-value is the probability of seeing a difference at least as large as observed if the change truly had no effect. If it is below the chosen threshold, often 0.05, the result is called statistically significant. It does not mean there is a 95 percent chance the variant is better, and significance is not the same as business importance. Always report the confidence interval of the lift as well.
35
Split the epic 'Customers can track their order online' into user stories.
Possible stories: As a customer, I want to see my order status (placed, packed, shipped, delivered) so that I know its progress. As a customer, I want an SMS or email when the status changes so that I do not have to check. As a customer, I want the expected delivery date so that I can plan. As a customer, I want a courier tracking link once shipped. As support staff, I want to see the same timeline so that I can answer queries.
Logically the database processes FROM and JOIN first, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY and finally LIMIT or TOP. This explains common errors: you cannot use a SELECT alias in WHERE because WHERE runs earlier, aggregate conditions must go in HAVING, and window functions cannot be filtered in WHERE, so you wrap them in a CTE or subquery. The optimiser may physically reorder steps, but the result follows this order.
A language for querying databases. BAs use it to pull data themselves, validate numbers, check reports and answer questions without waiting for engineers.
39
Write a UAT test case for logging in to a banking app with OTP.
Test case ID: UAT-LOGIN-03. Precondition: registered customer with a verified mobile number. Steps: 1. Open the app and enter the registered mobile number. 2. Tap Send OTP. 3. Enter the 6-digit OTP received by SMS within 3 minutes. 4. Tap Verify. Expected result: the customer lands on the account dashboard, and the login is recorded in the activity log. Related negative cases: wrong OTP shows an error, and three wrong attempts lock login for 30 minutes.
40
What is the debt-to-equity ratio and how do you interpret it?
Debt-to-equity equals total borrowings divided by shareholders' equity. It shows how much the company relies on borrowed money versus owners' funds. A ratio of 0.5 means 50 paise of debt for every rupee of equity. Higher leverage can boost returns but raises interest burden and risk in downturns. Acceptable levels depend on the industry: utilities and infrastructure carry more debt than software firms. Always read it with interest coverage, which is EBIT divided by interest expense.
Tips to crack the Tech Mahindra Business Analytics interview
Read about telecom basics like 4G, 5G and network operations, since communications is Tech Mahindra's largest vertical.
Practise English essay and verbal ability sections, which often appear in Tech Mahindra online assessments.
Revise SQL and one programming language, and prepare a clear two-minute explanation of your project.
Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
Practise the hard questions on this page aloud; Tech Mahindra interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Tech Mahindra Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + English essay); Coding test; Technical interview; HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the Tech Mahindra Business Analytics interview?
This practice set leans on UAT and BA Documentation (6), Requirements and Agile (6), Case Studies and Guesstimates (5), SQL for Business Analysis (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Tech Mahindra interviewers ask you to walk through real work.
Are these the exact questions asked at Tech Mahindra?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Tech Mahindra's. They are not a leaked or verified list of past questions.
Where does Tech Mahindra hire Business Analytics professionals in India?
Tech Mahindra has large teams in Pune, Hyderabad, Bengaluru, Noida, Chennai. Openings and locations change often, so check the Tech Mahindra careers page and filter by city and experience.
Business Analytics questions for similar companies