How would you design a data pipeline to capture real time data.
Sr Data Engineer Interview Questions
2,592 sr data engineer interview questions shared by candidates
How do you optimize SQL query? What is the difference between tuple and list in Python?
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
Viewing 391 - 400 interview questions
See Interview Questions for Similar Jobs
Data EngineeringSenior Data EngineerBig Data EngineerSenior Big Data EngineerData EngineerSenior Data ConsultantLead Data EngineerData ScientistsData Scientist IiiPrincipal Data EngineerData Mining EngineerBigdata EngineerSr Data AnalystEtl Data Stage DeveloperSr Database EngineerDatabase Administrator IiSenior Data Stage DeveloperEtl Informatica Developer