How will you model a OLTP and OLAP database ?
Sr Data Engineer Interview Questions
2,556 sr data engineer interview questions shared by candidates
Implement this function, describe how you would optimize, discuss runtime & complexity.
Questions related to data modeling, DW design, metadata management, spark
SQL and Python related questions.
Last interview consisted of a case study that was supposed to showcase something I did in the past or I could also pick a task predefined by them.
Oh, you code in SQL? I sent you a link. CODE SQL OR ELSE!!!!!
Round 2 Interview Topics Python Basic concepts such as generators and iterators. Sorting a list without using built-in functions. SQL Fundamental SQL queries. Analytical operations using window functions and data deduplication. PySpark Optimization techniques. Operations with window functions, grouping, filtering, and exploding data. System Design Questions Provide a detailed explanation of one of your projects, including end-to-end (ETE) project design. How the ETL process flow works?. Describe how you would develop an anomaly detection algorithm and an alerting mechanism.
Tell me about yourself ?
Explain about your project from end to end
Describe your tech stack and explain why you used that exact stack.
Viewing 2041 - 2050 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