Last interview consisted of a case study that was supposed to showcase something I did in the past or I could also pick a task predefined by them.
Sr Data Engineer Interview Questions
2,552 sr data engineer interview questions shared by candidates
Oh, you code in SQL? I sent you a link. CODE SQL OR ELSE!!!!!
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 !!!!!!
Viewing 2041 - 2050 interview questions