How to Prepare for a Data Analyst Interview in India

🎯

Data analyst interviews in India typically have 3–4 rounds. Knowing what to expect and preparing specifically for each round dramatically increases your chances of getting the offer.

🎯 Use HireTrack's free AI Interview Prep tool to practice role-specific questions — available in your profile.

The Typical Interview Process

Resume screening — ATS + HR review
Technical round 1 — SQL and Excel test
Technical round 2 — Case study / business problem
HR round — Behavioural, culture fit, salary

SQL Interview Questions

SQL is the most tested skill. You'll need:

SELECT, WHERE, GROUP BY, HAVING, ORDER BY
JOINs — INNER, LEFT, RIGHT, FULL OUTER
Subqueries and CTEs
Window functions — ROW_NUMBER(), RANK(), LAG(), LEAD()
Aggregate functions and date manipulation

Common SQL question:

"Find the second highest salary from the employee table."

SELECT MAX(salary) FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);

Case Study Framework

Clarify — Ask 2–3 questions before diving in
Structure — State your approach first
Analyse — Walk through thinking out loud
Conclude — Give a clear, data-backed recommendation

10 Common Interview Questions

Question	What They Test
Difference between UNION and UNION ALL?	SQL knowledge
How do you handle missing values?	Data cleaning approach
What is a KPI? Give an example.	Business understanding
Walk me through a sudden drop in sales	Problem-solving framework
Why do you want to work here?	Motivation and research

Practice with AI Interview Prep

HireTrack's AI generates role-specific questions and gives instant feedback — free.

Get Started Free →