Innoviti Technologies Private Limited Data Engineer Interview Questions and Answers

Q1. Explain the project architecture.
Ans. 
The project architecture consists of multiple components that work together to process and analyze data.
• The architecture follows a distributed computing model.

• Data is collected from various sources and stored in a data lake or data warehouse.

• Data processing and transformation tasks are performed using tools like Apache Spark or Hadoop.

• Processed data is then loaded into a database or data store for further analysis.

• Anal...read more
Answered by AI
View 1 more answer
Q2. What are flaws in your architecture?
Ans. 
Our architecture lacks scalability and real-time processing capabilities.
• Our current architecture is not designed to handle large volumes of data.

• Real-time processing of data is not possible with our current setup.

• We lack a proper data pipeline for efficient data processing.

• Our architecture is not fault-tolerant and lacks redundancy.

• We need to improve our data storage and retrieval mechanisms.

• Our architecture does not ...read more
Answered by AI
Add your answer

Machine coding.
Code structure, naming, best practices are more important than time or space complexity.

Same as Round 1, except more complex problem statement

Q1. Integration round. Given a library, do some operations with it, i.e. pull specific data point from file, make an POST call using different data point etc.
Add your answer

Q1. Given a codebase, fix a specific bug
Ans. 
I would start by reproducing the bug, analyzing the code, identifying the root cause, implementing a fix, testing the fix, and finally deploying it.
• Reproduce the bug by following the steps that lead to the issue.

• Analyze the code surrounding the bug to understand the context and potential causes.

• Identify the root cause of the bug by debugging and tracing the code execution.

• Implement a fix by making the necessary code ch...read more
Answered by AI
Add your answer

Q1. Standard HLD/LLD design problem
Ans. 
HLD focuses on overall system architecture, while LLD delves into specific implementation details.
• HLD includes components, modules, interfaces, and dependencies.

• LLD involves detailed class diagrams, data structures, algorithms, and database schema.

• Example: HLD may outline a system using microservices architecture, while LLD may specify how each microservice communicates and stores data.
Answered by AI
Add your answer

Q1. Coding questions on Python and SQL
Add your answer
Q2. Python basic DS questions
Add your answer

It was about DS Algo and Java garbage collection,multithreading

Q1. Low level design of rate limiter
Ans. 
Rate limiter is a system that controls the rate of traffic sent or received by a network interface.
• Implement a token bucket algorithm to track and limit the rate of requests

• Use a sliding window algorithm to track the number of requests within a specific time frame

• Consider using a distributed rate limiter for scalability and fault tolerance
Answered by AI
Add your answer
Q2. Springboot basics, java basics, future interfaces, basic sql queries
Add your answer

Q1. Longest Consecutive Sequence
Ans. 
Find the length of the longest consecutive elements sequence in an array.
• Sort the array to ensure consecutive elements are adjacent

• Iterate through the array and keep track of the current consecutive sequence length

• Update the longest consecutive sequence length as you iterate
Answered by AI
Add your answer
Q2. Core Java Questions
Add your answer

Q1. Executor Service and it's code
Ans. 
Executor Service is a framework provided by Java for managing and executing asynchronous tasks.
• Executor Service allows you to easily create and manage threads for executing tasks.

• It provides a way to control the number of threads used for executing tasks, which can help prevent resource exhaustion.

• You can submit tasks to an Executor Service using methods like execute() or submit().

• Executor Service can be used to execut...read more
Answered by AI
Add your answer
Q2. Core Java and Spring boot questions
Add your answer

Q1. Design patterns
Add your answer
Q2. Core Java questions
Add your answer

It consist of 4 DSA ques and few quiz and opps concept based ques
1st was string based Medium level ques.
2nd was a ques based on 2 pointer
And other 2 was from Vector and Linked list easy ques

Q1. It was stock buy and sell ques on leetcode where we need to find Max profit and what day to buy and sell
Add your answer
Q2. 2d array ques to print natural numbers in spiral form
Ans. 
Print natural numbers in spiral form using a 2D array.
• Create a 2D array with dimensions n x n.

• Initialize variables for row and column boundaries.

• Iterate through the array in a spiral pattern, filling in natural numbers.
Answered by AI
Add your answer
Q3. Hard level linked list ques
Add your answer

Q1. Describe projects
Ans. 
I have worked on various projects including developing web applications, creating mobile apps, and implementing machine learning algorithms.
• Developed a web application for a retail company to manage inventory and sales data

• Created a mobile app for a fitness tracking platform to track user's exercise routines

• Implemented machine learning algorithms for a recommendation system in an e-commerce website
Answered by AI
Add your answer
Q2. Knowledge testing on ML frameworks
Add your answer

Had a overall personality, technical & problem solving test with AVP

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer