Senior Data Engineer Interview Questions

2,567 senior data engineer interview questions shared by candidates

Write a SQL and PySpark code to display the 2nd lowest salary employees for each department having more than 10 employees, along with their employee name and department name. Two tables Employee and Department is giving? What to use Row_Number, Rank or Dense Rank?
avatar

Senior AWS Data Engineer

Interviewed at Blend360

4.1
Jun 5, 2025

Write a SQL and PySpark code to display the 2nd lowest salary employees for each department having more than 10 employees, along with their employee name and department name. Two tables Employee and Department is giving? What to use Row_Number, Rank or Dense Rank?

A few generic questions around Data Warehousing/ETL approach, scenario based questions. One interviewer was asking questions from Interview Q&A website, was not happy if answers and terms didn't match exactly. You don't ask syntactical questions to experienced staff who can lookup manual in a minute and figure things out.
avatar

Senior Data Engineer

Interviewed at Acrisure

2.9
Nov 2, 2022

A few generic questions around Data Warehousing/ETL approach, scenario based questions. One interviewer was asking questions from Interview Q&A website, was not happy if answers and terms didn't match exactly. You don't ask syntactical questions to experienced staff who can lookup manual in a minute and figure things out.

Viewing 1451 - 1460 interview questions

See Interview Questions for Similar Jobs

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