Upload Button Icon Add office photos
Engaged Employer

i

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

OLX Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

OLX Business Analyst Interview Questions and Answers

Updated 14 Dec 2024

OLX Business Analyst Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Difference Between Rank and Dense Rank
  • Ans. 

    Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.

    • Rank does not skip ranks when there are ties, while Dense Rank does

    • Rank will have gaps in ranks if there are ties, while Dense Rank will not

    • Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row

  • Answered by AI
  • Q2. Some Basic Joins
  • Q3. Socks Pair Puzzle Qustions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare BASIC SQL and some puzzles questions

Interview questions from similar companies

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

I was interviewed in Aug 2024.

Round 1 - Aptitude Test 

The questions were related to Data Interpretation/Logical Reasoning and general aptitude.

Round 2 - One-on-one 

(3 Questions)

  • Q1. Questions related to SQL queries, window functions, 2-3 sql queries had to write
  • Q2. Statistics related questions, left skewed, right skewed etc.
  • Q3. Questions related to basics of ML
Round 3 - Case Study 

A company wants to open a new store, what would the factors you would consider.
A ride sharing company wants dynamic pricing in place of flat pricing, what factors you would consider.

Round 4 - HR 

(2 Questions)

  • Q1. General Project and HR related questions.
  • Q2. Things you want to improve in swiggy and metrics to measure and evaluate them.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with the JD, R2 won't be outside the JD. Practice puzzles also.
Interview experience
4
Good
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Not Selected

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

Round 1 - Coding Test 

SQL queries - 3. Was asked to write on notepad using the table structure given by interviewer

Interview Preparation Tips

Topics to prepare for Amazon Business Analyst interview:
  • Hackerrank
  • Stratascratch
  • Leetcode
Interview preparation tips for other job seekers - Practice SQL as much possible and listen to the Q carefully before answering. Ask Qs if needed.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Cohort Analysis in google analytics
  • Ans. 

    Cohort analysis in Google Analytics helps track the behavior of specific groups of users over time.

    • Cohort analysis groups users based on a common characteristic or behavior, such as sign-up date or acquisition channel.

    • It helps in understanding user retention, engagement, and conversion rates for different cohorts.

    • Example: Analyzing the retention rate of users who signed up in a particular month compared to users who si

  • Answered by AI
  • Q2. Types of join in sql and their differences
  • Ans. 

    Types of joins in SQL include inner join, outer join, left join, right join, and full join.

    • Inner join: returns rows when there is a match in both tables

    • Outer join: returns all rows from both tables, filling in NULLs for missing matches

    • Left join: returns all rows from the left table and the matched rows from the right table

    • Right join: returns all rows from the right table and the matched rows from the left table

    • Full joi...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basis CAT like aptitude with 2 simple python coding question

Round 2 - One-on-one 

(1 Question)

  • Q1. What Central limit theorem
  • Ans. 

    The Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.

    • States that the sampling distribution of the sample mean will be approximately normally distributed regardless of the shape of the population distribution

    • Helps in making inferences about the population mean based on the sample mean

    • Important concept in statistics and hypothesis...

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

I was interviewed in Oct 2023.

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 - Aptitude Test 

Python, SQL, Quant, Statistics, Numpy

Round 3 - One-on-one 

(2 Questions)

  • Q1. SQL, Python, Puzzle total 9Q
  • Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Round 4 - One-on-one 

(1 Question)

  • Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Find 3rd highest salary using SQL
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.

    • Use SELECT statement to retrieve salary column

    • Use ORDER BY clause to sort salaries in descending order

    • Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary

  • Answered by AI
  • Q2. Queries on self join
Round 2 - Technical 

(1 Question)

  • Q1. Questions on Power B, DAX etc.,

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 8 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. They will ask about your profile and past experience.
Round 3 - Technical 

(1 Question)

  • Q1. A peer level colleague will ask some basic knowledge check questions
Round 4 - Coding Test 

This is literally a live coding test. For analytics expect SQL, python, R.

Round 5 - One-on-one 

(1 Question)

  • Q1. Interviewed by a manager of another team
Round 6 - One-on-one 

(1 Question)

  • Q1. Interviewed by dotted line reporting manager
Round 7 - One-on-one 

(1 Question)

  • Q1. Cross functional interview
Round 8 - One-on-one 

(1 Question)

  • Q1. Core Values Interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Know the core values, remember them, understand them and embody them. And being good at your advertised skills also helps.

I applied via Company Website and was interviewed in Feb 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Asking about yourself and asking of other knowledge and consulting knowledge.

Interview Preparation Tips

Topics to prepare for Indiamart Intermesh Business Analyst interview:
  • Sales
Interview preparation tips for other job seekers - Be prepared for the first time interview and be confident in yourself and date to answer all the questions about all.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduction and explain any one of the projects plus what was the analytics you used
  • Ans. 

    Implemented a project to optimize marketing campaigns using predictive analytics

    • Developed a predictive model to identify the most effective marketing channels

    • Utilized data from past campaigns to train the model

    • Used techniques such as regression analysis and decision trees to analyze the data

    • Generated insights on customer behavior and preferences to improve campaign targeting

  • Answered by AI
  • Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very very well prepared with SQL and you should be aware of advanced sql, not only concepts but solving questions

OLX Interview FAQs

How many rounds are there in OLX Business Analyst interview?
OLX interview process usually has 1 rounds. The most common rounds in the OLX interview process are Technical.
How to prepare for OLX 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 OLX. The most common topics and skills that interviewers at OLX expect are SQL, Python, Power Bi, R and Analytics.
What are the top questions asked in OLX Business Analyst interview?

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

  1. Difference Between Rank and Dense R...read more
  2. Socks Pair Puzzle Qusti...read more
  3. Some Basic Jo...read more

Tell us how to improve this page.

OLX Business Analyst Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more
OLX Business Analyst Salary
based on 10 salaries
₹3 L/yr - ₹9.7 L/yr
26% less than the average Business Analyst Salary in India
View more details
Dealer Success Manager
152 salaries
unlock blur

₹3 L/yr - ₹6.3 L/yr

Key Account Manager
141 salaries
unlock blur

₹3.2 L/yr - ₹8.9 L/yr

Accounts Manager
119 salaries
unlock blur

₹2.7 L/yr - ₹7 L/yr

Senior Accounts Manager
70 salaries
unlock blur

₹3.9 L/yr - ₹8 L/yr

Retail Associate
65 salaries
unlock blur

₹2.9 L/yr - ₹6 L/yr

Explore more salaries
Compare OLX with

Quikr

3.7
Compare

eBay

3.8
Compare

Tokopedia

4.0
Compare

Flipkart

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