OPTUMINSIGHT INDIA Senior Data Engineer Interview Questions and Answers

Q1. SQL Array Oop
Add your answer
Q2. Array defintiion and uses
Ans. 
An array is a data structure that stores a collection of elements of the same data type.
• Arrays are used to store multiple values in a single variable.

• Elements in an array are accessed by their index, starting from 0.

• Example: String[] names = {"Alice", "Bob", "Charlie"};
Answered by AI
Add your answer
Q3. Data structures and its uses
Ans. 
Data structures are used to organize and store data efficiently in computer memory.
• Data structures help in efficient data retrieval, insertion, and deletion operations.

• Examples include arrays, linked lists, stacks, queues, trees, and graphs.

• Each data structure has its own advantages and use cases based on the requirements of the application.

• For example, arrays are used for random access to elements, while linked lists
Answered by AI
Add your answer

Q1. List, tuple Decorators
Add your answer
Q2. What is the process for removing duplicates from a list?
Add your answer

Q1. Interviewer asked me basic SQL questions
Add your answer
Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Add your answer

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Q1. Tell me about your projects?
Add your answer
Q2. How do you approach the project if you are using logistic regression model?
Ans. 
Approach involves data preprocessing, model training, evaluation, and interpretation.
• Perform data preprocessing such as handling missing values, encoding categorical variables, and scaling features.

• Split the data into training and testing sets.

• Train the logistic regression model on the training data.

• Evaluate the model using metrics like accuracy, precision, recall, and F1 score.

• Interpret the model coefficients to under...read more
Answered by AI
Add your answer

Q1. What are you future goals?
Add your answer
Q2. What would you do if your interested field doesnt have any work in the company?
Ans. 
I would seek opportunities to apply my skills in related fields within the company.
• Explore other departments or teams within the company that may have projects related to my field of interest

• Offer to collaborate with colleagues in different departments to bring a new perspective to their projects

• Seek out professional development opportunities to expand my skills and knowledge in related areas
Answered by AI
Add your answer

Q1. What is the difference between normal and arrow functions
Ans. 
Arrow functions are more concise and have a lexical 'this' binding compared to normal functions.
• Arrow functions do not have their own 'this' keyword, they inherit it from the parent scope.

• Arrow functions do not have their own 'arguments' object.

• Arrow functions cannot be used as constructors with 'new'.

• Arrow functions are more concise and have implicit return when no curly braces are used.
Answered by AI
Add your answer
Q2. All basic JS Questions to cover Hoisting closure
Add your answer
Q3. They asked to show me an example using the API call
Add your answer
Q4. Difference between forEach and Map
Ans. 
forEach is used to iterate over an array and perform a function on each element, while map creates a new array by applying a function to each element.
• forEach does not return a new array, while map does

• forEach does not modify the original array, while map creates a new array

• forEach is used for side effects, while map is used for transformation

• Example: forEach - array.forEach(item => console.log(item)), map - const newAr
Answered by AI
Add your answer

Q1. What is Observables, Services, Promises, Closure ?
Add your answer

Q1. Basic Recommendation System Questions
Add your answer
Q2. A B Testing Questions
Add your answer

Q1. Explain collection framework and uses
Ans. 
Collection framework is a set of interfaces and classes in Java that provide a way to store and manipulate groups of objects.
• Provides interfaces like List, Set, Map for storing collections of objects

• Includes classes like ArrayList, HashSet, HashMap for implementing these interfaces

• Allows for easy manipulation, sorting, searching, and iteration of collections

• Used in various applications like data processing, data storag
Answered by AI
Add your answer
Q2. Explain springboot and it's annotation
Ans. 
Spring Boot is a Java-based framework used for creating standalone, production-grade Spring-based applications.
• Spring Boot simplifies the process of creating Spring applications by providing defaults for configuration and eliminating the need for XML configuration files.

• Annotations in Spring Boot are used to simplify the configuration of Spring applications by providing metadata about the application.

• Examples of annota...read more
Answered by AI
Add your answer