I applied online.

Experience was good, they made me comfortable throughout the interview process, I was judged on the basics specifically PySpark, SQL, and data warehousing concepts.

Round 1 — 1-Hour Interview

The interview started with a brief discussion about my current work, highest qualification, self-introduction, and general background.

• What is Data Engineering?
• Who is a Data Engineer, and how does a Data Engineer’s role differ from that of a Data Analyst?
• Explain the project you recently worked on and describe its overall architecture.
• What is Medallion Architecture?
• How were you implementing CDC (Change Data Capture) in your project?
• If corrupted data compromises your data warehouse, how would you handle the situation?
• How do you perform data quality checks?
• What are the different types of joins in Spark?
• Explain Broadcast Join in detail.
• What is the difference between ETL and ELT?
• What is the difference between an EDW (Enterprise Data Warehouse) and an EDL (Enterprise Data Lake)?
• Solve the Two Sum problem.
• What are the different types of constraints in SQL?
• Explain the Referential Integrity constraint in detail.

Project Based Discussion and Basics of Data Engineering