SQL aggregation and window function questions applied to a certain dataset
Sr Data Engineer Interview Questions
2,595 sr data engineer interview questions shared by candidates
Open questions, but generally about data architecture, CICD, IaC, data partitioning, Processing frameworks, orchestrator frameworks and so on.
Well thought out data structures & algorithm questions with interesting spins on common questions. If you have a decent foundation in CS fundamentals and are able to think on your feet to apply these fundamentals you should be able to do well.
How would you design end to end pipeline given what you have experienced and know?
Window function in sql and uses.
A simple test on Python and SQL
Had two homework assignments, one about coding in Python and the other one about writing a complicated SQL query. In the interviews we talked about SQL queries, AWS, Python, stakeholder management and mentorship.
Tell me about the last time you broke production.
What can you do to improve the performance of a SQL script?
1. Parse csv using standard library and do joins between tables 2. Optimize the query 3. remove duplicates of records between start date and end date
Viewing 461 - 470 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