Stripe Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Design an idempotent SQL ETL for late data
You own the daily_user_metrics fact table. Build an idempotent, rerunnable ETL that can be triggered for any date D and correctly handles duplicates, ...
Write SQL to monitor weekly chargeback spikes
Write a single SQL query (PostgreSQL) to detect weekly chargeback spikes by country and industry. Week starts Monday (use date_trunc('week', ts) with ...
Write SQL to detect recurring non-subscription users
You have two tables: merchant and transaction. Assume 'today' is 2025-09-01. Schema: merchant(merchant_id INT PK, merchant_name TEXT, country TEXT, cr...
Design metrics and write SQL for a case
Case: Measure the impact of outreach on subsequent purchases and diagnose anomalies. Define your primary metric and write SQL. Schema and tiny samples...
Write SQL for snapshot features and labels
Use 'today' = 2025-09-01. Invented schema (UTC): users(u_id INT, signup_dt DATE, country STRING) events(u_id INT, event_time TIMESTAMP, arrival_time T...
Design payment-to-invoice matcher with priorities
Design and implement a payment-to-invoice matcher. Inputs: (a) invoices, a list like ["invoice-id-1, 10000, 2022-01-01", "invoice-id-2, 30000, 2022-01...
Compute costs with validation and sorting in Python
Implement a three-part Python task to compute costs for purchase line items. Part 1: Write compute_cost(line_items, price_db) where line_items is a li...
Generate user notifications from schedules
Given a schedule template format and user profile data (timezone, locale, delivery preferences), implement a program that generates a user notificatio...