Shiprocket Private Limited Data Science Intern Interview Questions and Answers

Q1. Tell me about your self
Ans. My name is Kritika, I have 2 siblings, my mom is house wife and and I love dogs, my favourite thing traveling, i was passed m.com in 2019 from awadh university. I have 5 years experience work different different fields, like 1st job in publication and 2nd job in advertising company as a project manager and Last one cars24 Pvt Ltd corporate office as a associate
Answered by Kirtika
Add your answer

Convenience power, Patience

Q1. Projects covered during graduation
Add your answer
Q2. Why should we hire you
Add your answer

Test was based on SQL, coding and MCQ. Coding involved nested query.

There are 2 coding challenges and 7 objective questions

Q1. Technical questions related to role
Add your answer

Q1. Interviewer asked me basic SQL questions
Add your answer
Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Add your answer

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Quant, LR, puzzles, cat based level 2 questions

Q1. Difference between tuple nd list
Ans. 
Tuple is immutable and ordered, while list is mutable and ordered in Python.
• Tuple is created using parentheses () while list is created using square brackets []

• Tuple elements cannot be changed once assigned, while list elements can be modified

• Tuple is faster than list for iteration and accessing elements

• Example: tuple = (1, 2, 3) and list = [1, 2, 3]
Answered by AI
Add your answer
Q2. How will you cut a cake into 8 equal pieces by 3 cuts
Add your answer

Q1. Walk me through ur cv
Ans. 
I have a strong background in data analysis with experience in various industries.
• Bachelor's degree in Statistics with a focus on data analysis

• Proficient in SQL, Python, and data visualization tools like Tableau

• Experience working with large datasets and conducting statistical analysis

• Completed internships at XYZ Company and ABC Organization

• Presented findings at industry conferences
Answered by AI
Add your answer
Q2. What have learnt from this experience?
Ans. 
I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.
• Developed strong analytical skills through hands-on experience with various data analysis tools and techniques

• Improved ability to identify trends, patterns, and outliers in data sets

• Enhanced communication skills by presenting findings and recommendations to stakeholders

• Learned to collaborate with team memb
Answered by AI
Add your answer

Q1. Trapping Rain Water
Add your answer
Q2. Merge Intervals
Add your answer
Q3. Design a Customer Support Chat Application System
Ans. 
A customer support chat application system for efficient communication and problem-solving.
• Implement live chat functionality for real-time communication

• Include automated responses for common queries

• Integrate ticketing system for tracking and resolving issues

• Provide chat history for reference and continuity

• Ensure data security and privacy measures are in place
Answered by AI
Add your answer