SQL fundamentals + correctness
Joins (inner/left), window functions, deduping, aggregation, handling nulls
“Latest record per key”, sessionization, retention-style queries
Performance thinking: partition pruning, avoiding exploding joins, using appropriate filters
Python fundamentals
Writing clean functions, parsing/transforming data, error handling
Working with dates, JSON, config-driven pipelines
Unit-test mindset (what would you test, edge cases)
PySpark / distributed data
DataFrame API vs SQL, when to use each
Joins (broadcast vs shuffle), repartition/coalesce, caching, skew awareness
Window functions in Spark, incremental processing, idempotency
File formats (parquet), partitioning strategies, reading/writing S3/HDFS
SQL, Python, PySpark, project experience
The following metrics were computed from 2 interview experiences for the Autodesk Data Engineer role in Toronto, Canada.
Autodesk's interview process for their Data Engineer roles in Toronto, Canada is fairly selective, failing a large portion of engineers who go through it.
Candidates reported having very good feelings for Autodesk's Data Engineer interview process in Toronto, Canada.