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

I applied via Naukri.com and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

6 Questions

  • Q1. Tell me about your self
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • Experienced in conducting market research and competitor analysis

    • Proficient in using various data analysis tools such as Excel, SQL, and Tableau

    • Skilled in identifying business needs and translating them into functional requirements

    • Excellent communication and presentation skills

    • Ability to work colla...

  • Answered by AI
  • Q2. What do you want work here?
  • Ans. 

    I want to work here because of the company's reputation, growth opportunities, and alignment with my skills and interests.

    • I am impressed by the company's reputation in the industry.

    • I see great potential for growth and advancement within the company.

    • The company's values and mission align with my own.

    • I believe my skills and experience would be a valuable asset to the company.

    • I am excited about the opportunity to contribu...

  • Answered by AI
  • Q3. What makes you unique?
  • Ans. 

    I have a unique combination of technical skills and business acumen, allowing me to bridge the gap between IT and business stakeholders.

    • I have a strong background in both technology and business domains.

    • I can effectively communicate with both technical and non-technical stakeholders.

    • I have a track record of successfully translating business requirements into technical solutions.

    • I possess a deep understanding of various...

  • Answered by AI
  • Q4. What do you know about the company?
  • Ans. 

    The company is a leading technology firm specializing in software development and consulting services.

    • The company was founded in 2005 and has since grown to have a global presence.

    • They offer a wide range of services including business analysis, software development, and project management.

    • Some of their notable clients include Fortune 500 companies in various industries.

    • They have a strong focus on innovation and staying...

  • Answered by AI
  • Q5. What are your key professional strengths?
  • Ans. 

    My key professional strengths include analytical thinking, problem-solving, and effective communication.

    • Analytical thinking: I have a strong ability to analyze complex business problems and identify key insights.

    • Problem-solving: I am skilled at finding creative solutions to challenges and implementing them effectively.

    • Effective communication: I can communicate complex ideas and findings clearly and concisely to stakeho...

  • Answered by AI
  • Q6. What are your biggest weaknesses?
  • Ans. 

    My biggest weaknesses include perfectionism, overthinking, and public speaking anxiety.

    • Perfectionism: I tend to spend too much time on tasks to ensure they are flawless.

    • Overthinking: I sometimes overanalyze situations, which can lead to indecisiveness.

    • Public speaking anxiety: I get nervous when presenting in front of large audiences.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Tension free
Practice, practice, practice.

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Mainly about sql, previous job role

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.

I applied via Company Website and was interviewed before Oct 2021. There were 4 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 - Coding Test 

There is one OA after your interview shortlisted based on your domain or profile.

Round 3 - Technical 

(1 Question)

  • Q1. 2 technical interview will be there both are elimination round.interview related to your field.
Round 4 - HR 

(1 Question)

  • Q1. Before HR there is team round for which you are going to be hired after that there is final HR round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for your domain and read well about job profile,good luck.

I applied via Naukri.com and was interviewed in Jan 2022. 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 - One-on-one 

(2 Questions)

  • Q1. Explain group by clause with used cases
  • Ans. 

    Group by clause is used to group data based on a specific column in a table.

    • Used with aggregate functions like SUM, COUNT, AVG, etc.

    • Helps in analyzing data by grouping it based on a common attribute.

    • Can be used with multiple columns to create nested groups.

    • Example: GROUP BY department in a table of employees to get the total salary for each department.

  • Answered by AI
  • Q2. CountA,CountB,Countif used case in Google sheet
  • Ans. 

    CountA, CountB, Countif are functions used in Google Sheets to count cells based on certain criteria.

    • CountA counts the number of cells in a range that are not empty.

    • CountB counts the number of cells in a range that are not blank.

    • Countif counts the number of cells in a range that meet a certain condition.

    • Countif can be used with operators like >, <, =, and functions like AND, OR.

    • Countif can also be used with wildcards l

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Where have stayed...why want to switch...what will be your priority ..job or family

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview always on basic knowledge of MS SQL,and have strong knowledge on advanced MS Excel,basic knowledge on python,..but if you are fresher and showing projects on your resume.they can ask you from your project..So required end to end strong knowledge on the projects you have shown in your resume

Skills evaluated in this interview

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 

(4 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?
  • Q4. Tell me about yourself.
Round 3 - Technical 

(1 Question)

  • Q1. Sql, tableau, excel relates questions asked, it difficult but i focused on basics
Round 4 - HR 

(3 Questions)

  • Q1. Share details of your previous job.
  • Q2. What is your family background?
  • Q3. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Check the technical interview questions from YouTube before going
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
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Aug 2023.

Round 1 - Coding Test 

Simple python related and sql based question

Round 2 - One-on-one 

(2 Questions)

  • Q1. How to incentivise regular customer
  • Ans. 

    Regular customers can be incentivized through loyalty programs, personalized discounts, exclusive offers, and rewards points.

    • Implement a loyalty program where customers earn points for each purchase, which can be redeemed for discounts or free items.

    • Offer personalized discounts based on the customer's purchase history or preferences.

    • Provide exclusive offers or early access to new products/services for regular customers...

  • Answered by AI
  • Q2. Why discounting is way to incentivise inactive customer
  • Ans. 

    Discounting is a way to incentivize inactive customers by offering them reduced prices or special deals to encourage them to make a purchase.

    • Discounting can help attract the attention of inactive customers who may have lost interest in the product or service.

    • It can create a sense of urgency and motivate customers to take action before the discount expires.

    • Discounting can also help clear out excess inventory or generate...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - it was normal

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
27% less than the average Business Analyst Salary in India
View more details
Key Account Manager
149 salaries
unlock blur

₹3.2 L/yr - ₹8.6 L/yr

Dealer Success Manager
149 salaries
unlock blur

₹3 L/yr - ₹6.3 L/yr

Accounts Manager
109 salaries
unlock blur

₹2.7 L/yr - ₹6.8 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.1
Compare

Flipkart

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