Dataford
Top 50
Company roadmap
Updated weekly · Last refresh Sep 25

Transport for London Interview Questions

The questions to prepare for Transport for London interviews, across all roles. Questions from real interview reports rank first. Updated daily.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 1 drill · ~63 min
Using SQL Window FunctionsMedium
Practice

Calculate three-day rolling passenger entry averages for TfL stations using aggregation and window functions.

Window FunctionsData AnalysissqlTransport for London
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
More SQL & Data Manipulation questions with a free account
2
Coding5 questions · ~45 min
Implement a Basic Hash TableEasy
Practice

Implement a collision-resolving hash table for TfL stop data using separate chaining, updates, lookups, and deletion.

Data StructuresTransport for London
More Coding questions with a free account

Sign up to see every question

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

Get my prep plan
3
Execution6 questions · ~53 min
Clarify Ambiguous Project RequirementsMedium
Recently asked

Explain how you turn vague requirements into aligned scope, clear decisions, and shared understanding for the team.

ClarityDealing With AmbiguityProject ManagementTransport for London
More Execution questions with a free account
4
Strategy3 questions · ~27 min
Tell Me About YourselfEasy
Recently asked

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisTransport for London
More Strategy questions with a free account
5
Pipelines6 questions · ~53 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityTransport for London
More Pipelines questions with a free account
6
Metrics6 questions · ~53 min
Measure Marketing Campaign SuccessEasy

Define campaign success using business KPIs, funnel conversion, acquisition cost, and leading indicators tied to outcomes.

Funnel AnalysisKPIsLeading IndicatorsTransport for London
More Metrics questions with a free account
7
More topics18 questions · ~160 min
Common Pitfalls in Experiment ResultsHard

Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.

PeekingNovelty EffectSample Ratio MismatchTransport for London
Design Feature Drift Monitoring SystemHard

Design a production ranking system with robust feature drift monitoring across batch and real-time features at high QPS.

Feature StoreFeature DriftModel ServingTransport for London
More questions with a free account
The finish line: interview-readyComplete all 50 questions plus 1 hands-on drill to finish this plan.