Deloitte Data Engineer interview questions

Normal Interview Process: The typical selection process consists of two technical rounds followed by one HR round. Technical Rounds: In the technical interviews, you can expect questions and hands-on tasks focused on the following areas: • SQL: Writing complex queries, optimizing joins, working with window functions, CTEs, and handling large datasets efficiently. • Python: Core programming concepts, data structures, functions, and scripting for data processing and automation tasks. • PySpark: Working with big data using Spark, including data transformation, performance tuning, and writing efficient Spark jobs in PySpark. • Azure Databricks: Implementing ETL pipelines, notebooks, and collaborating using Databricks for big data processing and analytics. • Data Warehousing Concepts: Understanding of dimensional modeling, star and snowflake schemas, fact and dimension tables, and best practices for building scalable data warehouses. • Azure Data Factory: Designing, scheduling, and monitoring data pipelines for data movement and transformation in the Azure ecosystem. HR Round: The HR interview focuses on assessing communication skills, cultural fit, career goals, and discussing salary expectations, notice period, and other HR formalities.