myKaarma interview experience Real time questions & tips from candidates to crack your interview

Data Engineer

myKaarma
upvote
share-icon
3 rounds | 6 Coding problems

Interview preparation journey

expand-icon
Journey
My journey started at my college when I first learned to code. From there onwards, I have done a lot of practice from leetcode to code studio. I have maintained a streak of doing at least 50 questions a week to maintain my accuracy.
Application story
This company visited my campus for the placement. They first took the Online assessment and then allowed the selected candidates to face the interview.
Why selected/rejected for the role?
I was rejected because I have some design projects in my resume, and some of them are well known in the open source community.
Preparation
Duration: 4 months
Topics: Data Structures, Algorithms, OOPS, Dynamic Programming
Tip
Tip

Tip 1 : Practice popular questions from Arrays, Binary Trees, LinkedLists from CodeStudio's Interview Problems
Tip 2 : Make sure you are aware of calculating the time and space complexity for every problem you're coding.
Tip 3 : Prepare through Mock Interviews to practice explaining your approach while solving in an actual interview.

Application process
Where: Campus
Eligibility: Above 7 CGPA
Resume Tip
Resume tip

Tip 1 : Describe best of your projects in minimum words. Don't forget to add buzz words like REST APIs/ DB Indexing/ Benchmarking etc if you worked on backend.
Tip 2 : Don't add school achievements like Olympiads or Class Topper in your resume.
Tip 3 : If you've some work experience, put it in a way ,you're marketing yourself. Add terms like 'Created/Owned the Project through entire SDLC'
Tip 4 : Make sure you mention how your work experience actually impacted the company. Or how your self project can be actually useful to end user.

Interview rounds

01
Round
Medium
Video Call
Duration45 minutes
Interview date16 Aug 2021
Coding problem3

1. DBMS Questions

What is the difference between truncate, drop and delete?
Difference between UNIQUE and Primary Key. Which of these can be Null?

2. Word Ladder

Hard
10m average time
90% success
0/120
Asked in companies
OlaSalesforceMakeMyTrip

You are given two strings BEGIN and END and an array of strings DICT. Your task is to find the length of the shortest transformation sequence from BEGIN to END such that in every transformation you can change exactly one alphabet and the word formed after each transformation must exist in DICT.

Note:

1. If there is no possible path to change BEGIN to END then just return -1.
2. All the words have the same length and contain only lowercase english alphabets.
3. The beginning word i.e. BEGIN will always be different from the end word i.e. END (BEGIN != END).
Problem approach

You are given two strings BEGIN and END and an array of strings DICT. Your task is to find the length of the shortest transformation sequence from BEGIN to END such that in every transformation you can change exactly one alphabet and the word formed after each transformation must exist in DICT.

Try solving now

3. Minimum Cost to cross Grid

Moderate
30m average time
70% success
0/80
Asked in companies
MakeMyTripAmazonAmdocs

You are given a 2 - D grid having ‘N’ rows and ‘M’ columns. Each cell of the grid has an integer value written on it which denotes the cost it takes to pass through that cell. You are currently present at the Top-Left cell (0,0) and you want to reach the Bottom-Right cell (N - 1, M - 1). To do so, you start moving from the Top-Left cell and move through any of the adjacent cells until you reach the Bottom-Right cell. The total cost of the path will be the sum of the costs of all the cells that you have passed through in the path.

Given the cost of each cell in a 2 - D matrix 'MAT', your task is to find the minimum total cost that you need to spend to reach the Bottom-Right cell if you are starting from the Top-Left cell.

Note:
1) From any cell you can move UP, DOWN, LEFT, or RIGHT.

2) You cannot move out of the grid.
Problem approach

You are given a 2 - D grid having ‘N’ rows and ‘M’ columns. Each cell of the grid has an integer value written on it which denotes the cost it takes to pass through that cell. You are currently present at the Top-Left cell (0,0) and you want to reach the Bottom-Right cell (N - 1, M - 1). To do so, you start moving from the Top-Left cell and move through any of the adjacent cells until you reach the Bottom-Right cell. The total cost of the path will be the sum of the costs of all the cells that you have passed through in the path.

Try solving now
02
Round
Easy
Video Call
Duration60 minutes
Interview date16 Aug 2021
Coding problem2

1. Sub Matrices With Sum Zero

Moderate
15m average time
85% success
0/80
Asked in companies
MakeMyTripAmazonGoogle inc

You’re given a square matrix 'MAT' of order N. Your task is to find the number of non-empty sub-matrices such that the sum of all the elements inside the submatrix is zero.

NOTE:

1. The matrix may also contain some negative elements.
2. A square matrix is a matrix with the same number of rows and columns.
A matrix obtained by deleting some (possibly zero) of the rows and/or columns from the beginning and/or from the end of a matrix is said to be a sub-matrix of the given matrix.

Example: Given a matrix
 A = 1 2
     3 4

Possible non-empty sub-matrices of A are represented below by bold numbers-

alt text

Problem approach

You’re given a square matrix 'MAT' of order N. Your task is to find the number of non-empty sub-matrices such that the sum of all the elements inside the submatrix is zero.

Try solving now

2. Boundary Traversal of Binary Tree

Hard
20m average time
85% success
0/120
Asked in companies
SalesforceAmazonGoldman Sachs

You are given a binary tree having 'n' nodes.


The boundary nodes of a binary tree include the nodes from the left and right boundaries and the leaf nodes, each node considered once.


Figure out the boundary nodes of this binary tree in an Anti-Clockwise direction starting from the root node.


Example :
Input: Consider the binary tree A as shown in the figure:

alt text

Output: [10, 5, 3, 7, 18, 25, 20]

Explanation: As shown in the figure

The nodes on the left boundary are [10, 5, 3]

The nodes on the right boundary are [10, 20, 25]

The leaf nodes are [3, 7, 18, 25].

Please note that nodes 3 and 25 appear in two places but are considered once.
Problem approach

You have been given a binary tree of integers. Your task is to print the boundary nodes of this binary tree in Anti-Clockwise direction starting from the root node.

Try solving now
03
Round
Easy
HR Round
Duration30 minutes
Interview date16 Aug 2021
Coding problem1

1. Basic HR Questions

Why should we hire you?
Where do you see yourself after 5 years?
Can you work in team?

Problem approach

Tip 1 : DO NOT LIE
Tip 2 : Give examples of where you have used it. E.g: projects developed.
Tip 3 : Mention courses you have done for it

Tip 4 : Always show you are eager to learn.
Tip 5 : "Even if I haven't used them yet because I was focussing on developing my Backend skills first, I would love to start learning it soon"

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
company logo
Data Science Intern
2 rounds | 4 problems
Interviewed by myKaarma
742 views
0 comments
0 upvotes
company logo
Data Engineering Intern
2 rounds | 4 problems
Interviewed by myKaarma
524 views
0 comments
0 upvotes
company logo
Data Engineering Intern
2 rounds | 4 problems
Interviewed by myKaarma
617 views
0 comments
0 upvotes
company logo
SDE - Intern
4 rounds | 28 problems
Interviewed by myKaarma
390 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
Data Engineer
2 rounds | 4 problems
Interviewed by Amazon
1838 views
0 comments
0 upvotes
company logo
Data Engineer
4 rounds | 15 problems
Interviewed by Intuit
0 views
0 comments
0 upvotes