Envié una solicitud electrónica. El proceso duró 1 semana. Acudí a una entrevista en Amazon (Seattle, WA) en feb 2017
Entrevista
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
Preguntas de entrevista [1]
Pregunta 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
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
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.
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
Las mejores empresas en cuanto a «Remuneración y beneficios» cerca de ti
