KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
L #3133
Applications open Full-Time Job

Principal Data Engineer – Python Backend

Amgen

  • Hyderabad, India
  • Competitive Package
  • 5+ Years
  • Posted Yesterday
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Role Summary

We’re hiring a Data Engineer with Python backend development experience to build scalable data pipelines and services. The role combines data engineering with backend API development, including integrating data platforms with applications and AI agents.

The ideal candidate has hands-on experience with Python, SQL, Databricks, and Apache Spark. They should also understand REST APIs, relational and NoSQL databases, and how to improve Spark workloads for performance and scale.

Key Responsibilities

  • Design, build, and maintain data ingestion and ETL/ELT pipelines using Python, SQL, Databricks, and Spark/PySpark.
  • Integrate data from APIs, databases, files, and third-party systems.
  • Develop and maintain backend services and REST APIs using Python frameworks such as FastAPI, Flask, or Django.
  • Build API integrations that allow applications and AI agents to access approved data and services.
  • Design and work with relational and NoSQL databases, including schemas, data models, and queries.
  • Optimize Spark jobs and Databricks workloads for performance, scalability, and cost.
  • Apply distributed computing principles to process large datasets reliably.
  • Implement data validation, error handling, logging, and monitoring.
  • Troubleshoot pipeline, API, and database issues in development and production environments.
  • Write tests and documentation, and participate in Git, code reviews, CI/CD, and deployment workflows.
  • Collaborate with data, backend, AI/ML, product, and application teams.

Basic Qualifications and Experience

  • Master's OR Bachelor's degree in IT/Computer Science/Engineering. and 12 to 17 years of work experience

Required Skills

  • Strong Python development skills.
  • Strong SQL skills and experience with relational databases.
  • Hands-on experience with Databricks and Apache Spark/PySpark.
  • Experience building data pipelines and integrating data from multiple sources.
  • Experience developing or integrating REST APIs.
  • Working knowledge of NoSQL databases. Hands-on experience integrating APIs with AI agents or AI/ML applications.
  • Understanding of Spark performance optimization, scalability, and distributed systems.
  • Familiarity with Git, testing, debugging, and production support.
  • Strong problem-solving and communication skills.

Good to Have

  • Experience with FastAPI, Flask, or Django.
  • Experience with Delta Lake, Azure Data Lake, or Azure Data Factory.
  • Familiarity with Airflow, Kafka, Docker, or Kubernetes.
  • Experience with authentication and authorization for APIs.
  • Experience supporting GenAI or machine learning data pipelines.

Preferred Candidate Profile

We’re looking for someone who can work across the data and backend layers: ingest and transform data, store it in suitable relational or NoSQL systems, and expose it through APIs for applications or AI agents.

The candidate should be able to design, build, optimize, test, and support a solution such as:

Source systems → Databricks/Spark processing → relational or NoSQL storage → Python API → application or AI agent

EQUAL OPPORTUNITY STATEMENT

Amgen is an Equal Opportunity employer and will consider you without regard to your race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

We will ensure that individuals with disabilities are provided with reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request an accommodation.

Eligibility & process

Who can apply

Employment type: Full-time

Skills & stack

Python SQL Django FastAPI Flask REST APIs Azure Docker

Selection process

Details are shared by the recruiter after shortlisting.

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 (Python, SQL, Django, FastAPI, Flask, REST APIs, Azure, Docker) & 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 Amgen 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 Amgen as a Principal Data Engineer – Python Backend?
Highlight Amgen's market reputation, recent tech innovations, and how your skills in Python 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.
Amgen Competitive Package
Recruiter Resume Apply
Chat Chat with Kashii