Data engineering interview questions
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?
Calculate the total number of transactions (units sold) for each product.
Data Storage and Retrieval Optimization techniques
Data access strategy for clients
Deadlock: Definition and necessary conditions
Describe a project where you implemented a data quality framework.
Describe the ZS projects you worked on
Describe the concept of data sharding and when to use it.
Fetch the rows with the highest scores for each student in a year.
Find orders exceeding $1,000 in the last 30 days.
Find the names of managers who have at least 7 employees directly reporting to them.
Given the data with id, name, and department, how would you calculate how many employees are in each department?
Highlight the tools and technologies you've used in your current project
How do you run one notebook in another notebook?
How do you secure API requests in this setup?
How would you implement custom alarms for data delays or job failures?
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.
Our database contains 46 General/Other questions sourced from real interviews at 97+ companies. The frequency varies by company and role level.
Start with high-frequency questions, understand the underlying concepts, and practice explaining your answers out loud. Use our AI Interview Coach to simulate real interview conditions.
Yes. General/Other questions appear across major tech companies, though the depth and focus varies. Use our company filter to see questions specific to your target company.