Amazon Data Scientist Phone Screen Questions

Interview Location : India Hyderabad, Round 1: was an online assesment on hacker rank , which I thought I failed but somehow made it. Round 2 : was a phone screen with...

Question 1: You have first two columns in the below table, how do you display the third column like shown below Table1: dw_run_date\tunits\tRolling_3_day_demand 4/20/2020 0:00\t10\t10 4/21/2020 0:00\t20\t30 4/22/2020 0:00\t30\t60 4/23/2020 0:00\t40\t90 4/24/2020 0:00\t50\t120 4/25/2020 0:00\t60\t150 4/26/2020 0:00\t70\t180 4/27/2020 0:00\t80\t210 4/28/2020 0:00\t90\t240 4/29/2020 0:00\t100\t270 4/30/2020...

Summary: Just got an offer for a Business Analyst role at Amazon and feel super excited! The technical assessments were pretty straightforward. I found the Amazon SQL on LC and buying...

After a long follow up with Amazon HR team today I took my telephonic interview round 1 for a Business Intelligence role, After my little introduction we jumped into sql...

Hi folks, just wanna share a few sql questions I had on a recent Amazon Data Scientist phone interview there are 2 tables: STREAMS and TITLES STREAMS table USER_ID TITLE_ID STREAM_TIMESTART STREAM_MINUTES Key for this table is...

I had the phone interview with a senior BIE today in which I was asked below sql question- Write a SQL query to calculate total time spent by each employee on...

ORDERS order_id varchar customer_id int order_datetime timestamp item_id varchar item_price decimal item_quantity int primary key (order_id, item_id) ITEMS item_id varchar(10) item_category varchar(20) primary key (item_id) ADDRESSES customer_id int start_date timestamp end_date timestamp zip_code...

Masters Candidate, Tier1 College Campus Hiring Role: Data Scientist II Intern Duration of Internship: 6 months Stipend: 1.4 LPM Number of Rounds: 2 Round 1: Standard Coding Test (7 Debugging Questions + 2 Coding Questions +...

5 mins- ice breaker Talk about yourself other than whats on resume. General questions - Talk about what you do as a BIE your accomplishments walk through some of the dashboards you have worked...

I will have phone interview (technical 1 hour) with Amazon for DS role for Alexa shopping team. Also I\'m new in LeetCode, where can I start to prepare for this...