Online Assessment (OA) / Technical Screening – Focuses on Python and SQL coding challenges, data manipulation, and analytical problem-solving. Data Modeling Round – Tests ability to design scalable, normalized/denormalized schemas, star schemas, and handle slowly changing dimensions or business scenarios. Pipeline Design Round – Evaluates your understanding of ETL/ELT pipelines, data ingestion, transformation, orchestration (e.g., AWS Glue, Lambda, Redshift, S3, Kinesis), and performance optimization. Behavioral Round (“Leadership Principles”) – Assesses alignment with Amazon’s 16 Leadership Principles (e.g., “Dive Deep,” “Ownership,” “Invent and Simplify”) through situation-based questions.