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 applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
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...
What people are saying about Deloitte
I applied via Referral and was interviewed in Aug 2024. There were 3 interview rounds.
Deloitte interview questions for popular designations
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
Get interview-ready with Top Deloitte Interview Questions
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 appeared for an interview in Aug 2024.
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
*What is an aptitude test?
An aptitude test is a standardized test designed to assess a person's ability, skill, or knowledge in a specific area.
*Types of aptitude tests:*
1. Verbal Ability: Tests reading comprehension, grammar, and vocabulary skills.
2. Quantitative Ability: Tests mathematical skills, problem-solving, and data analysis.
3. Logical Reasoning: Tests ability to reason, think critically, and solve problems.
4. Technical Skills: Tests knowledge of specific technical skills, such as programming or coding.
Case study:-
I. Introduction:
- Brief overview of the company/organization
- Background on on the industry/market
- Purpose of the case study
II. Problem Statement:
- Description of the problem or challenge faced by the company
- Key issues and constraints
III. Analysis:
- SWOT analysis (Strengths, Weaknesses, Opportunities, Threats)
- Market analysis (competitor, customer, market trends)
- Financial analysis (revenue, costs, profitability)
IV. Alternatives and Options:
- Potential solutions or strategies
- Evaluation of pros and cons
V. Recommendations:
- Proposed solution or course of action
- Justification and rationale
VI. Implementation:
- Action plan and timeline
- Resources and budget required
VII. Conclusion:
- Summary of key findings
- Lessons learned and takeaways
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 18k reviews
Rating in categories
Consultant
33.8k
salaries
| ₹6.4 L/yr - ₹23.3 L/yr |
Senior Consultant
21.4k
salaries
| ₹11 L/yr - ₹42 L/yr |
Analyst
14.5k
salaries
| ₹3.9 L/yr - ₹12.7 L/yr |
Assistant Manager
10.2k
salaries
| ₹7.8 L/yr - ₹24 L/yr |
Manager
7.2k
salaries
| ₹16 L/yr - ₹53 L/yr |
Accenture
PwC
Ernst & Young
Cognizant