Ramp onsite - 4 rounds done, architecture round had a surprise SD

Ramp onsite - 4 rounds done, architecture round had a surprise SD

Result: Pending Number of Rounds: 4

Got through the phone screen 3 weeks ago and moved to onsite last week. Recruiter said to read any prep materials they sent carefully. The format is different from most places.

Coding round was practical. Flight data analysis. Get_user_with_most_flights() and get_user_location(time) from JSON flight records. Binary search for the time query. Spent a few minutes at the start just exploring the JSON format before writing anything, which the recruiter materials basically told me to do.

AI coding round was multi-source data reconciliation. Define matching logic across customer records from two different sources. The AI tooling was available but I wasn't sure how to evaluate myself on this one. Felt more about approach than output.

Architecture round was supposed to be just a project deep dive but the interviewer added a system design question at the end. Sliding window aggregation for tracking website visits in the past minute. Not what I expected.

Behavioral was standard.

Waiting on results. If the phone screen timeline holds, should hear in 3 days.