EY Data Engineer interview questions

There was a 2 Rounds of Interview Round 1: 1.Self into 2. Pyspark Coding( top 3 products ) 3. All Joins Operations ( Explain with an Example ) 4. SQL Normalizations 5. ACID Properties 6. Azure Scenario based Questions 7. How to optimize Slow Spark jobs. 8. How can we implement Parallel pipeline Execution in ADF 9. Broadcast Joins 10. Cache & Persistence 11. SQL Window Functions ( Coding ) Round 2: it will be more likely Managerial 1. Self intro 2. Project Discussion 3. Conflicts In Project 4. Domains worked That worked.