Reason About Indexes, Kafka, and Database Locking
Company: Persistence
Role: Software Engineer
Category: Software Engineering Fundamentals
Difficulty: medium
Interview Round: Onsite
Overview: Reason through practical database indexes, Kafka consumption, and transaction locking using concrete order and inventory workloads. The interview tests query-driven index design, partition ordering and consumer progress, duplicate-safe processing, atomic stock updates, concurrency control, deadlocks, and bounded retry.