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

Data Engineering Intern

myKaarma
upvote
share-icon
2 rounds | 4 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 4 months
Topics: Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic Programming
Tip
Tip

Tip 1 : Practice from internet, solve medium level problems.
Tip 2 : Brush up computer fundamentals from subjects like OS, DBMS and CN.
Tip 3 : Have a good project or good internship experience and have in-depth knowledge regarding what you have done.

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

Tip 1 : Have some projects on resume.
Tip 2 : Do not put false things on resume.

Interview rounds

01
Round
Easy
Video Call
Duration45 minutes
Interview date21 Aug 2021
Coding problem2

1. Row with Maximum 1's

Easy
10m average time
90% success
0/40
Asked in companies
ArcesiumDisney + HotstarMicrosoft

You have been given a non-empty grid ‘mat’ with 'n' rows and 'm' columns consisting of only 0s and 1s. All the rows are sorted in ascending order.

Your task is to find the index of the row with the maximum number of ones.

Note: If two rows have the same number of ones, consider the one with a smaller index. If there's no row with at least 1 zero, return -1.


Example:

Input: 'n' = 3, 'm' = 3, 'mat' = [[1, 1, 1], [0, 0, 1], [0, 0, 0]]

Output: 0

Explanation: The row with the maximum number of ones is 0 (0 - indexed).
Problem approach

You have been given a non-empty grid ‘MAT’ with 'N' rows and 'M' columns consisting of only 0s and 1s. All the rows are sorted in ascending order.
Your task is to find the index of the row that has the maximum number of ones.
Note: If two rows have the same number of ones, consider the one with a smaller index.

Try solving now

2. Shortest substring with all characters

Moderate
18m average time
85% success
0/80
Asked in companies
Chegg Inc.IntuitAmazon

You have been given a string 'S' which only consists of lowercase English-Alphabet letters.

Your task is to find the shortest(minimum length) substring of 'S' which contains all the characters of 'S' at least once. If there are many substrings with the shortest length, then find one which appears earlier in the string i.e. substring whose starting index is lowest.

For example-
If the given string is S = "abcba", then the possible substrings are "abc" and "cba". As "abc" starts with a lower index (i.e. 0, "cba" start with index 2), we will print "abc" as our shortest substring that contains all characters of 'S'.
Problem approach

You have been given a string 'S' which only consists of lowercase English-Alphabet letters.
Your task is to find the shortest(minimum length) substring of 'S' which contains all the characters of 'S' at least once. If there are many substrings with the shortest length, then find one which appears earlier in the string i.e. substring whose starting index is lowest.
For Example-
If the given string is S = "abcba", then the possible substrings are "abc" and "cba". As "abc" starts with a lower index (i.e. 0, "cba" start with index 2), we will print "abc" as our shortest substring that contains all characters of 'S'.

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

1. DBMS Questions

Explain the difference between intension and extension in a database.

Problem approach

Intension : Intension or popularly known as database schema is used to define the description of the database and is specified during the design of the database and mostly remains unchanged.

Extension : Extension on the other hand is the measure of the number of tuples present in the database at any given point in time. The extension of a database is also referred to as the snapshot of the database and its value keeps changing as and when the tuples are created, updated, or destroyed in a database

2. DBMS Questions

Explain different levels of data abstraction in a DBMS.

Problem approach

Physical Level : It is the lowest level and is managed by DBMS. This level consists of data storage descriptions and the details of this level are typically hidden from system admins, developers, and users.
Conceptual or Logical level : It is the level on which developers and system admins work and it determines what data is stored in the database and what is the relationship between the data points.
External or View level : It is the level that describes only part of the database and hides the details of the table schema and its physical storage from the users. The result of a query is an example of View level data abstraction. A view is a virtual table created by selecting fields from one or more tables present in the database

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
741 views
0 comments
0 upvotes
company logo
Data Engineering Intern
2 rounds | 4 problems
Interviewed by myKaarma
616 views
0 comments
0 upvotes
company logo
Data Engineer
3 rounds | 6 problems
Interviewed by myKaarma
775 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 Engineering Intern
3 rounds | 4 problems
Interviewed by Dunzo
841 views
0 comments
0 upvotes