Skip to contentSkip to footer

Bi Developer Interview Questions

Salaries
Interviews

4,380 bi developer interview questions shared by candidates

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 2861 - 2870 interview questions

Glassdoor has 4,380 interview questions and reports from Bi developer interviews. Prepare for your interview. Get hired. Love your job.