Dataford
Top 13
Prep plan
Updated weekly · Last refresh Sep 24
Z

Zalando Product Analyst Interview Questions

The questions to prepare for a Zalando Product Analyst interview. Questions from real interview reports rank first. Updated daily.

13questions
~2htotal time
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
A/B Testing & ExperimentationStart here. 4 questions · ~32 min
Plan Sample Size for Checkout TestMedium

Design a checkout A/B test with explicit MDE, sample-size math, guardrails, and a pre-registered decision rule under a 14-day limit.

MDEPower AnalysisSample SizeZZalando
Explain p-Values to StakeholdersMedium

Tests ability to communicate experiment results clearly to non-technical stakeholders.

CommunicationP-ValuesZZalando
Control-Treatment InterferenceHard

Tests your understanding of experimental validity and mitigation of cross-group contamination.

ZZalando
More A/B Testing & Experimentation questions with a free account
2
SQL & Data Manipulation4 questions + 3 drills · ~62 min
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByZZalando
Retention Rate SQL QueryMedium

Assesses your ability to translate a product question into correct SQL logic for retention.

sql queryData AnalysisZZalando
Optimize Slow Multi-Table JoinsHard

Evaluates query optimization techniques for performance and scalability on large datasets.

performanceZZalando
SQL Data Cleaning in PythonMedium

Tests practical data cleaning skills and handling of missing and anomalous values.

data cleaningoutlierspythonZZalando
Running Total With Window FunctionsEasy
Practice
Practice drill

Calculate each user's running order total over time using a window function.

Window FunctionsDate FunctionsRunning TotalsBayerSparksoftWestern Digital
Top Technicians QueryMedium
Practice
Practice drill

Rank ServiceTitan technicians by completed job revenue, requiring multiple completed jobs and returning their performance metrics.

Joinssql queryData AnalysisServiceTitan
Top 10 Users by Usage SQLMedium
Practice
Practice drill

Join three tables and aggregate usage records to return the ten highest-volume users.

Joinssql queryData AnalysisHKT Services

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership5 questions · ~40 min
Balancing Technical Debt and DeliveryMedium

Tests prioritization under pressure: balancing technical debt, delivery commitments, and stakeholder alignment with clear ownership.

Stakeholder ManagementOwnershipPrioritizationZZalando
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 13 questions plus 3 hands-on drills to finish this plan.