Index a CSV Movie Catalog for Fast Year-Range Queries
Company: SIG (Susquehanna)
Role: Software Engineer
Category: Software Engineering Fundamentals
Difficulty: easy
Interview Round: Onsite
Overview: Build an immutable movie catalog from CSV data so frequent inclusive year-range queries avoid scanning every record. A sound design addresses standards-compliant parsing, validation policy, stable tie ordering, preprocessing, boundary searches, edge cases, and precise construction and query costs.
Read the full SIG (Susquehanna) Software Engineer interview experience this question came from