American Express

What were the biggest infrastructure-level challenges you faced, and how did you resolve them?

Explain the difference between mutable and immutable objects in Python.

Explain the differences between multiprocessing and multithreading.

Write a decorator function to log the execution time of a function.

Describe a cross-team data project where you had to align architectural boundaries, ownership, and SLAs. How did you handle conflicting priorities, technical debt, and the scalability of communication as the number of stakeholders grew?

How do you handle schema evolution in data lakes or data warehouses?

Write a query to find the first number repeating consecutively three times in a sequence.