AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Amazon
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Amazon Data Engineer Interview Questions and Answers for Experienced
Amazon Data Engineer Interview Experiences for Experienced
8 interviews found
Anonymous
Oops dsa sql network
(2 Questions)
- Q1. Dsa based python question
- Q2. Dsa based python question on tress
(2 Questions)
- Q1. Sql question queries
- Q2. Sql question query
Shivangi Jain
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)
(2 Questions)
- Q1. Which techniques you would have used on a system you have worked in the past to be able to optimise it further. (Deep knowledge of the databases is required)
- Ans.
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.
- Q2. Situational questions on the ETL tools used and advantages and disadvantages of both
(1 Question)
- Q1. Describe a complex situation you were in at workplace and how did you handle it?
- Ans.
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
I applied via Job Fair and was interviewed in Jun 2024. There was 1 interview round.
Duration - 3 hours, DSA
Interview Preparation Tips
What people are saying about Amazon
Roshini Chester
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.
Amazon interview questions for designations
I applied via Amazon jobs and was interviewed in Sep 2023. There were 3 interview rounds.
Basic with python SQL and data models
(2 Questions)
- Q1. Real life example
- Ans.
Developing a data pipeline to analyze customer behavior for an e-commerce company
Collecting and storing customer data from website interactions
Cleaning and transforming data to identify patterns and trends
Building machine learning models to predict customer behavior
Visualizing insights for stakeholders to make data-driven decisions
- Q2. Scenario based questions
Interview Preparation Tips
I applied via Approached by Company and was interviewed before Aug 2023. There were 2 interview rounds.
Python SQL coding question and basic SQL understanding
(1 Question)
- Q1. White board Rround
Data Engineer Jobs at Amazon
Anusha Chimmili
Selected
I was interviewed before Feb 2023.
(1 Question)
- Q1. Basic SQL with some personality questions
I applied via Approached by Company and was interviewed before Jun 2021. There were 5 interview rounds.
About your tech stack along with 2 Programming question basic DS Problems, and 2-3 SQL Queries moderate level.
3-4 SQL queries medium to high level and 2 programming question moderate level
Data modeling and Data warehousing questions along with SQL queries Hard level
(2 Questions)
- Q1. Create a Data model for the use case like CCD, Pizza hut and questions from that Data model
- Q2. Data Warehousing and Big data related problems Data pipelines and ETL related Question Cloud computing related questions
(1 Question)
- Q1. Techno manager round on case studies to come complex problems.
Interview Preparation Tips
Interview questions from similar companies
I was interviewed before May 2016.
Interview Questionnaire
4 Questions
- Q1. Tell us about yourself
- Ans.
I am a passionate software engineer with experience in developing web applications and a strong background in computer science.
Experienced in developing web applications using technologies such as HTML, CSS, JavaScript, and React
Strong background in computer science with knowledge of data structures and algorithms
Proficient in programming languages such as Java, Python, and C++
Familiar with Agile development methodolog
- Q2. Why Flipkart
- Ans.
Flipkart is a leading e-commerce platform in India with a strong focus on technology and innovation.
Flipkart offers a challenging and dynamic work environment for software engineers.
The company has a strong reputation for investing in technology and innovation.
Flipkart has a large user base and offers opportunities to work on a variety of projects.
The company has a strong focus on customer satisfaction and user experie...
- Q3. Are you comfortable to reallocate
- Ans.
Yes, I am comfortable with reallocating as needed.
I am flexible and adaptable to changing circumstances.
I have experience working in dynamic environments where priorities can shift.
I am willing to take on new challenges and responsibilities as required.
- Q4. Why should we hire you
- Ans.
I have a strong technical background, excellent problem-solving skills, and a proven track record of delivering high-quality software.
Extensive experience in software development, including proficiency in multiple programming languages such as Java, Python, and C++
Strong problem-solving skills demonstrated through successful completion of complex projects
Proven track record of delivering high-quality software on time a...
Interview Preparation Tips
Experience: 2 problem statements to be coded using any language
Tips: Focussed on string manipulations and enormous data size handling
Duration: 1 hour 30 minutes
Total Questions: 2
Skills: C/C++
College Name: Guru Premsukh Memorial College of Engineering
Interview Preparation Tips
Experience: GD was conducted for shortlisted candidates and candidates were divided into groups of 6 people.There were 3 topics and each topic was discussed for 2 minutes.No specific rules,like each person needs to speak,are to be followed during the GD.Anyone can initiate,intervene,etc. Finally we were asked to link all three topics and this discussion went on for another 2 minutes.
Round: HR Interview
Experience: Only a single round lasting about 40-45 minutes.There were only 4 people in the panel and technical as well as HR questions were asked. First I was asked to go through my own resume, “Introduce/Tell us about yourself?". E.g.:“Where have you shown leadership qualities?Have you led a
team?Size of team? What new initiatives did you take?”.Core questions starting form basics like “How does an airplane fly?” to specific questions about the different types of engines used in airplanes,their specifications, etc. were asked. HR questions were put up like"What was the most difficult decision in your life?" and grilled on my internship for 15-20 minutes which I did in Transocean. (Another oil field services company).
General Tips: You need to be very good in the basics of your
core courses and if you have done an internship in the oil industry,
you will definitely be grilled on that.Questions will be asked in quick succession.
Skill Tips: Highlight any intern in Oil industry or anything related to that in your resume.Any POR or any sport activity which shows your leadership qualities should me mentioned in your resume.
Skills: Leadership qualities, Athletic, Quick thinking, presence of mind
College Name: IIT MADRAS
Amazon Interview FAQs
Some of the top questions asked at the Amazon Data Engineer interview for experienced candidates -
The duration of Amazon Data Engineer interview process can vary, but typically it takes about 2-4 weeks to complete.
Tell us how to improve this page.
Amazon Interviews By Designations
- Amazon Software Developer Interview Questions
- Amazon Customer Service Associate Interview Questions
- Amazon Transaction Risk Investigator Interview Questions
- Amazon Customer Service Executive Interview Questions
- Amazon Software Developer Intern Interview Questions
- Amazon Associate Interview Questions
- Amazon Seller Support Associate Interview Questions
- Amazon Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Amazon Data Engineer Interview Process for Experienced
based on 7 interviews
3 Interview rounds
- Coding Test Round - 1
- Coding Test Round - 2
- Technical Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Amazon Data Engineer Reviews and Ratings
based on 35 reviews
Rating in categories
|
Customer Service Associate
4.2k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Transaction Risk Investigator
3.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate
2.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
2.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Program Manager
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Flipkart
TCS
Netflix
- Home >
- Interviews >
- Amazon Interview Questions >
- Amazon Data Engineer Interview Questions for Experienced
