Data Scientist Interview - Uber | AB Testing + SQL

Do you have a technical interview lined up for the data scientist interview?

Here's a 45-minute mock, technical screen conducted by a Sr. DS at a product company. The technical screen for most product-based roles is usually 45 minutes with SQL questions and AB testing.

What are the benefits of enrolling in the Premium content? 👇

✍️ Learn from 30+ Hours of Video and Text-Based Courses created by interview experts who worked in top companies like Google and Meta!

📚 200+ Actual Interview Questions + Detailed Solutions - Get practice questions seen in actual interviews with detailed solutions solved by engineers from top companies (e.g. Google & Meta)

📝 Cover Core Areas in Technical Interviews including AB testing, product sense, applied statistics, machine learning, business case, SQL, data science coding and much more!

⭐ Become an SQL Pro with Interactive Pad with 100 SQL questions, easy to hard-level questions asked in top companies + highly optimized solutions.

🎥 Watch Mock Interview Videos with real candidates and an interviewer at top companies.

💭 Join the Private Chat Group to practice interview questions with peers and instructors. And, network with peers for your next job!

[brittosabu]

Q1:
SELECT
MONTH(order_time),
SUM(CASE WHEN DATETIME_DIFF(actural_delivery_time, predicted_delivery_time, MINUTE)<=-20 THEN 1 ELSE 0 END)*100/COUNT(*)
FROM delivery_table
GROUP BY 1
ORDER BY 1 DESC;

[balanaveenvishal]

When MDE increases, the sample size decreases !

[dtucfu]

The interviewee does not understand what he said. Unfortunately, he now becomes interviewer. This explains why so many people who knows these stupid stuff failed the interviews.

[beyondtheclouds]

0.07 is still not stat sig - going ahead and rejecting the null in that scenario would be wrong

[gowthamchandanraju]

Why can't we use MIN function to determine the first order the driver delivered:
WITH zero_rating_first_order AS(
SELECT driver_id, MIN(order_place_time)
FROM delivery_orders
WHERE delivery_rating = 0
GROUP BY driver_id)

SELECT
FROM delivery_orders JOIN zero_rating_first_order as zrfo
ON driver_id;

Or is there anything that I missed?

[learningrealenglish]

ChatGPT can answer all the question related to code. So I don't think interviewer should ask those questions anymore. They would focus on how we solve the problems by ideas