AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Deloitte
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Deloitte Analyst Interview Questions, Process, and Tips
Top Deloitte Analyst Interview Questions and Answers
- Q1. Reverse a Number Problem Statement Given an integer 'N', write a program to generate the reverse of the number and print the resulting reversed number. The reversed numb ...read more
- Q2. Idempotent Matrix Verification Determine if a given N * N matrix is an idempotent matrix. A matrix is considered idempotent if it satisfies the following condition: M * ...read more
- Q3. Sql is installed on the server for enable which port needs to be open?
Deloitte Analyst Interview Experiences
352 interviews found
Anonymous
Interview Questionnaire
18 Questions
- Q1. A Telecommunication company starting a new scheme and they have approached Deloitte for consulting. How and what will we guide?
- Q2. Is JavaScript clientside or serverside?
- Ans.
JavaScript is both clientside and serverside.
JavaScript is primarily used for clientside scripting in web browsers.
However, it can also be used for serverside scripting with Node.js.
Clientside JavaScript is executed by the user's browser.
Serverside JavaScript is executed by the server.
JavaScript can be used for both front-end and back-end development.
- Q3. Explain your B.E.Project
- Q4. Difference between C and Java?
- Ans.
C is a low-level programming language while Java is a high-level programming language.
C is compiled while Java is interpreted
C has pointers while Java does not
C is closer to the hardware while Java is platform-independent
C is used for system programming while Java is used for web and mobile app development
- Q5. Are you okay with relocation?
- Q6. What are your weaknesses and how did you overcome it while coordinating in team projects?
- Ans.
My weakness is time management, but I improved by setting clear deadlines and prioritizing tasks.
Identified time management as a weakness
Started setting clear deadlines for tasks
Learned to prioritize tasks based on importance and urgency
Utilized tools like calendars and task lists to stay organized
Sought feedback from team members on time management improvements
- Q7. What do u mean by DNS?
- Ans.
DNS stands for Domain Name System, which is a system that translates domain names into IP addresses.
DNS is used to locate websites and other resources on the internet.
It works by translating human-readable domain names into machine-readable IP addresses.
DNS servers store information about domain names and their corresponding IP addresses.
Examples of DNS servers include Google DNS, OpenDNS, and Cloudflare DNS.
- Q8. What are the 7 layers in OSI model of Networking?
- Ans.
The OSI model has 7 layers that define how data is transmitted over a network.
The layers are: Physical, Data Link, Network, Transport, Session, Presentation, and Application.
Each layer has a specific function and communicates with the layers above and below it.
For example, the Physical layer deals with the physical transmission of data, while the Application layer deals with user interfaces and applications.
The OSI mod...
- Q9. Is it possible to convert bytecode in Java back to original code and how to do it?
- Ans.
Yes, it is possible to decompile bytecode in Java back to the original code.
Decompilation is the process of converting bytecode back to its original source code.
There are several tools available for decompiling Java bytecode, such as JD-GUI, FernFlower, and Procyon.
Decompiling bytecode can be useful for understanding how a program works, reverse engineering, or debugging.
However, the decompiled code may not be an exact...
- Q10. What is the use of JVM in Java?
- Ans.
JVM is the virtual machine that executes Java bytecode. It provides platform independence and memory management.
JVM stands for Java Virtual Machine
It interprets compiled Java code into machine language
JVM provides platform independence by executing bytecode on any platform
It manages memory allocation and garbage collection
Examples of JVM-based languages include Kotlin and Scala
- Q11. What’s the relation between pointers and Security?
- Ans.
Pointers are used in programming to manage memory and can be a potential security vulnerability if not handled properly.
Pointers allow direct access to memory locations, making it possible to manipulate data or execute arbitrary code.
Improper use of pointers can lead to buffer overflows, memory leaks, and other security vulnerabilities.
Pointers can be exploited by attackers to gain unauthorized access, execute maliciou...
- Q12. Explain the concept of inheritance in Java .What is its use?
- Ans.
Inheritance in Java allows a class to inherit properties and methods from another class, promoting code reuse.
Inheritance is achieved using the 'extends' keyword in Java.
The class that is being inherited from is called the superclass or parent class.
The class that inherits from the superclass is called the subclass or child class.
The subclass can access the public and protected members of the superclass.
Inheritance pro...
- Q13. What is Abstraction?
- Ans.
Abstraction is the process of simplifying complex systems by focusing on the essential details.
Abstraction involves hiding unnecessary details and exposing only the relevant information.
It allows us to create models or representations that capture the important aspects of a system.
Abstraction helps in managing complexity and improving understanding and communication.
For example, in programming, object-oriented abstract...
- Q14. You have to design a database for library. Which language will u prefer?
- Ans.
I would prefer using SQL for designing a database for a library.
SQL is a widely used language for managing relational databases.
It provides a structured and efficient way to store, retrieve, and manipulate data.
SQL allows for easy querying and joining of tables, which is essential for library operations.
It supports transactions and ensures data integrity.
SQL also offers various security features to protect sensitive li
- Q15. Tell us about Firewall?
- Ans.
A firewall is a network security system that monitors and controls incoming and outgoing network traffic.
Firewalls can be hardware or software-based
They can be configured to block or allow specific types of traffic
Firewalls can also be used to create virtual private networks (VPNs)
Examples of popular firewall software include Norton, McAfee, and Windows Firewall
- Q16. Why Deloitte?
- Q17. 1 Reason why we shouldn’t hire you?
- Q18. What is your biggest achievement since you joined engineering?
Interview Preparation Tips
Experience: Aptitude consisted of Quants, Logical and Verbal…All three were manageable..Around 68 people got shortlisted from 200.
Round: Case Study Interview
Experience: Here the quality as well as quantity of points mattered.. Our group consisted of 7 people..4 got shortlistedTotal around 30 got shortlisted.
Round: HR Interview
Experience: So it started with tell me about yourself?your academic achievements?Why computer engineering?Which projects did you do in these 4 years…(the main projects)
Round: Technical Interview
Experience: at the end 7 people got selected in Deloitte.
College Name: IIT MADRAS
Skills evaluated in this interview
I applied via campus placement at Thadomal Shahani Engineering College, Mumbai and was interviewed in Aug 2024. There were 3 interview rounds.
In the aptitude round there were various sections such as quants, verbal and technical questions based on networking and cloud platforms and some pseudo codes . No coding questions were asked .
It was structured group discussion with one panel member and a case study was provided to us .
(5 Questions)
- Q1. Tell me about yourself .
- Ans.
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.
I am proficient in using statistical software such as R and Python to analyze data and generate insights.
I have experience working with cross-functional teams to develop and implement data-driven strategie...
- Q2. Tell me about the projects that you have made .
- Ans.
I have worked on various projects including financial analysis, market research, and data visualization.
Developed financial models to analyze company performance
Conducted market research to identify growth opportunities
Created interactive dashboards for data visualization
Collaborated with cross-functional teams to implement project recommendations
- Q3. Puzzles questions
- Q4. Coding question
- Q5. Machine learning question
Interview Preparation Tips
- Data Structures
- quants
- logical aptitude
- technical aptitude
- Indiabix for aptitude
- past year questions
- past interview experiences
Selected
I applied via Campus Placement
Simple quat questions
(2 Questions)
- Q1. Which language you are comfortable in and write code for any sorting algorithm you know
- Q2. What is oops
What people are saying about Deloitte
Selected
I applied via campus placement at Veermata Jijabai Technological Institute (VJTI), Mumbai and was interviewed in Sep 2024. There were 3 interview rounds.
20 Mins GD on ESG Compliance
(3 Questions)
- Q1. Internship Experience
- Q2. Guesstimate on Size of EV Market in India
- Q3. What are business processes
(4 Questions)
- Q1. Internship Experience
- Q2. Projects from Resume
- Q3. Guesstimate on Revenue of a Fast Food Restaurant
- Q4. What all parameters would you consider for a companies office location
Interview Preparation Tips
Prepare for Guesstimates
Deloitte interview questions for designations
I applied via campus placement at Motilal Nehru Institute National Institute of Technology (NIT), Allahabad and was interviewed in Sep 2024. There were 2 interview rounds.
It cover the topics like computer networking , cloud computing ,testing
(5 Questions)
- Q1. Introduce yourself
- Ans.
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
Bachelor's degree in Statistics
Proficient in Excel, SQL, and data visualization tools
Experience in conducting market research and trend analysis
Strong analytical and critical thinking skills
Excellent communication and presentation abilities
- Q2. What is constraint
- Ans.
A constraint is a limitation or restriction that prevents something from being done or achieved.
Constraints can be physical, such as lack of resources or time constraints.
Constraints can also be imposed by rules, regulations, or limitations set by external factors.
Constraints can impact decision-making and problem-solving processes.
For example, a budget constraint may limit the amount of money available for a project.
A...
- Q3. Difference between null and blank
- Ans.
Null represents absence of a value, while blank represents an empty value or space.
Null is a specific value that indicates the absence of any data.
Blank typically refers to an empty value or space, such as an empty string or whitespace.
In programming, null is often used to represent a variable that has not been assigned a value, while blank may refer to a field that has not been filled in by a user.
Example: A database ...
- Q4. What is foreign key and primary key
- Ans.
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.
Primary key ensures uniqueness of each record in a table
Foreign key establishes a relationship between two tables
Example: In a 'students' table, 'student_id' can be a primary key, while in a 'courses' table, 'student_id' can be a foreign key linking to 'students' table
- Q5. Python vs pyspark
- Ans.
Python is a general-purpose programming language, while PySpark is a distributed computing framework built on top of Spark for big data processing.
Python is a versatile language used for various applications, including web development, data analysis, and automation.
PySpark is specifically designed for processing large datasets in parallel across a cluster of machines.
Python is easier to learn and more widely used, whil...
Interview Preparation Tips
Skills evaluated in this interview
Get interview-ready with Top Deloitte Interview Questions
Selected
I applied via Campus Placement
Included 2 coding questions and many mcqs. mainly sql and sorting
(4 Questions)
- Q1. Asked me about my project(arduino) and fine tuning them
- Q2. Asked me about my research intern which was in ML
- Q3. What it iot? explain.
- Q4. Difference between normal sensor and smart sensor
Analyst Jobs at Deloitte
Selected
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
Aptitude/ English & Coding test
(2 Questions)
- Q1. What is partition in SQL
- Q2. Basic python programming questions
(2 Questions)
- Q1. Why do you want to join Deloitte
- Q2. Where do you see yourselfr in 5 years
Aptitude ,technical mcq ,coding test
(1 Question)
- Q1. Tell me about projects you done ,write code on dsa concepts
I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.
The online assessment consists of 67 questions divided into 4 sections with a sectional cutoff for each. The topics covered included Analytical Ability, Quantitatitive Ability, Verble Ability and CS fundamentals focusing on key areas like OS, DBMS, SQL, Cloud and Pseudocodes. It also consist two coding questions.
(4 Questions)
- Q1. The technical segment focused on my resume and projects, with an emphasis on Data Structures, Algorithms, OOPS, DBMS and other courseworks.
- Q2. Coding question include problem to reverse a string, while SQL questions involved crafting a query to perform a left join between two tables.
- Q3. Verbal SQL tpoics - Explains joins, group by and aggregate functions.
- Q4. Behavioral Questions: Assessing teamwork, communication and problem-solving.
Interview Preparation Tips
(4 Questions)
- Q1. What is reindexing
- Q2. How do you drop columns and rows
- Q3. What is comprehension
- Q4. Write python code to find odd sum pairs in a list
poorvi gupta
(2 Questions)
- Q1. Flexible search Queries were asked
- Q2. Solr related question on indexes, sort etc
Deloitte Interview FAQs
The duration of Deloitte Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Deloitte Interviews By Designations
- Deloitte Consultant Interview Questions
- Deloitte Analyst Interview Questions
- Deloitte Senior Consultant Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Associate Analyst Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Deloitte Analyst Interview Process
based on 273 interviews
6 Interview rounds
- Aptitude Test Round
- Technical Round
- HR Round - 1
- HR Round - 2
- Personal Interview1 Round - 1
- Personal Interview1 Round - 2
Top Skills for Deloitte Analyst
Analyst Interview Questions from Similar Companies
Fast track your campus placements
Deloitte Analyst Reviews and Ratings
based on 1.4k reviews
Rating in categories
|
Consultant
33.4k
salaries
|  ₹6.3 L/yr - ₹23.2 L/yr |
|
Senior Consultant
21k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
14.3k
salaries
| ₹3.9 L/yr - ₹12.6 L/yr |
|
Assistant Manager
10.1k
salaries
| ₹7.8 L/yr - ₹24 L/yr |
|
Manager
7.1k
salaries
| ₹16 L/yr - ₹52 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Analyst Interview Questions
