Deloitte Data Engineer interview questions

Most of the asked for SQL and spark related questions all the question are scenario based they give some code written in spark using python and some sql queries To performed

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.