Hi everyone, this topic is for sharing preparation guidelines and interview experience for the Business Analyst role at Axis Bank.
The Axis Bank Business Analyst role involves a multi-stage assessment and interview process, designed to evaluate technical expertise, problem-solving skills, business understanding, and cultural fit. Based on the transcripts and interview experiences shared, here’s a detailed breakdown of the process:
Assessment & Screening Rounds:
Round 1: Resume Shortlisting
Details: Based on resume quality, CGPA, projects, and relevance to the role.
Tips:
Keep the resume crisp, well-structured, and highlight relevant coursework, tools (SQL, Tableau, Python), and projects.
Mention real business outcomes or metrics if possible.
Round 2: Aptitude Test
Duration: Timed test with focus on speed and accuracy.
Question Types:
Quantitative Aptitude
Logical Reasoning
Verbal Ability
Data Interpretation (CAT-level in some cases)
Tips:
Practice timed mock tests.
Focus on accuracy and time management.
Round 3: Coding Test / Technical MCQs
Topics Covered:
SQL Queries (Joins, Subqueries, Data Cleaning)
Python (String manipulation, Libraries)
SAS (in some cases)
Tools: Tests were conducted on platforms requiring SAS/SQL/Python inputs.
Tips:
Revise SQL and Python thoroughly.
Focus on practical application and logic building.
Interview Rounds:
Round 4: One-on-One Technical Interview
Focus Areas:
SQL, Python, Tableau
Business understanding, Machine Learning (basic level)
Guesstimates, puzzles, and resume-based questions
Sample Questions:
“What are SQL Joins?”
“Explain a business case you handled.”
“What kind of dashboards did you build in Tableau?”
“What is Basel regulation?” (for regulatory roles)
Tips:
Prepare to discuss your projects in detail.
Focus on problem-solving approach, tools used, and business impact.
Round 5: Group Discussion / Case Study (in some cases)
Type:
Case-based GDs and guesstimates
Mathematical or business problem-solving
Tips:
Structure your answers logically.
Participate actively and maintain clarity in communication.
Round 6: HR Interview
Focus Areas:
Background, communication, career goals, salary expectations
Fitment to Axis Bank culture and team
Tips:
Prepare your “Tell me about yourself” well.
Align your responses with the role’s expectations.
Interview Preparation Tips:
Revise SQL, Python, Tableau, and relevant business concepts.
Practice guesstimates, puzzles, and case studies.
Be thorough with your resume – every point can be questioned.
Focus on clarity of thought and structured answers.
Research Axis Bank’s business model and recent initiatives.
Conduct and Logistics:
Interviews are one-on-one, virtual (Zoom/Meet), and elimination-based.
Each round can last from 10 to 30 minutes depending on the type.
The process may include 3 to 6 rounds, depending on the role and mode of application (campus/off-campus).
Final results are typically shared within a few days.
Application Process: I applied through LinkedIn and was interviewed in March 2024.
Interview Rounds:
Round 1 - One-on-one Round:
Questions Asked:
Share a current case where you faced difficulties.
Your Approach: I discussed a recent project where I encountered challenges related to data discrepancies and how I resolved them by collaborating with the team and using SQL for data validation.
Outcome: The interviewer seemed satisfied with my response, and I moved forward in the process.
Preparation Tips:
Focus on real-life case studies where you faced and resolved challenges.
Brush up on SQL and data analytics concepts, as they are crucial for this role.
Be ready to discuss your problem-solving approach in detail.
Conclusion:
The interview was a great learning experience. I felt confident discussing my practical experiences, but I could have prepared more case studies to showcase my analytical skills. For future candidates, I’d recommend being thorough with your past projects and ready to explain your thought process clearly.
Application Process: The application process involved three rounds: Resume Shortlist, Aptitude Test, and a One-on-One Interview.
Interview Rounds:
Round 1 - Resume Shortlist:
Details: The first round was a resume screening. The key here was to keep the resume crisp and impactful, as recruiters typically spend only a few seconds reviewing it.
Outcome: Successfully shortlisted for the next round.
Round 2 - Aptitude Test:
Questions Asked: The test included numerical problems, which were common for such roles. The questions were not overly difficult but required careful attention.
Your Approach: Focused on accuracy and time management to ensure all questions were answered within the allotted time.
Outcome: Cleared the aptitude test and moved to the final round.
Round 3 - One-on-One Interview:
Questions Asked:
What is the role of a Business Analyst?
What are user stories?
What is Jira, and why is it used?
What is a Scrum Master, and why is it needed?
Your Approach: Answered the questions confidently, drawing from prior knowledge and practical examples.
Outcome: The interview went well, and the responses were well-received.
Preparation Tips:
Prepare thoroughly and stay confident. Good preparation and presentation skills are crucial.
Dress formally, as it leaves a positive impression.
Conclusion:
The overall interview experience was smooth and well-structured. The key takeaways were the importance of a well-crafted resume, strong numerical skills, and clarity in explaining concepts related to the role. For future candidates, focus on these areas and practice presenting your knowledge confidently.
Questions Asked: Mini CAT Exam with hard to medium level difficulty.
Your Approach: Focused on solving quantitative and logical reasoning questions efficiently.
Outcome: Cleared the round.
Round 2 - Coding Test:
Questions Asked: SQL Coding and scenario-based questions.
Your Approach: Practiced SQL queries beforehand and applied logical thinking to solve the scenario-based problems.
Outcome: Successfully passed.
Round 3 - One-on-one Technical Round:
Questions Asked:
Technical question related to Machine Learning and Statistics.
SQL and Business Problems (Profile-level question).
Your Approach: Revised ML concepts and SQL queries, and prepared for business problem-solving.
Outcome: Cleared the round.
Round 4 - Group Discussion:
Questions Asked: Case Study and Guestimates.
Your Approach: Participated actively, shared logical insights, and collaborated with the group.
Outcome: Advanced to the next round.
Round 5 - HR Round:
Questions Asked: Salary discussion.
Your Approach: Researched industry standards and negotiated politely.
Outcome: Final offer discussion.
Preparation Tips:
Focus on aptitude and logical reasoning for the initial rounds.
Practice SQL queries and scenario-based problem-solving.
Revise Machine Learning and Statistics concepts for technical rounds.
Prepare for case studies and guestimates for group discussions.
Research salary benchmarks for the HR round.
Conclusion:
The interview process was comprehensive, testing both technical and analytical skills. The key to success was thorough preparation and active participation in group discussions. For future candidates, I recommend practicing SQL and business problem-solving extensively and being confident during discussions.
Application Process: Approached by the company for the interview process in May 2022.
Interview Rounds:
Round 1 - Resume Shortlist Round:
Questions Asked: No specific questions asked in this round.
Your Approach: Ensured my resume was concise and highlighted relevant skills and experiences.
Outcome: Successfully shortlisted for the next round.
Round 2 - HR Round:
Questions Asked: “Tell me about yourself.”
Your Approach: Gave a brief overview of my background, skills, and why I was interested in the role.
Outcome: Moved to the next round.
Round 3 - Technical Round:
Questions Asked: “Tell me about yourself.”
Your Approach: Focused on my technical skills and projects relevant to the Business Analyst role.
Outcome: Advanced to the final round.
Round 4 - One-on-one Round:
Questions Asked: “Tell me about yourself.”
Your Approach: Combined personal and professional aspects to present a well-rounded answer.
Outcome: Final evaluation pending.
Preparation Tips:
Prepare well for interviews and have a good understanding of banking concepts and industry trends.
Conclusion:
The interview process was straightforward but repetitive. While the questions were similar across rounds, it was important to tailor my answers to the context of each round. Future candidates should focus on presenting themselves clearly and confidently, ensuring their responses align with the role’s requirements.
Application Process: I applied via LinkedIn and was interviewed before March 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (Resume screening round)
Your Approach: Ensured my resume was well-formatted and aligned properly to make it easy for the recruiter to read.
Outcome: Shortlisted for the next round.
Round 2 - Aptitude Test:
Questions Asked: CAT-level questions, with a focus on Quantitative Aptitude and less on Data Interpretation.
Your Approach: Prepared by practicing quantitative problems and brushed up on basic DI concepts.
Outcome: Cleared the aptitude test.
Round 3 - Coding Test:
Questions Asked: Mostly based on string handling in Python.
Your Approach: Used Python to solve the problems, focusing on string manipulation techniques.
Outcome: Successfully cleared the coding round.
Preparation Tips:
Have some good projects to talk about during the interview, as this can significantly improve your chances of selection.
Conclusion:
Overall, the interview process was smooth, and I felt well-prepared. However, I would advise future candidates to focus on building strong projects and practicing aptitude and coding problems thoroughly.
Application Process: Applied via campus placement at Chandigarh Engineering College, Chandigarh, before August 2023.
Interview Rounds:
Round 1 - Aptitude Test:
Questions Asked: Very short timed quick aptitude test.
Your Approach: Focused on solving questions quickly and accurately under time constraints.
Outcome: Cleared the round successfully.
Round 2 - Coding Test:
Questions Asked: SQL and DSA (Data Structures and Algorithms) questions.
Your Approach: Prepared SQL queries and revised core DSA concepts beforehand to tackle the questions efficiently.
Outcome: Performed well and advanced to the next stage.
Preparation Tips:
Brush up on aptitude topics like quantitative ability, logical reasoning, and verbal ability for the first round.
Practice SQL queries and revise fundamental DSA concepts for the coding round.
Time management is crucial, especially for the aptitude test.
Conclusion:
The interview process was smooth and well-structured. The aptitude round tested speed and accuracy, while the coding round assessed technical skills. Preparing thoroughly for both aptitude and technical questions helped me perform well. For future candidates, I’d recommend practicing timed aptitude tests and strengthening SQL and DSA skills.
Application Process: I applied via LinkedIn and was interviewed in March 2022.
Interview Rounds:
Round 1 - Coding Test Round:
Questions Asked: Technical test in SAS and SQL.
Your Approach: I focused on brushing up my SQL and SAS skills beforehand to ensure I could tackle any queries or data-related tasks efficiently.
Outcome: Cleared the round successfully.
Round 2 - Technical Round:
Questions Asked: Basic questions on SQL queries, data cleaning, and dashboards.
Your Approach: I answered the questions based on my practical experience and knowledge of SQL and data analysis. I also explained my thought process while solving the problems.
Outcome: Passed the round.
Round 3 - HR Round:
Questions Asked: General questions about my previous job role, salary expectations, hobbies, and interests.
Your Approach: I kept my answers concise and professional, aligning my responses with the role and company culture.
Outcome: Successfully cleared the HR round.
Preparation Tips:
Axis Bank is known for its flexible work hours and supportive team environment.
Focus on strengthening your SQL and SAS skills, as they are crucial for the technical rounds.
Be prepared to discuss your previous work experience in detail, especially if it involves data analysis or related fields.
Conclusion:
Overall, the interview process was smooth and well-structured. The technical rounds tested my practical knowledge, while the HR round was more about fit and expectations. I would advise future candidates to prepare thoroughly for SQL and SAS, as they are key to clearing the initial rounds. Additionally, being clear and confident in the HR round can make a positive impression.
Application Process: Applied via campus placement before January 2021.
Interview Rounds:
Round 1 - Guesstimates and Behavioral Questions:
Questions Asked:
Three guesstimates (specifics not provided, but the focus was on the process rather than the correctness of the answer).
Thoughts on teamwork and the importance of each team member’s contribution.
Discussion about previous work experience with Tableau (what kind of work was done).
Your Approach:
For the guesstimates, focused on logical reasoning and a structured approach.
Emphasized the value of teamwork and shared experiences where collaboration led to success.
Highlighted specific projects and tasks handled in Tableau to showcase analytical skills.
Outcome: Successfully passed the round.
Preparation Tips:
Practice solving guesstimates beforehand to get comfortable with the process.
Be ready to discuss any analytical tools mentioned in your resume (e.g., Tableau) with concrete examples of your work.
Conclusion:
The interview was a good learning experience. The focus was more on problem-solving approaches and teamwork rather than technical depth. Preparing for guesstimates and being able to articulate past experiences clearly helped a lot. For future candidates, I’d recommend practicing logical reasoning questions and being thorough with your resume.
Questions Asked: Quantitative and Data Interpretation questions.
Your Approach: Focused on solving problems quickly and accurately, ensuring a strong grasp of basic quantitative concepts.
Outcome: Cleared the round successfully.
Round 2 - Technical Round:
Questions Asked:
Resume-based questions.
Puzzles and basic coding questions.
Your Approach: Prepared thoroughly on my resume, ensuring I could explain every detail. For puzzles and coding, practiced common problems beforehand.
Outcome: Performed well and advanced further in the process.
Preparation Tips:
Go prepared and be confident. Focus on resume clarity and practice puzzles and basic coding problems.
Conclusion:
The interview process was smooth, and I felt well-prepared. Being confident and thorough with my resume helped a lot. For future candidates, I’d recommend practicing aptitude tests and puzzles regularly to build confidence.
Application Process: Applied via Campus Placement before August 2020.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
SQL JOINS
Python Packages
Python Projects mentioned in the resume
Basics about loans default in banking
Puzzles
Your Approach: Focused on explaining SQL concepts clearly and discussing Python projects in detail. For puzzles, took a logical approach.
Outcome: Passed to the next round.
Round 2 - HR Interview:
Questions Asked:
Basic HR questions
Your Approach: Answered honestly and confidently, aligning responses with the role’s requirements.
Outcome: Cleared the HR round.
Round 3 - Aptitude Test:
Questions Asked: [Details not specified]
Your Approach: Prepared by revising quantitative and logical reasoning topics.
Outcome: Successfully cleared the test.
Round 4 - Final Interview:
Questions Asked: [Details not specified]
Your Approach: Combined technical and HR preparation to present a well-rounded profile.
Outcome: Selected for the role.
Preparation Tips:
Be calm and composed during the interview.
Thoroughly review your resume and be prepared to discuss any projects or skills mentioned.
Revise SQL, SAS, and Python, especially if targeting the business intelligence unit.
Conclusion:
The interview process was comprehensive, covering technical, HR, and aptitude aspects. Staying composed and well-prepared helped me succeed. For future candidates, focus on mastering the basics of SQL and Python, and ensure you can confidently discuss your resume.
Application Process: Applied via the company website and interviewed in September 2020.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
Basel regulatory
Implementation knowledge
Your Approach: Focused on explaining Basel regulations and demonstrated end-to-end techno-functional implementation knowledge.
Outcome: Cleared the round.
Round 2 - HR Interview:
Questions Asked: Not specified.
Your Approach: Prepared to discuss my background, skills, and alignment with the role.
Outcome: Not specified.
Preparation Tips:
Be thorough with Basel regulations and reporting templates.
Gain end-to-end techno-functional implementation knowledge.
Conclusion:
The interview process was insightful, and I realized the importance of regulatory knowledge in the banking sector. Future candidates should focus on both technical and functional aspects of the role.
Your Approach: Ensured the resume highlighted relevant coursework, projects, and extracurricular activities.
Outcome: Shortlisted for the next round.
Round 2 - Aptitude Test:
Questions Asked: Data interpretation and aptitude questions.
Your Approach: Focused on accuracy and time management, as the test required patience.
Outcome: Around 20-25 candidates were shortlisted after this round.
Round 3 - Case Study Interview:
Questions Asked: Questions related to case studies and coursework in mathematics.
Your Approach: Applied analytical skills and mathematical concepts to solve the case studies.
Outcome: Advanced to the next round.
Round 4 - HR Interview:
Questions Asked: Asked to talk about myself, my qualities, and activities I was involved in during the past 4-5 years.
Your Approach: Highlighted leadership roles, teamwork, and problem-solving experiences.
Outcome: Successful progression in the interview process.
Preparation Tips:
Revise math courses thoroughly, as they are useful for case study interviews.
Practice solving case studies to improve analytical skills.
Work on communication skills to articulate thoughts clearly during the HR round.
Conclusion:
The interview process was comprehensive, testing both technical and interpersonal skills. Preparing case studies and revising mathematical concepts were crucial. For future candidates, focusing on clear communication and thorough preparation for aptitude and case study rounds will be beneficial.
Application Process: Applied through an online platform. The process included an initial online aptitude and coding test followed by technical and HR rounds.
Interview Rounds:
Round 1 - Online Aptitude and Coding Test:
Questions Asked: The test included common aptitude questions, technical questions, and one coding problem.
Your Approach: Focused on solving the aptitude questions quickly to allocate more time to the coding problem. For the technical questions, relied on basic knowledge of databases and SQL.
Outcome: Cleared the round and moved to the next stage.
Round 2 - Technical and HR Interview:
Questions Asked: Mostly SQL and database-related questions, along with basic HR questions like “Tell me about yourself” and “Why Axis Bank?”.
Your Approach: Answered the technical questions confidently, drawing from prior experience with databases. For HR questions, kept responses concise and aligned with the role.
Outcome: The round was relatively easy, and the feedback was positive.
Preparation Tips:
Brush up on basic aptitude topics like quantitative ability and logical reasoning.
Revise SQL and database concepts, as they are frequently tested.
Practice coding problems to ensure you can solve at least one within the given time.
Prepare for common HR questions to present yourself well in the interview.
Conclusion:
The overall experience was smooth, and the interviewers were supportive. The key to success was balancing speed and accuracy in the aptitude test and being well-prepared for technical questions. For future candidates, I’d recommend focusing on SQL and databases, as they play a significant role in the technical round.
Application Process: Applied through campus placement.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
Questions about my projects and the tech stack they were built on.
A few Data Structures and Algorithms (DSA) and Object-Oriented Programming (OOP) questions.
SQL-related questions.
A guess estimate question at the end.
Your Approach:
I explained my projects in detail, focusing on the technologies used and the problem-solving approach.
For DSA and OOP, I provided clear and concise answers, ensuring I covered the fundamentals.
For SQL, I walked through my thought process while answering.
The guess estimate question was approached logically, breaking down the problem into smaller parts.
Outcome: The interviewers were satisfied with my responses, and I passed this round.
Conclusion:
The interview was a great experience overall. The interviewers were friendly and made the process comfortable. I felt confident about my technical explanations, but I could have prepared more for the guess estimate part. My advice to future candidates would be to thoroughly review your projects and brush up on DSA, OOP, and SQL concepts. Also, practicing guess estimates can be very helpful!
Application Process: Applied through campus placement.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked: Basic puzzles from GeeksforGeeks.
Your Approach: Struggled with the puzzles as they were unfamiliar.
Outcome: Not selected due to lack of familiarity with the puzzles and lower academic pointer.
Conclusion:
The interview was straightforward but focused heavily on puzzles, which I wasn’t prepared for. In hindsight, I should have practiced more puzzles and brushed up on problem-solving techniques. For future candidates, I’d recommend thoroughly preparing for puzzles and logical questions, especially from platforms like GeeksforGeeks, and ensuring your academic performance is strong to avoid any doubts about your capabilities.
Application Process: I applied for the Business Analyst role at Axis Bank through their online job portal. The process was straightforward, and I received a confirmation email shortly after submitting my application.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
Can you explain the role of a Business Analyst in a banking environment?
How would you analyze and interpret financial data to derive business insights?
Describe a time when you used data to solve a business problem.
Your Approach: I focused on my understanding of the banking sector and how data-driven decisions can impact business outcomes. I shared a specific example from my internship where I analyzed customer transaction data to identify trends and suggested improvements.
Outcome: I passed this round and was invited for the next interview.
Round 2 - HR Interview:
Questions Asked:
Why do you want to work at Axis Bank?
How do you handle pressure or tight deadlines?
Where do you see yourself in the next 5 years?
Your Approach: I emphasized my passion for the banking industry and my alignment with Axis Bank’s values. I also highlighted my ability to stay organized and prioritize tasks under pressure.
Outcome: The interviewer seemed satisfied with my responses, and I was selected for the role.
Preparation Tips:
Research the company thoroughly, including its products, services, and recent developments.
Practice answering common technical and HR questions related to the role.
Be ready to discuss your past experiences and how they relate to the job requirements.
Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared, but I could have practiced more case studies to better showcase my analytical skills. My advice to future candidates is to stay confident, be clear about your career goals, and demonstrate how your skills align with the company’s needs.
Application Process: The application process was smooth. I applied through the company’s career portal, and the recruitment team reached out for further rounds.
Interview Rounds:
Round 1 - Technical & HR Interview:
Questions Asked:
Detailed discussion about the technical projects mentioned in my resume.
A guesstimate question: “Estimate the number of schools in a city.”
HR questions:
“What are your strengths and weaknesses?”
“How would you handle conflict within a team?”
Your Approach:
For the technical projects, I focused on explaining my role, the challenges faced, and the outcomes.
For the guesstimate, I broke down the problem into smaller parts (population, density, and average number of schools per area) to arrive at a logical estimate.
For HR questions, I answered honestly, highlighting my adaptability and willingness to learn, while also acknowledging areas for improvement.
Outcome: I successfully cleared this round and moved forward in the process.
Preparation Tips:
Brush up on your resume thoroughly, especially technical projects.
Practice guesstimate questions to improve problem-solving skills.
Prepare for common HR questions to articulate your thoughts clearly.
Conclusion:
The interview experience with Axis Bank was insightful and well-structured. I felt prepared for the technical and HR aspects, but practicing more guesstimate questions beforehand would have been beneficial. My advice to future candidates is to focus on clarity in communication and logical structuring of answers.
Focus on functional concepts relevant to the role.
Questions about essential skills for everyday work.
Justification for changing jobs (if applicable).
Commitment to the role and long-term goals.
Your Approach:
Prepared by reviewing functional concepts and aligning them with the job requirements.
Practiced explaining my career transition (if any) and emphasized my long-term commitment.
Outcome: [Result not specified]
Preparation Tips:
Brush up on functional concepts related to business analysis.
Be ready to justify any career changes and demonstrate commitment to the role.
Practice articulating how your skills align with the job responsibilities.
Conclusion:
The interview focused heavily on functional knowledge and personal commitment. Being well-prepared in these areas can significantly improve your chances. If I could do anything differently, I would practice more real-world scenarios to better showcase my skills.
Application Process: The process began with an online test, which included coding and machine learning questions. Based on the test performance, candidates were shortlisted for further interviews.
Interview Rounds:
Round 1 - Online Test:
Questions Asked: The test covered coding problems and machine learning concepts. The difficulty level was moderate, with a mix of theoretical and practical questions.
Your Approach: I focused on solving the coding problems efficiently and ensured I understood the machine learning concepts thoroughly. I practiced similar problems beforehand to build confidence.
Outcome: Cleared the test and was shortlisted for the personal interview round.
Round 2 - Personal Interview:
Questions Asked: The interview revolved around my understanding of business analysis, problem-solving skills, and how I would apply machine learning in real-world scenarios. They also asked about my past projects and how they align with the role.
Your Approach: I emphasized my analytical skills and provided examples from my projects to demonstrate my ability to solve business problems. I also discussed how machine learning can be leveraged for data-driven decision-making.
Outcome: The interview went well, and I received positive feedback on my problem-solving approach and domain knowledge.
Preparation Tips:
Brush up on coding skills, especially problem-solving and algorithms.
Understand the basics of machine learning and its applications in business analysis.
Be ready to discuss past projects and how they relate to the role.
Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared, but I could have spent more time refining my explanations for the machine learning concepts. My advice to future candidates is to practice coding regularly and be clear about how their skills align with the role of a Business Analyst.