Deloitte India Data Analyst Interview Process — 2026 Guide
Based on real candidate experiences and interview reports shared on Glassdoor, LinkedIn, and community forums. Deloitte India hires data analysts across 4 analytics roles in India. Here is exactly what to expect — round by round — and how to prepare.
Deloitte India Data Analyst Interview Rounds
Round 1: Resume Screening
What they look for
Relevant SQL and analytics experience, portfolio projects, and clean formatting. Strong academic record is noted but not decisive. 1-page resume, quantified achievements, 3+ relevant projects.
Round 2: Online Assessment
What is tested
SQL queries (beginner to intermediate), logical reasoning, and sometimes a case study question. Duration: 45–90 minutes. HackerRank, Cocubes, or internal platforms are common.
Round 3: Technical Interview
Deep dive into
Advanced SQL (window functions, CTEs, query optimization), statistics (distributions, hypothesis testing, A/B testing basics), and a mini case study. Expect to write SQL live and explain your reasoning out loud.
Round 4: Managerial / HR Round
Focus areas
Behavioural questions (tell me about a time you found an insight that changed a decision), compensation discussion, culture fit assessment, and clarification of career goals. Prepare STAR-format answers for 5–6 typical scenarios.
What Deloitte India Actually Looks For
Beyond the job description — what consistently differentiates selected candidates:
Business case structuring
Deloitte India expects you to frame analytical questions as business problems. Start with the hypothesis, not the data.
Storytelling with data
The output of your analysis is a recommendation, not a table. Practice turning data findings into clear narratives with a single headline insight.
Domain-agnostic thinking
Consulting analysts work across industries. Show you can quickly learn a new domain and apply analytical frameworks to it.
Most Common SQL Questions at Deloitte India
Real-style questions from Consulting analytics interviews. Practice writing the SQL — not just reading the answers:
Q1: A retail client wants to know which store locations are underperforming. Write a query to compare each store's revenue against the average for its region.
Hint: Use AVG() OVER (PARTITION BY region) as a window function, then flag stores below average.
Q2: Calculate the revenue impact if the top 10% of churned customers had been retained.
Hint: Identify top decile by historical spend, calculate their avg spend, multiply by months remaining.
Q3: Write a query to identify customers at risk of churn (no purchase in last 60 days, but active in the 90 days before that).
Hint: Two date windows: no activity in recent 60 days + had activity in 60–150 days ago range.
Q4: Build a simple RFM (Recency, Frequency, Monetary) score for each customer.
Hint: Three separate calculations joined together: DATEDIFF for recency, COUNT for frequency, SUM for monetary. Great test of SQL composition.
Q5: A client's conversion rate dropped from 4.2% to 3.1% last month. Write a query to investigate by channel, device, and time of day.
Hint: Segment the conversion rate across each dimension. Use GROUP BY ROLLUP for multi-dimensional view.
Technical Skills Deloitte India Tests
How to Prepare in 2 Weeks
Structured day-by-day plan for the Deloitte India interview:
Days 1–2
- •SQL basics: SELECT, WHERE, GROUP BY, ORDER BY, HAVING
- •Practice 10 basic SQL problems on LeetCode or HackerRank
Days 3–4
- •SQL intermediate: JOINs (inner, left, right, full), subqueries
- •Practice join-heavy problems on real-world datasets
Days 5–7
- •SQL advanced: Window functions (ROW_NUMBER, RANK, LAG, LEAD), CTEs
- •Statistics basics: mean, median, standard deviation, distributions
Days 8–10
- •Case study practice: business problem → hypothesis → data approach → recommendation
- •Research Consulting key metrics and business model
Days 11–12
- •Mock interviews with SQL problems at target difficulty
- •Prepare STAR-format answers for behavioural questions
Days 13–14
- •Final polish: portfolio walkthrough, 5 smart questions to ask interviewer
- •Rest — do not cram the night before
Red Flags That Get Candidates Rejected
✗ Memorising answers without understanding
Interviewers ask follow-up questions to test depth. If you cannot explain why your SQL works, it shows immediately.
✗ Jumping to conclusions from data
Saying "the data shows X causes Y" without checking for confounds or data quality issues raises red flags for analytical rigor.
✗ No opinion on your own projects
Candidates who cannot say "if I redid this project, I would do X differently" appear to have not actually done the work themselves.
✗ Ignoring the business context
Giving technically correct but practically useless answers. Interviewers want analysts who ask "what decision does this need to support?"
5 Smart Questions to Ask in the Interview
These demonstrate analytical curiosity and seriousness — which is exactly what Deloitte India looks for:
- 1.How does the analytics team's work influence product or business decisions at Deloitte India?
- 2.What does the data infrastructure look like — what tools does the team use day-to-day?
- 3.What is the biggest analytical question you are trying to answer right now, and what makes it hard?
- 4.How does a new analyst typically ramp up — what does the first 3 months look like?
- 5.What separates a good analyst from a great one at this team specifically?
Interview Guides by Role at Deloitte India
Data Analyst
Data Analysts collect, process, and analyze structured data to generate act…
₹4-6 LPA – ₹15-25 LPA →
Data Scientist
Data Scientists build predictive models, perform statistical analysis, and …
₹6-10 LPA – ₹20-40 LPA →
Analytics Consultant
Analytics Consultants help organizations build data capabilities, design an…
₹6-10 LPA – ₹22-40 LPA →
Risk Analyst
Risk Analysts identify, measure, and mitigate financial and operational ris…
₹4-7 LPA – ₹15-25 LPA →
All Data Roles — Deloitte India Interview
Similar Companies Hiring in Consulting
Frequently Asked Questions
How many rounds does Deloitte India have for data analyst interviews?+
Deloitte India typically has 4 rounds: resume screening, online assessment, technical interview (SQL + case study), and HR/managerial round. Some roles add a take-home assignment between rounds 2 and 3.
What is the Deloitte India data analyst salary range?+
Deloitte India pays ₹9-22 LPA for data analytics roles. The lower end of this range is for fresher/entry-level roles, and the higher end for senior analytics roles with 4+ years of experience and specialised domain skills.
How difficult is the Deloitte India data analyst interview?+
Difficulty is moderate to high. SQL is consistently hard across all rounds. Case studies are the differentiator — practice business problem framing.
Does Deloitte India do a take-home assignment?+
Some Deloitte India analytics roles include a take-home data challenge — typically a business scenario with a dataset where you write SQL, do EDA in Python, and present findings. If you get one, the quality of your presentation and the insight quality matter as much as technical execution.
Want to crack the Deloitte India interview? Start with the right foundation.
The SQL depth, statistics knowledge, and case study thinking that Deloitte India tests — these are not things you can cram in a week. The SkillsetMaster course builds them systematically over 3–6 months, with real projects, live mentors, and a structured curriculum that matches what top analytics teams actually test.