Mercedes-Benz Research and Development India Data Engineer Interview Questions and Answers

I have experience working on projects involving data pipeline development, ETL processes, and data warehousing.

• Developed ETL processes to extract, transform, and load data from various sources into a data warehouse

• Built data pipelines to automate the flow of data between systems and ensure data quality and consistency

• Optimized database performance and implemented data modeling best practices

• Worked on real-time data pro...read more

Create a list containing all Python data types.

• Use the following data types: int, float, complex, str, list, tuple, dict, set, bool, bytes, bytearray, memoryview, None

• Example: ['int', 'float', 'complex', 'str', 'list', 'tuple', 'dict', 'set', 'bool', 'bytes', 'bytearray', 'memoryview', 'None']

Extract a character from a string in a list of strings.

• Iterate through the list of strings

• Use indexing to extract the desired character from each string

• Handle cases where the index is out of range

• Return the extracted characters as a new list

Create a dictionary with Name and Age for 4 records in Python.

• Use curly braces {} to create a dictionary.

• Separate key-value pairs with a colon :

• Separate each record with a comma ,

Function to check if a string is a palindrome.

• Create a function that takes a string as input.

• Reverse the string and compare it with the original string.

• Return true if they are the same, false otherwise.

• Example: 'racecar' is a palindrome.

Data normalization is the process of organizing data in a database efficiently, while data standardization is the process of ensuring consistency and uniformity in data.

• Data normalization involves organizing data into tables and columns to reduce redundancy and improve data integrity.

• Data standardization involves ensuring that data is consistent and uniform across the database.

• Normalization helps in reducing data redun...read more

The probability of drawing 3 balls of the same color from a box containing 4 balls of each color (Red, Green, Blue).

• Calculate the total number of ways to draw 3 balls out of 12 balls

• Calculate the number of ways to draw 3 balls of the same color

• Divide the number of favorable outcomes by the total number of outcomes to get the probability

Use SQL query to find the product with the second highest total price.

• Use the ORDER BY clause to sort the products by total price in descending order

• Use the LIMIT clause to select the second row after sorting

The question is about a Pyspark problem.

• Use SparkSession to create a Spark application

• Load data from a source like CSV or Parquet files

• Perform transformations and actions on the data using PySpark functions

• Optimize performance by using caching and partitioning