Modak Analytics Data Engineer Interview Questions and Answers

Two coding questions, one is easy and the other is difficult. Who solved 2nd question was shortlisted for an interview.

Q1. Introduce yourself—questions from OS, DBMS, DSA, Project, and one coding problem.
Add your answer

Q1. Maximal rectangal
Ans. 
Find the largest rectangle containing only 1s in a binary matrix.
• Use dynamic programming to track heights of consecutive 1s.

• For each row, treat it as a histogram and calculate the maximal rectangle.

• Utilize a stack to efficiently compute the largest rectangle in a histogram.

• Example: For a matrix [[0,1,1],[1,1,0],[1,1,1]], the largest rectangle has area 4.
Answered by AI
Add your answer
Q2. Loop in linked list
Ans. 
Loop in linked list is a situation where a node points to a previous node in the list, creating an infinite loop.
• Check for loops using Floyd's cycle detection algorithm

• Use two pointers, one moving twice as fast as the other, to detect a loop

• If the fast pointer catches up to the slow pointer, there is a loop
Answered by AI
Add your answer

Q1. Basic hr question regarding your project and all
Add your answer
Q2. He was more interested in what is my thinking pattern
Add your answer

50 questions 12 mins

Q1. Quant based questions (P&C,Averages,probability) followed by case study
Add your answer

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer

Aptitude test was divided into 3 parts and was not a typical quant, logical question it was more of an application based questions

Q1. What do you understand about the company?
Add your answer

Q1. Mostly behavioural and situation based questions.
Add your answer

Q1. Advanced Excel questions
Add your answer
Q2. SPSS and python
Add your answer

Q1. About healthcare industry
Add your answer

Q1. What do you know about healthcare industry
Add your answer

Q1. Brief introduction
Add your answer

Q1. Question regarding skill set
Add your answer
Q2. How does vlookup work
Add your answer