Basic sql using aggregations, window functions like lead,lag, row number etc
Sr Data Engineer Interview Questions
2,605 sr data engineer interview questions shared by candidates
1. Coding question (Easy) 2. SQL questions - window functions , query optimisation 3. BigData tools
Q: What is a data lake and how is it compared to a data warehouse?
Do you know the programming language Scala?
How do you design a DWH based on client requirements
Given dataset in CSV, create an ETL pipeline and RESTful API endpoints.
Can you design a sql script and report pipeline given a couple of tables?
Tell me about the time you disagreed with someone on your team
Q: Given the card table, and given that a customer can only have one open card at any given time, how would you determine each card's close_date?
Q: By customer by month, what is the total value of transactions?
Viewing 891 - 900 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