Expedia Data Engineer 2 — DSA, hard SQL, Spark/ETL, design; offer

Round 1 (elimination round)

Count all pallindrome substring
2 leetcode hard sql.
3-4 spark questions.

Round 2

Linked list - find a loop and remove it.
2 leetcode hard sql.
2-3 spark questions.
ETL related questions.

Round 3 (System design)

Payment system. ER diagram, and also list all entities and attributes. Then qrite sql queries on top of it.

Round 4 (HM round) (Most important round)

Project discussion and behavioural question.

Round 5

Salary discussion.

SELECTED. But they put me on hold as they found someone else who can join early.