Generate user notifications from schedules
Company: Stripe
Role: Software Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: Medium
Interview Round: Technical Screen
Given a schedule template format and user profile data (timezone, locale, delivery preferences), implement a program that generates a user notification sheet. The program should merge event data with user information, handle recurring events, perform correct timezone conversions, localize date/time and text, resolve conflicting or overlapping events, and validate missing or malformed fields. Specify input and output schemas, show example transformations, and discuss the time and space complexity of your approach.
Quick Answer: This question evaluates skills in data manipulation and integration, including schema design, merging event and user profile data, recurring event handling, timezone and locale-aware conversions, conflict resolution, and data validation using SQL and Python.