Data sparsity, data assets , sql logics
Sr Data Engineer Interview Questions
2,437 sr data engineer interview questions shared by candidates
From your experience, how you would build a scalable architecture to ingest data from rdbms data to data warehouse or data lake?
They asked me regarding Airflow Pyspark, cloud technologies, kafka, mysql, postgresql.
How would you design a data pipeline to capture real time data.
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
Viewing 371 - 380 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