Add office photos
i
Deloitte
CompareProud 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 of a number Write a program to generate the reverse of a given number N. Print the corresponding reverse number. Note : If a number has trailing zeros, then its r ...read more
- Q2. Idempotent Matrix Given a N * N matrix and the task is to check matrix is idempotent matrix or not. See the sample input. Idempotent matrix M follows the following proper ...read more
- Q3. Technical Questions OOPS concepts. What is SQL and NO SQL database? What is difference between Stored procedures and functions?
Deloitte Analyst Interview Experiences
352 interviews found
Anonymous
Interview Questionnaire
11 Questions
- Q1. How was your day?
- Ans.
It was a busy day filled with meetings and deadlines.
Had multiple meetings with clients and colleagues
Worked on completing a project before the deadline
Managed to finish all tasks on time
- Q2. Tell me about yourself?
- Ans.
I am a highly motivated individual with a passion for learning and a strong work ethic.
I have a degree in computer science and have worked in the tech industry for 5 years.
I am proficient in programming languages such as Java, Python, and C++.
I am a team player and enjoy collaborating with others to solve complex problems.
In my free time, I enjoy hiking and playing basketball.
- Q3. Saw my resume and asked about the competitions i took part in and what i did in that
- Q4. Which language m comfortable in ( I said all three java c c++) So he asked if hes a customer and wants a library app which lang will i suggest him?
- Q5. How to find Largest element in the array wid most efficiency?
- Ans.
Use a loop to iterate through the array and keep track of the largest element.
Initialize a variable to store the largest element as the first element of the array
Loop through the array and compare each element to the current largest element
If the current element is larger, update the largest element variable
Return the largest element variable
- Q6. You know Normalizastion? Tell me what is 3rd normal form
- Ans.
3rd normal form is a database normalization technique where every non-key attribute is dependent on the primary key.
In 3NF, there should be no transitive dependencies between non-key attributes.
It reduces data redundancy and improves data integrity.
Example: A table with columns for customer ID, order ID, and product ID. The product name should not be stored in this table as it is dependent on the product ID, not the cu...
- Q7. Which subject do you like?
- Ans.
I enjoy studying psychology.
Fascinated by the workings of the human mind
Enjoy learning about different theories and approaches
Find it applicable to everyday life and relationships
- Q8. Are you comfortable with networking?
- Ans.
Yes, I am comfortable with networking.
I have experience in setting up and maintaining networks.
I am familiar with different network protocols and technologies.
I have troubleshooted network issues and resolved them.
I have worked with both wired and wireless networks.
I am comfortable with configuring routers, switches, and firewalls.
- Q9. On resume- difference between html5 and its previous version?
- Ans.
HTML5 is the latest version of HTML with new features and improvements.
HTML5 has new semantic tags like
, HTML5 supports audio and video elements without the need for plugins.
HTML5 has improved form elements like date pickers, range sliders, etc.
HTML5 has improved canvas and SVG support for graphics.
HTML5 has improved accessibility features.
HTML5 has improved support for mobile devices.
Previous versions of HTML
- Q10. Why should we not hire you?
- Ans.
I cannot think of any reason why you should not hire me.
I have the necessary skills and experience for the job.
I am a quick learner and can adapt to new situations easily.
I am a team player and can work well with others.
I am passionate about the work and will give my best effort.
I am reliable and can be counted on to meet deadlines.
I am open to feedback and willing to improve.
I have a positive attitude and can bring en
- Q11. Are you comfortable with relocation?
- Ans.
Yes, I am comfortable with relocation.
I have relocated for work in the past and have found it to be a positive experience.
I am open to exploring new places and cultures.
I understand that relocation may be necessary for career growth and development.
Interview Preparation Tips
Experience: 1st Round was the online aptitude test with 3 sections Quant Verbal Logic
Tips: Make sure u r good at aptitude tests as most of us feel its easy and in the end not even qualify
Round: Group Discussion
Experience: After short listing 60-70 could make it to the 2nd round which was G.D in a group of 8 it was a case study on developing a system as a deloitte employee my advise for G.D is dont take a start if you are not comfortable but at the same time make sure u speak 3-4 times in between and that too with strong points, such that others listen to you and start adding on to your points. Then ur definately in.After the GD 3-4 people from each batch got shortlisted we were 33 students for PI Mostly all students had 1 round, both tech and HR included, few were called twice. I had only 1 round
Round: HR Interview
Tips: Answers to these Qs are easy and depend on your interests. make your resumes strong and knw what you have done, dont try to fool them. For eg in Q7 above i placed html on my resume but didnt knew the answer so i frankly told them nd still i ws selected. Not necessary you should answer everything. finally ask them Questions (Q11). In the end if its your day u will definately get the job, otherwise theres always sumthing better for you so dont get depressed, instead get motivated For the next company
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
- Ans.
I am comfortable in Java and can write code for sorting algorithms like Bubble Sort, Selection Sort, and Merge Sort.
I am proficient in Java and have experience writing code for sorting algorithms.
I can implement popular sorting algorithms like Bubble Sort, Selection Sort, and Merge Sort.
I have a strong understanding of algorithm complexity and efficiency.
I can provide examples of code for sorting algorithms upon reques
- Q2. What is oops
- Ans.
OOPs stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
OOPs focuses on creating objects that interact with each other to solve a problem
It involves concepts like inheritance, encapsulation, polymorphism, and abstraction
Examples of OOPs languages include Java, C++, and Python
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
- Ans.
I completed a summer internship at a financial firm where I analyzed market trends and created financial models.
Conducted market research to identify investment opportunities
Utilized Excel and financial software to create models for forecasting
Presented findings to senior analysts and managers
Collaborated with team members on various projects
- Q2. Guesstimate on Size of EV Market in India
- Ans.
The EV market in India is estimated to be around 2-3% of total vehicle sales currently.
EV sales in India have been steadily increasing due to government incentives and growing environmental awareness.
Major players in the Indian EV market include Tata Motors, Mahindra Electric, and Hero Electric.
Charging infrastructure is a key factor in the growth of the EV market in India.
The government has set a target of 30% EV pene...
- Q3. What are business processes
- Ans.
Business processes are a series of structured activities that organizations use to achieve specific goals.
Business processes involve a series of steps or tasks that are performed in a specific order.
They are designed to achieve a particular outcome or result.
Business processes can be automated or manual, depending on the organization's needs.
Examples include order processing, inventory management, and customer service.
...
(4 Questions)
- Q1. Internship Experience
- Ans.
I completed a 6-month internship at a financial consulting firm where I gained experience in financial analysis and market research.
Conducted financial analysis on various companies to assess their performance
Assisted in preparing client presentations and reports
Participated in meetings with clients to discuss investment strategies
Utilized financial modeling techniques to forecast future trends
Collaborated with team me
- Q2. Projects from Resume
- Q3. Guesstimate on Revenue of a Fast Food Restaurant
- Ans.
The revenue of a fast food restaurant can vary greatly depending on factors like location, menu offerings, and customer traffic.
Consider the average number of customers served per day
Look at the menu prices and estimate the average spend per customer
Factor in any special promotions or discounts that may impact revenue
Take into account the operating hours of the restaurant and peak times of business
Compare with industry
- Q4. What all parameters would you consider for a companies office location
- Ans.
Parameters for selecting a company's office location include accessibility, cost, amenities, proximity to clients/talent, and safety.
Accessibility to public transportation and major highways
Cost of real estate and office space in the area
Availability of amenities such as restaurants, gyms, and shopping
Proximity to clients, partners, and talent pool
Safety and security of the neighborhood
Potential for future growth and e
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.
- Ans.
IoT stands for Internet of Things, which refers to the network of physical devices connected to the internet, allowing them to collect and exchange data.
IoT involves connecting everyday objects to the internet to enable them to send and receive data.
Examples of IoT devices include smart thermostats, wearable fitness trackers, and connected home security systems.
IoT technology can be used in various industries such as h...
- Q4. Difference between normal sensor and smart sensor
- Ans.
Normal sensors collect raw data, while smart sensors process data and provide actionable insights.
Normal sensors collect raw data without any processing
Smart sensors have built-in processing capabilities to analyze data and provide actionable insights
Smart sensors can communicate with other devices or systems to trigger actions based on the data collected
Examples of smart sensors include smart thermostats, fitness trac
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
- Ans.
Partition in SQL is a way to divide a large table into smaller, more manageable parts.
Partitioning helps improve query performance by allowing operations to be performed on smaller subsets of data.
It can also help with data management, such as archiving old data or optimizing storage.
Common types of partitioning include range, list, hash, and composite partitioning.
Example: PARTITION BY RANGE (order_date);
- Q2. Basic python programming questions
(2 Questions)
- Q1. Why do you want to join Deloitte
- Ans.
I want to join Deloitte because of its reputation for providing top-notch consulting services and opportunities for professional growth.
Deloitte is known for its prestigious reputation in the consulting industry
I am impressed by the diverse range of projects and clients Deloitte works with
I believe Deloitte offers excellent opportunities for career development and growth
I am attracted to the collaborative and innovativ
- Q2. Where do you see yourselfr in 5 years
- Ans.
In 5 years, I see myself as a senior analyst leading a team and contributing to strategic decision-making.
Leading a team of analysts
Contributing to strategic decision-making
Continuing professional development and growth
Possibly pursuing advanced certifications or degrees
Skills evaluated in this interview
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
Prep Insta
(4 Questions)
- Q1. What is reindexing
- Ans.
Reindexing is the process of restructuring the index of a database table to improve performance.
Reindexing helps optimize database performance by organizing data more efficiently.
It involves rebuilding the index of a table to reduce fragmentation and improve query speed.
Reindexing is commonly done in databases like MySQL and PostgreSQL.
Example: ALTER INDEX index_name REBUILD;
- Q2. How do you drop columns and rows
- Ans.
To drop columns and rows in a dataset, you can use the drop() method in pandas library in Python.
Use the drop() method with the axis parameter set to 0 for dropping rows and 1 for dropping columns.
Specify the labels of the rows or columns you want to drop in the labels parameter.
Use the inplace parameter to make the changes in the original dataset.
Example: df.drop(labels=['column1', 'column2'], axis=1, inplace=True) wi...
- Q3. What is comprehension
- Ans.
Comprehension is the ability to understand and grasp information or concepts.
Comprehension involves understanding the meaning of something.
It requires interpreting and processing information.
Examples include reading a text and being able to summarize its main points or solving a complex problem by understanding its components.
- Q4. Write python code to find odd sum pairs in a list
- Ans.
Python code to find odd sum pairs in a list
Iterate through the list and check for pairs with odd sum
Use a nested loop to compare each pair of elements
Add the pairs with odd sum to a new list
Skills evaluated in this interview
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 Associate Analyst Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Business Technology Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Deloitte Analyst Interview Process
based on 170 interviews in last 1 year
3 Interview rounds
- Aptitude Test Round
- Technical Round
- HR Round
Top Skills for Deloitte Analyst
People are getting interviews through
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
32.8k
salaries
|  ₹6.2 L/yr - ₹23 L/yr |
|
Senior Consultant
20.9k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
13.9k
salaries
| ₹3.8 L/yr - ₹12.6 L/yr |
|
Assistant Manager
9.9k
salaries
| ₹7.6 L/yr - ₹24 L/yr |
|
Manager
7k
salaries
| ₹15.6 L/yr - ₹52 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
Calculate your in-hand salary
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Analyst Interview Questions
