American Express Global Business Travel Data Engineer Interview Questions
The questions to prepare for a American Express Global Business Travel Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Rank American Express GBT clients within each region using aggregation, a LEFT JOIN, and the RANK window function.
American Express Global Business TravelUse a CTE and windowed SUM to calculate monthly and cumulative travel spend for active corporate accounts.
American Express Global Business TravelRank American Express GBT corporate clients by fiscal-year spend using joins, aggregation, and ROW_NUMBER.
American Express Global Business TravelRecursively validate Commure clinical event payloads against nested object, array, primitive, and required-field rules.
American Express Global Business TravelEvaluates debugging approach for data transformation failures caused by bad or unexpected input.
American Express Global Business TravelSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Compare star and snowflake schemas in a warehouse pipeline, including structure and transformation trade-offs.
American Express Global Business TravelApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
American Express Global Business TravelApproach for maintaining data quality and integrity across ETL pipelines.
American Express Global Business Travel