FARFETCH Data Engineer Interview Questions

The questions to prepare for a FARFETCH Data Engineer interview. Questions from real interview reports rank first. Updated daily.

8questions

~1htotal time

Track your progressSign up free to work through all 8 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 4 questions + 2 drills · ~58 min

SQL Query OptimizationMedium

Practice

Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.

Performance Tuningdatabase optimizationindexesFFARFETCH

Star vs Snowflake for OpsMedium

Explain how to choose between star and snowflake schemas for corporate operations reporting, balancing query simplicity, integrity, and performance.

snowflake schemastar schemaData ModelingFFARFETCH

Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByFFARFETCH

Handling Slowly Changing DimensionsMedium

Tests understanding of SCD strategies and how you implement them in warehouse models.

data warehousedimensionsData ModelingFFARFETCH

SQL for Transaction PaymentsMedium

Practice

Practice drill

Aggregate settled payment activity by merchant and month while demonstrating a reporting-ready fact and dimension model.

Joinssqldimensions

Zoom Video Communications

Optimize a Slow SQL QueryHard

Practice

Practice drill

Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.

database optimizationJoinsData Wrangling

Biz2Credit

AmeripriseEEltro Cyberchrome Private

System Design4 questions · ~38 min

High-Volume Ingestion FailuresHard

Assesses fault tolerance and resilience in data ingestion pipelines.

system designdata ingestionFFARFETCH

Batch vs Stream for Retail AnalyticsMedium

Evaluates architecture choices for analytics workloads in a retail context.

Stream ProcessinganalyticsBatch ProcessingFFARFETCH

Data Consistency Across Distributed SystemsHard

Assesses distributed systems design and data consistency strategies in a global retail context.

distributed systemsdata consistencyarchitectureFFARFETCH

Real-Time Data ArchitectureMedium

Tests system design for streaming data and data lake integration in a fashion retail setting.

FFARFETCH

Sign up to see every question

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

Get my prep plan

The finish line: interview-readyComplete all 8 questions plus 2 hands-on drills to finish this plan.