Sun Dew Solutions Data Engineer Interview Questions and Answers

Easy and moderate level question

Given a relevant topic and discussion on it

Q1. Introducd yourself
Add your answer
Q2. Why do you want to join us
Add your answer

Q1. Palindrome code should design
Ans. 
Palindrome code should be designed to check if a given string is the same forwards and backwards.
• Create a function that takes a string as input

• Remove any spaces and punctuation from the string

• Reverse the string and compare it to the original string to check if it is a palindrome
Answered by AI
Add your answer
Q2. Regarding sql topics like joins and acid
Add your answer
Q3. Project explain and domain
Add your answer
Q4. Project explain and domain and internal working
Add your answer
Q5. Oops concepts and coding
Add your answer

Q1. Diff btw vite and webpack
Add your answer
Q2. What is currying in js
Add your answer

Q1. What is currying in javascript?
Add your answer
Q2. Diff btw webpack and vite
Add your answer

Q1. Difference between function and method
Add your answer
Q2. A program related to strings
Add your answer
Q3. A program related to prime numbers
Add your answer

The aptitude test was relatively straightforward, consisting of both aptitude and technical questions, with a difficulty level ranging from easy to medium.

Q1. Was asked to write a code on basic DSA concept
Add your answer
Q2. Then was asked basic questions on DSA and SQL
Add your answer

Q1. How to rotate a matrix?
Ans. 
To rotate a matrix, transpose it and then reverse each row or column depending on the direction of rotation.
• Transpose the matrix by swapping elements across the diagonal

• For clockwise rotation, reverse each row of the transposed matrix

• For anti-clockwise rotation, reverse each column of the transposed matrix
Answered by AI
Add your answer
Q2. How to find a particular element in a sorted array?
Ans. 
Use binary search to efficiently find a particular element in a sorted array.
• Start by comparing the target element with the middle element of the array.

• If the target element is less than the middle element, search the left half of the array.

• If the target element is greater than the middle element, search the right half of the array.

• Repeat the process until the target element is found or the search space is empty.
Answered by AI
Add your answer

Forecasting problem - Predict daily sku level sales

Q1. What is difference between bias and variance
Ans. 
Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.
• Bias is the error introduced by approximating a real-world problem, leading to underfitting.

• Variance is the error introduced by modeling the noise in the training data, leading to overfitting.

• High bias can cause a model to miss relevant relationships between features and target variable.

• High variance can cause a model to ...read more
Answered by AI
Add your answer
Q2. Parametric vs non parametruc model
Ans. 
Parametric models make strong assumptions about the form of the underlying data distribution, while non-parametric models do not.
• Parametric models have a fixed number of parameters, while non-parametric models have a flexible number of parameters.

• Parametric models are simpler and easier to interpret, while non-parametric models are more flexible and can capture complex patterns in data.

• Examples of parametric models inc...read more
Answered by AI
Add your answer