Practical coding & data (Python + SQL)
The live-coding and data rounds FDEs face: API integration, parsing messy data, SQL analytics, debugging scripts.
- Write a function that pulls every record from a paginated REST API. What do you handle besides the happy path? · easy · reported 2×Free
- Your integration calls a customer's API and an LLM API. Both sometimes return 429 or 503. How do you write the retry logic? · medium · reported 1×Free
- The customer sends you a CSV export that is full of problems. How do you parse it safely in Python? · easy · reported 3×Free
- Build a small pipeline: read customer documents, call an LLM to extract fields, and handle the case where the model returns malformed output. · medium · reported 1×Free
- Given orders, customers and products tables, write a SQL query that answers: which customer segments generated the most revenue last quarter? · easy · reported 3×Free
- Your join query returns revenue 3x higher than finance's number. What happened and how do you fix it? · medium · reported 2×Pro
- For each customer, return their most recent order and the top 3 products by spend. Which SQL feature do you reach for? · mediumPro
- How do NULLs and missing values change the result of your SQL or pandas code? Give an example where it bites. · medium · reported 1×Pro
- Two systems list the same customers with different spellings and ids. How do you merge and deduplicate them in Python? · mediumPro
- Given a list of event dicts, group them by user, count events per type and return the top 3 users. How do you write it? · easy · reported 2×Pro
- A customer's nightly Python script that worked for months now fails or gives wrong totals. Walk me through how you debug it live. · medium · reported 3×Pro
- Implement a rate limiter that lets a client make at most N calls per minute to an API. How would you do it and test it? · hard · reported 1×Pro
- You must process a 40 GB log or export file, and your script keeps running out of memory. How do you redesign it? · hard · reported 1×Pro
- Write SQL to compute month-over-month retention (or repeat-purchase rate) from an events or orders table. · hardPro
- Your script loads cleaned data into the customer's database every night. How do you make it safe to rerun and safe to fail halfway? · hardPro