Order Table OrderID|Merch ID|MerchantID|Category|date|price|quantity|…… MerchantID|ID|Name|Status 1. To find out all merchants with ‘Amazon’ in name and return a column ‘internal customer’ if Upper(Amazon) in name or else ‘3P Seller’. Return Null if the merchant name is null
4. What is ETL? what it is used for
Tell me about yourself. Why Amazon?
Every question was from a questionnaire I received before. They were related to "describe a situation when/where ... you had to ... work on difficult feedback / challenge customer expectations / etc."
HR decides if the candidates is able to move to the next round
Tell me a time when you used the wrong dataset to do data analysis.
I signed an NDA
First round of interview sales SALE_ID PRODUCT_ID YEAR QUANTITY PRICE 1 100 2008 10 5000 2 100 2009 12 5000 7 200 2011 15 9000 11 300 2010 20 7000
Questioned me in depth on the machine learning project for the L5 position of Sr. BIE.
🔹 7. FizzBuzz (Python) Question (reconstructed): Write a simple FizzBuzz function: Print "FizzBuzz" if divisible by 3 and 5 "Fizz" if divisible by 3 "Buzz" if divisible by 5 IMPORTANT. Here how you think about efficiency is tested as well. Check for both first, then check for 3, then for 5. Both because well logically you need that. After for 3 and not for 5 for optimization (less checks overall as more number are divisible per 3 so you never go on the divisible per 5 check.)
Viewing 151 - 160 interview questions