AVASOFT 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

Q1. Stored procedure sql hard
Add your answer
Q2. Easy dsa problem solving
Add your answer

Q1. Write a program to reverse the string
Ans. 
Program to reverse a string using array of characters
• Create an array of characters from the input string

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

• Return the reversed string
Answered by AI
Add your answer

It also had apptitude questions as well

Q1. Object oriented programming concepts like class , object , constructor , polymorphism, etc. The question tested deep knowledge of OOPS
Add your answer
Q2. Static and dynamic casting
Add your answer

Q1. What was my work in my internship?
Add your answer
Q2. I was in the field of Cybersecurity so they cross questioned me on that field like kubernetes security , Active Directory and cloud security
Add your answer

Q1. Are you willing to re-locate?
Add your answer
Q2. What are your motives to join this particular company
Add your answer

Q1. What are your strengths
Add your answer
Q2. What are your weaknessess
Add your answer

Practice topics like Event loop based questions, polyfills etc

Q1. Questions around design patterns
Add your answer