Skip to contentSkip to footer

Data Engineer Interview Questions

Salaries
Interviews

20,163 data engineer interview questions shared by candidates

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

in the phone interview: - pretty basic python algorithm question. Having read the others here, I assumed I'd get pitched a softball and then a harder question. I was able to solve it within the first several minutes, but spent the rest of the session trying to optimize the solution. - some basic SQL questions on joins and such. I answered probably 5 or 6 questions. Both of these interviews seemed like minimum bar screens. For the in-person interview: - more difficult python question and had to code on a white board. It was a pretty simple sorting question that was easy to solve but less trivial to optimize. - more difficult SQL questions. I struggled here but I was a bit weaker in SQL so I figured as much. This progressed into dashboard design. - Lunch was at a cafe on campus and delicious. Interviewer was just asking me about work experience and culture and it seemed just like a general personality compatibility test. - Full Stack interview was my favorite part and a lot of fun. Without giving too much away, I was given a realistic problem and tasked with conceptualizing the solution in real time, from start to finish, on a white board. It was a mix of coding and conceptual and seemed to be meant to test product sense.
avatar

Data Engineer

Interviewed at Meta

3.6★
Sep 27, 2015

in the phone interview: - pretty basic python algorithm question. Having read the others here, I assumed I'd get pitched a softball and then a harder question. I was able to solve it within the first several minutes, but spent the rest of the session trying to optimize the solution. - some basic SQL questions on joins and such. I answered probably 5 or 6 questions. Both of these interviews seemed like minimum bar screens. For the in-person interview: - more difficult python question and had to code on a white board. It was a pretty simple sorting question that was easy to solve but less trivial to optimize. - more difficult SQL questions. I struggled here but I was a bit weaker in SQL so I figured as much. This progressed into dashboard design. - Lunch was at a cafe on campus and delicious. Interviewer was just asking me about work experience and culture and it seemed just like a general personality compatibility test. - Full Stack interview was my favorite part and a lot of fun. Without giving too much away, I was given a realistic problem and tasked with conceptualizing the solution in real time, from start to finish, on a white board. It was a mix of coding and conceptual and seemed to be meant to test product sense.

Viewing 161 - 170 interview questions

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