KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #2703
Applications open Internship

Data Engineer Intern

Amazon

  • Pan India (Bengaluru, Chennai, Hyderabad, Noida)
  • ₹1.5 LPA per month
  • Fresher (0-1 Yrs)
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Amazon, a global leader in e‑commerce, cloud computing, digital streaming and artificial intelligence, has built a reputation for relentless customer obsession and innovation. With a presence in more than 20 countries and a workforce of over a million, Amazon offers a fast‑paced environment where ideas are turned into products that impact billions of users. The company’s data ecosystem powers everything from recommendation engines to supply‑chain optimization, making data engineering a core pillar of its business strategy.

Interns at Amazon get a front‑row seat to this data‑driven culture, working alongside seasoned engineers and product managers to solve real‑world problems.

The Data Engineer Intern role for the 2027 batch is designed to give fresh talent hands‑on experience in building and maintaining large‑scale data pipelines. You will collaborate with business analysts, software developers, and senior data engineers to ingest, transform, and store data from diverse sources. The internship is full‑time and spans a typical 12‑week period, during which you will be expected to contribute to production‑grade solutions and present your work to cross‑functional stakeholders.

Key Responsibilities

  • Design, develop, and support analytical data platform solutions that enable data‑driven decision making.
  • Create and maintain data schemas, and manage internal data warehouses using SQL and NoSQL databases.
  • Build ETL pipelines that extract, transform, and load data from various sources using AWS services such as EMR, Redshift, and Glue.
  • Work with data‑lake components like Amazon S3 and Hadoop to store and process massive datasets.
  • Implement and optimize big‑data processing jobs using Spark, Hive, and Impala on Hadoop clusters.
  • Explore and adopt new AWS technologies (Lambda, Athena, etc.) to improve efficiency and add capabilities.
  • Develop dashboards, reports, and metrics that surface actionable insights for business teams.
  • Ensure data quality, integrity, and documentation throughout the pipeline lifecycle.
  • Participate in code reviews, adhere to software‑engineering best practices, and contribute to agile sprint activities.
  • Continuously learn and share knowledge about emerging data‑engineering tools and practices.

Tech Stack: Python, SQL, PostgreSQL/MySQL, DynamoDB, Amazon S3, EMR, Redshift, Glue, Lambda, Hadoop, Spark, Hive, Impala, Airflow (optional), Git, Docker.

Growth Path: Successful interns often receive full‑time offers as Data Engineers or Software Development Engineers, with clear career ladders that lead to senior, principal, and leadership roles within Amazon’s data organization.

Why Join Amazon?: You will work on high‑impact projects that scale to millions of users, gain exposure to cutting‑edge cloud technologies, and develop a deep understanding of end‑to‑end data pipelines. The internship also provides mentorship from senior engineers, a collaborative culture, and the opportunity to turn data insights into tangible business outcomes.

Eligibility & process

Who can apply

Final year undergraduate or postgraduate students (B.Tech/B.E., B.Sc., M.Tech, M.Sc.) in Computer Science, Information Technology, Electronics & Communication, or related engineering streams. Minimum CGPA/percentage of 6.5/70% (or equivalent). No active backlogs at the time of joining. Must be able to commit full‑time for the entire internship duration and provide a university declaration of availability.

Skills & stack

SQL Python Aws (S3 Redshift EMR Glue Lambda) Hadoop

Selection process

  1. Round 1: Online Assessment (coding & logical reasoning)
  2. Round 2: Technical Interview (data engineering concepts, AWS services, coding)
  3. Round 3: HR Interview (fit, availability, internship logistics)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (SQL, Python, Aws (S3, Redshift, EMR, Glue, Lambda), Hadoop) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Amazon Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Amazon as a Data Engineer Intern?
Highlight Amazon's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Amazon ₹1.5 LPA per month
Recruiter Resume Apply
Chat Chat with Kashii