
PolicyBazaar Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 8 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at PolicyBazaar.
Business Analyst
It was a bad and frustrating experience, I went through 5 rounds, with two face-to-face interviews, nothing went wrong and still didn’t get the offer. If they had a different candidate or budget constraints in mind, they shouldn’t have dragged me along till the last.
- Can you tell me about your experience with SQL?
- How proficient are you with Excel?
- Let's do a guesstimate question.
Business Analyst
It was pretty straightforward, with a strong emphasis on technical abilities such as SQL and advanced Excel. They presented some case scenarios to assess your analytical thinking. There were no language restrictions, so you could use Hindi or English as you preferred.
- Could you solve a case study involving Vlookup and if statements?
Business Analyst
There were three rounds. First was HR, just screening my resume. The second round was technical. They asked questions about advanced SQL, basic python, pandas and Excel. The third round was about the projects I have on my resume, asking about the process and tools used. The whole thing was pretty quick and not too hard.
- Can you write a query to find the 3rd highest salary using a subquery?
- Can you solve the same problem of finding the 3rd highest salary using a window function?
PolicyBazaar Business Analyst Interview Questions
Quoted word for word from PolicyBazaar interview reports.
“What are the differences between group by and pivot?”
Read reports →“Can you write a query to find the 3rd highest salary using a subquery?”
Read reports →“Can you solve the same problem of finding the 3rd highest salary using a window function?”
Read reports →“Tell me about Pandas libraries.”
Read reports →“Can you explain the distinctions between INNER JOIN, LEFT JOIN, and RIGHT JOIN in SQL, and give an example scenario for using each one?”
Read report →“Describe aggregate questions.”
Read report →“Can you explain SQL concepts?”
Read report →“Could you solve a case study involving Vlookup and if statements?”
Read report →“What do you know about the insurance industry?”
Read report →Formats, difficulty and experience
Across all 8 PolicyBazaar interview reports.