I recently interviewed with Advance Auto Parts for a Junior Data Engineering position. The process focused heavily on technical skills. I was asked to write PySpark queries for data transformations and also solve SQL problems involving window functions. They discussed my project experience in detail, particularly how I handled both real-time and batch data pipelines, and wanted to understand my approach to designing and managing data flows. Additionally, I was asked about the different techniques to optimize SQL queries, such as using proper indexing, minimizing subqueries, applying partitioning, avoiding unnecessary joins, and analyzing query execution plans.