Kotak Mahindra Bank Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Kotak Mahindra Bank hiring for Business Analytics roles
Kotak Mahindra Bank is a major Indian private sector bank offering retail banking, corporate banking, wealth management, credit cards and digital banking through products like Kotak 811. The wider Kotak group also includes securities, asset management and insurance businesses. It hires for relationship management, operations, risk, analytics and technology roles across its offices and branches.
For Business Analytics roles, this Kotak Mahindra Bank practice set focuses most on SQL for Business Analysis (6), Power BI and Tableau (6), Case Studies and Guesstimates (5), Excel for Business Analysts (5). It has 6 easy, 30 medium, 4 hard questions, so you can start easy and work up to the harder ones.
Company type
Banking & finance
Headquarters
Mumbai, India
Main India offices
Mumbai, Bengaluru
Kotak Mahindra Bank Business Analytics interview process
Online assessment or resume screening
Functional or technical interview
Managerial round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Kotak Mahindra BankStart 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.
✓ 3 questions free • Unlock the rest in seconds
01
What is the difference between defect severity and defect priority?
Severity describes the impact of a defect on the system or business, such as critical when payments fail or low for a spelling mistake. Priority describes how urgently it must be fixed, which is a business decision. They can differ: a wrong company logo on the login page is low severity but high priority before a launch, while a crash in a rarely used year-end report may be high severity but lower priority if the report is months away.
02
A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?
Check whether the extra sign-ups are lower-intent users who would naturally retain less. Compare Day-7 retention for comparable users in both versions and count retained users in absolute terms, not just rates. If the new flow skips a step that led users to the aha moment, retention per user may truly fall. The decision depends on whether total retained, valuable users went up or down.
03
How would you decide whether to launch a new product?
Assess market size and demand, customer need, competition, unit economics, capabilities, risks and strategic fit, then test with a pilot before scale-up.
First measure each handoff: waiting time, rework rate and volume, using system timestamps where possible. Then classify steps as value-adding, required for compliance or waste. Look for patterns: repeated approvals, information re-entered in two systems, work bouncing back for missing documents. Typical fixes are merging roles, adding a checklist at intake so applications arrive complete, parallelising checks and automating rule-based approvals. Quantify the expected reduction in cycle time for each option.
07
Your process diagram has grown to 80 shapes on one page and stakeholders say they cannot read it. What do you do?
Restructure it into levels. Create a high-level map with 7 to 10 main steps, then collapse detailed parts into sub-processes with their own diagrams. Move complex decision logic into a decision table rather than chains of gateways. Show the happy path first and handle exceptions in separate views. Use consistent naming in verb-noun form and remove duplicated steps. Finally, test readability by asking a stakeholder to explain the diagram back to you.
MECE means Mutually Exclusive and Collectively Exhaustive. When you break a problem into parts, the parts should not overlap and together should cover every possibility. For example, profit splits into revenue and cost, and revenue into price times volume. A breakdown of customers into 'young' and 'students' is not MECE because they overlap. MECE structures prevent double counting and missed causes, which is what interviewers check.
09
Write a defect report for an invoice that calculates GST incorrectly.
Title: Invoice applies 12 percent GST instead of 18 percent for service items. Environment: UAT, build 2.4.1. Steps: create an order with service item SRV-101 at 1,000 rupees for a customer in Maharashtra and generate the invoice. Expected: CGST 90 and SGST 90, total 1,180. Actual: CGST 60 and SGST 60, total 1,120. Severity: high, as it affects tax compliance. Attachments: invoice PDF and screenshot. Linked requirement: FR-TAX-07.
10
What is the profit equation and how do you use it in cases?
Possible causes include falling sales against unchanged purchasing, poor demand forecasts, bulk buying for discounts, slow-moving or obsolete SKUs, or deliberate stock-building ahead of a festive season or expected price rise. Analyse by SKU, warehouse and age bucket to find where stock is stuck. Recommend clearing aged items, adjusting reorder points using recent demand, and reviewing supplier minimum order quantities. Also quantify the cash locked up and the carrying cost to show urgency.
12
How would you forecast next quarter's sales in Excel?
Unit economics measure revenue and cost for one unit of business, such as one order, one customer or one subscription. For an order you compute average order value minus product cost, delivery, payment fees, discounts and support cost to get contribution margin. If each unit loses money, scale only increases losses. Leaders use unit economics to decide pricing, which cities or channels to grow and where to cut cost.
14
How do you write a query to find users active in consecutive months?
First agree on the definition: date range, gross or net, tax, returns, currency and which date (order or invoice) is used. Then reconcile at a small grain, such as one month and one region, comparing row counts and sums between the source query and the sheet. Common causes are filters on the page, missing relationships, duplicate rows after a join or a late refresh. Document the agreed definition in the report tooltip.
16
The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?
Check the refresh history error first: expired credentials, gateway offline, source schema change or timeout. Fix the quick cause and trigger a manual refresh. If it cannot be fixed in time, inform the stakeholders early, state the last refreshed date clearly on the report and share the key numbers from a direct query if needed. Afterwards add refresh failure alerts and a data-as-of label so it never surprises anyone.
17
How do sample size and minimum detectable effect affect an A/B test design?
The minimum detectable effect is the smallest lift worth detecting, such as a 2 percent relative increase in conversion. Smaller effects, lower baseline rates and higher required power need much larger samples, roughly four times the users to detect half the effect. Calculate sample size before starting using the baseline rate, MDE, significance level and power, usually 80 percent, then fix the test duration and avoid stopping early.
18
Tell me about a dashboard you built that changed a business decision.
Situation: regional sales heads reviewed discount spend only at month end. Task: I was asked to give weekly visibility. Action: I built a Power BI report linking discounts to margin by product and region, with a drill-through to deal level and an alert when margin fell below target. Result: the team spotted two regions giving deep discounts on low-margin items, tightened approval rules, and margin improved by about two points the next quarter.
19
What is the difference between top-down and bottom-up market sizing?
Top-down starts from a large known number, such as population or total industry size, and narrows it with percentages to the target segment. Bottom-up starts from a unit, such as one store's daily sales or one customer's purchase frequency, and multiplies up by the number of units. Top-down is fast; bottom-up is more grounded in operations. Doing both and comparing results is a strong sanity check.
20
After joining orders to a payments table, your total revenue doubled. What went wrong?
The join created a fan-out: some orders have more than one payment row, such as split payments or retries, so each order amount is repeated. Check the grain by counting rows per order_id on both sides. Fix it by aggregating payments to one row per order in a CTE before joining, joining on the full key, or summing from the table whose grain matches the metric. Always compare row counts before and after a join.
21
Write an Excel formula for a two-way lookup that finds sales for a given product and month.
UAT sign-off is the formal acceptance by the business that the solution meets agreed requirements and is fit to go live, often with a list of known open defects and agreed workarounds. It should be given by the accountable business owner or product owner, not by the IT team or the BA. The BA prepares the evidence: test execution summary, defect status and traceability to requirements. Sign-off is recorded in writing, usually by email or in the test management tool.
23
Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.
Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.
24
What is the difference between absolute, relative and mixed cell references in Excel?
A relative reference like A1 shifts when the formula is copied. An absolute reference like $A$1 stays fixed, useful for a tax rate or target cell. A mixed reference fixes only the column ($A1) or only the row (A$1), which is handy in multiplication grids or when copying a formula across months and products. Press F4 to cycle through the four options while editing a formula.
25
Write a SQL query to show cumulative revenue by month.
WITH monthly AS (
SELECT DATE_TRUNC('month', order_date) AS month,
SUM(amount) AS revenue
FROM orders
GROUP BY 1
)
SELECT month, revenue,
SUM(revenue) OVER (ORDER BY month) AS cumulative_revenue
FROM monthly
ORDER BY month;
-- add PARTITION BY EXTRACT(YEAR FROM month) to reset each year
A window function calculates across a set of related rows using OVER(), but it keeps every original row instead of collapsing them. GROUP BY returns one row per group. For example, SUM(amount) OVER (PARTITION BY region) shows each order next to its region total, which helps compute share of total, rankings, running totals and month-over-month change. Common window functions are ROW_NUMBER, RANK, LAG, LEAD and SUM.
28
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
Standardise both first: trim spaces, fix case, convert IDs to the same type and remove duplicates. Use a unique key like customer ID, or a combined key of phone and email if IDs differ. Then use XLOOKUP or COUNTIFS to mark each record as matched, only in sales or only in billing, or a Power Query merge with anti joins. Summarise mismatches by type and share the exception list with both owners.
29
Your measure shows the same value on every row of a matrix. Why might that happen?
The filter from the row field is not reaching the fact table. Usually there is no relationship between that dimension and the fact, the relationship is inactive, or it filters in the wrong direction. It can also happen when the measure uses ALL or REMOVEFILTERS on that column, or when the row field comes from the fact table of a different grain. Check the model view and test the measure with a simple SUM.
30
After many sprints, project documentation is out of date and new team members are confused. What do you do?
Identify which documents are actually used: usually a product overview, process maps, business rules, data dictionary and integration details. Update those first rather than everything. Make documentation part of the Definition of Done, so a story is not complete until related docs are updated. Keep living documents in a shared wiki with owners and last-reviewed dates, and archive outdated files clearly. Test the result by having a new joiner use it during onboarding.
31
The CEO wants one KPI to judge the customer support team. What would you propose?
A single KPI can be gamed, so I would propose one headline with guardrails. The headline could be first-contact resolution rate, because it reflects solving problems, not just closing tickets. Guardrails would be customer satisfaction score after the ticket and median first response time. I would also watch ticket volume per thousand orders, which shows whether product issues are falling. Review targets quarterly with the support head.
32
Guesstimate: how many pizzas are sold in Mumbai on a weekend?
About 20 million people, roughly 10% order pizza on a weekend, about 1 pizza per 2 people in an order. This gives roughly 1 million pizzas, adjusted for outlets and delivery capacity.
Dimensions are qualitative fields such as Region, Category or Customer Name; placing them on a shelf creates headers and splits the view into groups. Measures are numeric fields such as Sales or Quantity that Tableau aggregates, usually with SUM or AVG. Tableau also marks fields as discrete (blue pills, headers) or continuous (green pills, axes). A date can act as either, which changes whether you get separate bars or a continuous trend line.
The cash conversion cycle measures how many days cash is tied up in operations. It equals days inventory outstanding plus days sales outstanding minus days payables outstanding. Example: inventory sits 40 days, customers pay in 30 days and suppliers are paid in 45 days, so the cycle is 40 + 30 - 45 = 25 days. A shorter cycle means less working capital is needed. Some marketplaces have a negative cycle because they collect from customers before paying sellers.
35
How would you size the market for IT courses in Delhi NCR?
Top-down: NCR population aged 18–30 × share of graduates × share wanting paid upskilling × average fee. Cross-check bottom-up with institutes × batches × students × fees. State your assumptions.
36
Write a DAX measure to count distinct active customers in the last 30 days.
Active Customers 30D =
CALCULATE(
DISTINCTCOUNT(Sales[CustomerID]),
DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -30, DAY)
)
-- MAX('Date'[Date]) makes it relative to the date in the current filter
37
What checklist do you apply to a BPMN diagram before sharing it with stakeholders?
Every diagram has clear start and end events and a title with version and owner. Activities use verb-noun names such as Approve invoice. Each gateway is labelled with a question and its outgoing flows with answers. Splits and joins use matching gateway types. Message flows only connect separate pools. No dangling or crossing arrows where avoidable. The happy path reads left to right. Exceptions are handled, and complex rules are referenced to decision tables rather than drawn as gateways.
38
Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?
Confirm the data first: definition changes, failed-payment handling or a billing date shift. Then segment churn by plan, tenure, acquisition channel, city and device to find where it concentrates. Separate voluntary cancellations from involuntary card failures. Look at events before the jump, like a price change, app release or competitor offer, and read cancellation reasons. Recommend targeted fixes, such as payment retries or win-back offers, and track the affected cohort.
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.
40
Your TO-BE process cuts the account-opening cycle time by half, but the compliance team rejects it. How do you handle it?
Ask compliance which specific controls they believe are weakened, and map each regulatory requirement to steps in the old and new flows. Often the control can be kept in a different form, such as automated checks, risk-based sampling or a post-approval audit instead of a manual pre-check. Bring compliance into the redesign rather than presenting a finished model. Document the agreed controls in the TO-BE diagram so audit can trace them. Speed never overrides a mandatory control.
Tips to crack the Kotak Mahindra Bank Business Analytics interview
Revise banking basics such as types of accounts, loans, interest rates, KYC and the role of the RBI.
For technology and analytics roles, prepare SQL, Excel and one programming language, with examples from your projects.
Read about Kotak's digital banking efforts like Kotak 811 and recent banking news to discuss them in interviews.
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; Kotak Mahindra Bank interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Kotak Mahindra Bank Business Analytics interview?
Candidates usually go through 4 stages: Online assessment or resume screening; Functional or technical interview; Managerial round; 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 Kotak Mahindra Bank Business Analytics interview?
This practice set leans on SQL for Business Analysis (6), Power BI and Tableau (6), Case Studies and Guesstimates (5), Excel for Business Analysts (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Kotak Mahindra Bank interviewers ask you to walk through real work.
Are these the exact questions asked at Kotak Mahindra Bank?
No. These are curated practice questions that match the skills and difficulty usually tested in banking & finance interviews like Kotak Mahindra Bank's. They are not a leaked or verified list of past questions.
Where does Kotak Mahindra Bank hire Business Analytics professionals in India?
Kotak Mahindra Bank has large teams in Mumbai, Bengaluru. Openings and locations change often, so check the Kotak Mahindra Bank careers page and filter by city and experience.
Business Analytics questions for similar companies