Deloitte Interview Experience for Analyst (On-Campus) (2022-23)
Interview Experience
Deloitte came to our campus for an analyst profile and the following was the recruitment process:Online Test: Computer-Based Online Recruitment Test (AMCAT): Topics of the...
Full Details
Deloitte came to our campus for an analyst profile and the following was the recruitment process: Online Test: Computer-Based Online Recruitment Test (AMCAT): Topics of the test were: • Analytical ability • Quantitative ability • Verbal ability • Computer science fundamentals (OS, DBMS, Cloud computing, SQL, Psuedocodes)
Note: Questions were of intermediate level. If you have the basics clear you can clear the round easily. Out of 160 students, 44 were promoted to the interview round. Interview: There were two interview rounds: First round (Kind of HR round): Questions asked were: • Where are you from? • What do you like about your current place the most compared to your native city? • Why do you want to make a career in this field (since I had a Mechanical Engineering background) • What would you do if you get stuck on some problem? • Asked one code to write(any code) and asked to go through it and explain. • Asked a few questions about the project I mentioned in the resume. Second round (Technical Round): The questions were completely from the skills mentioned in the Job description for the profile. • Explain the OOPS concept • Write pseudocode for multiple inheritances • Is multiple inheritances possible in python? If possible How to do it? • Explain Polymorphism in detail. • Explain the difference between method overloading and method overriding. • Why most of the firms are switching to cloud platforms (mention advantages)? • Asked a few SQL queries to write. • What are the different types of joins in SQL explain them with some examples. • Difference between c and c++ • Difference between python and c++ • How to connect python with the database? • What are the objects used for the database connection.
Verdict Out of 44 students 7 were selected. I was one of them.
About This Question
This is a candidate experience report from a deloitte interview for a data science role during the oa round reported in 2024.
It covers the following topics: Sql .
Topics
More Deloitte Interview Questions
About Deloitte Interview Reports
This question was reported by a candidate who interviewed at Deloitte. LeakCode aggregates interview reports from 10+ sources, including 1Point3Acres, Glassdoor, LeetCode Discuss, Blind, Reddit, Indeed, and Nowcoder. Each report is translated where necessary, deduplicated against existing entries, and tagged by company, role, round type, and reporting date.
Use this question as one calibration data point, not a memorization target. Companies typically rotate their question pools every 2-4 months; the exact wording of a 2024 question may differ from what you encounter today. The underlying pattern, difficulty level, and follow-up depth at Deloitte are the higher-signal extractions to take from this report.
For broader preparation context, the Deloitte interview process typically includes a recruiter screen, one or two technical phone screens, and a 4-5 round on-site loop covering coding, system design (at L4+ levels), and behavioral. Reports tagged on LeakCode show the round-by-round distribution and typical difficulty calibration. To browse questions filtered by round type and seniority, use the company hub linked above.
How To Practice This Type of Question
Solve similar problems on LeetCode under timed conditions (25-35 minutes per medium difficulty). The goal is pattern recognition: recognize the underlying technique (sliding window, two-pointer, BFS, memoized recursion, etc.) within 60-90 seconds of reading. Strong candidates verbalize their hypothesis out loud before coding, then iterate based on feedback. Weak candidates dive into implementation immediately, lose time on the wrong approach, and run out of time for follow-ups.
Companies update their question pools every 2-4 months. The exact wording of any given question may have been retired by the time you interview. Focus your prep on the pattern, not the specific problem. The patterns that appear in Deloitte reports consistently are the ones worth investing in; one-off niche problems are not.
During Your Deloitte Round
Apply the standard interview round template: clarify requirements (2-3 minutes), state your approach out loud and confirm direction with the interviewer (3-5 minutes), code with narration (15-25 minutes), test with concrete examples including edge cases (5 minutes), discuss optimization or trade-offs if time permits (5 minutes). This template is universally accepted across FAANG and adjacent companies; deviating from it produces weaker interviewer feedback signal.
The single most predictive failure mode in Deloitte reports tagged "no hire": not asking clarifying questions. Interviewers are explicitly trained to weight this. Strong candidates ask 3-5 clarifying questions even on problems that look obvious; weak candidates dive into code immediately. The clarifying-question check is often the first signal recorded in the interviewer's written notes.