Amex Data Engineer Interview Questions
The questions to prepare for a Amex Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Explain how ROLLUP creates subtotal and grand total rows in SQL aggregations.
AmexIdentify duplicate transaction rows, retain the earliest record, and delete later duplicates safely.
AmexFind the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.
JPMorganChase
Silicon Valley Bank
Banco SantanderImplement a standard merge sort solution that returns an integer array in nondecreasing order.
AmexUse a sliding window and frequency map to find the longest subarray containing at most k distinct values.
AmexSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Build and maintain a reporting model for dashboards using dimensional design, ELT, data quality checks, and scheduled transformations.
AmexDiscuss how cloud storage fits into ETL pipelines, including staging, data quality, and operational monitoring.
AmexCompare Star Schema and Snowflake Schema, including performance, maintainability, storage, and ML analytics tradeoffs.
AmexTests your understanding of multithreading fundamentals and common pitfalls.
Amex