Real interview questions asked at Infosys. Practice the most frequently asked questions and land your next role.
Infosys data engineering interviews test your ability across multiple domains. These questions are sourced from real Infosys interview experiences and sorted by frequency. Practice the ones that matter most.
What is the difference between SparkSession and SparkContext in Spark?
What are traits in Scala, and how are they different from classes?
How do you handle data security and compliance in a cloud environment?
How would you read data from a web API? What steps would you follow after reading the data?
Architecturally, how would you justify or challenge Hadoop vs. a cloud-native data lake (S3 + EMR/Databricks) for a greenfield enterprise data platform? Discuss scalability ceilings, cost model trade-offs, and operational complexity.
How would you read data from a web API using PySpark?
What is broadcasting in Spark, and why is it used? Can you give an example of its use?
What is the difference between map and flatMap in Spark, and when would you use each?
What is the purpose of the Bronze, Silver, and Gold layers in a data pipeline?
What work is done by the executor memory in Spark?
When and how do you use Broadcast Join?
Why is SparkSession used in Spark 2.0 and later versions?
Write a Python script to find the count of each word in a text file using Spark.
Write the PySpark code to find the second highest salary in each department.
Explain the difference between a list and a tuple in Python.
How do you handle exceptions in Python? Provide an example.
What is the difference between shallow copy and deep copy in Python?
Write a Python function to find the first non-repeating character in a string.
What are decorators in Python, and how do they work?
Explain the difference between args and kwargs in Python.
Write a Python function to check if a string is a palindrome.
What is the difference between a set and a list in Python?
How do you handle memory management in Python?
What is the difference between a generator and a list in Python?
Write a Python function to find the maximum value in a list without using the built-in max() function.
Tell me about your project: Explain your project, its goals, and the technologies you used.
Given the data with id, name, and department, how would you calculate how many employees are in each department?
How do you deploy from a development environment to QA and production?
Explain the architectural rationale for using LeftAntiJoin vs. NOT IN vs. NOT EXISTS in a distributed context. When does LeftAntiJoin become a performance or scalability bottleneck, and how do broadcast vs. shuffle joins affect cost?
How would you handle null values in a dataset, especially in a single column?
Can you explain the concept of incremental loading in Sqoop and how to use it for job processing?
Can you explain the concept of mappers in Spark, and how are they used in data transformations?
How would you move a file to another path in Databricks File System (DBFS)?
How would you read data from an RDBMS using Spark? Provide the syntax.
What Hadoop command would you use to merge multiple files into one?
What is YARN, and how does it manage resources in a Hadoop ecosystem?
What is the difference between managed and external tables in Hive or Spark SQL?
What performance tuning techniques do you apply in both Sqoop and Spark to optimize their execution?
Have you worked with Oozie? If yes, can you explain what it is and how it's used in data pipelines?
Download the complete interview prep bundle with expert answers. Study offline, on your commute, anywhere.