Shiprocket Private Limited Data Engineer Interview Questions and Answers

It was demure and well balanced.

Q1. Databases based on resume.
Add your answer
Q2. Sql based questions
Add your answer

Q1. Sql based question
Add your answer
Q2. Resume and intern experiences.
Add your answer

Questions from arrays and strings and some aptitude questions

Q1. How to merge 2 csv files
Ans. 
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
• Open both CSV files in a software like Microsoft Excel.

• Copy the data from one CSV file and paste it into the other CSV file.

• Save the merged CSV file with a new name.

• Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
Answered by AI
Add your answer
Q2. Basic questions on arrays
Add your answer

Q1. 3 reasons why u choose this company
Ans. 
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
• Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.

• Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.

• Company culture - I value a positive work environment and the...read more
Answered by AI
Add your answer

Q1. Questions on python
Add your answer

Questions were crayon box ,the bot and the game and happy neighbourhood for 90 mins

Q1. Array basics was asked
Add your answer
Q2. Segment tree,prefix sum
Add your answer

Q1. Low level design was asked
Add your answer

Q1. Create pagination component using an api show the data for the pages
Ans. 
Create a pagination component using an API to display data for different pages.
• Use API to fetch data for each page

• Implement pagination logic to display data for each page

• Allow users to navigate between pages
Answered by AI
Add your answer

SQL based questions wer asked on joins , rank function,

So after Resume shortlisting you have Round 1 as Programming Test (60%) & Aptitude Test (40%) in which you will be asked 15 aptitude questions and 2 DSA problems. You will get 1 hour to write the test.
DSA problems:
1. Merge 2 sorted arrays
2. find the target sum in given array and return their indexes

Q1. If you clear Round 1 then you will go forward to Round 2 which is one-to-one technical round. In this round you will be asked leetcode problems and some conceptual questions. I was asked to Find the Max su...read more
Add your answer
Q2. Length of Longest Substring with distinct character
Ans. 
Find the length of the longest substring with distinct characters in a given string.
• Use a sliding window approach to keep track of the current substring.

• Maintain a set to store the distinct characters in the current substring.

• Update the maximum length of the substring whenever a longer substring is found.
Answered by AI
Add your answer
Q3. Find Max sum of subarray.
Ans. 
The maximum sum of a subarray is to be found.
• Use Kadane's algorithm to find the maximum sum of a subarray.

• Initialize two variables: maxSum and currentSum.

• Iterate through the array and update currentSum by adding the current element.

• If currentSum becomes negative, reset it to 0.

• If currentSum is greater than maxSum, update maxSum.

• Return maxSum as the maximum sum of a subarray.
Answered by AI
Add your answer

Q1. Last round was Head of engineering round in this you will be asked some technical questions like: Apply Merge sort on a Linked List
Add your answer
Q2. 25 Horses: Google interview problem
Add your answer