📢
Admissions Open for August 2026 Batch | Free Career Counselling | Limited Scholarships
Register Now →

Interview Preparation

OLX Data Science Interview Questions and Answers (2026 Guide)

Quick answer: OLX Data Science and Analytics interviews generally test SQL, Python, statistics and Machine Learning fundamentals alongside a company or domain specific case discussion. This guide covers the likely process, core technical questions, and how to prepare.

About OLX

OLX is a global online classifieds marketplace connecting buyers and sellers for used goods, vehicles, real estate and services across many countries.

OLX works across areas such as:

  • Online classifieds marketplace

  • Used vehicle marketplace

  • Real estate listings

  • Trust and safety

  • Advertising and monetisation

Data and analytics teams typically support work such as:

  • Listing quality and fraud detection

  • Search and recommendation ranking

  • Pricing guidance for sellers

  • User engagement and retention analytics

  • Ad monetisation optimisation

Roles that commonly open up in this space include:

  • Data Analyst

  • Data Scientist

  • Machine Learning Engineer

  • Product Analyst

  • Trust and Safety Analyst

Interview Process

Hiring processes vary by role, team and experience level. A data role at a company of this size generally moves through several stages.

1. Online Assessment

Often covers:

  • Aptitude and logical reasoning

  • SQL queries

  • Python programming

  • Statistics fundamentals

2. Technical Interview

Topics commonly covered include:

  • SQL joins, aggregations and window functions

  • Python and Pandas for data manipulation

  • Statistics and probability

  • Machine Learning fundamentals

  • Data visualisation and reporting

Case or Business Round

You may be asked to reason through an open ended business problem, explain your approach, and justify the metrics you would track.

Managerial and HR Round

Focus areas usually include project experience, communication, stakeholder management, and how you handle ambiguity.

SQL Interview Questions

What is the difference between WHERE and HAVING?

WHEREHAVING
Filters individual rowsFilters grouped results
Applied before GROUP BYApplied after GROUP BY
Cannot use aggregate functionsCan use aggregate functions

What is the difference between INNER JOIN and LEFT JOIN?

INNER JOIN returns only the rows that match in both tables. LEFT JOIN returns every row from the left table, and fills unmatched columns from the right table with NULL.

SELECT c.customer_id,
       c.name,
       o.order_id
FROM customers c
LEFT JOIN orders o
  ON c.customer_id = o.customer_id;

How do you find duplicate records in a table?

SELECT email, COUNT(*) AS record_count
FROM customers
GROUP BY email
HAVING COUNT(*) > 1;

What are window functions?

Window functions perform a calculation across a set of rows while still returning every individual row. They are widely used for ranking, running totals and period on period comparisons.

SELECT region,
       sales_amount,
       RANK() OVER (
         PARTITION BY region
         ORDER BY sales_amount DESC
       ) AS sales_rank
FROM regional_sales;

Python Interview Questions

Why is Python widely used for data work?

Python combines readable syntax with a mature ecosystem of libraries, including Pandas for data manipulation, NumPy for numerical computing, Scikit-Learn for Machine Learning, and Matplotlib or Seaborn for visualisation.

What is the difference between a list and a tuple?

ListTuple
Mutable, can be changedImmutable, cannot be changed
Written with square bracketsWritten with parentheses

How do you handle missing values in Pandas?

import pandas as pd

df.isnull().sum()
df = df.dropna(subset=['customer_id'])
df['income'] = df['income'].fillna(df['income'].median())

Statistics Interview Questions

What is the difference between mean, median and mode?

The mean is the arithmetic average, the median is the middle value in sorted data, and the mode is the most frequent value. The median is preferred when the data contains outliers.

What is a p-value?

A p-value is the probability of observing a result at least as extreme as the one measured, assuming the null hypothesis is true. A small p-value gives evidence against the null hypothesis, but it does not by itself tell you the size of the effect.

What is the difference between Type I and Type II error?

Type I errorType II error
False positiveFalse negative
Rejecting a true null hypothesisFailing to reject a false null hypothesis

Machine Learning Interview Questions

What is the difference between supervised and unsupervised learning?

Supervised learningUnsupervised learning
Uses labelled dataUses unlabelled data
Predicts a known targetDiscovers structure and patterns

What is overfitting and how do you prevent it?

Overfitting happens when a model learns noise in the training data and fails to generalise. Common remedies include cross validation, regularisation, simplifying the model, and gathering more representative data.

Why is accuracy a poor metric for imbalanced data?

If only one percent of cases are positive, a model that always predicts negative is ninety nine percent accurate and completely useless. Precision, recall, F1 score and ROC AUC give a far more honest picture.

Marketplace and Trust Analytics Questions

How would you detect fraudulent listings?

Look for signals like unrealistic pricing, duplicate images across accounts, and new accounts posting high value items, combined with user reports.

How would you improve search relevance for classifieds?

Combine listing attributes, user search history and click behaviour, while accounting for the fact that classifieds inventory changes constantly unlike a fixed product catalogue.

Case Study Questions

Suggesting a fair price to a seller listing an item

Use recent comparable listings and their actual sale outcomes rather than just other asking prices, since asking price and final sale price can differ substantially.

HR and Behavioural Questions

Tell me about yourself

A clear structure works well: your education, your technical skills, one or two projects you can defend in depth, any work experience, and what you are looking for next.

Why OLX?

A strong answer references the two-sided marketplace dynamics of classifieds, where trust and search relevance both directly affect whether a transaction happens at all.

Describe a project you are proud of

Use a simple arc: the business problem, the data you had, what you built, how you evaluated it, and what changed as a result.

Preparation Tips

Build genuine SQL fluency

Practise joins, aggregations, subqueries, window functions and CTEs until you can write them without hesitation.

Get comfortable with Pandas

Focus on merging, grouping, reshaping and cleaning messy real world data rather than memorising the entire library.

Prepare two projects properly

Two projects you can discuss deeply beat six you can only describe superficially. Be ready to explain your choices and limitations.

Final Thoughts

Interviews at OLX reward candidates who combine solid technical foundations with clear business reasoning. Strong SQL, practical Python, dependable statistics, and the ability to explain your thinking usually matter more than knowing an unusually advanced algorithm.

Prepare systematically, build projects you can genuinely defend, and practise speaking about your work out loud.

FAQ

Frequently Asked Questions

What is the OLX Data Science interview process like?

It typically includes an online assessment, a technical round covering SQL, Python and statistics, a domain or case discussion, and a managerial or HR round. Exact steps vary by role, team and experience level, and not every candidate goes through every stage.

What topics should I prepare for a OLX interview?

Focus on SQL joins and aggregations, Python and Pandas for data manipulation, core statistics such as hypothesis testing and probability, and Machine Learning fundamentals like overfitting and model evaluation, alongside enough business context to reason through a case question.

What data roles does OLX commonly hire for?

Common roles include Data Analyst, Data Scientist, Machine Learning Engineer, Product Analyst and Trust and Safety Analyst. Exact openings vary over time and by location.

How should I prepare for a OLX Data Science interview?

Build genuine SQL fluency, get comfortable with Pandas on messy real world data, revise the statistics that actually come up in interviews, and prepare two projects you can discuss in real depth rather than several you can only describe superficially.

Want This Mapped to Your Own Background?

A free counselling session will tell you which path fits, and will tell you honestly if none of ours does.

Book Free Career Counselling

Keep Reading

Related Articles