Ho presentato la mia candidatura online. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Amazon (Seattle, WA) nel mese di feb 2017
Colloquio
Interview started with job description and duties to perform in the team if selected
Interviewer then questions on current work roles & responsibilities
Questions on Databases
Questions on Datawarehouse concepts
Questions on Performance Tuning
After that asked SQL technical questions
Domande di colloquio [1]
Domanda 1
1. What difference have you made in current team apart from regular work ?
2. What are the steps you follow to rebuild a table in database ?
3. How did you do performance tuning ?
4. How do you find the skewness of data in table ?
5. Difference between RDBMS and Dimensional Modeling
SQL
1) purchase
customer_id product_id quantity purchase_date
1 111 1 01/01/2017
1 111 2 01/02/2107
1 222 2 01/02/2017
2 111 3 01/04/2017
2 222 1 01/03/2017
3 222 1 01/05/2017
3 222 1 01/06/2017
3 111 1 01/06/2017
3 111 1 01/04/2017
Q: How many customers bought each product how many times during the week?
Product_Id Number_of Customers Number_of_Times
111 2 2
111 1 1
222 2 1
222 1 2
2) daily_usage
account_id usage_amount usage_date
1 10 1
1 20 2
1 15 3
1 30 4
Q.
a) How do you print the usage_amount of previous/consecutive rows
b) Without using window functions
Ho sostenuto un colloquio presso Amazon (Seattle, WA)
Colloquio
Very difficult process it took me a round 1 month to get back what’s the review for the interview so I think overall it’s bad experience and difficult interview process while it has lot of questions I wa able to answer
Ho sostenuto un colloquio presso Amazon (New York, NY)
Colloquio
Standard three-round process consisting of an online assessment followed by a comprehensive interview loop, where candidates were evaluated across technical skills, problem solving ability, and overall fit for the role.
Ho sostenuto un colloquio presso Amazon (Bengaluru)
Colloquio
In my 5th semester, Amazon visited our campus to hire interns for multiple roles, and I was shortlisted for the Data Engineer role.
I cleared the online assessment and attended two technical interviews. The first round focused on coding, while the second round focused on SQL. I faced some challenges in the SQL round, and although I was not selected, the experience helped me identify areas for improvement, especially in advanced SQL concepts
Le migliori aziende per "stipendio e benefit" vicino a te
