Your free, offline-ready interview & exam prep companion for consulting and technology roles in India.
“Analyst” is a level, not one syllabus. Choose the closest track; you can switch anytime.
There is no single universal “Deloitte paper.” Deloitte India and Deloitte US-India Offices (USI) are distinct organizations, and the sequence changes by practice, role, campus, and hiring campaign. Use this as a preparation map—not a promised process.
Official Job-specific profile or campus placement route; recruiters and hiring managers review fit.
Observed Some fresher technology drives report aptitude, verbal/reasoning, CS MCQs, and coding. Other practices report business or domain assessments instead.
Projects and resume depth plus role fundamentals—coding/SQL/OOP for software, Excel/Python/statistics for data, accounting/controls for audit or risk, and platform depth for experienced hires.
Official guidance Case/scenario interviews assess clear thinking, assumptions, analysis, recommendations, and impact—not one memorized “right answer.”
Resume ownership, communication, leadership, teamwork, ambiguity, priorities, client judgment, and genuine STAR examples. This may be combined with another interview.
Some campaigns add a manager, Director/Partner, or HR round; others conclude after a combined interview. Offer and onboarding follow only after the actual process is complete.
Frequently reported: timed aptitude/verbal/reasoning + CS/technical MCQs + two coding problems, then a technical or combined interview; a separate manager/HR round appears in some—not all—drives.
Prioritize: arrays/strings, SQL, OOP, DBMS/OS/network basics, projects, and behavioral scenarios.
Some campus tracks report an assessment, business discussion or GD, then senior interviews focused on projects, data/GenAI, commercial thinking, and scenarios rather than a coding-heavy funnel.
Prioritize: structured communication, business application, project ownership, cases, and senior-panel maturity.
Expect deeper probing of end-to-end delivery, design choices, troubleshooting, stakeholder workshops, testing, risk/quality, and measurable impact. Generic puzzle preparation has lower return.
Prioritize: turn every important JD bullet into one defensible project story.
Coding aloud, arrays/strings, OOP, DBMS, OS, networks, SQL, project architecture, tests, and edge cases.
SQL, Excel, Python/pandas, statistics, model evaluation, cleaning, dashboards, and business interpretation.
Clarify, structure, analyse, synthesise, recommend, and state risks and next steps; add commercial awareness.
Risk-control mapping, security basics, named platforms, implementation lifecycle, troubleshooting, and documentation.
Role-relevant accounting and audit fundamentals, evidence, controls, ethics, scenarios, and communication.
Structure behavioral answers using Situation-Task-Action-Result.
Revenue (Price × Volume) vs Costs (Fixed + Variable). Segment by product/region/channel.
Market size → Growth → Competition → Customer segments → Capabilities → Entry mode → Financials.
Top-down (TAM→SAM→SOM) or Bottom-up (units × price). State assumptions explicitly.
Cost-plus, value-based, competitive benchmarking. Consider elasticity and willingness-to-pay.
Strategic rationale → Standalone value → Synergies → Risks → Valuation → Integration.
Bottleneck analysis, capacity planning, lean/six-sigma principles, automation ROI.
Write solutions below. Code runs locally in a disposable worker with a two-second limit; output appears in the console area. Do not paste untrusted code.
Draft a query, then compare it with a reference solution. SQL dialects vary; no query is sent anywhere.
| Topic | Formula |
|---|---|
| Speed-Distance-Time | S = D/T; Relative speed (same dir) = |s1-s2| |
| Work | Combined rate = 1/A + 1/B; Time = 1/(combined rate) |
| Percentage | %change = (diff/original)×100 |
| Profit/Loss | Profit% = (SP-CP)/CP × 100 |
| SI/CI | SI=PRT/100; CI=P(1+R/100)^T - P |
| Probability | P(A∪B)=P(A)+P(B)-P(A∩B) |
| Permutation | nPr = n!/(n-r)! |
| Combination | nCr = n!/[r!(n-r)!] |
| Clause | Use |
|---|---|
| WHERE | Filter rows before grouping |
| HAVING | Filter groups after GROUP BY |
| PARTITION BY | Window function grouping |
| COALESCE | First non-null value |
Important: Aptivra is an independent, free educational resource. It is NOT affiliated with Deloitte, any Big-4 firm, or any recruitment agency. No proprietary or confidential material is used.
Recruitment processes change frequently and can differ by business unit, campus, geography, role, and candidate. Aptivra does not claim that any roadmap or test format is current or universal. Verify the role description and official candidate communication on the day you apply.
Official sources define guidance and organizational context. Observed sources are individual candidate reports—useful for patterns, never guarantees.
Questions are representative of common patterns but are original compositions. No actual proprietary test questions are reproduced. Difficulty levels and topic coverage are approximations. Always verify with official sources.