Hi,\n\nHad my Amazon data engineering internship (summer 2023) interview on Wednesday and I wanted to get my decision before posting this. I just received the offer today. The interview consisted of two 45-minute (each) video interviews back-to-back on amazon chime. They were both pretty easy. Interviewers had their video turned off and were always on mute when they weren\'t speaking so it kind of felt like I was talking to myself most of the time.\n\n**1st Interview**: completely technical\nAsked to introduce myself\n**SQL non-coding questions**\nthe difference between ***union*** and ***union all***. mentions ways to optimize SQL queries. what does the ***except*** sql statement do. explain different types of join. who would you contact if there are issues with your database?\n\n**SQL coding questions**\nTables: employee, department (lots including IT), salary\n* find the 2nd highest salary, for the department IT\n* select employees who are not in any department\n\n**2nd Interview**: behavioral and technical\nintroduce yourself\n**SQL non-coding questions**\nexplain different types of joins. what are primary and foreign keys?\n\n**SQL coding questions**\nthe livecode page was closed before I could copy the questions, but very similar to 1st interview. 2 tables (Orders and Marketplace) and simple select statements requiring joins, group by. \n\n**Python**: Write pseudo-code for extracting data from the Orders table. I used pandas.\n\n**Behavioral**\n* Tell about a time when you had a tight deadline and had to choose between options. How much time did you have? What did you do? What was the outcome?\nthere was a follow-up question about the specific amount of time I spent in hours. \n* Describe a challenging problem and how you overcame it.\n

Hi,\n\nHad my Amazon data engineering internship (summer 2023) interview on Wednesday and I wanted to get my decision before posting this. I just received the o