Business Analyst is one of the fastest-growing roles in India, with demand surging across IT services, BFSI, e-commerce, and consulting sectors. Naukri.com shows 45,000+ active BA openings in India, with salaries ranging from ₹4–8 LPA for freshers to ₹18–35 LPA for senior BAs at top MNCs and product companies. The interview, however, is uniquely broad — blending analytical thinking, domain knowledge, communication skills, and tool proficiency. This guide tells you exactly what to prepare.
The Business Analyst Landscape in India
| Sector | Top Hiring Companies | Typical BA Focus | Salary Range |
|---|---|---|---|
| IT Services | TCS, Wipro, Infosys, HCL | Requirement gathering, documentation | ₹4–12 LPA |
| BFSI | HDFC, ICICI, Kotak, Bajaj Finance | Process improvement, data analysis | ₹6–18 LPA |
| E-commerce | Flipkart, Amazon India, Meesho | Product analytics, funnel analysis | ₹10–25 LPA |
| Consulting | Deloitte, McKinsey, KPMG, PwC | Business problem solving, strategy | ₹12–35 LPA |
| Fintech | Razorpay, PhonePe, Paytm, CRED | Product insights, market analysis | ₹10–28 LPA |
| Healthcare | Apollo, Narayana Health, 1mg | Process optimisation, EHR analysis | ₹6–15 LPA |
What BA Interviewers Are Really Testing
| Competency | How It’s Tested |
|---|---|
| Analytical thinking | Case studies, data interpretation, SQL/Excel problems |
| Requirement elicitation | “Walk me through how you’d gather requirements from a stakeholder” |
| Documentation skills | BRD, FRD, user story writing samples |
| Communication | Can you explain a technical concept to a non-technical person? |
| Domain knowledge | Questions specific to BFSI, e-commerce, or IT sector |
| Tool proficiency | SQL, Excel, JIRA, Confluence, Power BI |
| Stakeholder management | “Tell me about a time you handled a difficult stakeholder” |
The 5-Part BA Interview Structure
Part 1: Introduction and Background (10–15 min)
Tell your story in a way that connects to the BA role specifically.
BAD intro: “I graduated in 2022 from XYZ college and worked as a software developer…”
STRONG intro: “I’ve spent 3 years at the intersection of technology and business — my role as a software developer gave me deep technical grounding, but I kept gravitating toward the product and business problems. I formally moved into BA work 18 months ago when I led the requirement gathering for a ₹2Cr CRM implementation at [Company], and I’ve been building on that ever since.”
Part 2: Behavioural Questions (STAR Format)
| Common Question | STAR Key Points to Hit |
|---|---|
| “Tell me about a complex requirement you gathered” | Tools used, stakeholders involved, challenges, documentation output |
| “Describe a time requirements changed mid-project” | How you managed change, communicated impact, adapted the BRD |
| “Tell me about a conflict with a developer over a requirement” | Root cause, how you clarified, outcome |
| “How did you handle a stakeholder who kept changing their mind?” | Structured sign-off, meeting notes, change management |
Part 3: Technical / Analytical Questions
SQL questions common in BA interviews:
> “Given a table of customer transactions, write a query to find the top 5 customers by transaction volume in Q3 2024.”
SELECT customer_id, SUM(amount) AS total_volume
FROM transactions
WHERE transaction_date BETWEEN ‘2024-07-01’ AND ‘2024-09-30’
GROUP BY customer_id
ORDER BY total_volume DESC
LIMIT 5;
Excel / Data questions:
- VLOOKUP / XLOOKUP scenarios
- Pivot table construction from messy datasets
- Interpreting a dashboard with conflicting metrics
Process questions:
- “Map the current loan disbursement process and identify 3 inefficiencies”
- “Draw a use case diagram for an online returns management system”
Part 4: Domain Case Study (15–30 min)
BAs are often given a mini-case. Common formats in India:
| Case Type | Example | What They’re Testing |
|---|---|---|
| Process improvement | “Our KYC process takes 72 hours. How would you reduce it to 24?” | Structured thinking, process knowledge |
| Requirements scenario | “A bank wants to launch UPI autopay for SIPs. Gather your requirements.” | Elicitation technique, domain knowledge |
| Data analysis | “Here’s a spreadsheet of app user data. What insights do you find?” | Analytical depth, communication |
| Prioritisation | “The product team has 20 feature requests. How do you prioritise?” | Frameworks (MoSCoW, RICE), stakeholder management |
Part 5: Questions You Ask the Interviewer
Asking good questions shows BA-level thinking:
- “How does the BA team engage with the product and tech teams — is it a waterfall or agile environment?”
- “What does the first 90-day onboarding look like for a new BA here?”
- “What’s the most complex domain challenge this team is working on right now?”
BA Tools You Must Know in India
| Tool Category | Tools | Proficiency Level Needed |
|---|---|---|
| Documentation | Confluence, MS Word, SharePoint | High |
| Project / Story Tracking | JIRA, Azure DevOps, Trello | Medium-High |
| Data Analysis | Excel (Advanced), SQL, Power BI | High |
| Diagramming | Lucidchart, Draw.io, Visio | Medium |
| Communication | Slack, MS Teams, Zoom | Basic |
| Prototyping | Figma (basic), Balsamiq | Basic–Medium |
BA Interview Preparation Plan (4 Weeks)
Week 1: Fundamentals
☐ Read: “Business Analysis Body of Knowledge” (BABOK) summary
☐ Practise: Draw BPMN process flows for 5 familiar processes (e.g., leave approval)
☐ Write: One user story in correct format (As a [user], I want [action], so that [benefit])
Week 2: Technical Skills
☐ Complete: 10 SQL problems on HackerRank (EASY-MEDIUM)
☐ Practise: Excel VLOOKUP, pivot tables, conditional formatting
☐ Learn: Basic Power BI dashboard creation using a sample dataset
Week 3: Domain Preparation
☐ Choose your target domain (BFSI, e-commerce, IT)
☐ Research: 3 key processes in that domain + common pain points
☐ Prepare: 5 domain-specific STAR stories
Week 4: Mock Interviews
☐ 2 mock BA case study sessions with peers
☐ Record and review your stakeholder scenario answers
☐ Prepare 5 questions to ask the interviewer
References:
- IIBA — Business Analysis Body of Knowledge (BABOK) — https://www.iiba.org/babok
- Naukri.com — Business Analyst Jobs India 2024 — https://www.naukri.com/business-analyst-jobs
- AmbitionBox — BA Salary India Report — https://www.ambitionbox.com/salaries/business-analyst-salaries
- HackerRank — SQL Practice for BA Interviews — https://www.hackerrank.com/domains/sql
- Coursera — Business Analysis Fundamentals — https://www.coursera.org/learn/business-analysis-fundamentals