Given an eight-page case write-up about a hospital chain in India experiencing low asset utilization and stagnant revenues, the interviewer asked for my gut feeling on what was going wrong.
Your Approach:
Defined the problem: A hospital chain focusing on lower-end diseases (non-lifestyle diseases) was facing declining revenues.
Structured the analysis using: Sales = ∑ (Price * Quantity), where Quantity = number of patients * average patient days.
Proposed breaking revenue analysis by:
Diseases served.
Types of customers (demographic, psychological, economic).
Referral vs. non-referral patients.
Identified key issues:
Market shift towards lifestyle diseases (higher revenue).
Lack of focus on global/medical tourism.
Weak partnerships with insurance companies.
Recommended solutions:
Enter the lifestyle disease market.
Focus on global branding.
Partner with insurance firms.
Outcome: The interviewer appreciated my structured approach and analysis.
Preparation Tips:
Prepare for case write-up-based interviews by practicing with real-world cases.
Group discussions and mock cases from work experiences can help understand industries better.
Conclusion:
The interview was a great learning experience. The case was comprehensive, and my structured approach helped me navigate it effectively. Making detailed notes during the case read was crucial. For future candidates, I’d recommend practicing case analysis and being open to feedback during the discussion.
Application Process: Applied via Naukri.com and was interviewed in March 2024.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
Basics of Business Analysis (BA). Process of BA.
Basics of the product owner role.
Your Approach: Answered the questions based on my understanding of the domain and practical experience.
Outcome: [Not specified]
Round 2 - Technical Round:
Questions Asked:
Basics of the product owner role.
Your Approach: Provided a detailed explanation of the product owner’s responsibilities and skills.
Outcome: [Not specified]
Preparation Tips:
Guys, don’t even think of joining this company. They play with candidates. The interviewer was very mannerless and lacked domain knowledge. The interviewer didn’t allow me to speak properly and seemed confused about what to ask.
Conclusion:
The overall experience was disappointing. The interviewer’s behavior and lack of preparation were unprofessional. My advice to future candidates is to thoroughly research the company and be prepared for unexpected situations during the interview.
Application Process: I applied through a recruitment consultant and was interviewed in December 2020.
Interview Rounds:
Round 1 - Technical:
Questions Asked: Focused on current topics related to my field.
Your Approach: I prepared by staying updated with trending topics in my domain.
Outcome: Successfully cleared this round.
Round 2 - HR:
Questions Asked: General HR questions about my experience and fit for the role.
Your Approach: I answered honestly and aligned my responses with the job requirements.
Outcome: Advanced to the next round.
Round 3 - Group Discussion:
Questions Asked: Discussion on a case study or scenario.
Your Approach: I actively participated and contributed relevant points.
Outcome: Moved forward in the process.
Round 4 - Case Study:
Questions Asked: Detailed case study analysis.
Your Approach: I structured my analysis logically and presented clear solutions.
Outcome: Cleared this round.
Round 5 - Final Interview:
Questions Asked: Combined technical and behavioral questions.
Your Approach: Balanced technical knowledge with soft skills.
Outcome: Received positive feedback.
Preparation Tips:
Stay updated with current trends and topics in your field.
Practice case studies and group discussions to improve analytical and communication skills.
Conclusion:
Overall, the interview process was thorough and challenging. Staying updated with industry trends and practicing case studies helped me perform well. For future candidates, I recommend focusing on both technical knowledge and soft skills to excel in such interviews.
Application Process: Applied via a recruitment consultant in May 2021.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
Calculate the angle between the minute hand and hour hand of a clock at a given period of time.
You have 2 unevenly greased ropes and 1 candle. Burning of 1 complete rope takes 1 hour. How will you calculate 45 minutes?
Your Approach:
For the clock angle question, I used the formula to calculate the angle based on the positions of the hour and minute hands.
For the ropes and candle problem, I thought about the burning rates and how to use both ropes to measure 45 minutes accurately.
Outcome: Passed the round.
Round 2 - Technical Interview:
Questions Asked:
Questions on every technology mentioned in my resume, including database queries and Java8 stream coding questions.
Your Approach:
I reviewed my resume thoroughly before the interview and practiced coding problems related to Java8 streams and SQL queries.
Outcome: Passed the round.
Round 3 - Client Interview:
Questions Asked:
Detailed questions about my experience and how I would handle specific client scenarios.
Your Approach:
I focused on providing practical examples from my past work to demonstrate my problem-solving and client-handling skills.
Outcome: Passed the round.
Round 4 - Client Interview:
Questions Asked:
More in-depth questions about my technical expertise and alignment with the client’s requirements.
Your Approach:
I ensured my answers were aligned with the job description and emphasized my ability to adapt to client needs.
Outcome: Passed the round.
Preparation Tips:
Thoroughly review every technology mentioned in your resume.
Practice database queries and Java8 stream coding problems.
Be prepared to discuss past experiences in detail, especially those relevant to client interactions.
Conclusion:
The interview process was rigorous but well-structured. Preparing for technical questions and client scenarios in advance helped me perform well. I would advise future candidates to focus on both technical and soft skills, as EY values a balance of both.
Questions Asked: Similar to the first round, with deeper questions on Python and Selenium.
Your Approach: I elaborated on my technical skills and provided examples of my work.
Outcome: Passed to the next round.
Round 3 - Coding Test:
Questions Asked: Practical coding problems to solve.
Your Approach: I tackled the problems methodically, ensuring my solutions were efficient and well-structured.
Outcome: Passed to the next round.
Round 4 - Coding Test:
Questions Asked: Another set of coding challenges.
Your Approach: I reviewed my code for errors and optimized it where possible.
Outcome: Passed to the next round.
Round 5 - Client Interview (Small Round):
Questions Asked: General questions about my experience and how I handle client interactions.
Your Approach: I highlighted my communication skills and past client-facing experiences.
Outcome: Passed to the next round.
Round 6 - Client Interview (Major Round):
Questions Asked: In-depth discussion about my projects and problem-solving abilities.
Your Approach: I provided detailed examples and explained my thought process clearly.
Outcome: Passed to the next round.
Round 7 - Client Interview (Major Round):
Questions Asked: Further technical and situational questions.
Your Approach: I remained confident and answered honestly, showcasing my expertise.
Outcome: Passed to the next round.
Round 8 - HR Interview:
Questions Asked: Typical HR questions about my background, salary expectations, and fit for the role.
Your Approach: I kept my answers professional and aligned with the company’s values.
Outcome: Successfully cleared the interview process.
Preparation Tips:
Be thorough with the fundamentals of Python and Selenium.
Practice coding problems to improve efficiency and accuracy.
Prepare for client-facing questions by reflecting on past experiences.
Conclusion:
The interview process was extensive but well-structured. I felt confident in my technical rounds, but I could have prepared more for the client interactions. My advice to future candidates is to focus on both technical and soft skills, as EY values a balanced skill set.
Application Process: I applied via a recruitment consultant and was interviewed in January 2022.
Interview Rounds:
Round 1 - Coding Test:
Questions Asked: MCQ-based test of 45 minutes covering ReactJS, JavaScript, HTML, CSS, and Git.
Your Approach: I reviewed the basics of these technologies and practiced MCQs to ensure I was comfortable with the format.
Outcome: Passed the round.
Round 2 - Technical Round:
Questions Asked:
What is Virtual DOM? How does it work & its algorithm?
React component life cycle in detail.
Higher-order components.
Basic JavaScript-based object/array logical codes (e.g., reverse a string in a different style).
Usage of map, reduce, filter.
Hooks (including names and their usage).
Redux basic functionality.
Your Approach: I focused on explaining concepts clearly and provided practical examples where applicable. For coding questions, I walked through my thought process step-by-step.
Outcome: Advanced to the next round.
Round 3 - Technical Round:
Questions Asked:
CSS Grid.
DOM.
CSS Position Properties.
HTML semantic tags.
Event propagation.
Hoisting in JavaScript.
Arrow vs. Normal Function.
Pure vs. Normal Components.
Your Approach: I ensured I understood the fundamentals of each topic and could explain them concisely. I also demonstrated how I would apply these concepts in real-world scenarios.
Outcome: Successfully cleared the round.
Preparation Tips:
Topics to Prepare: JavaScript, React.JS, HTML, CSS, GitHub, Redux, Hooks.
General Tips:
Showcase your ability to learn quickly and adapt.
Be thorough with the basics of the technologies you’re applying for.
Confidence is key during interviews.
Conclusion:
Overall, the interview process was thorough and focused on both theoretical knowledge and practical application. Being well-prepared with the fundamentals and demonstrating a willingness to learn helped me succeed. My advice to future candidates is to stay confident and ensure you can articulate your thought process clearly.
Application Process: Approached by the company and interviewed in April 2022.
Interview Rounds:
Round 1 - Resume Shortlist Round:
Outcome: Passed the initial screening based on my resume.
Round 2 - HR Round:
Questions Asked:
Your experience and qualifications.
Why do you want to change your job?
What is your current & expected CTC?
Your Approach: I answered honestly, focusing on my relevant experience and explaining my career goals for the change.
Outcome: Cleared the HR round.
Round 3 - One-on-one Round:
Questions Asked:
Explain your role in your current organization.
What tools and technology do you use?
Tell me a time when you made a suggestion for clients.
Can you show us some dashboards you created?
Your Approach: I detailed my responsibilities, listed the tools I use, shared a client success story, and presented my dashboard work.
Outcome: Advanced to the next round.
Round 4 - Technical Round:
Questions Asked:
Explain your total years of experience.
Tell us a story when you got appreciation from team leaders.
Show us the dashboards you have created and explain how you created them.
Do you know Power Query, SQL, Python? (Followed by technical questions on these.)
Your Approach: I highlighted my experience, shared a positive feedback story, demonstrated my dashboard skills, and answered technical questions confidently.
Outcome: Successfully cleared the technical round.
Round 5 - Client Interview Round:
Questions Asked:
Go through your resume.
A story when you suggested a plan of action and the result.
Show us a sample of your work.
Have you worked in the government sector before?
What technology do you use?
Your Approach: I walked through my resume, shared a problem-solving story, presented my work samples, and clarified my technology stack.
Outcome: Cleared the final round and received the offer.
Preparation Tips:
Be confident and answer questions in a storytelling mode.
Do not lie; admit if you don’t know something.
Keep samples of your work ready to showcase during the interview.
Conclusion:
The interview process was thorough but fair. Being prepared with my work samples and stories helped me stand out. I could have brushed up more on technical specifics, but overall, it was a great learning experience. For future candidates, authenticity and preparation are key!
Application Process: Applied via Naukri.com and was interviewed in August 2024.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
DAX Question related to Filter and Time Intelligence function.
Power BI Service features such as Gateways, RLS, Schedule Refresh.
Introduction and Current Role Project.
Power BI desktop features such as Tooltip, Drill Through filter, Bookmarks, etc.
Your Approach: Prepared thoroughly for DAX functions and Power BI features, focusing on practical applications.
Outcome: Successfully cleared the round.
Round 2 - Technical Round:
Questions Asked:
Incremental Refresh.
DAX questions related to Filter, Relationship, Table Manipulation, and Time Intelligence functions.
Power BI Services features.
SQL Interview Questions.
Introduction and Current Role Project.
Your Approach: Revised SQL concepts and Power BI services, emphasizing real-world scenarios.
Outcome: Cleared the round with positive feedback.
Round 3 - Technical Round:
Questions Asked:
Data Modeling Questions.
Data Warehousing Concepts such as SCD, Dimension and Fact Tables.
Scenario Question related to BI tool such as why you would consider this tool and how it differs from others.
Why are you leaving your last organization?
Current role in the Project and Introduction.
Your Approach: Focused on explaining data warehousing concepts clearly and justified my reasons for leaving the previous job professionally.
Outcome: Cleared the final round and received the offer.
Preparation Tips:
For SQL Learning: Ankit Bansal YouTube channel.
For Power BI:
DAX: Learnwidgiggs.
Other topics: Amit Chandak, Analytics With Nag playlist.
Recommended Books:
Reza Rad Book.
Power Query Book (Ken Puls).
Phillip Seamark and Marco Russo DAX book for deep understanding.
Conclusion:
The interview process was rigorous but well-structured. Focusing on practical applications of Power BI and SQL helped me clear the rounds. I recommend future candidates to thoroughly understand DAX and Power BI features, as well as data modeling concepts. Also, be prepared to explain your career decisions clearly.