Decision Point 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

Basic Multiple choice questions

Q1. Two sum problem
Add your answer
Q2. Check if there is a loop in linked list
Ans. 
Check for a loop in a linked list by using two pointers moving at different speeds.
• Use two pointers, one moving at a normal speed and another moving at double the speed.

• If there is a loop, the two pointers will eventually meet at some point.

• Alternatively, use a hash set to store visited nodes and check for duplicates.
Answered by AI
Add your answer

Leet Code Medium, string, list, tuple

Q1. Pyspark, sql, Python.
Add your answer

Q1. Python, dsa,PySpark
Add your answer

Q1. Simple questions
Add your answer

2 MCQs sections based on SQL and Power BI.

Q1. Standard SQL question - 6 to 8 queries.
Add your answer
Q2. Case studies - 2 in total.
Add your answer
Q3. Why I'm curious about Data Science and other Data science related personal talk to understand the understanding in Data domain
Add your answer

Q1. Medical to Hard level SQL and Power BI - DAX queries. 5-6 queries.
Add your answer
Q2. Again talked about Data Science and called back again after 4 hours to know more about my SQL understandings.
Add your answer

Q1. 15 min quick discussion. Discuss the roles and responsibilities. Discuss the salary.
Add your answer
Q2. Guy looked exhausted and wrap the call quickly.
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Started with basic introduction about myself and then 2 DSA problems to be solved on CodeChef or any IDE of your preference. Interviewer was helpful throughout the interview and helped with syntaxes at one point as well.
Parameters tested - 
1. Ability to think of edge test cases.
2. Coding Practices like naming variables and functions properly and using the most suitable access modifiers.
3. Ability to think of time and space complexity and optimise it.
Reaching the correct output was not mandatory but was preferred. Priority to coding practices was given.

Q1. 
Next Greater Element Problem Statement
You are given an array arr of length N. For each element in the array, find the next greater element (NGE) that appears to the right. If there is no such greater ele...read more
Ans. 
The task is to find the next greater element for each element in the given array.
• Iterate through the array from right to left.

• Use a stack to keep track of the next greater element.

• Pop elements from the stack until a greater element is found or the stack is empty.

• If the stack is empty, there is no greater element, so assign -1.

• If a greater element is found, assign it as the next greater element.

• Push the current element ...read more
Answered by AI
View 2 more answers
Q2. 
Zigzag Binary Tree Traversal Problem Statement
Determine the zigzag level order traversal of a given binary tree's nodes. Zigzag traversal alternates the direction at each level, starting from left to rig...read more
Ans. 
The zigzag level order traversal of a binary tree is the traversal of its nodes' values in an alternate left to right and right to left manner.
• Perform a level order traversal of the binary tree

• Use a queue to store the nodes at each level

• For each level, alternate the direction of traversal

• Store the values of the nodes in each level in separate arrays

• Combine the arrays in alternate order to get the zigzag level order tra
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Started with basic introduction about myself and then 2 DSA problems to be solved on google doc. Interviewer was helpful throughout the interview.
Parameters tested - 
1. Ability to think of edge test cases.
2. Coding Practices like naming variables and functions properly and using the most suitable access modifiers.
3. Ability to think of time and space complexity and optimise it.
4. Making it to the correct output.

Reaching the correct output was mandatory in best possible time comlexity.

Q1. 
Problem: Search In Rotated Sorted Array
Given a sorted array that has been rotated clockwise by an unknown amount, you need to answer Q queries. Each query is represented by an integer Q[i], and you must ...read more
Ans. 
This is a problem where a sorted array is rotated and we need to search for given numbers in the array.
• The array is rotated clockwise by an unknown amount.

• We need to search for Q numbers in the rotated array.

• If a number is found, we need to return its index, otherwise -1.

• The search needs to be done in O(logN) time complexity.

• The input consists of the size of the array, the array itself, the number of queries, and the q
Answered by AI
Add your answer
Q2. 
K-th Element of Two Sorted Arrays
You are provided with two sorted arrays, arr1 and arr2, along with an integer k. By merging all elements from arr1 and arr2 into a new sorted array, your task is to ident...read more
Ans. 
The task is to find the kth smallest element of a merged array created by merging two sorted arrays.
• Merge the two sorted arrays into a single sorted array

• Return the kth element of the merged array
Answered by AI
View 1 more answer

Round duration - 40 minutes
Round difficulty - Easy

I was asked to introduce myself and general family background check and then discussion around salary negotiation.

Two easy questions two wasy questions two easy questions two easy questions

Q1. Technical interviews was very easy techijcal interviews was very easy very easy very easy
Add your answer
Q2. Interviews was conducted in advance of a news conference in the United Kingdom and the European government on Tuesday
Add your answer

Mathametics and statistics besed on the subject .

This test also i interested.

Q1. I knlw the statistical technical skill.
Add your answer
Q2. Data analysis with statistical tools
Ans. 
Data analysis involves using statistical tools to analyze and interpret data.
• Statistical tools help in summarizing and visualizing data

• They can be used to identify patterns, trends, and relationships in the data

• Common statistical tools include regression analysis, hypothesis testing, and clustering

• Statistical tools help in making data-driven decisions and predictions
Answered by AI
Add your answer