How do you optimize SQL query? What is the difference between tuple and list in Python?
Senior Data Engineer Interview Questions
2,553 senior data engineer interview questions shared by candidates
How did you manage conflict in team?
Questions were on SQL, Kafka, and programming Data Warehousing designs and data pipeline building
What are your top skills?
They question were on performance tuning data partitioning in SQL
Asked about projects, ETL pipelines, Gave some ETL scenarios and asked how to solve them, diff between Natural key and Surrogate key, Asked to write a lot of SQL queries (~12 questions), questions about joins, dimensional modeling Asked questions focusing on the tech stack used by them, indexing, coalesce, if null, how to increase query performance, factless fact, list vs tuple
Q: Do you know about columnar data format?
Why are interested in this specific role?
Java, spark
It was mostly about the technical expertise.
Viewing 381 - 390 interview questions