01
Random forest vs a single decision tree?
Show answer
A forest averages many trees trained on bootstrapped rows and random feature subsets, which cuts variance and overfitting at the cost of interpretability.
Pine Labs Data Science Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Pine Labs hiring for Data Science roles
Pine Labs is an Indian merchant commerce and payments company known for card payment terminals at retail stores. It offers point-of-sale payments, EMI and buy-now-pay-later options at checkout, online payments and gift card solutions through Qwikcilver. It serves merchants in India and other Asian markets and hires software engineers, quality engineers, data analysts and product roles.
For Data Science roles, this Pine Labs practice set focuses most on Machine Learning (7), SQL for Data Science (7), A/B Testing & Experimentation (4), Deep Learning and NLP (4). It has 3 easy, 33 medium, 4 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Fintech
- Headquarters
- Noida, India
- Main India offices
- Noida, Bengaluru
Pine Labs Data Science interview process
- Online coding assessment
- Technical round 1 (DSA)
- Technical round 2 (design or domain)
- Hiring manager and HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Pine LabsStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
02
A key metric dropped 8 percent week over week. How do you check whether it is real?
Show answer
First rule out data issues: tracking changes, pipeline delays, missing partitions or a changed metric definition. Then compare with the same week last year and look for holidays or seasonality. Check normal weekly variation to see if 8 percent is unusual. Break the drop down by platform, region, app version and user type to find where it is concentrated. Finally, check releases, campaigns or outages that happened that week.
03
Your test shows a 2 percent lift in conversion, but revenue per user went down. What do you do?
Show answer
Do not ship on conversion alone. Check whether the change shifted buyers to cheaper items, increased discount usage or pulled in low-value orders. Break down revenue into conversion times average order value, look at item mix, and confirm the revenue drop is statistically meaningful rather than noise. Then go back to the agreed primary metric and guardrails; if revenue is the business goal, it should guide the decision.
04
Explain the KNN algorithm and its drawbacks.
Show answer
It predicts from the k nearest labelled points. It is simple but slow at prediction time, sensitive to scaling and irrelevant features, and weak in high dimensions.
05
Soon after a new model version went live, customer complaints spiked. How do you roll back safely and learn from it?
Show answer
Roll back immediately to the previous registry version through the deployment pipeline, rather than editing servers by hand, and confirm metrics recover. Then investigate offline: compare predictions of both versions on the same traffic, check feature pipelines and data changes, and review what the offline evaluation missed. Add the failing cases to the test set, and use canary or shadow rollout with alert thresholds for future releases.
06
Your forecast uses actual daily temperature as a feature and looks great in backtesting, but it performs worse in production. Why?
Show answer
In backtesting you used the actual temperature for future days, which you will never know at forecast time. In production the model gets a weather forecast, which has its own error, so performance drops. This is a subtle form of leakage. Fix the backtest by using the weather forecast that was available on each forecast date, or lagged actuals, so offline results match what production can really achieve.
07
How does dropout work?
Show answer
During training it randomly switches off a fraction of neurons so the network cannot depend on any single unit, acting as a regulariser against overfitting.
08
What is normalisation, and why are analytics tables often denormalised?
Show answer
Normalisation splits data into related tables to remove redundancy, so each fact is stored once, which suits transactional systems with many updates. Analytics workloads mostly read large volumes, and joins across many tables are slow and error-prone. So warehouses often use denormalised, wide tables or star schemas that repeat some attributes. The trade-off is more storage and the need to keep copies consistent through pipelines.
09
Your notebook runs on your laptop but fails on a colleague's machine. How do you make the work reproducible?
Show answer
First pin the environment: a requirements.txt or conda environment file with exact versions, or a Docker image. Set random seeds for NumPy, scikit-learn and any framework you use. Remove hard-coded local paths and read them from a config file. Make sure data comes from a shared, versioned location. Finally, restart the kernel and run the notebook top to bottom, so hidden cell order bugs are caught before sharing.
10
Write SQL to pivot order counts by status into columns using CASE WHEN.
Show answer
SELECT DATE_TRUNC('month', order_date) AS month,
SUM(CASE WHEN status = 'delivered' THEN 1 ELSE 0 END) AS delivered,
SUM(CASE WHEN status = 'cancelled' THEN 1 ELSE 0 END) AS cancelled,
SUM(CASE WHEN status = 'returned' THEN 1 ELSE 0 END) AS returned
FROM orders
GROUP BY 1
ORDER BY 1;
11
What is TF-IDF?
Show answer
Term Frequency × Inverse Document Frequency: a word scores high if it is frequent in one document but rare across all documents. A classic way to turn text into numeric features.
12
What is the randomisation unit in an experiment, and why does it matter?
Show answer
The randomisation unit is what you assign to variants: a user, a session, a device, a page view or even a city. Choosing user-level keeps each person's experience consistent and avoids contamination. The analysis unit should match the randomisation unit, because if you randomise by user but analyse by page view, observations are correlated and standard errors come out too small, producing false positives. Use the delta method or bootstrap when they differ.
13
Write SQL to find the top 3 products by revenue in each category.
Show answer
WITH rev AS (
SELECT category, product_id, SUM(price * qty) AS revenue
FROM order_items
GROUP BY category, product_id
), ranked AS (
SELECT *, ROW_NUMBER() OVER (PARTITION BY category ORDER BY revenue DESC) AS rn
FROM rev
)
SELECT category, product_id, revenue
FROM ranked
WHERE rn <= 3;
14
What is subword tokenisation like BPE or WordPiece?
Show answer
Subword tokenisers split text into frequent pieces between characters and full words. Byte Pair Encoding starts from characters and repeatedly merges the most frequent pairs. WordPiece, used by BERT, is similar but chooses merges by likelihood. Rare words like unhappiness become un, happi, ness, so there are no unknown words and the vocabulary stays around 30,000 to 100,000. Token counts also decide LLM cost and context use.
15
A query on a 200 million row table takes 20 minutes. How do you speed it up?
Show answer
Start with EXPLAIN to see the plan and find full scans, bad joins or spills. Filter as early as possible and select only needed columns. Make sure the table is partitioned or clustered on the date column and that the query filters on it. Check join keys for type mismatches and duplicates that explode rows. Pre-aggregate into a summary table if the query runs daily, and replace correlated subqueries with joins or window functions.
16
Pandas: find customers whose monthly spend increased for three consecutive months.
Show answer
m = (df.assign(month=df['date'].dt.to_period('M'))
.groupby(['customer_id', 'month'])['amount'].sum()
.reset_index()
.sort_values(['customer_id', 'month']))
m['up'] = (m.groupby('customer_id')['amount'].diff() > 0).astype(int)
# three rises in a row = three consecutive increases
m['streak'] = (m.groupby('customer_id')['up']
.rolling(3).sum().reset_index(level=0, drop=True))
result = m.loc[m['streak'] == 3, 'customer_id'].unique()
17
When would you use MAE, MSE or RMSE for a regression model?
Show answer
MAE is the average absolute error; it is easy to explain and less sensitive to outliers. MSE squares errors, so large errors are punished heavily, and it is smooth for optimisation. RMSE is the square root of MSE, so it is in the same units as the target while still punishing big misses. Use RMSE when large errors are very costly, like stock-out forecasts, and MAE when outliers should not dominate.
18
What is an AI agent in the context of LLMs?
Show answer
An AI agent is an LLM that works in a loop: it plans a step, calls a tool, reads the result and decides the next step until the goal is met. For example, it might query a database, run Python on the result and write a summary. Agents handle multi-step tasks but are less predictable, slower and costlier than a single call. Good designs limit tools and steps, log every action and keep a human check for risky actions.
19
Write Pandas code to read a large CSV in chunks and compute total sales per city.
Show answer
# process 1 million rows at a time
import pandas as pd
totals = {}
for chunk in pd.read_csv('sales.csv', usecols=['city', 'amount'], chunksize=1_000_000):
part = chunk.groupby('city')['amount'].sum()
for city, amt in part.items():
totals[city] = totals.get(city, 0) + amt
result = pd.Series(totals).sort_values(ascending=False)
20
What is the difference between a subquery and a correlated subquery?
Show answer
A normal subquery runs once on its own and its result is used by the outer query, for example WHERE price > (SELECT AVG(price) FROM products). A correlated subquery refers to columns of the outer query, so it is logically evaluated once per outer row, for example comparing each product with its own category average. Correlated subqueries can be slow; joins or window functions are usually faster alternatives.
21
What is an autoencoder and what is it used for?
Show answer
A network that compresses inputs into a small latent code and reconstructs them; used for denoising, dimensionality reduction and anomaly detection.
22
Your experiment ended with no statistically significant difference. What do you tell the team?
Show answer
Not significant does not mean no effect. Report the observed effect with its confidence interval, for example minus 0.3 to plus 1.2 percent, and compare it with the MDE the test was powered for. If the interval rules out effects that matter, conclude the change has little impact and decide based on cost or design preference. If the interval is wide, the test was underpowered, and a longer test or variance reduction may help.
23
How do you turn text columns into features for a tabular model?
Show answer
Simple options are length, word count and keyword flags. TF-IDF vectors capture important words and work well with linear models. For meaning, use sentence embeddings from a pretrained model and optionally reduce them with PCA. You can also train a separate text classifier and feed its predicted score as one feature. Fit any vocabulary or encoder on training data only to avoid leakage.
24
Write a Python function to compute MASE for a seasonal forecast.
Show answer
import numpy as np
def mase(y_train, y_true, y_pred, m=7):
# Scale: in-sample error of seasonal naive
y_train = np.asarray(y_train)
scale = np.mean(np.abs(y_train[m:] - y_train[:-m]))
err = np.mean(np.abs(np.asarray(y_true) - np.asarray(y_pred)))
return err / scale
# MASE below 1 beats seasonal naive
25
What is mean Average Precision (mAP) in object detection?
Show answer
For each class, detections are ranked by confidence and a precision-recall curve is computed, where a detection is a true positive if its IoU with an unmatched ground truth box passes a threshold. Average Precision is the area under that curve. mAP is the mean across classes. mAP@0.5 uses IoU 0.5, while mAP@0.5:0.95 averages over thresholds from 0.5 to 0.95 and rewards tighter boxes.
26
Your model's most important feature is customer_id. What is wrong?
Show answer
An ID has no real meaning, so high importance means the model is memorising individual customers. It often happens when the same customers appear in both train and test, or when IDs were assigned in time order and act as a proxy for date or signup cohort. I would drop the ID, use a group-based split by customer, and if timing matters, add an explicit feature like account age instead.
27
What is Naive Bayes and why is it called naive?
Show answer
It applies Bayes' theorem assuming features are independent given the class. The assumption is rarely true but the model is fast and works well for text.
28
How do you work with domain experts to find good features?
Show answer
Situation: on an insurance claims model, my first features gave average results. Task: improve fraud detection. Action: I sat with two claim investigators for a day and asked what made them suspicious. They mentioned claims filed soon after policy start and repeated garage names. I turned these into features and checked them with the team. Result: recall at the same precision rose by 12 points. Experts often know signals the data hides.
29
Your GPU model-serving bill has doubled while traffic grew only 20 percent. How do you bring cost down?
Show answer
Profile utilisation first; idle or under-filled GPUs are common. Enable dynamic batching so each GPU call handles several requests, right-size instance types and autoscale on queue depth rather than CPU. Reduce model cost with quantisation, distillation or a smaller model for easy requests. Cache repeated predictions, move non-urgent work to batch jobs on cheaper hardware, and track cost per thousand predictions as a standing metric.
30
How do you use groupby with multiple aggregations?
Show answer
df.groupby('region').agg(total=('sales','sum'), avg=('sales','mean')) gives named aggregations per group in one pass.
31
Write Python code to fit a Holt-Winters model and forecast the next 12 months.
Show answer
from statsmodels.tsa.holtwinters import ExponentialSmoothing
s = df.set_index('month')['sales'].asfreq('MS')
train, test = s[:-12], s[-12:]
model = ExponentialSmoothing(
train, trend='add', seasonal='mul',
seasonal_periods=12
).fit()
forecast = model.forecast(12)
mae = (forecast - test).abs().mean()
print(forecast.round(1), 'MAE:', round(mae, 1))
32
Explain logistic regression.
Show answer
It models the log-odds of a binary outcome as a linear function and passes it through a sigmoid to give probabilities, trained by maximising likelihood.
33
How do you detect outliers?
Show answer
Use the IQR rule (below Q1-1.5 IQR or above Q3+1.5 IQR), z-scores beyond 3, box plots or model-based methods such as Isolation Forest, then decide whether to cap, remove or keep them.
34
Your deployed model gives different predictions than the same model in your notebook. Why?
Show answer
Usually preprocessing differs between training and serving. Check that the same pipeline object was saved, not just the estimator, and that category order, missing value handling and scaling match. Compare library versions, feature types like strings versus integers, column order, and time zones in date features. Send the same few rows through both paths and compare features step by step to find the first mismatch.
35
Why is XGBoost so popular?
Show answer
It combines gradient boosting with regularisation, handling of missing values, parallel tree construction and speed optimisations, and it performs strongly on tabular data.
36
How do you pull large data from a SQL database into Pandas efficiently?
Show answer
Push as much work as possible into SQL: filter, aggregate and select only needed columns before pulling. Use pd.read_sql with a SQLAlchemy engine and chunksize to stream large results. For very large extracts, export to Parquet from the warehouse and read that, which is much faster than row-by-row transfer. Set dtypes like category early, and never use SELECT star on a big table from a notebook.
37
Marketing wants to measure the impact of a TV and outdoor campaign that cannot be randomised at user level. How do you design the measurement?
Show answer
Plan a geo experiment: select comparable cities or regions, randomly assign some to run the campaign and keep others as control, matching them on past sales trends. Measure the difference in sales during and after the campaign, using methods like difference-in-differences or synthetic control to build a counterfactual. Run a pre-period check that test and control regions track each other, and include enough regions for reasonable power.
38
What is regularization? Explain L1 vs L2.
Show answer
Regularization adds a penalty on weights to reduce overfitting. L1 (Lasso) adds |w| and can push features to exactly zero. L2 (Ridge) adds w² and shrinks weights smoothly.
39
What are guardrails in LLM applications?
Show answer
Guardrails are checks around the model that keep inputs and outputs safe and on-topic. Input guardrails detect prompt injection, abuse or off-topic requests. Output guardrails check for personal data, toxic content, policy violations or invalid formats before the answer reaches the user. They can be rules, classifiers or a second LLM call. Good guardrails also define fallback responses and log blocked cases for review.
40
Write SQL to compute a 7-day rolling average of daily active users.
Show answer
WITH daily AS (
SELECT activity_date, COUNT(DISTINCT user_id) AS dau
FROM events
GROUP BY activity_date
)
SELECT activity_date, dau,
AVG(dau) OVER (ORDER BY activity_date
ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS dau_7d_avg
FROM daily
ORDER BY activity_date;
Tips to crack the Pine Labs Data Science interview
- Learn how card payments work at a store terminal, including authorisation, settlement and EMI conversion at checkout.
- Practise DSA and backend design, focusing on reliability and security for systems handling financial transactions.
- Read about Pine Labs products like EMI offers and gift cards to show interest in merchant commerce.
- Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
- Practise the hard questions on this page aloud; Pine Labs interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Pine Labs Data Science interview?
Candidates usually go through 4 stages: Online coding assessment; Technical round 1 (DSA); Technical round 2 (design or domain); Hiring manager and HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the Pine Labs Data Science interview?
This practice set leans on Machine Learning (7), SQL for Data Science (7), A/B Testing & Experimentation (4), Deep Learning and NLP (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Pine Labs interviewers ask you to walk through real work.
Are these the exact questions asked at Pine Labs?
No. These are curated practice questions that match the skills and difficulty usually tested in fintech interviews like Pine Labs's. They are not a leaked or verified list of past questions.
Where does Pine Labs hire Data Science professionals in India?
Pine Labs has large teams in Noida, Bengaluru. Openings and locations change often, so check the Pine Labs careers page and filter by city and experience.
Data Science questions for similar companies
Fintech
PhonePe
Data Science interview questions
Bengaluru, Pune
View questionsFintech
DE Shaw
Data Science interview questions
Hyderabad, Bengaluru, Gurugram
View questionsFintech
Cashfree Payments
Data Science interview questions
Bengaluru
View questionsFintech
Bloomberg
Data Science interview questions
Mumbai
View questionsFintech
Bajaj Finserv
Data Science interview questions
Pune
View questionsFintech
Razorpay
Data Science interview questions
Bengaluru, Mumbai
View questionsMore ways to practise
Company-wise Data Science questionsPackage-wise Data Science questionsExperience-wise Data Science questionsRole-wise Data Science questionsCity-wise Data Science questionsMost asked Data Science questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsData Science mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsData Science topic sheets