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 Interview Questions, Process, and Tips
Top Deloitte Interview Questions and Answers
- Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
- Q2. What is the journal entry for prepaid expenses and how do you treat it?
- Q3. Scenario : 2 Talend jobs related to each other. If one fails somehow,the other shouldn't. How to do that?
Deloitte Interview Experiences
173 interviews found
Sowmya Pundla
Selected
I applied via Naukri.com and was interviewed before Feb 2023. There was 1 interview round.
Anonymous
I applied via Approached by Company and was interviewed in Aug 2021. There were 2 interview rounds.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before Jan 2023. There were 2 interview rounds.
What people are saying about Deloitte
I applied via Naukri.com and was interviewed in Aug 2021. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Informatica lookup transformation, difference between static and dynamic lookup.
- Ans.
Static and dynamic lookup in Informatica
Static lookup caches the lookup table data at the beginning of the session while dynamic lookup caches data as required during the session
Static lookup is faster but consumes more memory while dynamic lookup is slower but consumes less memory
Static lookup is used when the lookup table is small and doesn't change frequently while dynamic lookup is used when the lookup table is lar
- Q2. How to write file name into a flat file?
- Ans.
To write file name into a flat file, use file handling functions in programming languages.
Open the flat file in write mode
Use file handling functions to write the file name into the flat file
Close the flat file
- Q3. Basic SQL questions like rank and dense rank
Interview Preparation Tips
Round 1(MCQ):
1.Practice SQL gate questions from Geeks for Geeks will help.
2.Be prepared for questions on the ETL tool of your choice.
Round 2(Face to Face):
1.Again there were questions on SQL and Informatica.
Round 3(Discussion with senior leadership):
This round is to check if you are the right fit for the role.Confidence is the key to clearing this round.
Disclaimer:Just writing about my experience ,not sure if this is the standard interview pattern.
Skills evaluated in this interview
Deloitte interview questions for designations
Sam David Lazarus
Selected
I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.
Get interview-ready with Top Deloitte Interview Questions
Shivani Jaiswal
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.
Consultant Jobs at Deloitte
Interview Questionnaire
2 Questions
- Q1. Do you like to work in a team or alone?
- Ans. It depends on situations. If any discussion and conclusion is required then in team simultaneously if focused work require alone.
- Q2. How Profit and Loss account, Balance Sheet and Cash flow statement are different from each other? Usage of theses.
- Ans.
Profit and Loss account, Balance Sheet, and Cash flow statement are different financial statements used for different purposes.
Profit and Loss account shows the company's revenues, expenses, and net profit or loss over a specific period.
Balance Sheet provides a snapshot of a company's financial position at a specific point in time, showing its assets, liabilities, and shareholders' equity.
Cash flow statement tracks the...
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2021. There were 2 interview rounds.
Interview Preparation Tips
I got most of the question from complex SQL queries
SQL and T-SQL - 60% Question
ADF, ADB - 25%
Python - 10%
Others - 5%
A very common question I faced in almost all interview is what is my project, responsibilities and day-to-day work in current company.
Generally I don't face question from topics which are not mentioned in CV.
In Deloitte, first round was 100% technical round
2nd was a techno managerial round
3rd was HR discussion
After getting offer, i had interview with client.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before May 2022. There were 3 interview rounds.
Interview Preparation Tips
Deloitte Interview FAQs
Some of the top questions asked at the Deloitte Consultant interview for experienced candidates -
The duration of Deloitte Consultant 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
- Associate Consultant Interview Questions
- Senior Consultant Interview Questions
- Lead Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Technical Consultant Interview Questions
- SAP Abap Consultant Interview Questions
- AST Consultant Interview Questions
- SAP Fico Consultant Interview Questions
- Show more
Deloitte Interview Process
based on 86 interviews
5 Interview rounds
- Technical Round - 1
- Technical Round - 2
- Personal Interview1 Round - 1
- Personal Interview1 Round - 2
- Personal Interview1 Round - 3
Top Skills for Deloitte Consultant
Consultant Interview Questions from Similar Companies
Fast track your campus placements
Deloitte Consultant Reviews and Ratings
based on 2.7k reviews
Rating in categories
|
Consultant
33.5k
salaries
|  ₹6.3 L/yr - ₹23.4 L/yr |
|
Senior Consultant
21.2k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
14.4k
salaries
| ₹3.8 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 - ₹53 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Consultant Interview Questions for Experienced
