Vistaprint Senior Data Scientist Interview Questions and Answers for Experienced

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.

Q1. Analytical question asked.
Add your answer

Q1. Case study question asked.
Add your answer

Q1. What’s your previous experience
Ans. 
I have 3 years of experience as a data analyst in the finance industry.
• Worked with large datasets to extract meaningful insights

• Performed data cleaning, transformation, and visualization

• Created and maintained dashboards and reports for stakeholders

• Conducted statistical analysis and built predictive models

• Collaborated with cross-functional teams to identify business opportunities
Answered by AI
Add your answer
Q2. What’s your skills for the current role
Ans. 
I have strong skills in data analysis, including proficiency in statistical analysis, data visualization, and programming languages such as Python and SQL.
• Proficient in statistical analysis techniques

• Skilled in data visualization using tools like Tableau

• Strong programming skills in Python and SQL

• Experience with data cleaning and preprocessing

• Ability to interpret and communicate insights from data

• Familiarity with machin...read more
Answered by AI
Add your answer

Q1. Insert node in BST
Ans. 
Insert a node in a Binary Search Tree (BST)
• Start at the root node and compare the value of the node to be inserted with the current node

• If the value is less than the current node, move to the left child. If greater, move to the right child

• Repeat the process until reaching a leaf node, then insert the new node as a left or right child
Answered by AI
Add your answer
Q2. Design Lift system
Ans. 
Design a lift system for efficient vertical transportation
• Consider the number of floors in the building

• Include safety features like emergency stop button

• Optimize for speed and energy efficiency

• Implement a user-friendly interface for passengers
Answered by AI
Add your answer

Preparing media plan for app campaign at a certain budget and expected installs first orders etc

Q1. Guessestimate and general mathematical aptitude
Add your answer
Q2. No of petrol pumps in city
Ans. 
The number of petrol pumps in the city is not available.
• I do not have access to the data on the number of petrol pumps in the city.

• It would be best to consult the city's government or relevant authorities for this information.

• Alternatively, one could conduct a survey or research to estimate the number of petrol pumps in the city.
Answered by AI
Add your answer
Q3. How would you optimize the campaigns in terms of bids budgets
Ans. 
Optimizing bids and budgets involves analyzing data, setting goals, and adjusting strategies accordingly.
• Analyze campaign data to identify top-performing keywords and adjust bids accordingly

• Set clear goals for each campaign and allocate budgets accordingly

• Regularly monitor and adjust bids and budgets based on performance data

• Consider using automated bidding strategies to save time and improve efficiency

• Use A/B testing ...read more
Answered by AI
Add your answer

Q1. Why do you want to join meesho
Add your answer
Q2. Basics of Digital marketing CPM CTR CPC difference
Add your answer

SQL query optimisation

Q1. Regular discussion, about job role, why swiggy
Add your answer

Q1. Fundamentals and Basics of android, projects you are worked on.
Add your answer

It was sort of pair programming where you will be told to implement some feature. Here they check your coding style, your approach and the architecture you follow.

Q1. Advanced android questions were asked and some scenario based questions.
Add your answer

Q1. It was managerial round, most discussion were on my projects and past experience.
Add your answer

Q1. Asking my past experience and work environment
Add your answer
Q2. About yourself and work experience
Add your answer

Q1. Asking how to sell a product, disscus my last job
Add your answer
Q2. My family and education background
Add your answer