Skip to contentSkip to footer

Data Engineer Interview Questions

Salaries
Interviews

20,985 data engineer interview questions shared by candidates

Asked by the interviewer a "Data Engineer" to join 2 tables together to label start/end of a track play , only when I proposed a working solution he diverted me to another solution that he had in mind all along, thinking it was better as it didn't require window functions, but it did require them. He just didn't know they are called window functions. Admittedly, the "Data Engineer" said he hasn't worked on spark in a while, and is quite junior.
avatar

Data Engineer

Interviewed at Spotify

4★
Apr 7, 2020

Asked by the interviewer a "Data Engineer" to join 2 tables together to label start/end of a track play , only when I proposed a working solution he diverted me to another solution that he had in mind all along, thinking it was better as it didn't require window functions, but it did require them. He just didn't know they are called window functions. Admittedly, the "Data Engineer" said he hasn't worked on spark in a while, and is quite junior.

1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION
avatar

Data Engineer

Interviewed at Meta

3.6★
Oct 26, 2018

1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION

Viewing 161 - 170 interview questions

Glassdoor has 20,985 interview questions and reports from Data engineer interviews. Prepare for your interview. Get hired. Love your job.