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
5 Questions
- Q1. How can you troubleshoot Disk corrupt issue.
- Ans.
To troubleshoot disk corrupt issue, check disk errors, run chkdsk, repair disk, and recover data.
Check for disk errors using Event Viewer or Disk Utility
Run chkdsk command to scan and fix disk errors
Repair disk using disk repair tool or reinstalling OS
Recover data using data recovery software or professional services
- Q2. Sql is installed on the server for enable which port needs to be open?
- Ans.
Port 1433 needs to be open for SQL Server.
SQL Server uses port 1433 for communication.
Ensure that port 1433 is open in the server's firewall.
Check the SQL Server configuration to confirm the port number.
- Q3. If C drive is running out of space , what kind of troubleshooting you will do.
- Ans.
To troubleshoot a C drive running out of space, check for large files, uninstall unnecessary programs, clear temporary files, and consider expanding storage capacity.
Check for large files that can be deleted or moved to another drive
Uninstall unnecessary programs to free up space
Clear temporary files using disk cleanup tools
Consider expanding storage capacity by adding a new hard drive or using external storage
- Q4. If you have created the server , some website is not working . what will you do.
- Ans.
I would check the server logs and troubleshoot the issue.
Check if the website is properly configured on the server
Check if there are any errors in the server logs
Check if there are any issues with the website's code or database
Restart the server or relevant services if necessary
- Q5. Two VM's are running on differenct host how they are communicating.
- Ans.
VMs communicate through network protocols and virtual switches.
VMs use network protocols like TCP/IP to communicate.
Virtual switches connect VMs to the physical network.
Hosts can also use virtual network adapters to communicate with VMs.
Firewalls and security policies can restrict VM communication.
Examples of virtual switches include VMware vSwitch and Hyper-V Virtual Switch.
Interview Preparation Tips
I would like to share here my advice be confident while speaking share your full knowledge about that question, mostly hands on experience.
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
