Celebal Technologies Senior Data Engineer Interview Questions and Answers

Q1. How did you ingest kafka data and you day to day activity
Ans. 
I ingested Kafka data using Kafka Connect and performed data processing and analysis on a daily basis.
• Used Kafka Connect to ingest data from various sources into Kafka topics

• Developed custom Kafka Connect connectors for specific data sources

• Utilized Kafka Streams for real-time data processing and analysis

• Worked with schema registry for data serialization and deserialization
Answered by AI
Add your answer
Q2. What is catalyst optimizer
Ans. 
Catalyst optimizer is a query optimization framework in Apache Spark that improves performance by generating optimized query plans.
• Catalyst optimizer is a rule-based optimization framework in Apache Spark.

• It leverages advanced techniques like predicate pushdown, constant folding, and join reordering to optimize query plans.

• Catalyst optimizer helps in improving the performance of Spark SQL queries by selecting the most ...read more
Answered by AI
Add your answer

SQL test, 3-5 questions. Easy to moderate difficult.

Q1. Your current and expected slaray
Add your answer
Q2. Do you have any offer in hand
Ans. 
Yes, I have received an offer from another company.
• Received an offer from XYZ company for a Senior Data Engineer position

• Currently evaluating the offer and considering my options

• Have not made a decision yet
Answered by AI
Add your answer

Low level Design Problem in Java

Q1. Data Structures - Graph Problem DFS
Add your answer

System Design with few details

Good , just practice Leet code easy questions

Q1. Basic questions on resume back propagation , gradient descent , activation functions and what is the significance why resnet , vanishing gradient poroblem
Add your answer

Top is Love marriage arrange marriage

Q1. What is array and tell array methods
Ans. 
An array is a data structure that stores a collection of elements of the same type in a contiguous memory location.
• Array methods include push() - adds an element to the end of the array

• Array methods also include pop() - removes the last element from the array

• Other array methods are shift() - removes the first element, and unshift() - adds an element to the beginning

• Array methods like splice() - adds or removes elements...read more
Answered by AI
Add your answer
Q2. What is object and tell how its work in js
Ans. 
An object in JavaScript is a collection of key-value pairs that represent a real-world entity or concept.
• Objects are used to store data and functions together.

• Properties in an object are accessed using dot notation or bracket notation.

• Objects can be created using object literals or constructor functions.
Answered by AI
Add your answer

Aptitude of from all topics

Q1. Node js & javascript coding question
Add your answer
Q2. Array related questions
Add your answer