kipi.ai Sdet Lead Interview Questions and Answers for Experienced

Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
Add your answer
Q2. Joining tables with different joins
Ans. 
Joining tables with different joins in SQL
• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer

Test of SQL, Tableau and other skills based on your resume on Skillate

Q1. SQL and other skills technical questions
Add your answer

Q1. Manager round / 2nd technical round
Add your answer

Q1. Basic technical discussion for an hour
Add your answer
Q2. Coding on array asc or desc
Add your answer

Again further basic technical discussion for half time and a coding problem

Again same as round 2 and coding test

Discussion abt tech stack and worked assignments and ending with a coding test .This round happens for more experienced ppl by project lead/learning director level guys.The result wl told in their attitude and words here if salary you are expecting is out of their budget..Total wasted my time

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