Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Deloitte Team. If you also belong to the team, you can get access from here

Deloitte Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Deloitte Interview Questions, Process, and Tips

Updated 9 Mar 2025

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?
View all 86 questions

Deloitte Interview Experiences

173 interviews found

Consultant Interview Questions & Answers

user image Anonymous

posted on 5 Feb 2022

I applied via Company Website and was interviewed in Aug 2021. There were 4 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Do practice case studies and guesstimates

I applied via Naukri.com and was interviewed before May 2021. There were 2 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Last 2 rounds are manger and hr round which is non tech

Consultant Interview Questions Asked at Other Companies for undefined

asked in Deloitte
Q1. How would you pass an entry for travel expenses incurred and paid ... read more
Q2. If a policy is billed monthly and is an annual policy and due to ... read more
asked in Infosys
Q3. How Data Flow in SCOM monitoring Tool? DB name for SCOM and DB qu ... read more
asked in Deloitte
Q4. What is the journal entry for prepaid expenses and how do you tre ... read more
asked in Deloitte
Q5. Scenario : 2 Talend jobs related to each other. If one fails some ... read more

Consultant Interview Questions & Answers

user image Anonymous

posted on 20 Apr 2021

I applied via Recruitment Consultant and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

5 Questions

  • Q1. How to create dynamic tgt files dept wise
  • Ans. 

    Dynamic tgt files can be created dept wise using scripting languages and database queries.

    • Identify the data fields required for the tgt files

    • Create a database query to extract the required data for each department

    • Use a scripting language like Python or Perl to automate the process of creating the tgt files

    • Ensure that the script is dynamic and can handle changes in the data or department structure

    • Test the script thoroug...

  • Answered by AI
  • Q2. How to run second session after completion of first session
  • Ans. 

    To run a second session after completion of the first session, follow these steps:

    • Ensure that all necessary resources are available for the second session

    • Communicate with participants to confirm their availability for the second session

    • Review the outcomes of the first session and adjust the agenda for the second session accordingly

    • Schedule the second session at a convenient time and location

    • Send out reminders to partic

  • Answered by AI
  • Q3. How to call a stored procedure without using stored procedure
  • Ans. 

    It is not possible to call a stored procedure without using a stored procedure.

    • Stored procedures are designed to be called from within a database.

    • Attempting to call a stored procedure without using a stored procedure would defeat the purpose of having a stored procedure.

    • If you need to execute a set of SQL statements without using a stored procedure, you can use a script or a batch file.

  • Answered by AI
  • Q4. How to run wf from failed session like 10000th record the session failed then how to load from 10000th after fix the issue at mapping level
  • Q5. How to generate sequence from wf to mapping
  • Ans. 

    To generate sequence from wf to mapping, use a mapping transformation in the integration tool.

    • Create a mapping transformation in the integration tool

    • Add the workflow as a source in the mapping

    • Add the target mapping as the target in the mapping

    • Map the fields from the workflow to the target mapping

    • Execute the mapping to generate the sequence in the target mapping

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please focus on scenarios like delete dups query aggregate functions nth highest sal,pivot query to convert rows to columns how many records will get for inner left right full joins take nulls from table 1 and table 2 and try for all joins etc.all the best for interview for informatica developer position

Skills evaluated in this interview

Consultant Interview Questions & Answers

user image Anonymous

posted on 7 Mar 2022

I applied via Approached by Company and was interviewed in Sep 2021. There were 2 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Shortlisted, took all documents. No offer letter released. Been more than 1 month

Deloitte interview questions for designations

 Risk Consultant

 (2)

 Management Consultant

 (2)

 Business Consultant

 (2)

 Junior Consultant

 (2)

 Solution Consultant

 (1)

 Senior Consultant Engineer

 (1)

 Senior Consultant

 (119)

 Tax Consultant

 (68)

Consultant Interview Questions & Answers

user image Anonymous

posted on 8 Sep 2021

I applied via Job Portal and was interviewed in Aug 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I was asked mostly situation based questions which I was already aware of as I had experienced them

Interview Preparation Tips

Interview preparation tips for other job seekers - Be aware of the things you have mentioned in your resume because they shortlist the profile completely based on resume and its match with the job.

Get interview-ready with Top Deloitte Interview Questions

Consultant Interview Questions & Answers

user image Anonymous

posted on 5 Aug 2021

I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Scenario : 2 Talend jobs related to each other. If one fails somehow,the other shouldn't. How to do that?
  • Ans. 

    Use Talend job dependencies to ensure one job doesn't fail if the other does.

    • Create a parent job that calls both jobs as child jobs

    • Use the OnSubjobOk and OnSubjobError triggers to handle success and failure of child jobs

    • Set the 'Die on child error' option to false in the parent job to ensure it continues even if a child job fails

  • Answered by AI
  • Q2. Scenario : Create one talend job which will read may be 1 csv file today, next day 2 or more csv files and process it.
  • Ans. 

    Create a Talend job to read and process varying numbers of CSV files

    • Use a tFileList component to dynamically retrieve the CSV files

    • Use a tFlowToIterate component to iterate over the files

    • Use a tFileInputDelimited component to read the CSV files

    • Process the data as required using other Talend components

    • Use a tLogRow component to output the results

  • Answered by AI
  • Q3. Sql basics. Analytic functions.
  • Ans. Mainly aggregate over partition by clause to be used.
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - 1st round was more or less easy, normal questions like any other interview but 2nd round was very challenging with lot of in depth questions. Overall the toughest I faced out of 12 interviews I sat for 12 companies alltogether

Skills evaluated in this interview

Consultant Jobs at Deloitte

View all

Consultant Interview Questions & Answers

user image Anonymous

posted on 19 Nov 2021

Interview Questionnaire 

1 Question

  • Q1. Some basic technical questions. Related to technology you have worked
  • Ans. Mention the topic you have worked on. Don't try to mention too many things.
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Know you basic well

Consultant Interview Questions & Answers

user image Anonymous

posted on 28 May 2021

I applied via Naukri.com and was interviewed in Apr 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Questions where from the technical skill mentioned in the resume and project architecture.
  • Q2. Performance related questions how I helped the project to improve the performance by doing poc's or any code related improvements.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident while answering and say bluntly no if you don't have answer to the question don't try to bluff with some unrelated things this will make bad impression and be genuine with the answer you give to the interviewer

Consultant Interview Questions & Answers

user image Anonymous

posted on 10 May 2023

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2022. There were 3 interview rounds.

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I have given interview for SAP BW consultant position. There are many question three round of interviews. Topic on which question asked: Bex query, ADSO, Composite provider, Native hana, variable and cust...

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be prepared technically

Deloitte Interview FAQs

How many rounds are there in Deloitte Consultant interview for experienced candidates?
Deloitte interview process for experienced candidates usually has 2-3 rounds. The most common rounds in the Deloitte interview process for experienced candidates are Technical, HR and One-on-one Round.
How to prepare for Deloitte Consultant interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Deloitte. The most common topics and skills that interviewers at Deloitte expect are Project Management, SQL, Risk Management, Data Analysis and Data Analytics.
What are the top questions asked in Deloitte Consultant interview for experienced candidates?

Some of the top questions asked at the Deloitte Consultant interview for experienced candidates -

  1. How would you pass an entry for travel expenses incurred and paid by employee a...read more
  2. What is the journal entry for prepaid expenses and how do you treat ...read more
  3. Scenario : 2 Talend jobs related to each other. If one fails somehow,the other ...read more
How long is the Deloitte Consultant interview process?

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 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
View more

Consultant Interview Questions from Similar Companies

PwC Consultant Interview Questions
3.4
 • 76 Interviews
BCG Consultant Interview Questions
3.7
 • 69 Interviews
TCS Consultant Interview Questions
3.7
 • 57 Interviews
IBM Consultant Interview Questions
4.0
 • 19 Interviews
View all
Deloitte Consultant Salary
based on 33.5k salaries
₹6.3 L/yr - ₹23.4 L/yr
11% more than the average Consultant Salary in India
View more details

Deloitte Consultant Reviews and Ratings

based on 2.7k reviews

3.8/5

Rating in categories

3.8

Skill development

3.2

Work-life balance

3.8

Salary

3.9

Job security

3.8

Company culture

3.4

Promotions

3.4

Work satisfaction

Explore 2.7k Reviews and Ratings
Consultant

Hyderabad / Secunderabad,

Pune

+1

4-6 Yrs

₹ 5.75-25.2 LPA

Consultant-Health Plan Modernisation

Hyderabad / Secunderabad,

Bangalore / Bengaluru

3-7 Yrs

17 LPA

Explore more jobs
Consultant
33.5k salaries
unlock blur

₹6.3 L/yr - ₹23.4 L/yr

Senior Consultant
21.2k salaries
unlock blur

₹11 L/yr - ₹42 L/yr

Analyst
14.4k salaries
unlock blur

₹3.8 L/yr - ₹12.6 L/yr

Assistant Manager
10.1k salaries
unlock blur

₹7.8 L/yr - ₹24 L/yr

Manager
7.1k salaries
unlock blur

₹16 L/yr - ₹53 L/yr

Explore more salaries
Compare Deloitte with

Accenture

3.8
Compare

PwC

3.4
Compare

Ernst & Young

3.4
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview