Ola Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 38 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Ola.
Ola
Business Analyst
Entry Easy Positive experience Decline offer 3 rounds
Interview process
Recruiter call Phone screen Technical screen
Interview formats
Technical Coding
The interview is mostly about checking if you know the basics and fundamental stuff. It's a lot about thinking logically, solving problems, and how you approach things with clear, structured thinking. They want to see that you have a good grasp of the core subjects and can think critically and use what you know in real situations.
Confirmed questions4 questions
- Can you explain JOINS?
- What about Order Execution?
- Do you know Python, specifically Pandas?
Ola
Business Analyst
Mid Average Neutral experience Decline offer 3 rounds
Interview process
Phone screen Technical screen Panel
Interview formats
Technical Behavioral
There were three rounds- First was a telephonic interview with basic SQL questions. Second, a technical round one to one with an interviewer covering resume, SQL, ML, and Excel. Third, a managerial round focusing on Key Performance Indicators and HR questions.
Confirmed questions5 questions
- Tell me about your resume.
- Can you answer some SQL questions?
- Do you have experience with ML?
Ola
Business Analyst
Senior Average Neutral experience Accept offer 1 round
Interview process
Technical screen
Interview formats
Technical Coding
The interview went pretty smoothly, and the questions weren't overly difficult. There was a focus on unstructured market sizing through guesstimates, along with questions about Excel and SQL. Essentially, I was asked to write a SQL loop and then replicate that functionality in Excel using built-in formulas, excluding any macros.
Confirmed questions3 questions
- Could you estimate the number of flights arriving at Delhi airport daily?
- How would you write a loop in SQL?
- How can you implement the logic of a SQL loop in Excel using formulas, without using macros?
Ola Business Analyst Interview Questions
Quoted word for word from Ola interview reports.
“Given a bag with 5 red and 5 blue balls, what's the probability of drawing all red balls?”
Read reports →“Could you estimate the number of flights arriving at Delhi airport daily?”
Read reports →“What is the basic probability regarding balls and urns?”
Read reports →“Can you express 2019 as the sum of two numbers, each raised to a power, in the form x^y + y^x, using integers?”
Read reports →“What is your guess for the number of trees on campus?”
Read report →“Explain how to create a table in SQL and demonstrate how this can be achieved using Python.”
Read report →“What is the economic viability of adding a new premium cab?”
Read report →“How do you identify users who exist in both tables?”
Read report →“How would you find the second highest salary in SQL?”
Read report →Formats, difficulty and experience
Across all 38 Ola interview reports.