Intuit Interview Questions
Practice the exact questions companies are asking right now.
Compute monthly signups, conversion, and YoY growth
You work at a subscription company and are given a user-level table. Table company_users - id (INT, PK) — user/customer id - signup_date (DATE) — date...
Pivot daily users and revenue by platform
You are given transaction-level data and need daily aggregates by platform. Input (Pandas DataFrame) df with columns: - file_date (DATE or string pars...
Design an experiment for pricing page redesign
A product team is redesigning a pricing tier page. Historically the page only offered a monthly plan; the redesign adds an annual plan option. You are...
Design an experiment to evaluate an onboarding progress bar
Scenario In a QuickBooks-like onboarding flow, the product team adds a progress bar. The onboarding has 4 steps: 1. Onboard 2. Send payment 3. Set up ...
Handle missing and unavailable predictive features
Scenario You are building a model to predict whether a user will successfully file taxes (binary label success) for a TurboTax-like product. One of th...
Extract insights from a multi-entry funnel scorecard
Scenario You are given a scorecard for a QuickBooks-like product showing a funnel by access point (15+ entry points, highly skewed traffic). For each ...
Decide when to model courier ETA
Predicting Delivery ETA (Pickup → Drop-off): Case For or Against ML Context: You’re proposing an ETA model to predict the time from rider pickup to cu...
Explain a non-linear industry switch
Behavioral Interview Prompt — Transition from Semiconductor to SaaS Analytics You are in an HR screen for a Data Scientist role. The interviewer chall...
Design an idempotent churn ETL pipeline
You must build a daily pipeline that produces month-end churn metrics (logo churn, gross revenue churn, net revenue retention) from streaming subscrip...
Choose the right test for proportions
A/B Test on Delivery Completion Rate (Binary Outcome) Context: You are evaluating an A/B test on a binary metric (delivered_bool). Treat each order as...
Diagnose rising delivery cost precisely
Problem: Delivery Cost per Order Increased — Design an Analysis Plan Context A restaurant reports a significant increase in delivery cost per order in...
Compute churn and revenue churn in SQL
You receive monthly end-of-month subscription snapshots and must compute August-2025 churn metrics. Schema and sample data: Table: subscription_monthl...
Build 30-day retention cohort table
Monthly 30-Day Retention Cohort (PostgreSQL) Context You are given a table of companies with signup and (optional) termination dates. Define monthly c...
Compute paid subscriber YoY counts by month
Write a single SQL query (PostgreSQL) that returns calendar-month counts of new paid subscribers starting from 2019-06-01 (inclusive) through the late...
Build cohort 30-day retention from signup date
Task: Monthly Cohorted Retention (30-day, then 30/60/90-day curve) You are given a single table, company, with columns: - company_id (INT) - signup_da...
Exclude free subscribers via anti-join
Extend your previous monthly new-subscriber + YoY query to exclude companies that ever received a free subscription, using an anti-join against Free_S...
Compute monthly new subscribers and YoY deltas
Write a single SQL query that returns monthly counts of new subscribers starting at 2019-06, plus year-over-year (same-month prior year) comparisons. ...
Aggregate transactions by status and failure reasons (SQL)
You are given a table transactions with (at least) the following columns: - transaction_id (unique identifier) - status (e.g., SUCCESS, FAILED, PENDIN...
Find largest filename from ls -l output
You are given a multi-line string (via stdin) that represents the output of ls -l, with one entry per line. Each file line follows the typical ls -l f...
Sum palindrome-change costs over all substrings
You are given a DNA string dna consisting only of characters A, C, G, T. For any substring dna[l..r], define its palindrome modification cost as the m...