Various Python, Snowflake, and dbt questions. More heavily weighted to Python, as noted above. Some ETL vs ELT and OLAP vs OLTP questions.
Sr Data Engineer Interview Questions
2,552 sr data engineer interview questions shared by candidates
Design an ETL pipeline that loads data every hour from X system to Y System with consistency and reliability describing edge cases.
interview 1 : 30 min screen call with engineering lead interview 2: 60 coderpad coding round. I was asked to optimized text search. Interview 3: 60 min debugging interview in python. they will give some code with bugs and then they will ask you to fix code to pass test cases Interview 4: 45 min data quality. i was given some football match dataset to draw insights to figure out who will buy the tickeys Interview 5: 45 min ML infra. they will ask you how would you push something developed by data science to production Interview 6: 2hr behavioral interview. they will start with your undergrad and will ask each and every thing about your schools, universities etc etc
Primarily on the data warehousing and cloud part
Previous data engineering experience, data pipelines and tech stack related questions.
Tell me about a project you worked on recently.
Coding questions were not algorithmic puzzles, but real life usage of calling web apis and processing data.
write sql query and then python code for a table of events and return a pivot like response for certain values.
What is data management? and follow-ups from the answer.
asked about time complexity and space complexity
Viewing 1991 - 2000 interview questions