Skip to contentSkip to footer

Junior Data Engineer Interview Questions

Salaries
Interviews

469 junior data engineer interview questions shared by candidates

1. From two flight tables fetch the time taken between src date and destination date. 2. From two tables fetch the name from table A and email from table B. 3. Find the 2nd highest salary from the employee table. 4. Which AWS service did I used and how to automate that process. 5. Count function. 6. Fetch the data where email is null in employee table. 7. Sum of even numbers in a list in python. 8. How to convert a list into dataframe using PySpark. 9. How to read a csv file using PySpark.
avatar

Junior Data Engineer

Interviewed at Tenant Inc.

3★
Mar 4, 2025

1. From two flight tables fetch the time taken between src date and destination date. 2. From two tables fetch the name from table A and email from table B. 3. Find the 2nd highest salary from the employee table. 4. Which AWS service did I used and how to automate that process. 5. Count function. 6. Fetch the data where email is null in employee table. 7. Sum of even numbers in a list in python. 8. How to convert a list into dataframe using PySpark. 9. How to read a csv file using PySpark.

Questions asked on Python, SQL, Previous work experience (Spark), and Some HR related 1. What is the Yield key does? 2. What is the difference between Inner and Outer join, window function use cases with example. 3. As I mentioned the spark optimization tasks in my previous job, asked about spark architecture repartition, count, sort, etc. 4. They were highly interested UnitTests some questions about that. 5. Hr asked about what's your motivation to apply for the position? 6. What is the difficult situation you faced and how did you tackle it. 7. What do you want to become in the next 5 years time down. 3. It's an onsite interview, where I visited the Berlin office for a coding session. coding question was easy, I need to print numbers 1 to 100, and if it's multiples of 3 print smart, and multiples of 5 print clip. note: for coding questions, I can choose any language they wanted to check how I approach the problem and solve it. They are very much interested in how I write test cases with 100% coverage, this was the interviewer's main motivation to test because the open position required the candidate to write a lot of unit test cases.
avatar

Junior Data Engineer

Interviewed at smartclip

4.3★
Oct 14, 2023

Questions asked on Python, SQL, Previous work experience (Spark), and Some HR related 1. What is the Yield key does? 2. What is the difference between Inner and Outer join, window function use cases with example. 3. As I mentioned the spark optimization tasks in my previous job, asked about spark architecture repartition, count, sort, etc. 4. They were highly interested UnitTests some questions about that. 5. Hr asked about what's your motivation to apply for the position? 6. What is the difficult situation you faced and how did you tackle it. 7. What do you want to become in the next 5 years time down. 3. It's an onsite interview, where I visited the Berlin office for a coding session. coding question was easy, I need to print numbers 1 to 100, and if it's multiples of 3 print smart, and multiples of 5 print clip. note: for coding questions, I can choose any language they wanted to check how I approach the problem and solve it. They are very much interested in how I write test cases with 100% coverage, this was the interviewer's main motivation to test because the open position required the candidate to write a lot of unit test cases.

Viewing 411 - 420 interview questions

Glassdoor has 469 interview questions and reports from Junior data engineer interviews. Prepare for your interview. Get hired. Love your job.