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

Data Engineer

Novus Platform
upvote
share-icon
3 rounds | 6 Coding problems

Interview preparation journey

expand-icon
Journey
Constantly working on my core primary skills and regular practice, along with hands-on experience on CodeStudio, helps me stay on top of my game.
Application story
I applied to the relevant jobs according to my role, and there were multiple rounds. After all of them, they released the offer.
Why selected/rejected for the role?
I was selected because I showed my technical skills, problem solving skills and ensured that they understand my previous project very well.
Preparation
Duration: 2 months
Topics: Data Structures & Algorithms, Python, AWS, SQL, System Design
Tip
Tip

Tip 1 : Study and research without long breaks.
Tip 2 : Keep practicing DSA.
Tip 3 : Ask questions from your mentors.

Application process
Where: Linkedin
Eligibility: 70% in Graduation
Resume Tip
Resume tip

Tip 1 : Keep it short and crisp.
Tip 2 : Mention adjectives and implementation steps.

Interview rounds

01
Round
Medium
Video Call
Duration60 minutes
Interview date3 May 2023
Coding problem3

1. Minimum Time

Moderate
30m average time
60% success
0/80
Asked in companies
AppleRubrik, Inc.Novus Platform

There are ‘N’ junctions connected by ‘M’ bi-directional roads. At most, one road is present between any pair of junctions. There is no road connecting a junction to itself. The travel time for a road is the same in both directions.

A vehicle at a junction can start moving along a road only when the light at the current junction flashes green. If a vehicle arrives at a junction between green flashes, it must wait for the next green flash before continuing in any direction. If it arrives at a junction exactly when the light flashes green, it can immediately proceed along any road originating from that junction.

You are given a city map that shows travel times for all roads. For each junction ‘i’, you are given ‘P[i]’, the time period between green flashes of the light at that junction. The light at junction ‘i’ flashes green at times 0, P[i], 2P[i], 3P[i] and so on.

Your task is to return the minimum time taken from a given source junction ‘src’ to a given destination junction ’des’ for a vehicle when the traffic starts. The junctions are identified by integers ‘0’ through ‘N - 1’. If we cannot reach the destination junction, then return -1.

For example:
Consider if ‘N’ = 3 and edges are 
[[0, 1, 2],
 [1, 2, 4]]
'P' = [2, 3, 4], and we have to reach from junction 0 to 2.
The time consumed from junction 0 to 1 is 2. We have to wait for 1 for the next green flash at junction 1. The time consumed from junction 1 to 2 is 4. The path 0 -> 1 -> 2 takes time 2 + 1 (wait till 3) + 4 = 7. Hence, the answer is 7.
Try solving now

2. DBMS

Julia has just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respective hacker_id and name of hackers who achieved full scores in more than one challenge. Order your output in descending order by the total number of challenges in which each hacker earned a full score. If more than one hacker received full scores in the same number of challenges, then sort them by ascending hacker_id.

Problem approach

Tip 1 : Use join.
Tip 2 : Use group by and having.
Tip 3 : Use order by.

3. Search In A 2D Matrix

Easy
10m average time
90% success
0/40
Asked in companies
HSBCAdobeCIS - Cyber Infrastructure

You have been given a 2-D array 'mat' of size 'M x N' where 'M' and 'N' denote the number of rows and columns, respectively. The elements of each row are sorted in non-decreasing order.


Moreover, the first element of a row is greater than the last element of the previous row (if it exists).


You are given an integer ‘target’, and your task is to find if it exists in the given 'mat' or not.


Example:
Input: ‘M’ = 3, 'N' = 4, ‘mat’ = [[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12]], ‘target’ = 8

Output: true

Explanation: The output should be true as '8' exists in the matrix.
Problem approach

We can consider 2d as 1d and we can simply apply binary search to search the targetto get,

element= s[mid/col][mid%col];
where mid is calculated mid value
miid/col give row value;
mid%col give you column value;

Try solving now
02
Round
Medium
Video Call
Duration60 minutes
Interview date11 May 2023
Coding problem2

1. Multiply Strings

Moderate
35m average time
55% success
0/80
Asked in companies
FacebookAmazonIBM

You are given two big numbers ‘A’ and ‘B’ as strings. Your task is to find the product of both the numbers.

Note:

There are no leading zeros in both the strings, except the number 0 itself.
Do not use any built-in Big Integer Library.
For Example:
If, A = 123, and B = 456.
So the product of both numbers will be 56088.
Problem approach

Consider '123' and '456'. Multiply the '6' from '456' with the '3' from '123' and keep track of this total sum. For the next '6' from '456' with the '2' from '123', multiply the product by 10^1 to account for the '2' in the tens place. Similarly, do this for each digit and keep adding the sums.

Try solving now

2. Permutations of a String

Moderate
15m average time
85% success
0/80
Asked in companies
MakeMyTripDisney + HotstarOla

You are given a string 'STR' consisting of lowercase English letters. Your task is to return all permutations of the given string in lexicographically increasing order.

String A is lexicographically less than string B, if either A is a prefix of B (and A ≠ B), or there exists such i (1 <= i <= min(|A|, |B|)), that A[i] < B[i], and for any j (1 <= j < i) A[i] = B[i]. Here |A| denotes the length of the string A.

For example :

If the string is “bca”, then its permutations in lexicographically increasing order are { “abc”, “acb”, “bac”, “bca”, “cab”, “cba” }.
Note:
Given string contains unique characters.
Problem approach

Using stack and recursion, push the item in the stack, store each permutation item and then, pop from the stack while an outer loop is running.

Try solving now
03
Round
Easy
HR Round
Duration30 minutes
Interview date20 May 2023
Coding problem1

1. Basic HR Questions

Tell me about yourself.

Tell me about your family.

Why are you looking for a job?

Why do you think you are fit for this role?

Problem approach

Tip 1 : Be confident.
Tip 2 : Be clear and concise.
Tip 3 : Take a quick look about company and its business.

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
SDE - 1
4 rounds | 8 problems
Interviewed by Amazon
8518 views
0 comments
0 upvotes
Analytics Consultant
3 rounds | 10 problems
Interviewed by ZS
907 views
0 comments
0 upvotes
company logo
SDE - Intern
1 rounds | 3 problems
Interviewed by Amazon
3320 views
0 comments
0 upvotes
company logo
SDE - 2
4 rounds | 6 problems
Interviewed by Expedia Group
2581 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