i
Deloitte
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
I was interviewed before Mar 2024.
MCQs were asked for screening
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
What people are saying about Deloitte
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Architecting a data pipeline involves designing a system to collect, process, and analyze data efficiently.
Identify data sources and determine how to extract data from them
Design a data processing workflow to clean, transform, and enrich the data
Choose appropriate tools and technologies for data storage and processing
Implement monitoring and error handling mechanisms to ensure data quality and reliability
Consider scala...
Deloitte interview questions for popular designations
I applied via Referral and was interviewed in Aug 2024. There were 3 interview rounds.
Get interview-ready with Top Deloitte Interview Questions
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
I applied via Campus Placement and was interviewed in Sep 2024. There were 3 interview rounds.
Many questions on SQL and python programing and some questions on general aptitude
A subquery in SQL is a query nested within another query to retrieve data from multiple tables.
Subqueries can be used in SELECT, INSERT, UPDATE, and DELETE statements.
They can be correlated or non-correlated.
Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
Aptitude/ English & Coding test
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);
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
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
I was interviewed in Aug 2024.
Some of the top questions asked at the Deloitte interview -
The duration of Deloitte interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 2.1k interviews
Interview experience
based on 17.8k reviews
Rating in categories
Hyderabad / Secunderabad,
Bangalore / Bengaluru
6-11 Yrs
₹ 16-48 LPA
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