Infosys
Global leader in next-generation digital services and consulting.
3 Rounds
~14 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
Coding
•
medium
Write a PySpark script to read a CSV, drop rows with nulls in a specific column, group by another column, and write the output as Parquet.
#PySpark
#DataFrame API
#Data Cleaning
Data Engineer
•
Technical
•
hard
How do you handle data skewness in a PySpark join operation?
#PySpark
#Performance Tuning
#Data Skewness
#Salting
Data Engineer
•
Technical
•
easy
Explain the difference between repartition() and coalesce() in PySpark. When would you use one over the other?
#PySpark
#Data Partitioning
#Shuffle
Data Engineer
•
Technical
•
medium
Explain the internal execution hierarchy of a Spark application.
#Spark Architecture
#Jobs
#Stages
#Tasks
Data Engineer
•
Technical
•
hard
How do you handle Out of Memory (OOM) errors in a PySpark application?
#PySpark
#Troubleshooting
#Memory Management
Data Engineer
•
Technical
•
hard
What is the Catalyst Optimizer in Spark? Explain its phases.
#Spark Internals
#Catalyst Optimizer
#Query Plans
Data Engineer
•
Technical
•
medium
How do you pass data between different tasks in an Apache Airflow DAG?
#Airflow
#Orchestration
#XComs
Data Engineer
•
Technical
•
medium
Explain the differences between Parquet, ORC, and Avro file formats. When would you choose Parquet over Avro?
#File Formats
#Storage Optimization
#Parquet
#Avro
Data Engineer
•
Technical
•
easy
What is the difference between cache() and persist() in PySpark?
#PySpark
#Memory Management
#Caching
Data Engineer
•
Technical
•
hard
How do you ensure exactly-once processing semantics in an Apache Kafka streaming application?
#Kafka
#Streaming
#Exactly-once Semantics
Data Engineer
•
Technical
•
medium
What are Broadcast Variables and Accumulators in Spark? Give use cases for each.
#PySpark
#Shared Variables
#Optimization
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.