Parafin Interview Questions
The questions to prepare for Parafin interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Explain how a primary metric differs from a guardrail metric and how both are used in A/B test decisions.
ParafinExplain how to diagnose and optimize a slow analytical query on a multi-terabyte event table using SQL-aware tuning strategies.
ParafinCompute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Spotify
Meta ITAggregate user activity by week, then use LAG to compare sessions and watch time versus the prior active week.
B Lab Global
Tapad
ScaleUse CTEs, joins, and date logic to compare 30-day activity rates across monthly signup cohorts.
Gappify
Docusign
JioDefine a North Star Metric for an SMB product that reflects customer value and supports growth decisions.
ParafinTests algorithmic accuracy and parsing logic for financial schedules.
ParafinTests hypothesis testing and correct interpretation of statistical significance for adoption experiments.
ParafinApproach for maintaining data quality and integrity across ETL pipelines.
ParafinDesign a production ranking system with robust feature drift monitoring across batch and real-time features at high QPS.
ParafinTests system design for resilience, fairness, and availability under load.
ParafinSign up to see every question
Create a free account to unlock this list and practice real interview questions.