Edvoy Data Engineer Interview Questions and Answers

Simple 30-question 30-minute general aptitude test (entry-level)

Q1. General discussion about projects created. Tech stack selection and other project related questions
Add your answer

Q1. What data structure is used to implement a priority queue?
Ans. 
Binary heap is used to implement a priority queue.
• Binary heap is a complete binary tree where each node has a value greater than or equal to its children.

• It can be implemented using arrays, where the parent of node at index i is at index (i-1)/2.

• Insertion and deletion operations have time complexity of O(log n) in a binary heap.
Answered by AI
Add your answer
Q2. How many trees will a binary tree have?
Ans. 
A binary tree can have any number of nodes, but the maximum number of trees with n nodes is 2^n.
• A binary tree can have 0 nodes, 1 node, 2 nodes, or any number of nodes.

• The maximum number of binary trees with n nodes is 2^n.

• For example, a binary tree with 3 nodes can have up to 8 different structures.
Answered by AI
Add your answer

Q1. SQL Query to return the second highest marks in a student database
Ans. 
Use a SQL query to find the second highest marks in a student database.
• Use the ORDER BY clause to sort the marks in descending order

• Use the LIMIT clause to limit the result to the second row
Answered by AI
Add your answer
Q2. Program to check if two strings are anagrams
Ans. 
Program to check if two strings are anagrams
• Create a function that takes in two strings as input

• Remove any spaces and convert both strings to lowercase for consistency

• Sort the characters in both strings and compare if they are equal to determine if they are anagrams

• Example: 'listen' and 'silent' are anagrams
Answered by AI
Add your answer

Sql, numpy, pandas, dictionary, pandas group by, merging

Q1. Normal questions
Add your answer

Q1. SQL queries , python pandas and numpy , power bi related questions
Add your answer

Q1. Previous experience, skills and expertise
Add your answer

Estimate a civil engineering project.

Q1. What is key features python programming
Ans. 
Key features of Python programming include simplicity, readability, versatility, and extensive libraries.
• Python is known for its simple and readable syntax, making it easy to learn and understand.

• It is a versatile language that can be used for various purposes such as web development, data analysis, and artificial intelligence.

• Python has a vast collection of libraries and frameworks that provide ready-to-use tools for ...read more
Answered by AI
Add your answer
Q2. What is pandas word?
Ans. 
Pandas is a powerful data manipulation library in Python, used for data analysis and data wrangling tasks.
• Pandas is a Python library that provides data structures and functions for efficient data manipulation.

• It is widely used for tasks like data cleaning, transformation, and analysis.

• Pandas offers powerful tools for handling structured data, such as CSV or Excel files.

• It provides functionalities like filtering, sortin...read more
Answered by AI
Add your answer
Q3. Different between seaborn and matplotlib
Ans. 
Seaborn is a high-level interface for statistical data visualization, while Matplotlib is a low-level library for creating basic plots.
• Seaborn provides a more aesthetically pleasing and informative visual representation of data compared to Matplotlib.

• Seaborn has built-in themes and color palettes that make it easier to create visually appealing plots.

• Matplotlib offers more flexibility and control over plot customizatio...read more
Answered by AI
Add your answer

Q1. What are your experiences and learnings?
Ans. 
I have over 5 years of experience in retail management, leading teams and driving sales. I have learned the importance of effective communication, problem-solving, and strategic planning.
• Managed a team of 20+ employees in a retail store, resulting in a 15% increase in sales over the past year

• Implemented new training programs to improve employee performance and customer satisfaction

• Developed and executed strategic marke...read more
Answered by AI
Add your answer
Q2. In which area have you managed projects or responsibilities?
Ans. 
I have managed projects in the marketing and sales department.
• Led a team in launching a new product campaign

• Managed budget and resources for various marketing initiatives

• Implemented sales strategies to increase revenue

• Collaborated with cross-functional teams to achieve project goals
Answered by AI
Add your answer

Q1. About past job experience
Add your answer

Q1. About current job role
Add your answer