Kagool Senior Data Engineer Interview Questions and Answers

First round was coding test on Coderbyte it was good.

Q1. This round is video technical interview on flowcareer platform
Add your answer
Q2. Coding DSA question was asked on array.
Add your answer

Q1. This round contains mix questions on theory as well as DSA.
Add your answer
Q2. Machine coding question asked on react.js.
Add your answer

Q1. Some basic react.js and node.js questions.
Add your answer
Q2. Questions asked on MongoDB and one DSA question on array asked.
Add your answer

Q1. This round is HR salary discussion round and i got offer.
Add your answer

Q1. What do u mean by data
Ans. 
Data refers to facts, statistics, or information collected for analysis or reference.
• Data is raw, unprocessed information.

• It can be in the form of numbers, text, images, or any other format.

• Examples include customer names, product prices, and sales figures.

• Data can be structured (organized in a specific way) or unstructured (not organized).
Answered by AI
Add your answer
Q2. What is preprocessed data
Ans. 
Preprocessed data is data that has been cleaned, transformed, and organized for analysis or modeling.
• Preprocessed data is often used in machine learning and data analysis to improve the accuracy and efficiency of models.

• Common preprocessing steps include removing missing values, scaling features, and encoding categorical variables.

• Examples of preprocessing techniques include normalization, standardization, one-hot enco
Answered by AI
Add your answer
Q3. What do u mean by info
Ans. 
Info refers to data or knowledge that provides details or context about a specific topic or subject.
• Info can be in the form of facts, statistics, or explanations.

• It helps to understand a topic better or make informed decisions.

• Examples of info include news articles, research papers, and educational resources.
Answered by AI
Add your answer
Q4. How to copy from 2 tables and paste in 3rd one in sql
Ans. 
Use SQL INSERT INTO SELECT statement to copy data from 2 tables and paste into a 3rd table.
• Use INSERT INTO SELECT statement to copy data from 2 tables and paste into a 3rd table.

• Specify the columns you want to copy from each table in the SELECT statement.

• Make sure the columns in the SELECT statement match the columns in the 3rd table where you are pasting the data.
Answered by AI
Add your answer
Q5. Reverse string using any language you know
Ans. 
Reverse a string using any programming language
• Use built-in functions like reverse() or slice() in languages like Python or JavaScript

• Iterate through the string in reverse order and append each character to a new string

• Use a stack data structure to push each character onto the stack and then pop them off to reverse the string
Answered by AI
Add your answer
Q6. A puzzle question was asked but i don't remeber it.
Add your answer

Q1. Given the react machine coding example
Add your answer

Q1. Explain about your projects
Add your answer

In the coding test, there were 2 problems based on arrays and hashing (easy to medium level leetcode)

Q1. Several OOP questions were asked.... like, Can we have a class inside an interface? Can we have a static constructor? Can we have multiple main methods?
Add your answer
Q2. DBMS question: Normalization questions and keys concepts.
Add your answer

Q1. DSA question (stack based) You have a stack full of numbers, you have to arrange them in ascending order in the same stack without using any other data structure.
Add your answer
Q2. OS and DBMS questions(sharding, semaphores, etc.)
Add your answer

Q1. Questions based on Consultadd principles.
Add your answer

Assusual apti questions from every topics

1. 1 coding Question we can use java, python etc to solve and
2. another 1 sql question

One question based on any one data structure (in my case I solved stack &queue combinely)

Q1. They ask about Ur background qualifications and verify
Add your answer
Q2. And then explain the process of company and ask everything is ok for us like bond etc
Add your answer
Q3. Then sheduled interview on the next day
Add your answer

Q1. She(hr) introduced herself
Add your answer
Q2. Then she asked me to introduce myself
Add your answer
Q3. What are the programming languages u know ( I said I'm strong in java)
Ans. 
I am strong in Java programming language.
• Proficient in Java programming language

• Experience in developing applications using Java

• Knowledge of Java frameworks like Spring and Hibernate
Answered by AI
Add your answer
Q4. Rate Urself in it out of 5
Ans. 
I rate myself 4 out of 5 in IT skills.
• Proficient in programming languages such as Java, Python, and C++

• Experienced in software development and debugging

• Familiar with database management systems like MySQL and MongoDB
Answered by AI
Add your answer
Q5. She asked me to explain lambda expressions in java
Add your answer
Q6. Explain detaily about Four pillars of oops
Ans. 
The four pillars of OOP are encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Inheritance: Allows a class to inherit properties and behavior from another class.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hides the complex implementation details and only shows the necessary features.
Answered by AI
Add your answer
Q7. Share Ur screen and get this output (pattern program)
Ans. 
Print a specific pattern using loops
• Use nested loops to print the desired pattern

• Increment the number of characters printed in each row

• Adjust the spacing to create the desired pattern
Answered by AI
Add your answer
Q8. Shorterm and long-term goals
Add your answer
Q9. If your assigned to a task how can you complete it
Add your answer
Q10. Exception handling concept (she specifically asked about throw, throws, finally keyword)
Add your answer
Q11. Explain about Static keyword
Ans. 
Static keyword is used in programming languages to declare variables, functions, or classes that are shared among all instances of a class or are only accessible within a specific scope.
• Static variables retain their values between function calls

• Static functions can only be called within the same file

• Static classes cannot be instantiated and are used for grouping related methods and properties
Answered by AI
Add your answer

Q1. A Lot of OOPS and Virtual concept
Add your answer
Q2. Basic SQL till joins
Add your answer
Q3. Java script medium
Add your answer
Q4. C# oops output based
Add your answer