Skip to contentSkip to footer

Bi Engineer Interview Questions

Salaries
Interviews

1,658 bi engineer interview questions shared by candidates

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?

Based on Amazon principles: 1. Share one instance where in you worked beyond your level/work and what was the achievement in terms of metrics? 2. Share one scenario showing leadership skills where you took ownership of some task and how you executed it? SQL questions: 1. userid status Timestamp 1 in 2019-01-01 08:00:00 1 out 2019-01-01 18:00:00 2 in 2019-01-01 09:00:00 2 out 2019-01-01 17:00:00 1 in 2019-01-01 19:00:00 quest: Write a query to give the users in the building between timestamp a & b? 2. Write a query to find the first active timestamp and last inactive timestamp for following? userid status cr_time 1 active 2019-01-01 08:00:00 1 active 2019-01-01 09:00:00 1 inactive 2019-01-01 10:00:00 1 inactive 2019-01-01 11:00:00 2 active 2019-01-01 08:00:00 2 inactive 2019-01-01 12:00:00
avatar

Senior BI Engineer

Interviewed at Amazon

3.5★
Apr 5, 2019

Based on Amazon principles: 1. Share one instance where in you worked beyond your level/work and what was the achievement in terms of metrics? 2. Share one scenario showing leadership skills where you took ownership of some task and how you executed it? SQL questions: 1. userid status Timestamp 1 in 2019-01-01 08:00:00 1 out 2019-01-01 18:00:00 2 in 2019-01-01 09:00:00 2 out 2019-01-01 17:00:00 1 in 2019-01-01 19:00:00 quest: Write a query to give the users in the building between timestamp a & b? 2. Write a query to find the first active timestamp and last inactive timestamp for following? userid status cr_time 1 active 2019-01-01 08:00:00 1 active 2019-01-01 09:00:00 1 inactive 2019-01-01 10:00:00 1 inactive 2019-01-01 11:00:00 2 active 2019-01-01 08:00:00 2 inactive 2019-01-01 12:00:00

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)

Viewing 1071 - 1080 interview questions

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