Instacart Data Scientist Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
4Questions
1Company
4 Questions 1 Company
Showing 4 results
Instacart
Medium
Data ScientistCalculate Weekly Revenue and Order Count for Standard Deliveries
instacart_orders +----------+---------+---------+------------+---------+--------------+ | order_id | user_id | revenue | created_at | geo | delive...
Data Manipulation (SQL/Python)
53
0
Jul 12, 2025
Instacart
Medium
Data ScientistWrite SQL to rank advertisers and profitability
You are given two denormalized tables. Use ANSI SQL (CTEs allowed) and UNPIVOT (or an equivalent UNION ALL approach if UNPIVOT is unavailable). Table:...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Instacart
Medium
Data ScientistAggregate weekly revenue and attribute 4% drop
Write SQL over the following schema to: (A) compute weekly revenue by ISO week (Monday–Sunday) from orders, excluding cancelled/refunded; revenue_usd ...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Instacart
Medium
Data ScientistExplain handling very large datasets
Describe a project where you ingested and processed a dataset of at least 500 million rows or 1 TB end-to-end. Detail storage formats and partitioning...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025