Deloitte Business Analyst Interview Questions & Experience Guide

Interview Preparation
,
61

Company Name: Deloitte

Position: Business Analyst

Location: [Location not specified]

Application Process: [Application process details not provided]

Interview Rounds:

  • Round 1 - Technical Round:

    • Questions Asked:
      • Questions based on core HR, SSHR, payroll, and absence management
      • Questions based on XML publisher reports
      • Questions based on SQL and PL/SQL
      • Questions based on AOL (Application Object Library)
      • Questions on inbound and outbound interfaces
      • Questions on hook registration and workflow
    • Your Approach: I answered confidently on topics I was familiar with and admitted when I didn’t know something. For SQL and PL/SQL, I wrote queries in Notepad and shared them in the chat.
    • Outcome: Passed to the next round.

  • Round 2 - Technical Round:

    • Questions Asked:
      • Similar to the first round, with a strong focus on SQL and PL/SQL.
      • Covered HCM topics, including reports, AOL, hooks, and interfaces.
    • Your Approach: I ensured I was thorough with the topics mentioned in the job description and maintained a confident demeanor.
    • Outcome: Successfully cleared this round as well.

  • Round 3 - HR Round:

    • Questions Asked: [Details not provided]
    • Your Approach: [Details not provided]
    • Outcome: [Details not provided]

Preparation Tips:

  • Be thorough with the topics mentioned in the job description.
  • Focus on SQL, PL/SQL, HCM topics, reports, AOL, hooks, and interfaces.
  • Practice writing queries and scenarios in Notepad.
  • Be honest about what you know and don’t know, but answer confidently.
  • Ensure your resume reflects your skills accurately.

Conclusion:
The interview process was very nice, with friendly and motivating interviewers. They stuck to the topics mentioned in the job description, so being well-prepared in those areas is crucial. I recommend attending the interview with a clear and focused mind, and always be honest about your knowledge. Confidence and presence of mind are key!

62

Company Name: Deloitte

Position: Business Analyst

Location: J S S Academy of Technical Education, Bangalore

Application Process: Applied via campus placement in December 2021.

Interview Rounds:

  • Round 1 - Technical:

    • Questions Asked: Introduction, “Tell me about yourself,” case study, “What are your future goals?”
    • Your Approach: Prepared a concise introduction, focused on relevant skills and experiences for the role, and linked my future goals to the company’s vision.
    • Outcome: Passed to the next round.

  • Round 2 - Aptitude Test:

    • Questions Asked: Logical reasoning, quantitative aptitude, and verbal ability questions.
    • Your Approach: Practiced previous aptitude tests and focused on time management.
    • Outcome: Cleared the aptitude round.

  • Round 3 - Assignment:

    • Questions Asked: Given a business problem to analyze and provide solutions.
    • Your Approach: Structured the problem, identified key issues, and proposed actionable solutions.
    • Outcome: Successfully completed the assignment.

  • Round 4 - Case Study:

    • Questions Asked: Presented with a real-world business scenario to analyze.
    • Your Approach: Used frameworks like SWOT or PESTLE to break down the problem and suggest recommendations.
    • Outcome: Advanced to the final round.

  • Round 5 - Interview:

    • Questions Asked: Behavioral questions, situational judgment, and role-specific queries.
    • Your Approach: Answered using the STAR method for behavioral questions and linked responses to the role’s requirements.
    • Outcome: Received positive feedback and cleared the interview.

Preparation Tips:

  • Focus on medium skillet (skillset) requirements.
  • Practice aptitude tests and case studies beforehand.
  • Be clear and concise in your responses.

Conclusion:
The overall experience was smooth, and the interviewers were supportive. I could have prepared more case studies to feel even more confident. For future candidates, focus on your problem-solving skills and align your answers with the company’s values.

63

Company Name: Deloitte

Position: Business Analyst

Location: [Not specified]

Application Process: The interview process began with a resume shortlist based on academic background, followed by multiple rounds including tests, telephonic discussions, HR interviews, and technical interviews.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Questions Asked: Selection was based on the candidate’s academic background (e.g., accounts, finance, or BBA). Engineers were generally not shortlisted for this role.

  • Your Approach: Ensure your resume highlights relevant coursework or experience in finance or accounts.

  • Outcome: Shortlisted candidates moved to the next round.

  • Round 2 - Test (Aptitude):

  • Questions Asked: Passages, idioms, phrases, and audio clips with challenging accents.

  • Your Approach: Find a quiet place to focus and listen carefully.

  • Outcome: Duration was 30 minutes with 10 questions.

  • Round 3 - Telephonic Round:

  • Questions Asked: Basic introduction and general knowledge questions.

  • Your Approach: Ensure a quiet environment and stable mobile network.

  • Outcome: Casual discussion with HR; no technical questions.

  • Round 4 - Test (Technical):

  • Questions Asked: Reasoning, Excel (shortcuts, functions, formulas), and finance (terms, formulas).

  • Your Approach: Refer to corporate finance and financial services materials; practice Excel commands.

  • Outcome: 60 questions in 60 minutes; cutoff-based selection.

  • Round 5 - HR Interview:

  • Questions Asked: “Tell me about yourself,” “Why should we hire you?” “Strengths and weaknesses,” “Tell me about Deloitte.”

  • Your Approach: Be honest and confident; focus on soft skills.

  • Outcome: All 12 candidates cleared this round.

  • Round 6 - Technical Interview:

  • Questions Asked: In-depth finance questions (Forex market, balance sheet problems, financial terms, Deloitte’s services).

  • Your Approach: Study corporate finance and financial services thoroughly.

  • Outcome: Candidates were tested on practical financial knowledge.

  • Round 7 - Technical + HR Interview:

  • Questions Asked: Implementing financial tools in market scenarios, contributions to the organization, and package discussions.

  • Your Approach: Be prepared to discuss real-world applications of financial concepts.

  • Outcome: Combined evaluation of technical and HR skills.

  • Round 8 - HR Interview (Final):

  • Questions Asked: Overview of the role and company operations by onsite employees/clients.

  • Your Approach: Listen attentively and engage in the discussion.

  • Outcome: Final welcome round for selected candidates.

Preparation Tips:

  • Focus on corporate finance and financial services topics.
  • Practice Excel shortcuts and functions.
  • Improve soft skills and listening abilities.
  • Stay calm under stress.

Conclusion:
The interview process was comprehensive, testing both technical and soft skills. Being thorough with finance concepts and Excel was crucial. The HR rounds were straightforward but required clarity and confidence. Overall, preparation and staying composed were key to success.

64

Company Name: Deloitte

Position: Business Analyst

Location: Model Engineering College, Kochi

Application Process: Applied via campus placement at Model Engineering College, Kochi, before October 2020.

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked:
      1. What are the OOP concepts?
      2. Explain the projects you have worked on in the past.
      3. Programming questions in C++.
    • Your Approach: I explained the OOP concepts clearly and discussed my past projects in detail, highlighting my contributions. For the C++ questions, I walked through my thought process while solving them.
    • Outcome: Passed to the next round.

  • Round 2 - HR Interview:

    • Questions Asked:
      1. Talk about how feedback and opinions affect our judgment in making decisions.
    • Your Approach: I shared my perspective on the importance of feedback and how it can shape decisions, using examples from my experiences.
    • Outcome: Successfully cleared the round.

  • Round 3 - Group Discussion:

    • Questions Asked: Topics were given on the spot, focusing on current trends and business scenarios.
    • Your Approach: I actively participated, listened to others, and presented my points logically.
    • Outcome: Advanced to the next stage.

  • Round 4 - Aptitude Test:

    • Questions Asked: Quantitative and logical reasoning questions.
    • Your Approach: I solved the questions systematically and managed my time efficiently.
    • Outcome: Cleared the test.

  • Round 5 - Final Interview:

    • Questions Asked: A mix of technical and behavioral questions, including situational scenarios.
    • Your Approach: I balanced technical knowledge with soft skills, ensuring clarity and confidence in my responses.
    • Outcome: Received a positive response.

Preparation Tips:

  • Stay calm and composed during the interview. Speak clearly and openly.
  • Brush up on OOP concepts, programming languages (like C++), and current business trends.
  • Practice group discussions to improve articulation and teamwork.

Conclusion:
Overall, the interview process was thorough but fair. Being well-prepared and maintaining a confident yet humble demeanor helped me succeed. For future candidates, focus on clarity in communication and a strong grasp of both technical and soft skills.

65

Company Name: Deloitte

Position: Business Analyst

Location: [Not specified]

Application Process: The interview process was conducted in August 2016, with students selected based on their job roles, last degree, and streams/subjects. For example, candidates for the Business Analyst role were expected to have a background in accounts or finance, and engineers were generally not shortlisted for this role.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: None explicitly mentioned.
    • Your Approach: Candidates were shortlisted based on their academic background in accounts, finance, or BBA.
    • Outcome: Engineers were typically not selected for this role.

  • Round 2 - Test:

    • Questions Asked: Passages, idioms, and phrases; audio clips with different accents.
    • Your Approach: Listening carefully to the audio clips and reading passages thoroughly.
    • Outcome: Duration was 30 minutes with 10 questions.

  • Round 3 - Telephonic Round:

    • Questions Asked: Basic introduction and general knowledge questions.
    • Your Approach: Keeping the conversation clear and concise.
    • Outcome: No technical questions; focused on basic interaction.

  • Round 4 - Test:

    • Questions Asked: Reasoning, Excel, and Finance sections with 60 questions in total.
    • Your Approach: Referred to corporate finance and financial services materials for the finance section; practiced Excel shortcuts and functions.
    • Outcome: Cutoff-based selection for further rounds.

  • Round 5 - HR Interview:

    • Questions Asked: Tell me about yourself, strengths and weaknesses, why should we hire you, and knowledge about Deloitte.
    • Your Approach: Answered honestly and confidently.
    • Outcome: All 12 candidates cleared this round.

  • Round 6 - Technical Interview:

    • Questions Asked: In-depth finance questions, situational scenarios, financial terms, balance sheet problems, and current market trends.
    • Your Approach: Reviewed corporate finance and financial services thoroughly.
    • Outcome: Advanced to the next round.

  • Round 7 - Technical + HR Interview:

    • Questions Asked: Implementation of financial tools in current market scenarios, contribution to organizational growth, and discussion about compensation.
    • Your Approach: Demonstrated practical knowledge and enthusiasm for the role.
    • Outcome: Successful clearance.

  • Round 8 - HR Interview:

    • Questions Asked: Briefing about the company and role by onsite employees and clients.
    • Your Approach: Engaged actively and asked relevant questions.
    • Outcome: Final welcome round for selected candidates.

Preparation Tips:

  • Focus on corporate finance and financial services for technical rounds.
  • Practice Excel shortcuts and functions.
  • Improve soft skills and listening abilities.
  • Stay updated with current market trends and financial terms.

Conclusion:
The interview process was comprehensive, testing both technical and soft skills. Being thorough with finance concepts and Excel was crucial. The HR rounds were more about personality and fit, while the technical rounds demanded deep subject knowledge. For future candidates, I’d recommend focusing on finance fundamentals and practicing situational questions.

66

Company Name: Deloitte

Position: Business Analyst

Location: [Location not specified]

Application Process: The students were selected based on their job roles, last degree, and streams/subjects. For example, candidates for the Business Analyst role were expected to have a background in accounts or finance. Engineers were generally not shortlisted for this role.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Questions Asked: Selection based on academic background (accounts, finance, or BBA).

  • Your Approach: Ensure your resume highlights relevant coursework or experience in finance or accounts.

  • Outcome: Shortlisted candidates moved to the next round.

  • Round 2 - Test (Aptitude and Listening):

  • Questions Asked: Passages, idioms, phrases, and audio clips with challenging accents.

  • Your Approach: Focus on listening carefully and practicing reading comprehension.

  • Outcome: Candidates who performed well advanced to the next round.

  • Round 3 - Telephonic Round (HR):

  • Questions Asked: Basic introduction and general knowledge questions.

  • Your Approach: Be clear and concise in your responses.

  • Outcome: Candidates who communicated effectively moved forward.

  • Round 4 - Test (Reasoning, Excel, Finance):

  • Questions Asked: Reasoning (English and aptitude), Excel (shortcuts, functions, formulas), and finance (terms, formulas).

  • Your Approach: Brush up on Excel commands and review corporate finance and financial services topics.

  • Outcome: Candidates meeting the cutoff proceeded further.

  • Round 5 - HR Interview:

  • Questions Asked: “Tell me about yourself,” “Why should we hire you?” “Your strengths and weaknesses,” “Tell me about Deloitte.”

  • Your Approach: Be honest and confident in your answers.

  • Outcome: All 12 candidates cleared this round.

  • Round 6 - Technical Interview:

  • Questions Asked: In-depth finance questions (Forex market, balance sheet problems, financial terms, Deloitte’s services).

  • Your Approach: Review corporate finance and financial services thoroughly.

  • Outcome: Successful candidates moved to the final round.

  • Round 7 - Technical + HR Interview:

  • Questions Asked: Implementing financial tools in current market scenarios, contributions to the organization, and discussion about compensation.

  • Your Approach: Demonstrate practical knowledge and enthusiasm for the role.

  • Outcome: Final selection of candidates.

  • Round 8 - HR Interview (Welcome Round):

  • Questions Asked: Overview of the company and role by onsite employees or clients.

  • Your Approach: Listen attentively and ask relevant questions.

  • Outcome: Formal welcome to the organization.

Preparation Tips:

  • Focus on finance and accounts if you have a background in these fields.
  • Practice Excel shortcuts and functions.
  • Review corporate finance and financial services topics.
  • Improve listening and reading comprehension skills for the aptitude test.
  • Be honest and confident during HR rounds.

Conclusion:
The interview process was thorough, with a strong emphasis on finance and soft skills. Being well-prepared in finance and Excel, along with clear communication, was key to success. Future candidates should focus on these areas and ensure they understand Deloitte’s services and values.

67

Company Name: Deloitte

Position: Business Analyst

Location: [Not specified]

Application Process: The students were selected based on their job roles, last degree, and streams/subjects. For example, candidates for the Business Analyst role were expected to have a background in accounts or finance. Engineers were generally not shortlisted for this role.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Experience: Selection was based on academic background, with preference given to candidates with accounts, finance, or BBA degrees. Engineers were not typically considered for this role.
    • Tips: If you have a background in accounts, finance, or BBA, this is a great opportunity for you.

  • Round 2 - Test:

    • Experience: The test included passages, idioms, and phrases. There were also audio clips with challenging accents to test listening skills.
    • Duration: 30 minutes
    • Total Questions: 10
    • Tips: A quiet environment is essential for this round.

  • Round 3 - Telephonic Round:

    • Experience: A casual discussion with HR, focusing on basic knowledge and self-introduction. No technical questions were asked.
    • Tips: Ensure you are in a quiet place with good mobile network reception.

  • Round 4 - Test:

    • Experience: The test had three sections: Reasoning, Excel, and Finance. There were 60 questions in total.
      • Reasoning: Included English and aptitude questions.
      • Excel: Covered shortcuts, functions, and general formulas.
      • Finance: Focused on fundamental finance terms and formulas (e.g., corporate finance, financial services).
    • Tips: Refer to corporate finance and financial services materials for the finance section.

  • Round 5 - HR Interview:

    • Experience: Questions included:
      • Tell me about yourself.
      • Why should we hire you?
      • Your strengths and weaknesses.
      • Tell me about Deloitte.
    • Outcome: All 12 candidates cleared this round.
    • Tips: Be honest and confident in your answers.

  • Round 6 - Technical Interview:

    • Experience: In-depth questions on finance topics such as:
      • How the Forex market works.
      • Situational finance questions.
      • Financial terms and services provided by Deloitte.
      • Balance sheet problems.
      • Current market scenarios (e.g., Sensex).
    • Sample Questions:
      • Walk me through a cash flow statement.
      • What is working capital?
      • How is the income statement linked to the balance sheet?
      • What is a deferred tax asset, and why might one be created?
    • Tips: Thoroughly study corporate finance and financial services.

  • Round 7 - Technical + HR Interview:

    • Experience: Combined technical and HR questions, focusing on:
      • Implementing financial tools in current market scenarios.
      • Contributions to organizational growth.
      • Discussion about compensation and allowances.

  • Round 8 - HR Interview (Final):

    • Experience: Conducted by onsite employees or clients (e.g., an Australian client in this case), providing an overview of the company’s operations.

Preparation Tips:

  • Focus on corporate finance and financial services for technical rounds.
  • Practice Excel shortcuts and functions.
  • Improve soft skills and listening abilities.
  • Stay updated on current financial market trends.

Conclusion:
The interview process was comprehensive, testing both technical knowledge and soft skills. The key to success is a strong foundation in finance, familiarity with Excel, and the ability to articulate your thoughts clearly. Being honest and confident in HR rounds also plays a crucial role. Good luck to future candidates!