AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
OLX
Compare
Filter interviews by
Clear (1)
OLX Business Analyst Interview Questions and Answers
OLX Business Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(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
- Q2. Some Basic Joins
- Q3. Socks Pair Puzzle Qustions
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. Question 1: General HR questions, some based on the CV Question 2: A marketing specific question
Interview Preparation Tips
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Duration: 40 minutes
Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Duration: 50 minutes
Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.
Skills: Communication And Confidence, Analytical Skills, Business Logic, Business Acumen
College Name: Institute of Management, Nirma University
Aman Tomar
Interview Questionnaire
3 Questions
- Q1. General HR questions, some based on the CV
- Q2. A marketing specific question
- Q3. Weight of an aircraft
- Ans.
The weight of an aircraft is crucial for its performance and safety.
The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.
The weight of an aircraft is measured in pounds or kilograms.
The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.
Aircraft manufacturers provide maximum takeoff and la...
Interview Preparation Tips
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.
Round: Guesstimate Interview
Experience: A very commonly asked guesstimate problem. Ask as many questions as possible to clear out the situation for yourself and get enough hints to solve the problem. Break it down into smaller sections and solve each section individually.
Tips: Follow "case in point", Analytics Vidya and similar blogs and websites to practice more and more guesstimates.
General Tips: There are so many opportunities. You just need one. Be focused on that ONE.
Skill Tips: Take part in discussions among your friends. Read books and quora to get more content. Practice as many questions as possible for aptitude. Discuss problems and have critical analysis sessions to understand things with a company's perspective.
Skills: Communication , Aptitude, Business Acumen
College Name: IIT GUWHATI
Motivation: To learn the operations and Logistics of the e-commerce industry.
Funny Moments: There will be many while you'll be preparing with your friends. :D
All the best.
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. SQL, Business cases
Interview Preparation Tips
I was interviewed before Nov 2019.
Interview Questionnaire
6 Questions
- Q1. Visualize a Uber database of drivers and riders(users) and write a SQL query to get the top 100 drivers by city.
- Ans.
SQL query to get top 100 Uber drivers by city
Join drivers and users tables on city
Aggregate driver ratings and count of rides
Order by rating and count of rides
Limit to top 100
- Q2. How do you optimize the listing of Restaurants on Swiggy?
- Ans.
Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.
Analyze user behavior and preferences to understand their needs and preferences
Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time
Optimize search functionality to ensure accurate and relevant results
Collaborate with restaurants to imp...
- Q3. What are the major differences between a Linear Regression and a Logistic Regression?
- Ans.
Linear Regression is used for continuous data while Logistic Regression is used for categorical data.
Linear Regression predicts continuous values while Logistic Regression predicts probabilities.
Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.
Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.
Linear Regression is...
- Q4. What is the Bias Variance trade-off and name some models with high bias and low variance?
- Ans.
Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.
Bias-Variance trade-off is a fundamental concept in machine learning.
High bias models are simple and have low variance, but are inaccurate.
Low bias models are complex and have high variance, but can overfit the data.
Examples of high bias models are linear r...
- Q5. A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
- Ans.
Possible reasons for a car manufacturer's decline in profits by 40% year over year
Decreased demand for cars due to economic downturn
Increased competition from other car manufacturers
Rising production costs and expenses
Decline in consumer confidence and spending
Changes in government regulations impacting the automotive industry
- Q6. If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the de...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Referral and was interviewed before Apr 2021. There were 3 interview rounds.
(3 Questions)
- Q1. Why are you looking for a change?
- Q2. Tell me about yourself.
- Q3. Why should we hire you?
Basic sql
(1 Question)
- Q1. Project manager round
Interview Preparation Tips
Neelesh Shekhar
Interview Questionnaire
5 Questions
- Q1. Why Snapdeal. Why reject Flipkart PPO
- Ans.
I chose Snapdeal over Flipkart because of its unique business model and growth potential.
Snapdeal offers a unique marketplace model that allows sellers to directly connect with customers, giving them more control over their business.
Snapdeal has shown consistent growth and has a strong presence in tier 2 and tier 3 cities, which presents a huge untapped market.
Snapdeal's focus on customer satisfaction and providing a p...
- Q2. Short term & Long term aims in Life
- Ans.
Short term aim is to excel in my role as a business analyst and contribute to the success of the company. Long term aim is to become a senior business analyst and eventually a business consultant.
Short term aim: Excel in my role as a business analyst
Short term aim: Contribute to the success of the company
Long term aim: Become a senior business analyst
Long term aim: Transition into a business consultant role
- Q3. What are you seeking from this Job
- Q4. Number of sparrows in IIT KGP
- Ans.
The number of sparrows in IIT KGP is unknown.
The exact number of sparrows in IIT KGP is not available.
There is no specific data on the population of sparrows in IIT KGP.
The number of sparrows in IIT KGP is not documented.
No information is available regarding the count of sparrows in IIT KGP.
- Q5. Road length of Ahmedabad
- Ans.
The road length of Ahmedabad is approximately 2,500 kilometers.
Ahmedabad has a well-developed road network.
The road length includes both national highways and city roads.
The road length is constantly expanding due to urban development and infrastructure projects.
Major roads in Ahmedabad include the SG Highway, Ashram Road, and C.G. Road.
Interview Preparation Tips
Experience: Simple questions. Accuracy and speed were determining factors.
Tips: Practice Quant/Give online Quant & LR tests.
Duration: 12 minutes
Total Questions: 50
Round: Resume Shortlist
Experience: CV Should carry proper format, action verbs . Impacts created (preferably numerical ) should be exclusively mentioned for each project under internships.
Tips: An E-Commerce internship background are an add-on. SQL , Google analytics , R Software knowledge are an advantage.
Round: Group Activity
Experience: Topic for GD : Impact of Coal-Gate scam on Indian economy.
Tips: Be updated about current affairs. Subscribe economic times or business standard. Don't create a fish market in the GD. put your points clearly and conclude what the entire group has agreed with
Round: Guesstimate Interview
Experience: Was able to do them. Prior consulting internships helped.
Tips: Practice Case in point. Have a well structured and calculative approach.
Round: HR Interview
Experience: Normal HR type questions. They see your attitude towards life and your work style.
Tips: Prepare well for them. These questions are not new or different for any interview,
College Name: IIT KHARAGPUR
Interview Questionnaire
2 Questions
- Q1. What are tree traversals?
- Ans.
Tree traversals are methods of visiting all nodes in a tree data structure.
There are three types of tree traversals: in-order, pre-order, and post-order.
In-order traversal visits the left subtree, then the root, then the right subtree.
Pre-order traversal visits the root, then the left subtree, then the right subtree.
Post-order traversal visits the left subtree, then the right subtree, then the root.
Tree traversals are ...
- Q2. What is pre-order and post-order?
- Ans.
Pre-order and post-order are traversal methods used in binary trees.
Pre-order: visit root, left subtree, right subtree
Post-order: visit left subtree, right subtree, root
Used to traverse binary trees and perform operations on nodes
Example: Pre-order traversal of binary tree: A, B, D, E, C, F, G
Example: Post-order traversal of binary tree: D, E, B, F, G, C, A
Interview Preparation Tips
Experience: I consulted my seniors for preparation of my resume. I believe that seniors provide the best provide you with the best possible insights in this regards.
Round: Test
Experience: The first round was the written test. There were 8 theoretical questions asked in the paper. The questions were either in the form of puzzles or probability based questions. The first three questions in the paper were compulsory questions and needed to be answered correctly for the rest of your paper to be evaluated; if a particular candidate answered any one of these questions incorrectly then he was rejected then and there. Apart from these 3 questions solving 2 more questions would have assured a candidate’s chance of getting selected for the next round. The duration of the test was of around 40 minutes.
For the written test nearly 300 people appeared out of which 30-40 were shortlisted for the interviews.
Round: Puzzle Interview
Experience: In the interview I was asked few puzzles and few coding problems.
Some puzzles asked were:
1) There are 3 couples (each couple consists of a man and a woman: husband and wife pair) who want to cross a particular river with only one boat available for the voyage. At a time the boat can carry a maximum of 2 people and a woman cannot stay in presence of other male in absence of her husband. All three couples want to cross the river, what are the ways in which this could be done?
2) There are 2 ropes which burn in 60 minutes. How to measure 45 minutes without cutting any of the ropes?
In the coding questions the interviewers did not ask me to write down the complete codes of the problems, they only asked me to suggest some suitable algorithms. In one of the questions they gave me a binary number and asked me to write down the algorithm to calculate the number of one’s in the binary number.
Round: Technical Interview
Experience: In second round of interview I was asked some hardcore programming questions on data structures since I wrote it as my area of interest. Some of the questions asked were:
If you have an array of ‘n+m’ elements and have these ‘n’ elements separately and you have to transfer these n elements in the n+m element slot which already contains the m elements. The transfer has to be done in such a way that all the m+n elements are sorted.
I was asked some puzzles as well. For instance in one of the puzzles, I was given a square consisting of 9 dots on its periphery. I was asked to join those 9 dots using 4 lines without lifting the pencil.
College Name: IIT ROORKEE
Skills evaluated in this interview
I was interviewed before Apr 2021.
(1 Question)
Round duration - 60 minutes
Round difficulty - Easy
In the interview I was asked few puzzles and few coding problems.
In the coding questions the interviewers did not ask me to write down the complete codes of the problems, they only asked me to suggest some suitable algorithms.
- Q1.
Count Set Bits Problem Statement
Given a positive integer
N, find the total number of '1's in the binary representation of all the numbers from 1 toN.You should return the result modulo 109+7 as the co...
- Ans.
Count the total number of set bits in the binary representation of numbers from 1 to N, modulo 10^9+7.
Iterate through numbers from 1 to N and count the set bits in their binary representation
Use bitwise operations to count set bits efficiently
Return the total count modulo 10^9+7 as the result
(1 Question)
Round duration - 45 minutes
Round difficulty - Easy
In second round of interview I was asked some hardcore programming questions on data structures since I wrote it as my area of interest.
I was asked some puzzles as well.
- Q1.
Merge Two Sorted Arrays Problem Statement
Given two sorted integer arrays
ARR1andARR2of size M and N, respectively, merge them intoARR1as one sorted array. Assume thatARR1has a size of M + N to hol... - Ans.
Merge two sorted arrays into one sorted array in place.
Iterate from the end of both arrays and compare elements to merge in place
Use two pointers to keep track of the current position in both arrays
Handle cases where one array is fully merged before the other
Interview Preparation Tips
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
Interview Preparation Tips
Experience: I had a standard resume for this company as per our institute placement cell norms.
I prepared resume keeping in mind the areas of interest that would suit the company’s requirements. The companies that recruit students from all departments usually tend to recruit students seeking interests in subjects related to management. I knew about this and while applying to non-core companies I specified my areas of interest as these subjects.
Round: Test
Experience: The first round was the written test. The paper was composed of general aptitude and basic programming questions. For programming questions we were told that in case we did not know the desired syntaxes we could write the algorithm for the problems. Since I was not a proficient coder I preferred writing only the algorithm for the coding questions. There were also some logical reasoning questions (mainly puzzle types). For example in one of the questions we were given a multi coloured cube with each side having a different colour. Initially the cube was kept with the blue colour appearing on the top surface; then the cube was rotated along various axes, we had to specify which colour would appear on the top surface. I qualified the first round.
Round: HR Interview
Experience: The second round was an aptitude interview round. In this interview I was asked about the preference with respect to the profiles ordered (programming or analytics). I replied that I would like to join the company as an analyst, however if given an option I would be open to learning programming as well. The interviewers were delighted to know about my interests in learning newer things.
The interview further asked me puzzle based logical reasoning questions like ‘How to find the odd coin out of 8 coins of which 7 are similar in all senses in two weighing steps by use of a balance?’ He asked me few more of these types; I successfully managed to answer all these questions.
Round: HR Interview
Experience: The final round was again a personal interview. This was actually supposed to be a profile specific interview; however since I had earlier said that I was open to getting recruited in both the profiles they asked me questions from programming as well as analytical questions. I informed them again that I was interested in learning programming but did not have much clue about it at that time. They did not pay any heed whatsoever to my plea and kept asking me questions related to programming. They asked me some questions and told me to suggest some algorithm for those questions since I did not know coding. I framed some algorithms but they did not seem very convinced with my answers. Eventually I was not recruited.
Tips: As per my experience I would say that knowledge about C++ is necessary to get into the software section of Snapdeal. They want people who are well versed with puzzle solving questions and who can solve analytical questions easily.
College Name: IIT ROORKEE
Motivation: I got to know about the company and the profile through the pre-placement talk by the company. The company is one of the leading e-commerce website today and is quite famous among the youth. Hence I had knowledge about its existence and field of work beforehand.
OLX Interview FAQs
Recently Viewed
INTERVIEWS
Bio-Rad Laboratories
No Interviews
INTERVIEWS
Osstem Implant India
No Interviews
INTERVIEWS
OLX
No Interviews
DESIGNATION
INTERVIEWS
Ciena
No Interviews
INTERVIEWS
Randox Laboratories India Private Limited
No Interviews
INTERVIEWS
OLX
No Interviews
INTERVIEWS
Ciena
No Interviews
INTERVIEWS
OLX
No Interviews
SALARIES
Ciena
Tell us how to improve this page.
OLX Interviews By Designations
- OLX Retail Associate Interview Questions
- OLX Dealer Success Manager Interview Questions
- OLX Sales & Marketing Interview Questions
- OLX Dealer Relationship Manager Interview Questions
- OLX Software Developer Interview Questions
- OLX Accounts Payable Executive Interview Questions
- OLX Key Account Manager Interview Questions
- OLX Senior Android Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
OLX Business Analyst Interview Process
based on 2 interviews
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
|
Dealer Success Manager
152
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Key Account Manager
141
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Accounts Manager
119
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Accounts Manager
70
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Retail Associate
65
salaries
| ₹0 L/yr - ₹0 L/yr |
Quikr
eBay
Tokopedia
Flipkart
- Home >
- Interviews >
- OLX Interview Questions >
- OLX Business Analyst Interview Questions
