Data Analyst Interview Questions: What Indian Companies Actually Ask
The data analyst interview questions Indian companies actually ask - SQL, Excel, Python, statistics, case studies and HR rounds - with what interviewers are really testing at each stage.
Data analyst interview questions in India follow a predictable pattern once you have sat through a few loops: a SQL or Excel screening round, a technical round on statistics and business thinking, a case or guesstimate, and an HR round. What changes between companies is the weight given to each. A service company hiring in bulk cares most about SQL and aptitude; a product company or a global capability centre will spend far longer on case problems and how you reason with messy data. This guide collects the questions that actually come up across both, organised round by round, with what the interviewer is really testing.
How data analyst interviews work in India
Most fresher and early-career loops have three or four stages. The first is usually an online test or a live SQL screen. Clearing it gets you a technical round on tools and statistics. Strong candidates then face a case round - "our app's orders dropped 15% last month, walk me through how you would investigate" - and finally an HR round on salary expectations, location and joining time.
The emphasis differs by employer type:
| Employer type | Heaviest round | What they optimise for |
|---|---|---|
| IT services (TCS, Infosys, Wipro, Accenture analytics practices) | Aptitude + basic SQL | Trainability; they expect to teach you the stack |
| Product companies and startups | Case study + SQL | Business reasoning with imperfect data |
| Global capability centres (bank and retail GCCs) | SQL + statistics | Depth in one tool plus communication with global teams |
| Consulting and analytics firms (Fractal, Mu Sigma, Tiger Analytics) | Guesstimates + case | Structured thinking under ambiguity |
SQL questions: the round that filters most people
SQL is where most Indian data analyst loops are won or lost. Interviewers consistently report that a majority of applicants cannot write a correct JOIN with a GROUP BY under time pressure. Expect questions like:
- "Find the second-highest salary in each department." (Tests window functions or correlated subqueries.)
- "Customers who ordered in January but not February." (Tests LEFT JOIN ... IS NULL or NOT EXISTS.)
- "Month-over-month revenue growth." (Tests LAG/LEAD and date grouping.)
- "Difference between WHERE and HAVING." (Tests whether you understand execution order.)
The interviewer is not testing syntax recall. They are watching whether you clarify the data first - duplicates, nulls, what "active customer" means - before writing a line. For a fuller bank of practice questions, our list of SQL interview questions goes deeper with worked answers.
Excel questions
Excel is still the working tool in most Indian analytics teams, especially in services and BFSI. Common questions:
- "VLOOKUP vs INDEX-MATCH vs XLOOKUP - when does each break?"
- "How would you remove duplicates but keep the most recent record?"
- "Walk me through building a pivot table that shows revenue by region and quarter."
- "Your file has 5 lakh rows and Excel is crawling. What do you do?"
The last one is a favourite. Good answers mention converting to tables, avoiding volatile functions, or moving the heavy work to SQL - answers that show you have actually worked with large files, not just tutorials.
Python and statistics questions
Python questions at the fresher level rarely go beyond pandas: reading a CSV, handling missing values, groupby aggregations, merging dataframes. If you claim pandas on your resume, be ready to do it on a shared screen, not describe it.
Statistics questions concentrate on a short list: mean vs median in skewed data, correlation vs causation, p-values explained to a non-technical manager, and when an average misleads. A classic: "Average salary in a team rose but every individual's salary fell - how?" (A compositional shift: a senior person left and juniors joined at the top of their band.)
Case study and guesstimate questions
Case rounds test structure, not arithmetic. Typical prompts: "Zomato orders fell 15% in a city - investigate," or "Estimate the number of Ola rides in Mumbai on a weekday." Interviewers grade whether you break the problem into drivers (supply, demand, external events), state assumptions out loud, and sanity-check your own numbers. A wrong answer with a clean structure scores better than a right number arrived at silently.
HR round questions
The HR round is short but ends candidacies. Expect: "Why data analytics and not software development?", "Are you comfortable with shift timings or relocation?", and the salary question. Have a researched range ready rather than a number from a friend's offer. Our guide to HR interview questions covers the standard set with answer frameworks.
Mistakes that cost freshers the offer
Three patterns come up repeatedly in interviewer feedback. The first is jumping into a case or SQL problem without clarifying the data - asking "are there duplicates?" or "what counts as an active customer?" takes ten seconds and immediately separates you from the majority who guess. The second is claiming tools you cannot demo. Listing "advanced Python" and then struggling to groupby on a shared screen ends the loop on the spot; it is far safer to list what you can actually do live. The third is treating the HR round as a formality. "I am open to anything" on location, shift or salary reads as unprepared, and mismatched expectations discovered after an offer waste everyone's time. Decide your real constraints before the interview, not during it.
How to prepare in the two weeks before
Prioritise in this order: daily SQL practice on real questions, one timed case study every two days, and a review of every project on your own resume - you will be asked to defend each one. If you are earlier in the journey and still building toward your first role, our step-by-step guide on how to become a data analyst covers the skills and portfolio order that gets freshers shortlisted.
Frequently asked questions
Are data analyst interviews hard for freshers?
The questions themselves are not advanced - basic SQL, Excel, statistics and one case. What makes loops hard is that most freshers have never written SQL against real data under time pressure. Two weeks of daily timed practice closes most of the gap.
Do I need Python to clear a data analyst interview?
Not always. Many service-company and BFSI roles test only SQL and Excel. Product companies and GCCs increasingly expect basic pandas. Check the job description: if Python is listed, assume a live exercise.
How many rounds does a data analyst interview have?
Typically three to four: an online or SQL screening round, a technical round, a case or managerial round, and HR. Bulk fresher hiring at service companies sometimes compresses this into one test plus one interview.
What salary should I quote as a fresher data analyst?
Fresher analyst offers in India commonly fall in the â¹3.5-6 LPA band depending on company type - service companies at the lower end, product companies and GCCs higher. Quote a range and anchor it to the specific company, since bands vary widely.
Sources
- Hiring round structures and question patterns reported by candidates on Glassdoor India and AmbitionBox interview reviews for TCS, Fractal, Mu Sigma and major GCCs (accessed October 2026).
- Company career pages for analyst role requirements (SQL/Excel/Python expectations).
- Fresher salary bands: publicly reported offer ranges on AmbitionBox and Glassdoor India (accessed October 2026).
