kipi.ai Data Engineer Interview Questions and Answers

Round duration - 60 mins
Round difficulty - Medium

Q1. 
Railway Seat Berth Determination
Given a railway seat number represented as an integer, determine if it is a valid seat number and identify its berth type. Possible berth types include lower berth, middle...read more
Ans. 
Given a railway seat number, determine if it is valid and identify its berth type.
• Parse input integer 't' for number of test cases

• For each test case, check if seat number is valid (1 <= N <= 100)

• Identify berth type based on seat number and output the result

• Possible berth types are Lower, Middle, Upper, Side Lower, and Side Upper
Answered by AI
Add your answer

Round duration - 90 mins
Round difficulty - Hard

First they asked me to introduce myself then they started questioning on oops concept from basic to advance level such as inheritance, polymorphism, abstraction, exception handling , STL etc. Next they started questioning on data structures. They asked me the logic of “how to find the middle of a linked list”.

Q1. 
Matrix Symmetry Check
You are provided with a square matrix. Your task is to return true if the matrix is symmetric; otherwise, return false.
A symmetric matrix is characterized by its transpose being eq...read more
Ans. 
Check if a square matrix is symmetric by comparing it with its transpose.
• Iterate through the matrix and compare each element with its corresponding element in the transpose

• If any pair of elements do not match, return false immediately

• If all pairs match, return true at the end
Answered by AI
Add your answer

Q1. Questions about the tech skills you have
Add your answer

Q1. Salary discussion .
Add your answer

If you are a fresher , then this is for you else almost no coding test for experienced candidates.

Q1. Javascript basics, Angular react general questions depends upon profile.
Add your answer

Q1. They asked general questions related to some hectic situation faced in previous company / project..
Add your answer

Q1. Self introduction
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking personal fitness goals and progress.
• Used React.js for front-end development

• Implemented RESTful APIs for data retrieval and storage

• Utilized MongoDB for database management
Answered by AI
Add your answer

Q1. Questions on project
Add your answer
Q2. Any problems faced
Ans. 
Yes, faced challenges with debugging complex code and integrating third-party APIs.
• Debugging complex code with multiple dependencies

• Integrating third-party APIs with inconsistent documentation

• Resolving compatibility issues between different software components
Answered by AI
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Q1. They asked general questions related to some hectic situation faced in previous company / project..
Add your answer