Data analyst is the breakout role of the decade, with companies across every sector scrambling to build analytics functions that can translate raw data into business decisions. For Indian freshers, this role sits at the intersection of technical ability (SQL and Python) and communication (can you explain an insight to a non-technical stakeholder?). That dual requirement makes it both attractive and sometimes harder to crack than a pure software engineering role.
The data analyst interview pattern changes a lot by company type. At IT services companies (Mu Sigma, Fractal, Accenture Analytics), the process usually has a quantitative and logical reasoning test, a case study or presentation round where you are given a dataset and asked to present findings, and a technical round on SQL queries, basic Python (pandas, numpy), and descriptive statistics. At startups and consumer tech companies, the bar is higher. You may face a take-home assignment, a SQL coding test, or a Python data cleaning exercise under time pressure.
The single biggest differentiator for data analyst candidates is SQL skill. Most list SQL on their resume but cannot write a query that joins three tables, uses window functions, or handles NULLs correctly. If you can write confident SQL in an interview, including GROUP BY, HAVING, subqueries, and CTEs, you are already ahead of most of the applicant pool.
Most Data Analyst fresher drives in Indian campus placements move through a fixed sequence of stages. Knowing the order lets you prepare each stage in turn instead of cramming everything at once. The typical round flow is: Aptitude -> Case Study / Assignment -> Technical SQL + Python -> Communication Round.
Each stage shortlists candidates for the next. Treat the early stages as filters to clear cleanly, then invest your deepest preparation in the technical and role specific rounds where offers are actually decided.
Interviewers for Data Analyst roles look for a consistent core of skills. Use this checklist to audit where you are strong and where you need more practice before the drive.
We are verifying more Data Analyst questions from recent drives and add them as students report them. In the meantime, use the round pattern and skills checklist above to structure your preparation, and browse company specific question sets for the recruiters you are targeting.
Preparation for a Data Analyst role works best when it mirrors the round pattern above. Work through these steps in order rather than trying to cover everything at once.
At a minimum: pandas for data manipulation (read CSV, filter, group by, merge), basic matplotlib/seaborn for charts, and the ability to write a clean for loop and conditional logic. You do not need machine learning or deep learning for a pure analyst role.
This is a personal decision, not an objective ranking. Data analysts who build strong SQL + Python skills and learn to work closely with business stakeholders can grow into senior analyst, analytics manager, or data science roles. Software engineers typically have a higher starting CTC. Both paths are valid.
Common types are: "here is a dataset, describe what you see", "a metric dropped this week, diagnose why", and "design a dashboard for a sales team". Practise thinking out loud. Interviewers care as much about your reasoning as your final answer.
Reading questions is not the same as answering them under pressure. Start a free AI mock interview tuned to the Data Analyst round you are preparing for and get a scored verdict on every answer. No credit card required.