Data Engineering Interview Questions

20,954 data engineering interview questions shared by candidates

Python -Count distinct words in a sentence -Count the number of times a word appear in a sentence using a Hash Map -Return tuples of a list, matching each item to another item -Count the number of times a substring appear in a string SQL -Return min and max age of male/female who bought a product -Count the number of stores in a state with grand total ? 25000 sq feet
avatar

Data Engineering

Interviewed at Meta

3.5
Jun 2, 2017

Python -Count distinct words in a sentence -Count the number of times a word appear in a sentence using a Hash Map -Return tuples of a list, matching each item to another item -Count the number of times a substring appear in a string SQL -Return min and max age of male/female who bought a product -Count the number of stores in a state with grand total ? 25000 sq feet

2) create daily revenue report between given start_date and end_date output schema: (order_date, number_of_customers, number_of_orders, daily_total_order_amount, mtd_order_amount) mtd_order_amount - total order_amt from the beginning of the month till order_date
avatar

Data Engineer - Business Intelligence

Interviewed at Amazon

3.5
Apr 6, 2018

2) create daily revenue report between given start_date and end_date output schema: (order_date, number_of_customers, number_of_orders, daily_total_order_amount, mtd_order_amount) mtd_order_amount - total order_amt from the beginning of the month till order_date

Calculating percentage of sales percentage of non dat and regular products Calculating percentage of sales that matched the start date and end date of the promotion Fill the none values in a list with the previous non none value
avatar

Data Engineer

Interviewed at Meta

3.5
Oct 7, 2020

Calculating percentage of sales percentage of non dat and regular products Calculating percentage of sales that matched the start date and end date of the promotion Fill the none values in a list with the previous non none value

try to get a pattern out of string or json. ask you to translate numbers from 1 to 100 to names of numbers ( for example 34 translated to thirty-four). you need to come with a solution within 10 seconds, I am able to get it done within 2 minutes. That's not fast enough.
avatar

Senior Data Engineer

Interviewed at Meta

3.5
May 8, 2018

try to get a pattern out of string or json. ask you to translate numbers from 1 to 100 to names of numbers ( for example 34 translated to thirty-four). you need to come with a solution within 10 seconds, I am able to get it done within 2 minutes. That's not fast enough.

Viewing 91 - 100 interview questions

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