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
353 interviews found
Anonymous
Selected
I applied via Campus Placement and was interviewed before Nov 2023. There were 2 interview rounds.
Aptitude with PSA and one on one interview
(2 Questions)
- Q1. Sql codes for table joins
- Ans.
SQL codes for table joins
Use JOIN keyword to combine rows from two or more tables based on a related column between them
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. Power BI codes for sql
- Ans.
Power BI can connect to SQL databases using SQL queries in the Power Query Editor.
Power BI can connect to SQL databases by importing data from SQL Server, Azure SQL Database, or other SQL sources.
In Power Query Editor, you can write SQL queries directly to retrieve data from SQL databases.
You can also use the 'Get Data' option in Power BI to connect to SQL databases and import data using SQL queries.
Skills evaluated in this interview
Harika Sunnam
(1 Question)
- Q1. About previous project
(2 Questions)
- Q1. Introduce yourself
- Ans.
I am a highly motivated and detail-oriented analyst with a strong background in data analysis and problem-solving.
Experienced in conducting thorough data analysis to identify trends and insights
Skilled in creating reports and presentations to communicate findings to stakeholders
Proficient in using analytical tools such as Excel, SQL, and Tableau
- Q2. Grc and security
What people are saying about Deloitte
I applied via Campus Placement
(2 Questions)
- Q1. Prepare guesstimates
- Q2. Prepare puzzles
Deloitte interview questions for designations
Selected
I applied via Approached by Company and was interviewed in Oct 2023. There were 2 interview rounds.
(1 Question)
- Q1. Discussion about technical knowledge
(1 Question)
- Q1. General discussion about experience
Get interview-ready with Top Deloitte Interview Questions
Selected
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There were 2 interview rounds.
Basic MCQ's of mathematics
(1 Question)
- Q1. Basic questions related to domain knowledge
Analyst Jobs at Deloitte
Selected
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
Numerical test and logical reasoning questions
Basic case study for an automobile company looking to expand
Selected
I applied via Walk-in and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Explain different ML algorithms
- Ans.
ML algorithms are techniques used to train models to make predictions or decisions based on data.
Supervised learning algorithms: Decision trees, Random forests, Support Vector Machines
Unsupervised learning algorithms: K-means clustering, Hierarchical clustering, Principal Component Analysis
Reinforcement learning algorithms: Q-learning, Deep Q-networks
Neural networks: Convolutional Neural Networks (CNN), Recurrent Neura...
- Q2. Tell us about one tough situation you faced and how to handled it
Interview Preparation Tips
Skills evaluated in this interview
Stay calm and composed. Just like any other oa.
Teams of 10 will be created. Need to perform well to clear.
(2 Questions)
- Q1. What is your Family Background
- Q2. What is 5 year plan
- Ans.
A 5 year plan is a strategic roadmap outlining goals and objectives to be achieved over the next five years.
Identify long-term goals and objectives
Break down goals into smaller, actionable steps
Allocate resources and set timelines for each goal
Regularly review and adjust the plan as needed
Interview Preparation Tips
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 274 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
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Consultant
21k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Analyst
14.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
10.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Manager
7.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Analyst Interview Questions
