Quick 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.

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

Loading…