Skip to contentSkip to footer

Consultant Interview Questions

Salaries
Interviews

Consultant Interview Questions

While there's no set list, businesses are pretty clear about qualities they like to see demonstrated by their employees and applicants. Generally, a consultant interviewer is looking for evidence of confidence, communication skills, your ability to gain a client's trust, overall leadership skills, and knowledge of your subject matter to name a few. There are generally two types of consulting interview questions: fit — designed to find out about your personal experience, motivation, and soft skills, and case — designed to assess your analytical consulting skills.

Top Consultant Interview Questions & How To Answer

Question 1

Question #1: Why do you want to work for this firm?

How to answer
How to answer: This question is asked to reveal your motivation for choosing a specific organization and to test your knowledge of the industry. Research the firm you're interviewing with and make sure to highlight some of your key points of interest. Additionally, mention any ways in which the company's values align with your own.
Question 2

Question #2: Give an example of a time you lead a team.

How to answer
How to answer: To answer this question, choose an experience in which you made a meaningful impact while managing or working with others. Provide context regarding the situation and objective, describe your leadership role, what actions you took, the outcome of those actions, and what you learned about yourself during the process.
Question 3

Question #3: How would you help a local cafe recover from a sharp profitability decline?

How to answer
How to answer: Breaking down complex business problems is one of the hallmarks of consulting. For questions like this, there's no universal framework — you'll have to create your own. Ask questions, define the problem clearly, create Mutually Exclusive, Collectively Exhaustive (MECE) categories, show how you would analyze each category, and define your next steps.

188,160 consultant interview questions shared by candidates

Spark : 1. Difference between map and flatmap. 2. Difference between groupbykey and reducebykey 3. Which file format spark saves file ? Answer should be ".orc" files only. (It took me multiple attempts to understand the question. and ".txt", ".csv" "xml" "anyflat-file-format" is not the correct answer. LOL ) 4. Difference between coalesce and repartition. 5. some more questions on RDD Hive 1 Difference between orderby and sortby 2. Select * from . How many mapper will be created. 3. Analytical function/ What is RANK ? hdfs 1. Difference between block and split SQL 1. What is indexing on single column ? (stopped in between of my answer ) and followed by what is sorting type in index key ascending or descending. (How does it matter its primary key not composite key) 2. Can you have two primary key . (I do not thing there will need of two primary as one it self does the job.) No tell the implementation is it possible, can you define two primary key ? (No) One of the panel member got irritated and fired a few questions after saying bye and answering my question related to profile and position . (Literally like Panel one : okay bye thanks for you ... Panel: No I will ask one last question . which file format spark saves files. )
avatar

Big Data Consultant

Interviewed at Prowareness

3.8★
Mar 3, 2017

Spark : 1. Difference between map and flatmap. 2. Difference between groupbykey and reducebykey 3. Which file format spark saves file ? Answer should be ".orc" files only. (It took me multiple attempts to understand the question. and ".txt", ".csv" "xml" "anyflat-file-format" is not the correct answer. LOL ) 4. Difference between coalesce and repartition. 5. some more questions on RDD Hive 1 Difference between orderby and sortby 2. Select * from . How many mapper will be created. 3. Analytical function/ What is RANK ? hdfs 1. Difference between block and split SQL 1. What is indexing on single column ? (stopped in between of my answer ) and followed by what is sorting type in index key ascending or descending. (How does it matter its primary key not composite key) 2. Can you have two primary key . (I do not thing there will need of two primary as one it self does the job.) No tell the implementation is it possible, can you define two primary key ? (No) One of the panel member got irritated and fired a few questions after saying bye and answering my question related to profile and position . (Literally like Panel one : okay bye thanks for you ... Panel: No I will ask one last question . which file format spark saves files. )

A few things I couldn't understand in the past with KAnand. 1. I had two interviews with Apple and I've got a written offer from KAnand starting from April 12. KAnand and I both signed the documents legally. 2. After the offer, I had to do another interview with Apple thru Cognizant/KAnand with his different JD which was nothing to do with my current offer with my JD, and which I was confused at that time since I've already got the offer, and Cognizant/KAnand also said my offer got confirmed already, so told me not to worry. 3. For some reason, the starting date was delayed one week, so I waited more than a week, but still I didn't know the starting date. 4. I contacted KAnand for many times, but I couldn't get responses about what's going on clearly. I didn't look for my job since my offer. 5. All of sudden, KAnand has cancelled my offer without any clear reason today on April 24. 6. I asked compensation, but Cognizant and KAnand didn't want to compensate.
avatar

Senior Consultant

Interviewed at KAnand

3.6★
Apr 25, 2017

A few things I couldn't understand in the past with KAnand. 1. I had two interviews with Apple and I've got a written offer from KAnand starting from April 12. KAnand and I both signed the documents legally. 2. After the offer, I had to do another interview with Apple thru Cognizant/KAnand with his different JD which was nothing to do with my current offer with my JD, and which I was confused at that time since I've already got the offer, and Cognizant/KAnand also said my offer got confirmed already, so told me not to worry. 3. For some reason, the starting date was delayed one week, so I waited more than a week, but still I didn't know the starting date. 4. I contacted KAnand for many times, but I couldn't get responses about what's going on clearly. I didn't look for my job since my offer. 5. All of sudden, KAnand has cancelled my offer without any clear reason today on April 24. 6. I asked compensation, but Cognizant and KAnand didn't want to compensate.

Viewing 1631 - 1640 interview questions

Glassdoor has 188,160 interview questions and reports from Consultant interviews. Prepare for your interview. Get hired. Love your job.