In Lyft operations workflows, raw exports from tools like Lyft Console or support intake sheets often contain the same business field in two columns with inconsistent formatting. Interviewers want to see whether you can standardize messy values before combining them into a single usable column.
Explain how you would clean and merge two columns when they represent the same information but use different formats. For example, one column may contain phone numbers with punctuation while another stores digits only, or one column may have city names with inconsistent casing and whitespace.
Address these points:
Keep the answer practical and SQL-focused. The interviewer is not looking for a full ETL architecture discussion; they want a clear PostgreSQL-based approach using common cleaning functions and simple decision logic.