Premium Employer

i

This company page is being actively managed by PolicyBazaar Team. If you also belong to the team, you can get access from here

PolicyBazaar Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

PolicyBazaar Business Analyst Interview Questions and Answers

Updated 14 Jan 2025

PolicyBazaar Business Analyst Interview Experiences

6 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Joins and their output
  • Ans. 

    Joins are used in SQL to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • INNER JOIN returns rows when there is at least one match in both tables

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table

    • RIGHT JOIN re...

  • Answered by AI
  • Q2. Employees who earn more than their manager

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Sumifs Functions
  • Q2. Vlookup Function

Interview Preparation Tips

Interview preparation tips for other job seekers - Based on my experience there is lack of hospitality & the interviewer was rude don't know a formal basic speaking btw the interview level is average of below average. Keep one thing in mind that they are looking for an MIS type person on a Business Analyst name. If you are a Business analyst and working on Strategy Implementation and execution part then it may not be a right fit. However, if you still wish to proceed please prepare for the following Topics:

Advance Excel -

Sumifs formula may be they will ask a commission payout question in which you have to find the commission payout value then in Sheet 1 you have the master data, sheet 2 you have Commission percentage in sheet 3 you have to do work

Then use the sumifs formula for just reference i am writing the formula here

=sumifs for the total & join the formula with vlookup for % calculation

in SQL they might ask the questions
-DDL & DML
-Group query etc.

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with ... read more
asked in Infosys
Q2. What is your strong point in terms of technical knowledge? Like J ... read more
Q3. There are 100 people standing in a circle, the first person has a ... read more
asked in Paytm
Q4. Sum of Squares of First N Natural Numbers Problem Statement You a ... read more
asked in EXL Service
Q5. If I have 333 digits to number pages of a book, How many pages ca ... read more
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic Sql questions
  • Q2. Basic python questions
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What analysis you have done in your previous organization
  • Q2. Find third manager for an employee on sql
  • Ans. 

    Use SQL query to find the third manager for an employee

    • Join the employee table with the manager table on the manager_id

    • Use a subquery to count the number of managers for the employee

    • Filter the results to only include the third manager

  • Answered by AI

Skills evaluated in this interview

PolicyBazaar interview questions for designations

 Senior Business Analyst

 (2)

 Quality Analyst

 (2)

 Senior Analyst

 (1)

 Data Analyst

 (1)

 Business Development Executive

 (1)

 Business Analytics

 (1)

 Senior Quality Analyst

 (2)

 (Bde)business Development Executive

 (1)

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Case Study 

Question regarding convergence rate

Round 2 - Technical 

(2 Questions)

  • Q1. Sql triggers code
  • Q2. Vlookup, hlookup, match and indexing
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Details about yourself
  • Q2. Personal information
Round 3 - Assignment 

They asked question from sql from join group by and from excel they asked about xlookup, vlookup, sumif,countif etc

Interview Preparation Tips

Topics to prepare for PolicyBazaar Business Analyst interview:
  • SQL
  • Advanced Excel
  • guestimate
  • communication
Interview preparation tips for other job seekers - this round is from manager they asked question from guestimate, and about projects you have done

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. How would you sell a simple pen for 1 lakh.
  • Ans. 

    This pen is not just a writing instrument, it's a statement of luxury and exclusivity.

    • Highlight the pen's unique design and craftsmanship

    • Emphasize the use of high-quality materials

    • Mention any special features or functions

    • Create a sense of exclusivity and rarity

    • Appeal to the buyer's desire for luxury and status

    • Offer personalized engraving or customization options

  • Answered by AI

I applied via Company Website and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself
  • Q2. Where do you see 5 years ahead in future?

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good.

I applied via Naukri.com and was interviewed in Jan 2021. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What's your weakness and strength?
  • Ans. 

    My strength is my analytical skills and attention to detail. My weakness is that I can be overly critical of my own work.

    • Strength: Analytical skills

    • Strength: Attention to detail

    • Weakness: Overly critical of my own work

  • Answered by AI
  • Q2. Where do you want to be in this organization?
  • Ans. 

    I want to be in a position where I can contribute to the growth and success of the organization.

    • I aspire to be in a role where I can utilize my skills and expertise to drive positive change and make a significant impact.

    • I am motivated to work towards achieving the organization's goals and objectives.

    • I am eager to take on more responsibilities and challenges to further develop my skills and knowledge.

    • I want to be part o...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself and be confident.

Interview Questionnaire 

5 Questions

  • Q1. What is interview?
  • Ans. 

    An interview is a formal conversation between an employer and a job candidate to assess their suitability for a role.

    • Interviews are used to evaluate a candidate's skills, experience, and personality.

    • They can be conducted in person, over the phone, or via video conferencing.

    • Interviews typically involve a series of questions and may include assessments or tests.

    • Examples of common interview questions include 'Tell me abou

  • Answered by AI
  • Q2. If you selected by the interviewers then firstly what you will do?
  • Q3. Before interview what type of stress loaded on your brain?
  • Q4. Ehat you will do with your first selary?
  • Ans. 

    I plan to save a portion, invest in professional development, and treat myself to a small reward.

    • Save a portion of the salary for future financial goals

    • Invest in professional development such as courses or certifications

    • Treat myself to a small reward or experience as a form of celebration

  • Answered by AI
  • Q5. When you join your first day at job then what is your responsibility.

Interview Preparation Tips

Interview preparation tips for other job seekers - i want to say only that when i started my job till end of job i doing my work with anthusiasam.

PolicyBazaar Interview FAQs

How many rounds are there in PolicyBazaar Business Analyst interview?
PolicyBazaar interview process usually has 1-2 rounds. The most common rounds in the PolicyBazaar interview process are Technical, Case Study and Resume Shortlist.
How to prepare for PolicyBazaar Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at PolicyBazaar. The most common topics and skills that interviewers at PolicyBazaar expect are SQL, Advanced Excel, Business Analysis, Excel and JIRA.
What are the top questions asked in PolicyBazaar Business Analyst interview?

Some of the top questions asked at the PolicyBazaar Business Analyst interview -

  1. Find third manager for an employee on ...read more
  2. Joins and their out...read more
  3. Vlookup, hlookup, match and index...read more

Tell us how to improve this page.

PolicyBazaar Business Analyst Interview Process

based on 7 interviews

1 Interview rounds

  • Technical Round
View more
Join PolicyBazaar Let's find you the Best Insurance
PolicyBazaar Business Analyst Salary
based on 68 salaries
₹4.3 L/yr - ₹15 L/yr
11% less than the average Business Analyst Salary in India
View more details

PolicyBazaar Business Analyst Reviews and Ratings

based on 6 reviews

3.0/5

Rating in categories

2.7

Skill development

2.9

Work-life balance

3.1

Salary

3.4

Job security

2.9

Company culture

2.8

Promotions

3.2

Work satisfaction

Explore 6 Reviews and Ratings
Sales Executive
1.2k salaries
unlock blur

₹1.6 L/yr - ₹5 L/yr

Associate Sales Consultant
1.1k salaries
unlock blur

₹1.5 L/yr - ₹6 L/yr

Relationship Manager
910 salaries
unlock blur

₹2.2 L/yr - ₹6 L/yr

Sales Associate
387 salaries
unlock blur

₹1.5 L/yr - ₹5.2 L/yr

Team Lead
376 salaries
unlock blur

₹3.1 L/yr - ₹12.2 L/yr

Explore more salaries
Compare PolicyBazaar with

Amazon

4.0
Compare

Flipkart

3.9
Compare

Indiamart Intermesh

3.6
Compare

BigBasket

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview