Senior business analyst

Senior business analyst Interview Questions and Tips

1

A.T. Kearney senior business analyst interview

3.2k views
Vignesh Shankar ExperiencedSelected
Application
I Applied for job through Walk-in for Senior Business Analyst role at A.T. Kearney
Interview Process
HR Interview Case Study Interview Case Study Interview Case Study Interview HR Interview
Round 1

HR Interview

Interview Questions
  • Question 1: Why Consulting?
  • Question 2: You have some experience in finance, why do you wish to switch to consulting’ ?
Interview Experience
The PI portion was resume-based. I was asked specific questions on points I had mentioned in my resume, for example: - You've mentioned that you were involved in recruitment during your previous job. What were you actually doing? - You've mentioned that you’re undertaking a study (independent study) in Real Estate. Why are you doing this and what are you doing? He followed up my answer to this question by asking some technical questions on how I would value a real estate project. I answered the question using my knowledge of the industry and finance valuation metrics.
Round 2

Case Study Interview

Interview Questions
  • Question 1: Market Estimation:
  • Question 2: You are the Chief Minister of XX state in India. What will you do to increase state income (GDP)?
Interview Experience
Market estimation :
I decided to proceed by estimating the population of Chennai, subsequently the high income population, and subsequently the population within eligible age (say 10 to 30). Thereafter, I stated that we would have to make some assumption regarding the proportion within the eligible age that would actually play tennis and subsequently some assumption regarding the number of courts that would be required in order to ensure that identified population could play tennis for, say 6 hours every week. The interviewer was satisfied with this. He later mentioned that I had missed out tennis courts in educational institutions and clubs. I said that these would be covered to a certain extent in my overall analysis, and he agreed. Note that I did not arrive at a final number. The interviewer was interested in my approach and logic.
Full Case
I approached the case using the Cobb Douglas Production function (which states that income is a function of productivity, capital input and labour input). The interviewer was quite satisfied with the approach. I broke down each lever into possible sub-parts. I said that the productivity lever could be thought of as a function of infrastructure, technology, transportation, etc. Labour could be analysed as (1) creating a talent pool (more colleges, schools, etc.) and (2) retaining the talent pool (creating jobs). The capital lever is all about bringing in more money, through greater support from the central government, increased state-levied taxes or increased private investment. The interviewer was quite happy and asked me to focus on productivity and capital. Before delving deeper, I mentioned that it would be tough to think of productivity and capital and two distinct levers, as most productivity improvements would require capital investment. The interviewer smiled and agreed. He asked me to mention 2 or 3 big items that I would look to work on under each lever. Under productivity, I mentioned power, transportation and irrigation. Under capital, I mentioned that the state government must create incentives for investment through laws and regulations (for example, certain real estate laws with respect to restriction on built-up area are governed by the state. These could be altered). The interviewer agreed that all this could be done, but how could a private investor decide to invest into a state? I said that the government would probably have to identify growth sectors, or sectors that desperately required funds, and then pitch to investors to invest in the identified sectors. The interviewer also mentioned to me that it was critical for the government to increase its speed of response and not let matters die under red tape. He mentioned that one of the biggest reasons why private investors shy away from large investments is because of government bureaucracy.
Interview Tips
I established a good vibe with the interviewer. I think that this was important, given that it was my first interview.
It is useful to make small talk in between different segments in an interview. It helps the interviewer get a sense of who you are. It might also put the interviewer at ease, by breaking the monotony of doing the same case over and over again with 10 different candidates. It is very important to be honest about all your resume points. In the real estate question above (in the PI portion), right at the start, I caveat by stating that the study was work-in-progress. I stated very clearly that I still had a fair way to go towards completion of the study, and so I could answer any questions on real estate based on my limited knowledge. The interviewer appreciated this.
Round 3

Case Study Interview

Interview Questions
  • Question 1: Estimate the first year sales for Tata Nano (TN)
Interview Experience
I stated that TN could capture sales from the two-wheeler segment (i.e., people who are buying two-wheelers merely because existing cars are too costly) and the cheap/small car segment (stealing market share). I started off with the population of India, segmented it into low-income, mid and higher income. Mid-income would clearly be the relevant segment for us. Within the mid-income segment, we need to understand the existing size of the bike market. We could do this by estimating the number of households within the mid-income segment and assuming a certain number of bikes per household. The interviewer broke me off and asked me to assume that the annual bike sales in India are 50 lakhs. Thereafter, I tried to arrive at an estimate of the annual sales that TN could capture. I fumbled quite a bit here. I started off with a certain percentage that, to me, seemed to make intuitive sense. The interviewer said that I was just pulling numbers out of a hat. How could I corroborate this through other means? He then told me that the existing small car market size was 7 lakhs. I said that we could use this to find out what our estimated market share would be, after eating into bike sales. The interviewer retaliated by stating that that would be as good as just assuming a certain market share directly, making my earlier analysis of population, income groups, etc. redundant. I said that that would not be the case, as we are using projected market share merely to see how aggressive/passive our bike to TN conversion ratio assumption is....... We went back and forth on the above for a while. We eventually agreed on a certain percentage (I really don’t know how or why). I intended to proceed with estimating sales captured from the existing cheap/small car segment, but the interviewer wished to stop.
Round 4

Case Study Interview

Interview Questions
  • Question 1: The client is an integrated copper mining and smelting company, whose end-product is metal bars. The company has been making losses for the last 5 years. Prepare a turnaround plan. Additional information – The client has 2 mines and processing plants. One mine and PC together (same location) and the other mine and PC in different locations. The intention here is to make the company profitable on a sustainable basis.
Interview Experience
I laid out a structure whereby I would first understand the market (competition, regulation, our value proposition, market growth – historical and expected) and then understand the company’s income statement in more detail. The interviewer was satisfied with the structure. I was given the following additional information regarding the market, on specific questions: - Our client is the only copper mining company in India. Other copper companies in India are only into smelting. - Our final product is commoditized. Prices are determined by the London Metal Exchange. - Assume no regulatory constraints - Our client has no specific value proposition - Market growth for the last 10-15 years, as well as the expected future growth, is 10% CAGR I later said that I would like to analyse the company’s profitability by understanding revenue and cost in further detail. The interviewer prodded me to look into the industry value chain. Simply put, the value chain involves (a) basic input, i.e., copper ore (b) smelting (c) consumption. Through follow-up questions, we broke each segment into 2 parts each, along with numbers. Under ‘a’, our client (the sole copper mining company in India) supplied 30,000 tonnes. There were imports of 610,000 tonnes. Under ‘b’, our client smelted 40,000 tonnes. There were 2 other major competitors in the market who smelted 300,000 tonnes each. Under ‘c’, 400,000 tonnes was consumed domestically, while the rest was exported. Our client made only domestic sales. (Note: Here, all information was not given to me directly. I was asked to make certain deductions. For example, I was not told directly that there were copper imports. Based on figures for consumption, I had to deduce that there were imports of 610k tones. I was not told directly that there were exports of 240k tones.......)
Based on the above information, the interviewer asked me to list out possible hypotheses that could be causing the client profitability problems. I listed out the following: - Our competitor has higher smelting capacity. Scale economies could be a very significant driver in this industry. - Imported iron ore might be cheaper than our client’s own domestic mining. - Export prices could be higher than domestic prices.
Interview Tips
As you move into subsequent rounds, PI becomes increasingly important.
Round 5

HR Interview

Interview Experience
This was the final interview. There were no cases. Completely PI. In fact, we conducted the interview out on the LRC lawns, next to a make-shift snack bar. We started talking as we were walking. The interview was quite long, over coffee and accessories. Kaustav asked me questions on what I felt about the firm, the recruitment process, the interviews, did I have any questions to which I had not received satisfactory answers in the past, etc. Kaustav asked me why I was interested in consulting. How did it tie in with my career plans? What were my career plans? Short-term and long-term goals? In my life, what decisions had I made that were tough and that involved significant trade-offs or choices? What do I feel about the decisions and choices I have made thus far? A little bit about my family, my personal background. Where had I studied? How would I feel about living away from home?
Read Full post...
2

eBay senior business analyst interview

2.5k views
Anshul VirmaniFresherSelected
Application
I was interviewed on-campus at IIM Lucknow for Senior business analyst role at eBay
Interview Process
Case Study Interview
Round 1

Case Study Interview

Interview Questions
  • Question 1: How would you increase sales on eBay website
Interview Experience
It was a very good experience interacting with the recruiter. He was guiding me throughout and kept on asking questions to push me to the right directiin.
Interview Tips
Always think about all the details and structure your thoughts before going ahead. always think aloud. This gives the recruiter a chance to help you with the case
Round 2

Skills

Skills Tested

Skill Tips
Practice a lot of case studies especially related to e commerce.
General Tips
Be confident and maintain your calm. It is more important to make an honest effort than to get to the right answer of a case/puzzle.
Motivation for applying
Good work cultureGlobal ecommerce playerGreat analytics work
Read Full post...
3

Sapient Corporation senior business analyst interview

221 views
Rudrasayak SardarExperiencedSelected
Interview Process
Technical Interview Behavioural Interview
Round 1

Technical Interview

Interview Questions
  • Question 1: Tell me about yourself?
  • Question 2: What are the documents that you had to create during the process
  • Question 3: What do you put in BRD
  • Question 4: What do you put in FRD
  • Question 5: Can you describe the difference between FRD and BRD?
  • Question 6: What is a Requirement creep?
  • Question 7: What are the different meetings that happen in Agile style development?
  • Question 8: What would be duration of a sprint and who leads it?
  • Question 9: If you had to accommodate a CR in agile how would you do so?
  • Question 10: What tools do you use to track your projects?
  • Question 11: Do you create DFD?
  • Question 12: Which document do you put the DFD?
  • Question 13: Who is a stake holder and how do you classify them?
  • Question 14: Any questions for me?
Round 2

Behavioural Interview

Interview Questions
  • Question 1: What technologies you have worked on?
  • Question 2: What do you know about AEM?
  • Question 3: What CMS tools have you used?
  • Question 4: How is Magento CMS tool different from WordPress
  • Question 5: What do you know about Sapient?
  • Question 6: Where do you see yourself in 5 years time?
  • Question 7: Expected CTC and Joining date?
Read Full post...
4

Brillio senior business analyst interview

320 views
AnonymousExperiencedSelected
Interview Process
Technical Interview Behavioural Interview
Round 1

Technical Interview

Interview Questions
  • Question 1: Tell me about yourself?
  • Question 2: What is your work profile?
  • Question 3: How do you gather requirements?
  • Question 4: Who is a stakeholder?
  • Question 5: What is a project lifecycle ?
  • Question 6: Can we have agile in a FP project?
  • Question 7: What is an RFP and how you respond back?
  • Question 8: What all eCommerce platforms have you worked on?
  • Question 9: What verticals did you work on?
Round 2

Behavioural Interview

Interview Questions
  • Question 1: Tell me about yourself?
  • Question 2: What is a project scope?
  • Question 3: If I tell you to prepare a TOC for a RFP what will you put into it?
  • Question 4: What are the different items you will look into if you have to gather a requirement?
  • Question 5: What is the difference in RFI and RFP?
  • Question 6: What are the modern trends in eCommerce?
  • Question 7: What all blog posts do you follow?
  • Question 8: Any questions you would like to ask?
Interview Experience
The second of Interview was the behavioral round which was with the Director of the Sales Department. Above given questions were asked to check my technical as well as my soft skills.
Interview Tips
be confident and have strong communication.
Read Full post...
SignUp/Login
1-Step Login | Get unlimited access!