Oh, you code in SQL? I sent you a link. CODE SQL OR ELSE!!!!!
Sr Data Engineer Interview Questions
2,599 sr data engineer interview questions shared by candidates
Round 2 Interview Topics Python Basic concepts such as generators and iterators. Sorting a list without using built-in functions. SQL Fundamental SQL queries. Analytical operations using window functions and data deduplication. PySpark Optimization techniques. Operations with window functions, grouping, filtering, and exploding data. System Design Questions Provide a detailed explanation of one of your projects, including end-to-end (ETE) project design. How the ETL process flow works?. Describe how you would develop an anomaly detection algorithm and an alerting mechanism.
Tell me about yourself ?
Explain about your project from end to end
Describe your tech stack and explain why you used that exact stack.
sql, dsa, puzzle, server , aws , nosql
- Online Interview (SQL) - Technical Discussion about most recent project or most significant one in your career which relevant to the role - System Design ( Revenue Management System) - Cultural Fit
Real time and practical questions
There was a lot of technical questions on ETL/ELT, SQL, Snowflake, Fivetran ,Python ,cloud technologies and implementation in the project . the interviewer were very knowledgeable and down to earth. Even the Managerial round had many technical questions and the interviewer was very humble .There were few personality questions asked like what comes to your mind if about a tiger/crow. The HR round was pretty senseless as per me and they agreed for the offer in first round. In the next interview which was with an HR from Danaher she said that they have a particular amount and said she will release the offer only if i accept it , it seemed i had no say in deciding my compensation. Ultimately they dropped my candidature . Utter Waste of Time !!!!!!
How to architect some system Explain a project in which I had an important invovement and what were my contributions and the challenges What was the asymptotic complexity of the algorithms I implemented
Viewing 2081 - 2090 interview questions