Deloitte interview questions and answers
Last updated 2026-11-19
Deloitte hires technology freshers in India mainly through its National Level Assessment, followed by a panel interview. Because it is a professional-services firm, the panel looks for two things at once: enough technical grounding to work on client projects, and the communication and judgement expected in a consulting environment.
This page covers technical and HR questions in that spirit, with worked answers. For the test itself, use Deloitte coding round questions, and for the overall process see how to crack the Deloitte interview.
| Entry roles (reported) | Analyst Trainee, Associate Analyst, Engineering Analyst Trainee |
|---|---|
| Stages | Online assessment, then panel interview |
| Panel focus | Technical knowledge, interest in technology, fit with values |
Rounds as commonly reported
Third-party guides describe the NLA as a monitored, adaptive online test of about 90 minutes with 67 questions: 65 multiple-choice questions and 2 coding questions, spread over five sections that include aptitude, English, technical MCQs and coding, with no negative marking. Those figures come from guides to the 2025 cycle and can change, so confirm them on the portal.
The panel interview that follows is described as covering your technical knowledge, your interest in technology and your fit with the firm's values. In practice that means a resume walkthrough, a few fundamentals questions (SQL, OOP, cloud, networking) and behavioural questions about teamwork and learning.
What consulting panels listen for
- A structured answer: start with the point, then the reasoning, then an example.
- Willingness to say what you do not know and how you would find out.
- Interest in what clients need, not only in code.
- Concrete examples of teamwork under a deadline from college or internships.
Hiring status
There is a dedicated page for current news at Deloitte hiring. The sourced facts we hold are these. In April 2026 Deloitte South Asia COO Nitin Kini said the firm plans to hire about 50,000 professionals in India, framed around AI and emerging-technology capability, with no fresher split or timeline given. Separately, the NLA registration window closed on 13 January 2025 and on 19 to 21 January 2026, so it has run in January in both years, but 2027 dates have not been announced.
Apply through Deloitte's own recruiting site, usrecruiting.deloitte.com, and confirm eligibility there. Eligibility criteria in third-party guides, such as 60% or 6.5 CGPA, are not official.
Deloitte interview questions and answers: questions with worked answers
1 What are IaaS, PaaS and SaaS? Give one example of each.
easyIaaS rents raw infrastructure (virtual machines, storage, networks), for example Amazon EC2 or Azure Virtual Machines; you manage the operating system and above. PaaS provides a managed platform to run code without managing servers, for example Azure App Service or Google App Engine. SaaS delivers a finished application over the internet, for example Microsoft 365 or Salesforce. As you move from IaaS to SaaS you manage less and give up control. Clients choose based on how much customisation and responsibility they want.
2 Write a SQL query to get each department and the number of employees, including departments with none.
mediumUse a LEFT JOIN from departments to employees and COUNT a column from the employee side, which is NULL for empty departments, so the count is zero. COUNT(*) would wrongly report 1 for those rows. See the SQL joins guide for the pattern. The point of the question is whether you understand how outer joins and NULLs interact with aggregates.
sqlSELECT d.name, COUNT(e.id) AS headcount FROM Department d LEFT JOIN Employee e ON e.dept_id = d.id GROUP BY d.id, d.name;3 What is the difference between Agile and Waterfall?
easyWaterfall completes phases in sequence (requirements, design, build, test, release) and suits fixed, well-understood scope. Agile delivers in short iterations with continuous feedback, so requirements can change. Consulting projects often mix them: a fixed contract with iterative delivery inside it. Mention Scrum roles (product owner, scrum master, team), sprints and the daily stand-up if you have used them in a college project.
4 What is a REST API and what do the common HTTP methods do?
easyA REST API exposes resources at URLs and uses HTTP methods for actions: GET reads, POST creates, PUT replaces, PATCH partially updates and DELETE removes. It is stateless, so each request carries what the server needs, and responses use status codes such as 200, 201, 400, 401, 404 and 500. GET should be safe and idempotent; PUT and DELETE are idempotent, POST is not.
5 Explain the CIA triad in information security.
mediumConfidentiality means only authorised people can read data, achieved with encryption and access control. Integrity means data is not altered improperly, checked with hashes, digital signatures and permissions. Availability means systems are usable when needed, supported by redundancy, backups and protection against denial-of-service. Give an example such as a bank: encrypted records (confidentiality), tamper-evident logs (integrity), failover servers (availability). Cyber and risk practices are a large part of professional-services firms.
6 What is the difference between SQL and NoSQL databases, and when would you choose each?
mediumSQL databases store structured data in tables with a fixed schema, support joins and ACID transactions, and suit financial and transactional systems. NoSQL stores flexible models (documents, key-value, wide column, graph), scales horizontally easily and suits changing schemas or huge volumes. Choose SQL when relationships and consistency matter, NoSQL when flexibility and scale dominate. Many real systems use both.
7 What is ETL, and why does it matter for analytics projects?
mediumETL stands for extract, transform, load: pull data from source systems, clean and reshape it (types, duplicates, joins, business rules), and load it into a warehouse or lake for reporting. Poor transformation means every dashboard downstream is wrong. In modern pipelines the order is sometimes ELT, loading raw data first and transforming inside the warehouse. Data and analytics work is a major part of consulting technology.
8 What happens when you type a URL into a browser?
mediumThe browser checks its cache, resolves the domain to an IP through DNS, opens a TCP connection (and a TLS handshake for HTTPS), sends an HTTP request, the server processes it and returns a response with HTML, and the browser parses it, fetching CSS, scripts and images, and renders the page. Mention caching and CDNs if you want depth. It is a favourite because it tests networking, web and OS knowledge in one answer.
9 Explain primary key, foreign key and normalisation.
easyA primary key uniquely identifies each row and cannot be NULL. A foreign key is a column that references another table primary key, enforcing referential integrity. Normalisation organises data to reduce redundancy: first normal form needs atomic values, second removes partial dependencies on a composite key, third removes transitive dependencies. Over-normalising can make reads slower, so analytical stores often denormalise on purpose.
10 Why do you want to join Deloitte instead of a product company?
easyBe honest and specific: consulting work exposes you to several industries and client problems early, and teams rotate technologies, which suits someone who wants breadth. Tie it to something you have done, such as a project that needed requirements from a non-technical user. Do not criticise product companies, and avoid repeating the firm brand name as the only reason.
11 Describe a time you had to learn something new quickly to finish a task.
mediumUse the STAR structure: the situation and deadline, the task you owned, the specific steps you took to learn (documentation, a mentor, a small prototype), and the result with a number or outcome if possible. End with what you would do the same way next time. A believable small example beats a dramatic one, and see tell me about yourself for how to frame your background.
12 A client says their report numbers do not match another team report. How would you approach it?
hardClarify exactly which numbers differ and by how much, then trace each figure back to its source: definitions (net versus gross, date ranges, time zones), filters, data refresh times and joins that may duplicate rows. Reproduce both numbers with queries, find the first step where they diverge, and explain it to the client in plain language with a proposed single definition. This tests structured thinking more than technical trivia.
Frequently asked questions
Is the Deloitte interview technical?
For technology roles, yes, at fundamentals level: SQL, OOP, cloud and projects, alongside behavioural questions. The reported panel focus is technical knowledge, interest in technology and values fit.
When does Deloitte hold its National Level Assessment?
The registration window closed in mid to late January in 2025 and 2026, but 2027 dates are not announced. Check Deloitte's recruiting portal and the Deloitte hiring page.
Is there negative marking in the NLA?
Third-party guides to the 2025 cycle report no negative marking. Confirm on the instructions of your own test.
How many people will Deloitte hire in India?
Deloitte South Asia COO Nitin Kini said in April 2026 that the firm plans to hire about 50,000 professionals in India, without a fresher breakdown or timeline.
What should I wear and how should I behave in the panel?
Dress professionally, keep your camera and audio ready for a remote panel, and answer in structured, concise points.
Sources
Related guides
More in Company Interview Questions
- Deutsche Bank coding round questions with solutions
- Deutsche Bank interview questions with answers (technology graduates)
- Directi Coding Round Questions With Solutions
- Directi Interview Questions and Answers
- Dream11 Coding Round Questions with Solutions
- Dream11 Interview Questions and Answers
- DXC Technology coding round questions
- DXC Technology interview questions and answers
- EPAM Coding Round Questions
- EPAM Interview Questions with Answers
- EY coding round questions
- EY interview questions and answers