Design a Sliding-Hour Top-100 User Event Pipeline
Company: Oracle
Role: Software Engineer
Category: System Design
Difficulty: medium
Interview Round: Onsite
Overview: Design a scalable event-time pipeline for the top 100 users in a trailing one-hour window. The answer compares batch and streaming choices, derives bucketed keyed state and exact local-to-global ranking, and covers watermarks, deduplication, skew, checkpoints, and reconciliation.
Read the full Oracle Software Engineer interview experience this question came from