Real Optum Data Engineer Interview | Spark & SQL Questions They Actually Asked

Описание: In this video, I’m sharing the real Spark & SQL questions that were asked in my Optum Data Engineer interview.

This was a hands-on coding round focused on practical problem-solving — not just theory. If you're preparing for Data Engineer interviews (especially 2–5 years experience), this will give you a clear idea of what companies actually expect.

I’ve explained:

1. Spark coding scenarios
2. SQL problem-solving questions
3. Real-time data engineering use cases
4. How to approach hands-on rounds
5. Mistakes to avoid

Many candidates prepare only theory, but real interviews test your ability to think and write code.

If you're serious about cracking Data Engineering interviews, this video will help you prepare the right way.

Subscribe to BigData Factory for real interview questions, practical explanations, and industry-level preparation.

#DataEngineerInterviewQuestions
#OptumDataEngineerInterview
#SparkInterviewQuestions
#SQLInterviewQuestions
#PySparkInterview
#BigDataInterviewPreparation
#HandsonCodingRound
#RealInterviewExperience
#dataengineeringcareer


00:00 Video Intro
00:34 Introduction Question
00:49 How do you find the 2nd highest salary in each department using Spark?
01:36 How do you calculate total revenue generated in each department?
02:02 How do you find duplicate records in a Spark DataFrame?
02:25 Policy numbers must always be 4 digits. If less than 4 digits, add leading zeros. How do you handle this in Spark?
02:54 Flatten the list [1, 2, [3, 4]] into [1, 2, 3, 4] in Python.
03:20 Given a large SQL query, how do you identify errors in it?
03:53 Interview Tips
04:49 End