Deloitte Data Engineer Interview Questions and Answers

Inbuilt platform where asked gcp releated mcqs

Q1. Python question on list
Add your answer
Q2. Sql window function question
Add your answer

Q1. Tell me about Azure data bricks
Ans. 
Azure Databricks is a unified analytics platform that provides collaborative environment for big data and machine learning.
• Azure Databricks is built on Apache Spark and provides a collaborative workspace for data engineers, data scientists, and machine learning engineers.

• It offers integrated notebooks for interactive data exploration and visualization.

• Azure Databricks allows for seamless integration with other Azure se...read more
Answered by AI
Add your answer
Q2. What are spark optimization techniques
Ans. 
Spark optimization techniques improve performance and efficiency of Spark jobs.
• Partitioning data correctly to avoid data shuffling

• Caching intermediate results to avoid recomputation

• Using appropriate data formats like Parquet for efficient storage and retrieval

• Tuning memory settings for optimal performance

• Avoiding unnecessary data transformations
Answered by AI
Add your answer

Q1. Asked for record cound in different types of joins
Ans. 
Understanding record counts in different types of SQL joins is crucial for data analysis and integrity.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id.

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id.

• RIGHT JOIN: Returns all records from the right table and...read more
Answered by AI
Add your answer
Q2. Lambda function related coding question
Ans. 
Lambda functions are anonymous functions defined using the lambda keyword in Python, useful for short, throwaway functions.
• Lambda functions can take any number of arguments but only have one expression. Example: lambda x: x + 10.

• They are often used in conjunction with functions like map(), filter(), and reduce(). Example: list(map(lambda x: x * 2, [1, 2, 3]))

• Lambda functions can be assigned to variables. Example: doubl...read more
Answered by AI
Add your answer
Q3. Window function related queries
Add your answer

Q1. What is your qualifications?
Ans. 
I hold a degree in Computer Science and have extensive experience in data engineering, ETL processes, and cloud technologies.
• Bachelor's degree in Computer Science with a focus on data management.

• 3+ years of experience in data engineering roles, working with large datasets.

• Proficient in SQL, Python, and data pipeline tools like Apache Airflow.

• Experience with cloud platforms such as AWS and Azure for data storage and pro...read more
Answered by AI
Add your answer

Basic Python and sql questions

Q1. Why you want to change your Job
Ans. 
Seeking new challenges and growth opportunities in a more dynamic environment.
• Looking for new challenges and opportunities for growth

• Interested in working in a more dynamic environment

• Seeking to expand my skills and knowledge in data engineering

• Want to work with cutting-edge technologies and tools
Answered by AI
Add your answer
Q2. Why Deloitte and what is your expected CTC
Ans. 
I chose Deloitte for its reputation in the industry and the opportunities for growth. My expected CTC is based on market standards and my experience.
• Chose Deloitte for its strong reputation in the industry

• Opportunities for growth and development

• Expected CTC based on market standards and experience
Answered by AI
Add your answer

Q1. What is the Underlying Architecture of bigquery
Ans. 
BigQuery is a fully-managed, serverless data warehouse that uses a distributed architecture to process and analyze large datasets.
• BigQuery uses a distributed architecture to store and process data, allowing for scalability and high performance.

• It separates storage and compute, enabling users to scale each independently based on their needs.

• BigQuery leverages Google's infrastructure to automatically handle tasks like re...read more
Answered by AI
Add your answer
Q2. What is difference between Cloud Run and Cloud Functions
Ans. 
Cloud Run is a fully managed compute platform that automatically scales your stateless containers, while Cloud Functions is a serverless execution environment for building and connecting cloud services.
• Cloud Run is designed for running containerized applications, while Cloud Functions is designed for running single-purpose functions.

• Cloud Run allows you to run any stateless container, while Cloud Functions only support...read more
Answered by AI
Add your answer