Myntra Data Engineer Interview Questions and Answers

Coding test has multiple choice questions based on basics of programming and 2 coding questions.

Q1. What are the details of Object-Oriented Programming (OOP) concepts?
Ans. 
OOP is a programming paradigm based on the concept of objects, which can contain data and code to manipulate that data.
• OOP focuses on creating objects that interact with each other to solve problems.

• Key concepts include classes, objects, inheritance, polymorphism, and encapsulation.

• Classes are blueprints for creating objects, defining their properties and behaviors.

• Inheritance allows new classes to be based on existing...read more
Answered by AI
Add your answer
Q2. DSA question to solve using any programming language ?
Add your answer
Q3. Some concepts of web development and binary tree related questions
Add your answer

Q1. What do you know about Digit insurance?
Ans. 
Digit Insurance is a technology-driven insurance company offering a range of general insurance products.
• Digit Insurance was founded in 2016 by Kamesh Goyal.

• It is known for its innovative and customer-centric approach to insurance.

• Digit offers various insurance products such as health insurance, motor insurance, travel insurance, and more.

• The company leverages technology to simplify the insurance process and provide a s
Answered by AI
Add your answer
Q2. Where do you see yourself after 5 years ?
Ans. 
In 5 years, I see myself as a senior software engineer leading a team of developers on innovative projects.
• Leading a team of developers on projects

• Continuing to learn and grow in my technical skills

• Contributing to the success and growth of the company

• Possibly pursuing further education or certifications

• Exploring opportunities for mentorship and leadership roles
Answered by AI
Add your answer

SQL and Python data analysis questions

Q1. How do you match the data in different columns.
Ans. 
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
• Use string matching techniques like exact match, partial match, or fuzzy matching.

• Apply data cleaning and preprocessing techniques to standardize the data before matching.

• Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

• Consider using database join...read more
Answered by AI
Add your answer

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

Dsa and alogorithm by third party agency.

Q1. One Dynamic programming question
Add your answer

DSA - arrays, hashing, stack, 2hrs , google meet

Q1. Low level design , OOPs, modular code,
Add your answer
Q2. Crickbuzz- players, teams, score
Add your answer

Round duration - 45 minutes
Round difficulty - Easy

This was a coding test with 2 DSA questions.

Q1. 
Merge Two Sorted Arrays Problem Statement
Given two sorted integer arrays ARR1 and ARR2 of size M and N, respectively, merge them into ARR1 as one sorted array. Assume that ARR1 has a size of M + N to hol...read more
Ans. 
Merge two sorted arrays into one sorted array in place.
• Iterate from the end of both arrays and compare elements to merge in place

• Use two pointers to keep track of the current position in each array

• Handle cases where one array is fully merged before the other
Answered by AI
Add your answer
Q2. 
Count Ways to Reach the Nth Stair
Given a number of stairs, starting from the 0th stair, calculate the number of distinct ways you can reach the Nth stair. You can climb either one step or two steps at a ...read more
Ans. 
The question is about calculating the number of distinct ways to reach the Nth stair by climbing one or two steps at a time.
• Use dynamic programming to solve this problem efficiently.

• Define a recursive function to calculate the number of ways to reach each stair.

• Consider base cases for 0 and 1 stairs.

• Use memoization to store intermediate results and avoid redundant calculations.

• Handle large values of N by taking modulo ...read more
Answered by AI
View 1 more answer

Round duration - 60 minutes
Round difficulty - Medium

This was the first round with questions on DSA and Low Level design.

Q1. 
Trapping Rain Water Problem Statement
You are given a long type array/list ARR of size N, representing an elevation map. The value ARR[i] denotes the elevation of the ith bar. Your task is to determine th...read more
Ans. 
Calculate the total amount of rainwater that can be trapped between given elevations in an array.
• Iterate through the array and calculate the maximum height on the left and right of each bar.

• Calculate the amount of water that can be trapped at each bar by taking the minimum of the maximum heights on the left and right.

• Sum up the trapped water at each bar to get the total trapped water for the entire array.
Answered by AI
Add your answer
Q2. Can you provide a low-level design of a hotel management system?
Ans. 
A low-level design of a hotel management system involves detailing the system's components and their interactions.
• Define classes for entities like Room, Guest, Reservation, and Staff

• Implement functions for booking rooms, checking availability, and managing guest information

• Include modules for billing, housekeeping, and reporting

• Utilize databases for storing information and APIs for external integrations
Answered by AI
Add your answer