I applied through an employee referral. I interviewed at Amazon
Interview
After OA and Phone Screening, there are 4 rounds in total. Two tech rounds followed by a hiring manager round and a bar raiser round.
SQL, Python scripting and few technical deep dives based on project experience are focussed in general. All 3 rounds might have SQL, one or two rounds might have python which depends on the team and the role's demand for scripting. For SQl often asked questions revolve around using CTEs, Window functions and Joins. Knowledge on ETL frameworks or Big data tools like Spark, Glue, Airflow, Kinesis or Datastores like Redshift are covered along with AWS services. BR round focuses mainly on Amazon's Leadership principles.
Interview questions [1]
Question 1
SQL
Given sales table (product, year, capital, units, cpu), calculate profit per product per year.
Find highest profit gained per product each year
Python
find first recurring character.
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
Top companies for "Compensation and Benefits" near you
