Expect a SQL round with warehouse-aware optimisation (retention cohorts on Redshift, distribution and sort keys, columnar scans), an ETL-design round on loading transactional data with schema-drift and idempotent reloads using Glue, S3, EMR, and Redshift, and a data-quality round on catching broken pipelines before dashboards. Interviewers weight correctness, cost-awareness, and clear pipeline SLAs, and every round is scored against Ownership, Dive Deep, and Insist on the Highest Standards. Bring STAR stories alongside technical depth.
Recruitment process
- Online assessment with SQL and data problems
- Technical phone screen on SQL and ETL
- Onsite loop: SQL, data modelling, pipeline design, and Leadership Principles
- Debrief and offer
Interview rounds
- Round 1 (60-90 min): online assessment with SQL and data-manipulation problems
- Round 2 (60 min): advanced SQL and warehouse-optimisation round
- Round 3 (60 min): ETL and pipeline design round on AWS with schema-drift and idempotency
- Round 4 (45-60 min): data-quality and Leadership-Principles behavioural round
Optimise and own framework
- Write warehouse-aware SQL, design idempotent AWS-native ETL with data-quality gates, and back every choice with cost, SLA, and Leadership-Principle reasoning
Practice questions
- 01Practise
How do you set the bar for promoting an SE3 to Staff? Walk me through the last time you said 'not yet', what was missing?
IntenseTech-leadership calibration probe. Wants concrete missing-bar dimension (scope-of-influence, ambiguity handling, cross-team mentoring) AND specific evidence the candidate gathered. 'Not enough technical depth' is too vague. - 02Practise
Given a list of orders with timestamps, find the K most frequently ordered items in a time range. Optimise it, then state your complexity.
IntenseAmazon coding rounds pair DSA with a Leadership Principle undertone (Dive Deep, Customer Obsession). Expect a heap or bucket approach and a follow-up on ties and streaming updates. - 03Practise
Given a grid of warehouse cells with obstacles, find the shortest path a robot can take from pickup to drop. Which traversal, and why?
Standard - 04Practise
Design an in-memory structure that returns the current most-recently-used product for a session in O(1). Walk me through the data structures.
IntenseLRU-style problem framed in-domain. Amazon wants the hash-map-plus-doubly-linked-list insight stated clearly, with correct handling of eviction and updates. - 05Practise
Given a large fact table of orders and a dimension table of customers, write SQL to compute month-over-month retention cohorts. Optimise for a columnar warehouse like Redshift.
IntenseAmazon BIE/data-engineer rounds combine advanced SQL with warehouse-aware optimisation (distribution keys, sort keys, columnar scans). - 06Practise
Design an ETL pipeline that loads daily transactional data from operational databases into a warehouse, handling schema drift and idempotent reloads. What do you use on AWS?
StandardAmazon data-engineer rounds test AWS-native ETL (Glue, S3, Redshift, EMR), idempotency, and schema-evolution handling. - 07Practise
How do you design a data-quality framework that catches broken pipelines and bad data before it reaches business dashboards? What checks and alerts do you add?
StandardAmazon prizes operational rigour: data-quality gates, freshness/volume/schema checks, and clear ownership of pipeline SLAs. - 08Practise
Design a recommendation model for a marketplace with millions of items and cold-start users. How do you handle sparsity and evaluate offline versus online?
IntenseAmazon applied-scientist rounds test recommender design: cold start, sparsity, candidate generation versus ranking, and offline/online eval alignment. - 09Practise
How would you detect and correct for label leakage in a fraud-detection model before it silently inflates offline metrics?
StandardAmazon probes ML rigour: leakage detection, temporal validation, and the gap between offline metrics and production performance. - 10Practise
Explain precision, recall, and how you'd choose an operating threshold for a model that flags suspicious transactions where false positives annoy customers.
StandardAmazon applied-scientist rounds tie metrics to business cost. Reason about the precision-recall trade-off in terms of customer friction and cost.
