How to Crack a Data Analyst Interview in India
Data analyst roles are among the fastest-growing positions in India’s tech, e-commerce, BFSI, and consulting sectors. Companies like Flipkart, Paytm, Razorpay, HDFC Bank, EY, and dozens of funded startups are aggressively hiring analysts to drive data-informed decisions. Yet the interview process is highly variable — ranging from pure SQL tests to business case discussions to Python-heavy technical rounds. This guide gives you a complete roadmap for cracking data analyst interviews in India. If you are targeting Data Analyst / Data Science Jobs specifically, weave concrete metrics and model outcomes into every answer. Once you feel ready, browse relevant roles on LinkedIn Jobs India and apply the same preparation to real openings.
The Data Analyst Interview Structure
| Round | What It Tests | Typical Platforms |
|---|---|---|
| Screening call | Background, motivation, communication | Phone/Video |
| SQL test | Query writing, joins, aggregations, window functions | HackerRank, Mettl, internal tool |
| Python/Excel test | Data cleaning, analysis, visualisation | Jupyter, Excel |
| Business case / case study | Analytical thinking, stakeholder communication | Live discussion |
| Statistics and probability | A/B testing, distributions, hypothesis testing | Whiteboard/Video |
| Behavioural | Problem-solving, impact, collaboration | STAR format |
Not all companies run all six rounds. IT services and traditional firms often focus on SQL + Excel. Product and data-first companies add business case + stats.
SQL: The Most Critical Skill to Master
SQL is asked in 90%+ of data analyst interviews in India. Priority topics:
Free mock interview
Reading tips isn't practice.
Run a free AI mock interview built from your CV and a real job description — scored feedback on your answers, pace and filler words.
Start a free mock interview →| SQL Concept | Must-Know |
|---|---|
| SELECT, WHERE, GROUP BY, HAVING | Core filtering and aggregation |
| JOINs (INNER, LEFT, RIGHT, FULL) | Multi-table analysis |
| Subqueries and CTEs | Complex query structuring |
| Window Functions (ROW_NUMBER, RANK, LAG, LEAD) | Running totals, rankings, time-based comparison |
| Date functions | DATEDIFF, DATE_TRUNC, EXTRACT — common in business data |
| CASE WHEN | Conditional logic in queries |
| String functions | CONCAT, SUBSTRING, LIKE |
Practice resources: Mode Analytics SQL Tutorial (free), StrataScratch (India-relevant business problems), LeetCode SQL section (Medium/Hard), SQLZoo.
Python and Excel: What to Prepare
Python (required at product/data companies):
- Pandas: read_csv, merge, groupby, pivot_table, fillna, apply
- NumPy: array operations, statistical functions
- Matplotlib/Seaborn: basic charts and distributions
- Jupyter Notebooks: running exploratory analysis cleanly
Excel (required at traditional and BFSI companies):
- VLOOKUP/XLOOKUP, INDEX-MATCH
- Pivot Tables and Pivot Charts
- Conditional formatting and data validation
- Power Query for data transformation
Business Case Questions for Data Analysts
Companies like Swiggy, Amazon, Zomato, and HDFC ask data-driven business case questions:
- “Our customer retention dropped 8% last month. How would you diagnose this?”
- “Design a dashboard for our sales team. What metrics would you track?”
- “We are launching a new feature. How would you measure its success?”
Framework for business case answers:
- Clarify the business objective (not just the data question)
- Identify key metrics / KPIs
- Describe data you would need and where to find it
- Outline your analysis approach (breakdown, segmentation, comparison)
- Explain how you would present findings to stakeholders
Statistics Knowledge: What Is Tested
For product analyst roles and analytics engineering roles, statistics is heavily tested:
Free CV check
Does your CV actually match the job?
Upload your CV and paste a job description — get a fit score, the exact skills you are missing, and an AI-tailored rewrite in a recruiter-ready format.
Check my CV against a job →| Topic | Key Concepts |
|---|---|
| A/B Testing | Hypothesis setup, p-value, statistical significance, sample size |
| Distributions | Normal, Poisson, Binomial — when to use each |
| Regression | Linear regression, R², interpreting coefficients |
| Probability | Bayes theorem, conditional probability |
| Cohort Analysis | Retention curves, LTV, cohort segmentation |
Don’t memorise formulas. Understand the intuition behind when to apply each technique.
What Indian Data Analyst Roles Pay
| Role | Experience | Typical CTC Range |
|---|---|---|
| Junior/Associate Data Analyst | 0–2 years | ₹4–8 LPA |
| Data Analyst | 2–5 years | ₹8–18 LPA |
| Senior Data Analyst | 5–8 years | ₹15–30 LPA |
| Lead / Analytics Manager | 7+ years | ₹25–50 LPA |
| Data Scientist (adjacent) | 3–6 years | ₹15–40 LPA |
Source: AmbitionBox, Glassdoor India (2024)
Tips for Freshers Entering Data Analytics in India
- Build a portfolio: 3–4 Kaggle/personal projects with clear business framing
- Get SQL certified: Mode Analytics, HackerRank SQL certificate
- Learn Python basics via UpGrad, Coursera, or Analytics Vidhya free courses
- Contribute to Kaggle competitions — even a top-30% ranking is worth mentioning
- Apply for analyst internships at startups (Internshala is a strong source)
- Target roles like “business analyst trainee,” “data operations analyst,” or “BI analyst” as entry points
References:
- StrataScratch SQL Interview Practice – https://www.stratascratch.com/
- Analytics Vidhya Career Guide – https://www.analyticsvidhya.com/
- AmbitionBox Data Analyst Salaries India – https://www.ambitionbox.com/salaries/data-analyst-salary
- Mode Analytics SQL Tutorial – https://mode.com/sql-tutorial/
- Kaggle Data Science Learning Path – https://www.kaggle.com/learn