Whenever you're ready, walk me through how you'd approach this.
Design a CSV merging API.
Clarify how the API should handle file upload, schema validation, duplicate headers, row-level conflicts, and output delivery. Assume the service is used by internal AWS customers and must support both synchronous merges for small files and asynchronous jobs for large files.