Design a solution for things they are actively working on.
Sr Data Engineer Interview Questions
2,567 sr data engineer interview questions shared by candidates
Recruiters question was tell me about yourself? About your project? Past experiances why did you choose this company? Then they handover the task.
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
Viewing 1441 - 1450 interview questions