HEPL - A Cavinkare Group Company Data Engineer Interview Questions and Answers

Oops dsa sql network

Q1. Dsa based python question
Add your answer
Q2. Dsa based python question on tress
Add your answer

Q1. Sql question queries
Add your answer
Q2. Sql question query
Add your answer

Some multiple choice, 2 sql and 2 python questions were asked

Q1. Tell me about you project
Ans. 
Developed a real-time data processing system for analyzing customer behavior
• Used Apache Kafka for streaming data ingestion

• Implemented data pipelines using Apache Spark for processing and analysis

• Utilized Elasticsearch for storing and querying large volumes of data

• Developed custom machine learning models for predictive analytics
Answered by AI
Add your answer
Q2. Optimising technique that you have used
Ans. 
I have used partitioning and indexing to optimize query performance.
• Implemented partitioning on large tables to improve query performance by limiting the data scanned

• Created indexes on frequently queried columns to speed up data retrieval

• Utilized clustering keys to physically organize data on disk for faster access
Answered by AI
Add your answer

Q1. Window partition question was asked
Add your answer
Q2. Project related question
Add your answer

First round is aptitude test containing general aptitude questions

Medium to easy level dsa problems

Q1. Questions based on resume
Add your answer
Q2. Questions on sql like set operators , and some easy level sql queries
Add your answer
Q3. How do you debug in projects
Add your answer

Q1. Introduction, Why EY
Add your answer
Q2. Are you open to Relocation
Add your answer

Q1. How you load the data using delta table in adf
Ans. 
You can load data using delta table in ADF by using the Copy Data activity and specifying the delta format.
• Use the Copy Data activity in ADF to load data into a delta table

• Specify the delta format in the sink settings of the Copy Data activity

• Ensure that the source data is compatible with the delta format
Answered by AI
Add your answer

Q1. What are cyclic linked lists
Ans. 
Cyclic linked lists are linked lists where the last node points back to the first node, creating a loop.
• Cyclic linked lists have no NULL pointers, making it difficult to determine the end of the list.

• They can be used to efficiently represent circular data structures like a round-robin scheduling algorithm.

• Detecting cycles in a linked list can be done using Floyd's cycle-finding algorithm.
Answered by AI
Add your answer
Q2. Coding question from BST
Add your answer

Q1. About data modelling and Architecture
Add your answer
Q2. Real world problem and solution
Ans. 
Real world problem: Predicting customer churn in a subscription-based service
• Collect and analyze customer data such as usage patterns, demographics, and interactions

• Use machine learning algorithms to identify factors leading to churn

• Implement targeted retention strategies based on the analysis

• Monitor and evaluate the effectiveness of the strategies over time
Answered by AI
Add your answer

Q1. Sql technical round
Add your answer
Q2. About various azure services
Add your answer

Q1. About my work area
Add your answer
Q2. Managerial and company fit
Add your answer

Asked me two string array question one was to reverse a string without any pre build function and second one was a medium question to print the number and the count of it into the next level of the tree

Q1. Who is your idol?
Add your answer
Q2. How do you menage your work?
Ans. 
I manage my work by prioritizing tasks, setting goals, staying organized, and communicating effectively with team members.
• Prioritize tasks based on deadlines and importance

• Set clear goals and milestones to track progress

• Stay organized with tools like project management software

• Communicate effectively with team members to ensure alignment and collaboration
Answered by AI
Add your answer

Q1. Project discussion
Add your answer
Q2. SQL
Add your answer