Bajaj Finserv Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Bajaj Finserv hiring for Business Analytics roles
Bajaj Finserv is a Pune-based financial services group, part of the Bajaj Group, with businesses in lending, insurance and investments. Its subsidiary Bajaj Finance is a large non-banking finance company known for consumer durable loans, personal loans and EMI cards. It hires for credit, risk, analytics, sales and technology roles, including data and digital product teams.
For Business Analytics roles, this Bajaj Finserv practice set focuses most on Excel for Business Analysts (9), UAT and BA Documentation (6), SQL for Business Analysis (5), Case Studies and Guesstimates (4). It has 5 easy, 33 medium, 2 hard questions, so you can start easy and work up to the harder ones.
Company type
Fintech
Headquarters
Pune, India
Main India offices
Pune
Bajaj Finserv 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 Bajaj FinservStart 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
In UAT cycle 2, a feature that passed in cycle 1 is now broken after a defect fix. What does this tell you and what should change?
It is a regression: the fix for one defect broke existing functionality, which usually means changes were not impact-analysed and there is no regression suite. Log it as a new high-priority defect linked to the fix. Agree with the team that every UAT build comes with release notes listing the changes, and that QA runs an automated or core manual regression pack before handing the build to business testers. Also add the broken flow to the UAT regression checklist.
02
How would you build a simple financial model in Excel?
Compare against the baseline you measured before the change, using the same definitions: cycle time, first-time-right rate, cost per case, backlog and customer complaints. Pull data from system timestamps rather than surveys. Check that the gain is not explained by lower volumes or seasonality, ideally by comparing similar periods. Also check for side effects, such as faster processing but more rework downstream. Present the before-and-after with the business owner, and note where adoption is still incomplete.
04
Write a SQL query to find requirements that have no linked UAT test case.
SELECT r.req_id, r.title, r.priority
FROM requirements r
LEFT JOIN test_case_links l ON l.req_id = r.req_id
WHERE l.req_id IS NULL
AND r.status = 'APPROVED'
ORDER BY r.priority;
-- Run this before UAT starts: every approved requirement
-- should trace to at least one test case.
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.
06
Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?
Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.
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.
08
UAT starts tomorrow, but the business has not nominated any testers. What do you do?
Escalate immediately to the business sponsor with the impact: each day without testers delays sign-off and go-live. Ask for named testers with protected time, even part-time. Meanwhile, prepare so no time is lost: finalise test cases, check the environment and data, and plan a short tester briefing. If testers cannot be released, propose re-planning UAT dates rather than letting IT or the BA test on the business's behalf, because acceptance must come from the users.
09
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.
10
Guesstimate: how many weddings take place in India in a year?
Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
12
Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?
Quantify both effects: extra sessions and revenue from notifications versus users lost through uninstalls and notification opt-outs, including their lifetime value. Segment by notification type and frequency to find which ones annoy users. Recommend frequency caps, personalised timing, relevance rules and easy preference settings, then test them with uninstall rate and opt-out rate as guardrails. Short-term engagement should not cost long-term users.
Start from the test cases and list the data each needs: customer types, product variants, edge values and historical records. Decide whether to use masked copies of production data, synthetic data or both, because real personal data must be anonymised under data protection rules such as the DPDP Act. Prepare data for negative and boundary cases, keep a refresh plan for repeated cycles, and assign owners. Poor test data is one of the most common causes of blocked UAT days.
14
How do you calculate monthly revenue growth in SQL?
A date table has one row per day with no gaps, plus columns like Year, Quarter, Month, Week and Fiscal Period. It is related to the fact table date column. Marking it as a date table tells Power BI to use it for time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR and DATESINPERIOD, which require a continuous date range. It also gives consistent month sorting and fiscal calendars across every report.
16
The totals in your Excel report differ from the finance system by a few rupees. What could cause this?
Usually rounding. Excel may display rounded values while summing the full-precision numbers, or line items were rounded individually in the source system and the total was computed differently. Check whether finance rounds each invoice line before summing, and apply ROUND at the same level in Excel. Other causes include floating-point artifacts, values stored as text being skipped by SUM, or hidden filtered rows. Agree and document one rounding rule with finance.
17
What are UAT entry and exit criteria? Give examples.
Entry criteria are conditions that must be met before UAT starts, for example system and integration testing completed, no open critical defects, UAT environment and test data ready, test cases reviewed and testers trained. Exit criteria define when UAT is complete, for example 100 percent of critical test cases executed, at least 95 percent passed, no open critical or high defects, and workarounds agreed for remaining medium ones. Clear criteria stop arguments about readiness near go-live.
18
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.
// Excel 365
=COUNTA(UNIQUE(A2:A500))
// unique customers in the North region only
=COUNTA(UNIQUE(FILTER(A2:A500, B2:B500="North")))
// older versions (no blanks in range)
=SUMPRODUCT(1/COUNTIF(A2:A500, A2:A500))
22
Tell me about a time you found an error in a spreadsheet just before it went to management.
Situation: an hour before a quarterly review I noticed regional totals were higher than the company total. Task: find the issue without delaying the meeting. Action: I traced it to a SUMIFS range that stopped at row 5000 while new data went beyond it, plus one duplicated region. I fixed both, converted the data to an Excel Table, and added a check cell comparing totals. Result: the correct deck went out on time and the check became part of our template.
23
Guesstimate: how many smartphones are sold in India each year?
Use a replacement plus new-buyer approach. India has about 144 crore people; assume around 60 crore active smartphone users. If people replace phones every 4 years on average, replacements are about 15 crore a year. Add first-time buyers, say 2 to 3 percent of the remaining adult population, roughly 1.5 crore. The estimate is about 16 to 17 crore phones a year, which is close to reported industry numbers of around 15 crore.
24
Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.
// second highest value
=LARGE(C2:C100, 2)
// rep name for that value
=INDEX(B2:B100, MATCH(LARGE(C2:C100, 2), C2:C100, 0))
// with ties, SORTBY gives a clean list:
=TAKE(SORTBY(B2:C100, C2:C100, -1), 2)
25
What are start, intermediate and end events in BPMN?
Events are circles that show something happening. A start event (thin border) triggers the process, such as a form submitted or a timer firing on the first of the month. An intermediate event (double border) happens during the process, such as waiting for a payment message or a 48-hour timer. An end event (thick border) marks where a path finishes and can carry a result such as a message, an error or termination of all paths.
26
How do you calculate the percentage contribution of each category?
WITH per_customer AS (
SELECT customer_id, COUNT(DISTINCT order_id) AS orders
FROM orders
GROUP BY customer_id
)
SELECT
ROUND(100.0 * SUM(CASE WHEN orders >= 2 THEN 1 ELSE 0 END)
/ COUNT(*), 2) AS repeat_rate_pct
FROM per_customer;
28
Where do you see yourself in five years as a business analyst?
Show ambition that fits the role. For example: in five years I see myself as a senior business analyst who owns a business domain, such as payments or supply chain, leads requirement and analytics work for major initiatives and mentors juniors. To get there I am building strong SQL and Power BI skills, learning the domain deeply and taking on more stakeholder-facing work. I would like to grow that path within this organisation.
29
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.
Costs: software 12 lakh in year 1 plus 3 lakh per year support, and 4 lakh for implementation and training. Benefits: 60,000 invoices a year at 10 minutes saved each is 10,000 hours; at 400 rupees per hour that is 40 lakh, plus around 5 lakh from fewer late-payment penalties. Year-1 net benefit is 45 - 16 = 29 lakh and payback is under six months. Then test sensitivity, for example if only half the time saving is realised.
32
A feature launched two months ago is used by only 4 percent of users. What would you do?
Find out whether it is a discovery problem or a value problem. Check how many users saw the entry point, how many tried it and how many returned. If few saw it, test better placement or onboarding prompts. If many tried and few returned, interview users and review session recordings to understand why. Also check if the 4 percent are high-value users. Then decide to improve, reposition or remove it.
33
Write a SQL query to find the percentage of orders delivered late in each city.
-- late = delivered after the promised date
SELECT
city,
COUNT(*) AS total_orders,
SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END) AS late_orders,
ROUND(100.0 * SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END)
/ COUNT(*), 2) AS late_pct
FROM orders
WHERE status = 'DELIVERED'
GROUP BY city
ORDER BY late_pct DESC;
Put it first and keep it to one page or five lines on a slide. Start with the answer or recommendation, then the two or three key findings that support it, each with a number, then the impact in rupees or percentage, and finally the decision or action needed and by when. Avoid methodology details, which go in the appendix. Test it by asking whether a busy leader could act after reading only this section.
36
Write a DAX measure for the product return rate that avoids divide-by-zero errors.
Return Rate % =
VAR ReturnedQty = SUM ( Returns[Quantity] )
VAR SoldQty = SUM ( Sales[Quantity] )
RETURN
DIVIDE ( ReturnedQty, SoldQty, 0 )
// DIVIDE returns the third argument (0) when SoldQty is zero or blank.
// Format the measure as a percentage in the model.
37
Write non-functional requirements for an online payment page.
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
38
What is Average Order Value and how can a business increase it?
Average Order Value is total revenue divided by number of orders. If an online store earns 9 lakh from 1,500 orders, AOV is 600 rupees. Businesses increase it with bundles, cross-sell and upsell recommendations, free delivery above a threshold, volume discounts and premium options. Watch margin and conversion while doing so, because a high free-delivery threshold can raise AOV but reduce the number of orders.
39
A lookup formula returns #N/A for some rows even though the values look present. What could be wrong?
Usually the values only look the same. Common causes are trailing or leading spaces, numbers stored as text in one sheet and as numbers in the other, non-breaking spaces from web exports, or different spellings. Check with =LEN() and =ISNUMBER(), clean with TRIM, CLEAN or VALUE, and confirm the lookup range covers all rows and uses exact match. Wrap the final formula in IFNA to label true misses.
A query nested inside another, used for filtering or calculating values such as customers whose spend is above the average.
Tips to crack the Bajaj Finserv Business Analytics interview
Learn lending basics such as credit scores, EMI calculation, interest rates and loan approval processes before the interview.
For analytics and risk roles, revise SQL, Excel and basic statistics, and discuss how data helps assess credit risk.
Understand the difference between a bank and an NBFC and know Bajaj Finserv's main product lines.
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; Bajaj Finserv interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Bajaj Finserv 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 Bajaj Finserv Business Analytics interview?
This practice set leans on Excel for Business Analysts (9), UAT and BA Documentation (6), SQL for Business Analysis (5), Case Studies and Guesstimates (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Bajaj Finserv interviewers ask you to walk through real work.
Are these the exact questions asked at Bajaj Finserv?
No. These are curated practice questions that match the skills and difficulty usually tested in fintech interviews like Bajaj Finserv's. They are not a leaked or verified list of past questions.
Where does Bajaj Finserv hire Business Analytics professionals in India?
Bajaj Finserv has large teams in Pune. Openings and locations change often, so check the Bajaj Finserv careers page and filter by city and experience.
Business Analytics questions for similar companies