Interview experience

Amazon · Data Engineer · Mid-Level

Community-sourced A factual summary of an interview experience shared publicly outside interviewd.

Sep 28

In Progress

Overall Experience

The process included a timed online assessment followed by an elimination technical interview. The interview began with a résumé discussion and covered data engineering fundamentals.

2 rounds

Posted by interviewd

Interview Process (2 rounds)

Round 1 of 2: Online Assessment

90 min

Question 1

Medium

The 90-minute assessment contained 10 multiple-choice questions and two medium SQL questions. What did the SQL tasks evaluate?

Experience

They tested query-writing skills and SQL fundamentals; exact prompts were not provided.

60 min

Question 1

Medium

Explain physical joins, hash joins, and broadcast nested-loop joins.

Experience

Compare the join strategies and their use in data processing.

Question 2

Medium

How do GROUP BY aggregations differ from window functions?

Experience

Discuss how each computes results over grouped or related rows.

Question 3

Medium

What are Slowly Changing Dimensions and their types?

Experience

Explain SCD concepts; specific types were not enumerated.

Question 4

Medium

How do star and snowflake schemas differ?

Experience

Compare the two data warehouse schema designs.

Question 5

Medium

How would you optimize SQL queries?

Experience

Discuss query optimization approaches; no specific approach was recalled.

Question 6

Medium

How do a data warehouse, data lake, and lakehouse differ?

Experience

Compare their data storage and processing roles.

Question 7

Medium

How does traditional batch architecture differ from event-driven incremental ingestion?

Experience

Compare ingestion patterns.

Question 8

Medium

What is idempotency in data processing?

Experience

Explain the concept in the context of data workflows.

Question 9

Medium

What is change data capture (CDC)?

Experience

Explain how CDC identifies and propagates data changes.

Question 10

Medium

Write a SQL query about consecutive user logins.

Experience

A live SQL coding task asked about consecutive user logins; the exact schema and expected output were not recalled.

Sort by:

Loading comments…