Data Engineer Interview Questions

18,677 data engineer interview questions shared by candidates

SQL: 1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products 2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales. Coding(Java): 1. find avg word length in a sentence 2. ip address validation 3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);
avatar

Data Engineer

Interviewed at Meta

3.6
Jun 2, 2019

SQL: 1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products 2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales. Coding(Java): 1. find avg word length in a sentence 2. ip address validation 3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);

Questions on the video call were technical, but basic. 1. What are ACID properties 2. What are indexes 3. What is the difference between Stored Procedures, Functions and Triggers 4. BASE properties 5. JVM, JRE, JDK and JIT 6. What are common table expressions 7. Difference between throw and throws in java 8. What is the difference between Clustered and non clustered index
avatar

Data Engineer

Interviewed at Viant

2.8
Feb 23, 2018

Questions on the video call were technical, but basic. 1. What are ACID properties 2. What are indexes 3. What is the difference between Stored Procedures, Functions and Triggers 4. BASE properties 5. JVM, JRE, JDK and JIT 6. What are common table expressions 7. Difference between throw and throws in java 8. What is the difference between Clustered and non clustered index

Viewing 71 - 80 interview questions

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