Real questions from top companies
Why should we hire you for this role?
Explain the difference between Azure Data Factory (ADF) and Databricks.
How do you handle data security and compliance in a cloud environment?
What are the key components of AWS Glue, and how do they work together?
What is Azure Data Factory (ADF), and what are its main components?
What is Snowflake's architecture, and why is it unique?
What is the difference between S3 and HDFS?
What is the role of AWS Lambda in a data engineering pipeline?
What is the role of the Integration Runtime (IR) in ADF?
Briefly explain the architecture of Kafka.
Describe the data pipeline architecture you've worked with.
Explain the trade-offs between batch and real-time data processing. Provide examples of when each is appropriate.
Have you worked on Data Warehousing projects?
How would you read data from a web API? What steps would you follow after reading the data?
Retrieve the most recent sale_timestamp for each product (Latest Transaction).
What is the difference between OLTP and OLAP?
What is the difference between SQL and NoSQL databases?
Detail examples of inner, outer, left, and right joins.
Difference Between Internal and External Tables in BigQuery
Difference between ROW_NUMBER(), RANK(), and DENSE_RANK() with examples.