Deloitte interview experience notes read differently from most other fresher company interviews. The technical bar is noticeably higher. SQL goes beyond DELETE vs TRUNCATE. Python questions go beyond list vs tuple. And puzzles and reasoning questions are more consistent here. After reviewing 27+ experiences from Deloitte Analyst Trainee roles, here’s what sets it apart.
Preparing for Deloitte or other fresher placements? Join our Telegram channel for daily job alerts and interview prep updates.
Job Summary
Deloitte interview experience — context matters
Deloitte recruits freshers primarily for their Analyst Trainee role at around Rs. 6 LPA — higher than most mass recruiters. The interview reflects this: they’re looking for sharper candidates. Total time is usually 30-45 minutes across both TR and HR rounds.
SQL — deeper than standard
Second-highest salary query. Write a query to find the second-highest salary from an employee table. Know both the subquery with MAX and the DENSE_RANK approach.
SQL vs MySQL. SQL is the language/standard; MySQL is a specific DBMS implementation. Know the difference.
DELETE vs DROP vs TRUNCATE. Including edge cases like “can you rollback after TRUNCATE?” Also: normalization forms (1NF, 2NF, 3NF), ACID properties, and transaction management.
Python — functional depth
Pickle module. What is pickling? What is unpickling? Real use case: saving trained ML models. This came up specifically in Deloitte experiences — not common elsewhere.
Lambda functions. What they are and when you’d use them over a regular function.
Programs. Armstrong number, Fibonacci, palindrome. Some interviewers asked for optimized versions.
OOPs and data structures
Deloitte asks OOPs with emphasis on real-world examples that make sense to non-technical people. Data structures included stack vs queue with real use-case examples, bubble sort traced through an example, and linked list operations.
Puzzle questions
Classic puzzles appeared: “You have 8 identical balls and one is heavier — how do you find the heavier one in two weighings?” Talk through your reasoning out loud rather than staying silent while you think.
HR at Deloitte
Why Deloitte, 5-year vision, and conflict resolution examples were consistent. Deloitte’s “why us?” expects you to know something specific about their consulting vs audit vs advisory divisions. “It’s a Big Four firm” is a starting point, not an answer.
📖 Want 27+ Real Deloitte Interview Experiences?
Get the complete PDF with actual SQL queries asked, Python questions, puzzle types, and what cleared candidates prepared.
Note: freshershunt.in compiles these interview experiences from student contributions. We are not affiliated with Deloitte.