Innovaccer Data Engineer Interview Questions and Answers

Q1. How to build data pipeline
Add your answer
Q2. IICS
Add your answer

Q1. About the project and technical aspect
Add your answer

Hackerearth problem on reversing the string & one more array question

Q1. Reverse the string
Ans. 
Reverse a given string
• Use built-in functions like reverse() in Python

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

• Use stack data structure to reverse the string
Answered by AI
Add your answer
Q2. SQL based windowing function
Add your answer

Logical questions which are highly useful

Multiple coding questions they asked in pyspark

Q1. What are advance types of join ?
Ans. 
Advanced types of join include outer join, self join, and cross join.
• Outer join: includes unmatched rows from one or both tables

• Self join: joins a table with itself

• Cross join: combines each row from one table with each row from another table
Answered by AI
Add your answer
Q2. Difference between having clause and where clause?
Ans. 
The WHERE clause is used to filter rows before grouping, while the HAVING clause is used to filter groups after grouping.
• WHERE clause is used with SELECT, UPDATE, and DELETE statements.

• HAVING clause is used with SELECT statements that include GROUP BY clause.

• WHERE clause filters individual rows based on conditions.

• HAVING clause filters groups based on conditions.

• WHERE clause is applied before the GROUP BY clause.

• HAVING...read more
Answered by AI
Add your answer
Q3. Differnce between join and union?
Ans. 
Join combines rows from two or more tables based on a related column, while union combines rows from two or more tables into a single result set.
• Join is used to combine rows from different tables based on a related column.

• Union is used to combine rows from two or more tables into a single result set.

• Join can be used with different types like inner join, left join, right join, etc.

• Union only combines rows with the same ...read more
Answered by AI
Add your answer
Q4. Basic oops concept ?
Add your answer
Q5. What are python data structure?
Ans. 
Python data structures are containers that hold and organize data in different ways.
• Some common Python data structures are lists, tuples, sets, and dictionaries.

• Lists are ordered and mutable, allowing duplicate elements.

• Tuples are ordered and immutable, useful for storing related data together.

• Sets are unordered and contain unique elements, useful for mathematical operations.

• Dictionaries are key-value pairs, providing
Answered by AI
Add your answer

Q1. About project what are optimization you have done
Add your answer