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.
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:
| 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:
| 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