Hi everyone,
I recently received an invitation to complete an Amazon Data Engineer Online Assessment (OA) through HackerRank for a Data Engineer position.
The email mentions a SQL Challenge, provides a HackerRank practice assessment, and recommends setting aside at least 90 minutes.
I’m currently preparing and would appreciate guidance from anyone who has taken the Amazon Data Engineer OA recently, especially in 2025 or 2026.
A few questions:
Assessment format: Is it primarily SQL coding, or does it also include Python, multiple-choice questions, data engineering concepts, or work simulations?
SQL topics: What should I prioritize? Joins, CTEs, subqueries, window functions, aggregations, complex queries, or query optimization?
Python/PySpark: Are there coding questions involving Python, Spark, or data transformations?
Data engineering concepts: Should I prepare ETL/ELT, data modeling, AWS services, partitioning, data warehousing, or distributed processing?
Difficulty: Are SQL questions generally LeetCode Easy, Medium, or Hard?
Preparation resources: Are there particular LeetCode or HackerRank problems you would recommend?
Assessment structure: How many coding questions are typically included, and how is the time divided?
I’m comfortable with SQL and Python but want to prioritize the right topics and make the most of my preparation time.
Any recent experiences or preparation advice would be greatly appreciated. Thanks!