i
Amazon
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Oops dsa sql network
I applied via Approached by Company and was interviewed in Aug 2024. There were 4 interview rounds.
Majorly the interviews revolve around the following skills :
1. Advanced SQL
2. PYTHON (DSA)
Majorly the interviews revolve around the following skills :
1. Advanced SQL
2. python (DSA)
I would have used indexing, query optimization, and data partitioning to optimize the system.
Implement indexing on frequently queried columns to improve search performance.
Optimize queries by using proper joins, filters, and aggregations.
Partition large tables to distribute data across multiple storage devices for faster access.
Use materialized views to precompute and store aggregated data for quicker retrieval.
Handled a complex data migration project by breaking it down into smaller tasks and collaborating with team members.
Identified key stakeholders and their requirements
Developed a detailed project plan with timelines and milestones
Assigned specific tasks to team members based on their strengths and expertise
Regularly communicated progress updates and addressed any issues promptly
What people are saying about Amazon
I am a data engineer with 5 years of experience in designing and implementing data pipelines for analytics.
Experienced in ETL processes and data modeling
Proficient in programming languages like Python and SQL
Familiar with big data technologies such as Hadoop and Spark
Developed a real-time data processing system for analyzing customer behavior
Used Apache Kafka for real-time data streaming
Implemented data pipelines using Apache Spark for processing large volumes of data
Designed and optimized data models for efficient querying
Integrated machine learning models for predictive analytics
Amazon interview questions for designations
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
Types of joins in SQL include inner, outer, left, right, and cross join.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows when there is a match in one of the tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Cross join: Returns the Cartesian produ
I applied via Job Fair and was interviewed in Jun 2024. There was 1 interview round.
Duration - 3 hours, DSA
Advance SQL coding questions
I applied via amazon jobs and was interviewed in May 2024. There was 1 interview round.
They didn't score properly on the assessments for theoretical answers. Types of Data Modeling is a basic question with just 3 types but they marked the answer as wrong. I did not argue with the interviewer but yes, didn't feel comfortable after the process.
I applied via Company Website and was interviewed in Nov 2023. There were 2 interview rounds.
30 minutes of sql coding
The duration of Amazon Data Engineer interview process can vary, but typically it takes about 2-4 weeks to complete.
based on 21 interviews
3 Interview rounds
based on 35 reviews
Rating in categories
Customer Service Associate
4.2k
salaries
| ₹0.6 L/yr - ₹6.8 L/yr |
Transaction Risk Investigator
3.1k
salaries
| ₹2 L/yr - ₹6.5 L/yr |
Associate
2.5k
salaries
| ₹0.8 L/yr - ₹6.5 L/yr |
Senior Associate
2.5k
salaries
| ₹2 L/yr - ₹10.1 L/yr |
Program Manager
2.1k
salaries
| ₹9 L/yr - ₹36 L/yr |
Flipkart
TCS
Netflix