Why is parquet file way faster when retrieving data from compared to csv?
Data Engineer Interview Questions
20,238 data engineer interview questions shared by candidates
They want to know why you're interested in the company and the team/job.
Questions on Joins, CTE, recursive CTE, UNION and common scenarios, self join , manager question.
Why several switches in your previous roles? What was some feedback that you received in your previous roles? Did you leave your last job without any offer in hand? What are you looking for in your next job? Design a data quality system.
They've shown great interest in my previous experience and actually asked concise questions around what I did.
What are slowly changing dimensions?
How would you get all the records that are in table A but not in table B?
Describe the project and what was the major issue you have faced.
Stats, distributed systems, databases, map-reduce, general analytics skills
Top k most frequent element -> leetcode medium, ETL/ELT experience, snowflake/stars schema.
Viewing 1481 - 1490 interview questions