i
OLX
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
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
Top trending discussions
I was interviewed in Aug 2024.
The questions were related to Data Interpretation/Logical Reasoning and general aptitude.
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.
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
SQL queries - 3. Was asked to write on notepad using the table structure given by interviewer
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
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...
Basis CAT like aptitude with 2 simple python coding question
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...
I was interviewed in Oct 2023.
Python, SQL, Quant, Statistics, Numpy
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
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
I applied via Approached by Company and was interviewed before Apr 2022. There were 8 interview rounds.
This is literally a live coding test. For analytics expect SQL, python, R.
I applied via Company Website and was interviewed in Feb 2022. There were 2 interview rounds.
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
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.
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
based on 2 interviews
Interview experience
Dealer Success Manager
152
salaries
| ₹3 L/yr - ₹6.3 L/yr |
Key Account Manager
141
salaries
| ₹3.2 L/yr - ₹8.9 L/yr |
Accounts Manager
119
salaries
| ₹2.7 L/yr - ₹7 L/yr |
Senior Accounts Manager
70
salaries
| ₹3.9 L/yr - ₹8 L/yr |
Retail Associate
65
salaries
| ₹2.9 L/yr - ₹6 L/yr |
Quikr
eBay
Tokopedia
Flipkart