Find Strictly Decreasing Forecast Windows for Equatorial Cities
Company: Versemedical
Role: Software Engineer
Category: Software Engineering Fundamentals
Difficulty: medium
Interview Round: Onsite
Overview: Build a reliable report that queries equatorial cities from PostgreSQL, fetches three days of hourly forecasts, and finds every strictly decreasing eight-hour window. The exercise covers parameterized data access, timestamp continuity, overlapping windows, API failures, rate limits, testing, and repeatable operations.