You've cleared the resume screen, and now a hiring manager at Swiggy or Zerodha wants to see if you can actually wrangle messy datasets and explain what they mean. The data analyst interview in India has split into two tracks: one that tests SQL and Excel competence for traditional analytics roles, and another that assumes you can write Python, work with cloud pipelines, and talk intelligently about how LLMs might automate parts of your own job.
What interviewers actually test
Expect three layers. First, the technical screen: SQL queries, usually live or on a shared screen. You'll be asked to pull cohort retention numbers, calculate month-over-month growth, or identify duplicate records in a mock orders table. If the company is Razorpay, Nykaa, or another product-led firm, add a take-home case study where you analyze a CSV, build a dashboard in Tableau or Power BI, and present insights in a deck.
Second, the business sense round. You'll get a vague prompt like "our checkout drop-off rate increased 8% last week, what would you investigate?" or "how would you measure the success of a new feature?" They want structured thinking, not just tool knowledge. Name your hypotheses, the data you'd need, and which stakeholder you'd talk to first.
Third, the AI and automation question. In 2026, this comes up more often than it did two years ago. Interviewers at Tata Digital, Accenture, and IBM India now ask how you'd use ChatGPT or Copilot in your workflow, or whether you've experimented with natural language querying tools. The right answer is honest and specific, not defensive.
Sample questions and how to answer them
"Write a SQL query to find the top 5 products by revenue in the last quarter."
Straightforward, but watch for tricks: do they want gross or net revenue? Do returns count? Clarify before you write. Use SUM(), GROUP BY, ORDER BY, and LIMIT. Comment your code if the interface allows it.
"How would you handle missing values in a dataset?"
Don't just say "remove them." Explain that it depends on the pattern. If missingness is random and under 5%, you might drop rows. If it's systematic, like missing pin codes for cash-on-delivery orders, that's a signal worth investigating. Mention imputation only if you've actually done it.
"Explain a time you found an insight that changed a business decision."
Use the STAR method, but keep it tight. Mention the metric, the anomaly you spotted, the hypothesis you tested, and the outcome. If you're early in your career and lack corporate examples, use internship work or a personal project, but be upfront about the context.
"What's the difference between a left join and an inner join?"
If you stumble here, the interview is over. Practice joins until they're muscle memory.
"How do you decide which visualization to use?"
Bar charts for comparisons, line charts for trends, scatter plots for correlation. Avoid pie charts unless you have three or fewer categories. If you mention Gestalt principles or preattentive attributes, you'll stand out, but only if you can explain them plainly.
What the salary data says
Reported ranges for data analysts in India typically start at ₹4 to ₹7 lakh per annum for entry-level roles at service firms like Infosys, TCS, or Wipro. Product companies including Flipkart, Paytm, and Zomato often pay ₹8 to ₹14 LPA for candidates with one to three years of experience and demonstrated skill in Python or cloud tools. Senior analysts with domain expertise in fintech or e-commerce can see ₹18 to ₹25 LPA, especially in Bengaluru and Gurugram. Check live numbers at UnoJobs Salary Intelligence before you negotiate.
The AI variable
Generative AI hasn't replaced data analysts, but it has raised the bar. Teams are smaller, expectations higher. If you can show that you use AI tools to write boilerplate SQL, generate regex patterns, or draft stakeholder emails, you signal efficiency. If you pretend AI doesn't exist, you signal risk.
The analysts getting multiple offers in 2026 are the ones who treat interviews as a two-way audit: they ask about data infrastructure, cross-functional workflows, and how the team measures its own impact.
Ready to put this into practice? Browse live data analyst openings, filter by salary and skills, and see which companies are hiring right now at UnoJobs Data Analyst Roles.
Keep growing with UnoJobs
Want more career insights like this?
Explore hiring intelligence, interview playbooks, and job-ready guides from the UnoJobs editorial team.