Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Amgen Data Engineer Interview Questions

The questions to prepare for a Amgen Data Engineer interview. 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
PipelinesStart here. 37 questions · ~309 min
Design Real-Time IoT Sensor PipelineHard

Design a real-time IoT telemetry pipeline processing 180K sensor events/sec with <10s latency, replayability, data quality checks, and warehouse delivery.

InfrastructureStream ProcessingDependenciesAmgen
Capacity Planning for Data PipelinesMedium

How to think about capacity planning for a pipeline, including throughput, storage growth, latency, and operational headroom.

system designhardware architecturecapacity planningAmgen
Scripting and Automation ToolsEasy

Tests hands-on automation skills and your ability to operationalize scripts safely.

InfrastructureToolsQualityAmgen
More Pipelines questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~72 min
Cleaning Nulls and Duplicate RecordsEasy

Explain how to clean nulls, remove duplicates, and standardize inconsistent values during SQL transformations.

Data WranglingCase WhenAggregationsAmgen
Union vs Union AllEasy

Tests understanding of set operations and their impact on duplicates in SQL.

sqlAmgen
SQL for Patient or Ops DataMedium

Evaluates SQL skills for extracting, aggregating, and transforming complex datasets relevant to Amgen operations.

sql queriesdata extractionAmgen
SQL for Enrollment Funnel Drop-OffMedium
Practice
Practice drill

Measure patient losses between Amgen enrollment stages and calculate each stage's drop-off rate.

Funnel Analysisnull handlingJoinsAmgen
SQL for Output and DefectsMedium
Practice
Practice drill

Aggregate Amgen production, downtime, and defect rates by site, shift, and calendar week.

Date FunctionsJoinssqlAmgen
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
3
Behavioral & Leadership7 questions · ~58 min
Explaining a Technical Concept ClearlyEasy

Tests communication, ownership, and stakeholder management when translating technical complexity into actionable business understanding.

Problem SolvingData Structurestechnical fundamentalsAmgen
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~8 min
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.