Questions / American Express Global Business Travel Data Engineer 1 Star vs Snowflake Schema Written Easy75× 2 Simplify Reporting Queries with CTEs SQL Easy90× 3 Data Quality and Schema Evolution Written Medium378× 4 Data Quality in ETL Pipelines Written Easy1701× 5 Implement CI/CD for Data Pipelines Written Easy6× 6 Data Governance in Pipelines Written Medium172× 7 Design CI/CD for Data Pipelines Written Medium15× 8 Handling a Production Pipeline Failure Written Easy66× 9 Data Validation in ETL Pipelines Written Medium29× 10 Handle Late Data in Streaming Written Hard57× 11 Automate Databricks Pipeline Deployments Written Medium7× 12 Batch vs Stream Processing Trade-offs Written Medium249× Show all 22 questions ↓ Show fewer ↑ 13 Backfilling Missing Pipeline Data Written Medium304× 14 Build Observable Deployment Pipelines Written Medium5× 15 Reduce CI/CD Pipeline Bottlenecks Written Easy5× 16 Improve Data Pipeline Deployment Workflow Written Medium3× 17 Describe a Complex Transformation Pipeline Written Medium114× 18 ETL vs ELT Trade-offs Written Easy212× 19 Optimize a Pipeline Bottleneck Written Medium59× 20 Data Integrity During System Migration Written Hard31× 21 Production Pipeline Quality Monitoring Written Medium148× 22 Fault Tolerance in Data Pipelines Written Hard125×