Return Every Employee with a Mapped or Default Unique ID
Company: Agoda
Role: Data Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: easy
Interview Round: Technical Screen
Overview: Join employees to unique-ID mappings while preserving unmatched employees and applying an explicit fallback identifier.
Read the full Agoda Data Engineer interview experience this question came from