Recruiters question was tell me about yourself? About your project? Past experiances why did you choose this company? Then they handover the task.
Senior Data Engineer Interview Questions
2,569 senior data engineer interview questions shared by candidates
Leetcode anagram question Design data model for fitness app. Design Etl pipeline for user behavior analytics. How would you analyze sudden drop in certain metrics.
Q: What was the one thing that they asked you?
Prisoner's dilemma Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with the other. The police admit they don't have enough evidence to convict the pair on the principal charge. They plan to sentence both to a year in prison on a lesser charge. Simultaneously, the police offer each prisoner a Faustian bargain.
Most questions were around Snowflake, dbt, and SQL especially how I build models, handle data quality tests, and write efficient queries.
1. When will you use cte vs subquery
Q: How would you resolve a conflict among two of your coworkers?
Ask about SQL question with emp name , emp Id and emp salary to calculate cumulative sum .
General data warehousing questions and experience chat
What are data quality metric you would implement for a real-time ingestion pipeline ?
Viewing 1441 - 1450 interview questions