Constellation Technologies Interview Questions
The questions to prepare for Constellation Technologies interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.
Measure monthly user retention by signup cohort using date calculations and aggregated activity.
Measure three-month customer activity and classify churn while adjusting for monthly seasonal expectations.
Amazon DSP
SyntesExplain what a p-value means, how it relates to statistical significance, and how to describe it clearly to non-technical stakeholders.
Explain how you choose among common statistical methods based on the question, data structure, and risk of bias.
Outline the first checks to diagnose a sudden drop in a core product metric, starting with data quality, scope, and decomposition.
Define a success metric for a new feature that captures real user value, not just raw usage.
Explain common online experimentation pitfalls and how to design, analyze, and decide in ways that avoid false wins.
Framework for using product data to identify and prioritize the user problem that should be solved first.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.