Skip to contentSkip to footer

Bi Engineer Interview Questions

Salaries
Interviews

1,658 bi engineer interview questions shared by candidates

Phone interview 1 Q1)Explain bias vs variance (say it in non technical terms) Q2)What is descriptive statisticts Q3)What is spss,explain the steps involved in it Q4)Behavioural question outlining amazon's 14 principles Phone interview 2 Q1) How do you approach data Q2)How do you approach unstructured data Q3)Rate your skills in SQL Q4)Questions on joins (level easy) Q5)Write a sql query related to correlated query (level medium) Q6)Write a sql query related to the previous category implementing it with certain constraints (level hard)
avatar

Senior BI Engineer

Interviewed at Amazon

3.5★
Apr 2, 2020

Phone interview 1 Q1)Explain bias vs variance (say it in non technical terms) Q2)What is descriptive statisticts Q3)What is spss,explain the steps involved in it Q4)Behavioural question outlining amazon's 14 principles Phone interview 2 Q1) How do you approach data Q2)How do you approach unstructured data Q3)Rate your skills in SQL Q4)Questions on joins (level easy) Q5)Write a sql query related to correlated query (level medium) Q6)Write a sql query related to the previous category implementing it with certain constraints (level hard)

Q.Tell me about yourself? Two SQL Questions: Shipment Table (table name - “shipments”): It contains information at a shipment level, with data such as number of items in package, package type, warehouse, country, and the customer ID. Primary key - shipment_id shipment_date shipment_id package_type warehouse_id customer_id num_items country 2020-01-01 112344 BOX WAR1 YYTGBCSDFG 1 US 2020-01-04 927612192 PADDED MAILER WAR2 HIGDSGKJAF 1 UK 2020-04-03 812618726 POLYBAG WAR9 HJFGJLFFHJK 3 IN 2020-06-01 921629712 BOX WAR13 TEEWRJGHKJKG 2 UK 2020-12-05 4982472376 OWN_BOX WAR1 KHGHJFDKLJHFF 10 US Returns table (table name - "returns"): contains information on returns by Amazon customers. Primary key – return_id return_id return_date customer_id 716219621 2017-09-26 ASKGASKAJSA 918261982 2017-03-30 UKHJDLKGSDG 984673876 2017-12-16 UPFASFJSHDV 836453323 2018-09-24 AWETUYOIUBV Q1.Find the number of customers who have had a shipment and made a return during the last 30 days? Q2.Which package type has the highest % of shipments in US in 2020?
avatar

BI Engineer

Interviewed at Amazon

3.5★
Jun 19, 2021

Q.Tell me about yourself? Two SQL Questions: Shipment Table (table name - “shipments”): It contains information at a shipment level, with data such as number of items in package, package type, warehouse, country, and the customer ID. Primary key - shipment_id shipment_date shipment_id package_type warehouse_id customer_id num_items country 2020-01-01 112344 BOX WAR1 YYTGBCSDFG 1 US 2020-01-04 927612192 PADDED MAILER WAR2 HIGDSGKJAF 1 UK 2020-04-03 812618726 POLYBAG WAR9 HJFGJLFFHJK 3 IN 2020-06-01 921629712 BOX WAR13 TEEWRJGHKJKG 2 UK 2020-12-05 4982472376 OWN_BOX WAR1 KHGHJFDKLJHFF 10 US Returns table (table name - "returns"): contains information on returns by Amazon customers. Primary key – return_id return_id return_date customer_id 716219621 2017-09-26 ASKGASKAJSA 918261982 2017-03-30 UKHJDLKGSDG 984673876 2017-12-16 UPFASFJSHDV 836453323 2018-09-24 AWETUYOIUBV Q1.Find the number of customers who have had a shipment and made a return during the last 30 days? Q2.Which package type has the highest % of shipments in US in 2020?

Viewing 1081 - 1090 interview questions

Glassdoor has 1,658 interview questions and reports from Bi engineer interviews. Prepare for your interview. Get hired. Love your job.