Sign up for free to view this conversation on Fishbowl By continuing you agree to
Participate in safe communities with other verified professionals.
Candidly discuss workplace matters in company exclusive channels and group chats.
Flexible identity preferences allows honest conversations with other colleagues.
Already have an account? Log in
More Posts Posting as :
Example questions
The main difficulty with TPM interviews at Amazon is that youll be asked a wide range of questions. Weve grouped them in three buckets and analyzed how frequently they were asked by Amazon interviewers using TPM interview reports available on Glassdoor.
Here are the results of our analysis:
Behavioral questions (54%)
Technical questions (36%)
Program management questions (10%)
Related Posts Posting as :
Amazon Business Intelligence Engineer Technical and SQL Interview Questions
Some past Amazon BI Engineer interview questions include:
How would you simplify a complex pipeline?
How is variance calculated in PCA?
Name the assumptions in a random forest model.
Are there any statistical problems when the analysis to know whether people like a product is based on their behavior on the website?
How would you design a data model for Lyft App?
What are dimension and fact tables?
Explain how youâd set up an online A/B testing scenario and decide whether to roll out a new program based on the test results.
In a new project, how would you tell if the data weâre using is correct and will give accurate results?
Differentiate between OLTP and OLAP.
Explain the concept of a join to a non-technical person.
You need to find the traffic insights on your website. Write an SQL query to find the top 10 people who visited the website in the last six months.
Explain all types of joins in SQL.
When would you use ELT over ETL, and Why?
What is the difference between union and union all? Which one is faster?
What are DML, DCL, and DDL?
How would you handle a report running slowly?
Write code to get the largest palindrome product of two numbers. The number of digits of the two numbers isnât fixed.
Explain the ways we can optimize queries and tune performance.
