Sr Data Engineer Interview Questions

2,552 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.
avatar

Senior Data Engineer

Interviewed at athenahealth

4.1
Oct 19, 2024

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.

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 !!!!!!
avatar

Senior Data Engineer

Interviewed at Cepheid

2.9
Nov 12, 2021

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

Glassdoor has 2,552 interview questions and reports from Sr data engineer interviews. Prepare for your interview. Get hired. Love your job.