Whale Cloud Data Engineer Interview Questions and Answers

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

Q1. About the experience part
Add your answer
Q2. About the technical part
Add your answer

Q1. What is ITSM stands for?
Ans. 
ITSM stands for Information Technology Service Management.
• ITSM is a set of policies, processes, and procedures for managing IT services.

• It focuses on delivering value to customers through the management of IT services.

• Examples of ITSM tools include ServiceNow, BMC Remedy, and Jira Service Desk.
Answered by AI
Add your answer
Q2. What are role of an system engineer in daily work day?
Ans. 
System engineers are responsible for designing, implementing, and maintaining computer systems and networks.
• Designing and implementing computer systems and networks

• Troubleshooting and resolving technical issues

• Collaborating with other team members to ensure system functionality

• Monitoring system performance and security

• Updating and upgrading systems as needed
Answered by AI
Add your answer

Q1. It start with technical screening.
Add your answer
Q2. Exaplain about you last project role
Add your answer
Q3. What is dead lock
Ans. 
Deadlock is a situation in which two or more competing actions are each waiting for the other to finish, preventing any of them from completing.
• Occurs in multi-threaded or distributed systems

• Caused by resource contention and circular wait

• Can be prevented by proper resource allocation and avoiding circular wait

• Example: Process A holds resource X and waits for resource Y, while process B holds resource Y and waits for re
Answered by AI
Add your answer
Q4. What is pagination
Ans. 
Pagination is the process of dividing content into separate pages to improve user experience and optimize loading times.
• Pagination is commonly used in websites to display a large amount of data in manageable chunks.

• It allows users to navigate through different pages of content, typically with 'Next' and 'Previous' buttons.

• Pagination can also include options to jump to specific pages or adjust the number of items displa...read more
Answered by AI
Add your answer

Q1. This was the final round with client in which they took interview based on skills mentioned in resume
Add your answer

Q1. Data sharding, hld, slices, index, goroutines, why mongodb database, arrays,
Add your answer

General aptitude questions

Basic DSA questions(Arrays, Sorting etc)

Q1. Project discussion
Add your answer
Q2. Questions around android development
Add your answer
Q3. OOPS in depth questions
Add your answer

Topics:
Python, Django, MySQL, Automation, Technical questions

Q1. Topics: Python, Django, MySQL, Automation, Technical questions
Add your answer
Q2. Explain Django Architecture
Ans. 
Django follows Model-View-Controller (MVC) architectural pattern.
• Django has a high-level architecture that follows the Model-View-Controller (MVC) architectural pattern.

• The Model layer represents the database schema and business logic.

• The View layer is responsible for rendering the templates and presenting the data to the user.

• The Controller layer handles the user's input and interacts with the Model and View layers.

• Dj...read more
Answered by AI
Add your answer
Q3. Difference between XML and JSON
Ans. 
XML is a markup language while JSON is a lightweight data interchange format.
• XML uses tags to define elements while JSON uses key-value pairs.

• XML is more verbose and complex than JSON.

• JSON is easier to read and parse than XML.

• XML supports namespaces and validation while JSON does not.

• XML is widely used in web services and document exchange while JSON is preferred for data exchange between applications.
Answered by AI
Add your answer

There will be 3 coding questions. They are of medium and hard level.

Q1. Sort array consisting 0's 1's and 2's without inbuilt functions
Ans. 
Sort an array of 0's, 1's, and 2's without using inbuilt functions.
• Use three pointers to keep track of the last index of 0's, 1's, and 2's

• Iterate through the array and swap elements based on their value

• Continue until all elements are sorted
Answered by AI
View 1 more answer

Q1. Os cn related questions
Add your answer

Q1. Java questions and general hr questions
Add your answer