Point72 Data Scientist Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Convert Dates to Calendar Quarter Labels in SQL/Python
Transactions +----+-----------+ | id | trans_dt | +----+-----------+ | 1 | 20230115 | | 2 | 20230402 | | 3 | 20230930 | | 4 | 20231201 | +---...
List Departments with Student Counts Including Zero
Students +----+--------+---------+ | id | name | dept_id | +----+--------+---------+ | 1 | Alice | 1 | | 2 | Bob | 2 | | 3 | Caro...
Determine Circle Intersection Status for Rendering Order
Scenario Graphics engine must evaluate multiple pairs of circles to decide rendering order based on intersection. Question Given an array where each e...
Determine Most Frequent Product Color in Carts
Scenario Online store wants to know which color of product appears most frequently in customers’ carts. Question Implement a function getMaxColor(colo...
Classify relationships for multiple circle pairs
Given an array pairs of N circle pairs, where each circle is (x, y, r) with integer coordinates and r ≥ 0, classify each pair into one of: IDENTICAL (...
Write SQL for top student per department
Schema: Departments(dept_id PK, dept_name) Students(student_id PK, student_name, dept_id FK nullable, gpa numeric(3,2) nullable, enrolled_at date) Sam...
Maximize outfits with distinct colors
You're given counts of items by color; each outfit must contain exactly 3 items, all of distinct colors. You cannot reuse items. Input formats: either...
Convert integer dates to quarters
Given an 8-digit integer date_key in YYYYMMDD (e.g., 20240331), write: (a) a SQL expression and (b) a Python function that convert it to a quarter lab...
Price a coin-doubling game rationally
Coin-Doubling (St. Petersburg) Game: EV, Log-Utility Pricing, Kelly Staking, and House Cap Context and assumptions - Single play: You buy one ticket t...
Explain and tune decision trees robustly
Decision Trees: Splitting, Tuning, Overfitting, and When to Use Ensembles Context: You built a CART-style decision tree for a take‑home ML project. An...
Write SQL for recent customer activity
Write a single ANSI‑SQL query that produces, for every customer who has at least one non‑canceled order ever: (1) last_order_ts across all time consid...
Solve date, shopping, and circle problems
Take‑Home: Three Independent Tasks (Data/Algorithms) Implement three independent functions that will be unit‑tested separately. Provide clear error ha...