Skip to contentSkip to footer

Data Engineer Interview Questions

Salaries
Interviews

18,790 data engineer interview questions shared by candidates

telephonic with technical and SQL coding ) 1 hr Difference b/w SQL and HDFS How do you read, map and reduce and text file in spark ETL How do you create tables in Hive Group by and union with Customer tables Size of data in Hadoop cluster Data warehousing Primarily focused for 45 min on Hive, Spark, Hadoop, HDFS, data warehousing and ETL And, no status on the interview yet, but even though I answered all the questions but, I failed in one coding question of 2 so, I don’t have any hopes for next rounds. It may be useful for you all. Here is the question I got on Amazon Interview Input: SALES_MONTH | PRODUCT_ID |SALE_AMOUNT JAN - 2020 |P1 | 100 FEB - 2020 |P2 | 200 JAN - 2020 |P3 | 500 MARCH - 2020 |P4 | 10 OUTPUT SALES_MONTH | P1_TOTAL |P2_TOTAL JAN - 2020 |100 | 0 FEB - 2020 |0 | 200 MARCH - 2020 |10 | 0
avatar

Big Data Engineer

Interviewed at Amazon

3.5★
Sep 3, 2020

telephonic with technical and SQL coding ) 1 hr Difference b/w SQL and HDFS How do you read, map and reduce and text file in spark ETL How do you create tables in Hive Group by and union with Customer tables Size of data in Hadoop cluster Data warehousing Primarily focused for 45 min on Hive, Spark, Hadoop, HDFS, data warehousing and ETL And, no status on the interview yet, but even though I answered all the questions but, I failed in one coding question of 2 so, I don’t have any hopes for next rounds. It may be useful for you all. Here is the question I got on Amazon Interview Input: SALES_MONTH | PRODUCT_ID |SALE_AMOUNT JAN - 2020 |P1 | 100 FEB - 2020 |P2 | 200 JAN - 2020 |P3 | 500 MARCH - 2020 |P4 | 10 OUTPUT SALES_MONTH | P1_TOTAL |P2_TOTAL JAN - 2020 |100 | 0 FEB - 2020 |0 | 200 MARCH - 2020 |10 | 0

Given a string, write a function “recurring char” to find the strings first recurring character. Return “None” if there is no recurring character. Note: Treat upper and lower case letters as distinct characters. You may assume the input string includes no spaces. Example: input = "interviewquery" output = "i" input = "interv" output = "None"
avatar

Data Engineer

Interviewed at Amazon

3.5★
Aug 16, 2024

Given a string, write a function “recurring char” to find the strings first recurring character. Return “None” if there is no recurring character. Note: Treat upper and lower case letters as distinct characters. You may assume the input string includes no spaces. Example: input = "interviewquery" output = "i" input = "interv" output = "None"

Viewing 1881 - 1890 interview questions

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