Prepare for and practice interview questions from Insud pharma.

Insud pharma Interview Questions

Insud pharma Interview Guides

Behavioral

Describing a data project and its challenges

Hurdles In Data Projects

Strategically resolving misaligned expectations with stakeholders for a successful project outcome

Stakeholder Communication

How to present complex data insights with clarity and adaptability tailored to a specific audience

Presentations and Insights

How would you answer when an Interviewer asks why you applied to their company?

Why Do You Want to Work With Us

How would you analyze and optimize a low-performing marketing automation workflow?

Marketing Workflow Optimization

Machine Learning

Which model do you pick given 85% and 82% accuracy

85% vs 82%

How would you evaluate whether a decision tree is the right model and assess its performance before and after deployment

Decision Tree Evaluation

Explain the key differences between classification models and regression models

Classification and Regression

Credit Card Fraud Model

Minimize Wrong Orders

Data Structures & Algorithms

Given two sorted lists, write a function to merge them into one sorted list.

Merge Sorted Lists

Given an array and a target integer, write a function that returns the indices of two integers in the array that add up to the target integer.

Target Indices

Given a string, write a function to determine if it is palindrome or not.

String Palindromes

Business Case

How would you think about pricing delivery fees when launching a new market

Delivery Fees

How would you approach promoting Meta's products in an emerging market

Meta in an Emerging Market

Select the 2nd highest salary in the engineering department

2nd Highest Salary

Duplicate Rows

What are the key differences between classification models and regression models?

What is the MOST important difference between regression and classification models?

What is the MOST important difference between regression and classification models?

Classification vs Regression

Imagine you work at a major credit card company and are given a dataset of 600,000 credit card transactions to build a fraud detection model.

How would you approach this task? Write your answer in the comments.

Let’s say you work as a data scientist at a bank.

You are tasked with building a decision tree model to predict if a borrower will pay back a personal loan they are taking out.

<ol>
<li>How would you evaluate whether using a decision tree algorithm is the correct model for the problem?</li>

<li>Let’s say you move forward with the decision tree model. How would you evaluate the performance of the model before deployment and after?</li>
</ol>

When an interviewer asks a question along the lines of:

<ul>
<li>What would your current manager say about you? What constructive criticisms might he give?</li>
<li>What are your three biggest strengths and weaknesses you have identified in yourself?</li>
</ul>

How would you respond?

When asked about your strengths in an interview, what is an effective way to respond?

When asked about your strengths in an interview, what is an effective way to respond?

Your Strengths and Weaknesses I

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Your Strengths and Weaknesses II

What do you tell an interviewer when they ask you what your strengths and weaknesses are?

Your Strengths and Weaknesses

What is the difference between Logistic and Linear Regression?

When would use one instead of the other in practice?

What is the difference between Logistic and Linear Regression?

Linear vs Logistic Regression

Write a SQL query to select the 2nd highest salary in the engineering department.

Note: If more than one person shares the highest salary, the query should select the next highest salary.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Given two sorted lists, write a function to merge them into one sorted list.

Bonus: What’s the time complexity?

Example:

Input:

<pre tabindex="0" class="chroma"><code>list1 = [1,2,5]
list2 = [2,4,6]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def merge_list(list1,list2) -&gt; [1,2,2,4,5,6]
</code></pre>

You have two sorted lists, one with m elements and one with n elements. What would be the time complexity of merging the two lists via merge sort?

You have two sorted lists, one with m elements and one with n elements. What would be the time complexity of merging the two lists via merge sort? 

Merging Lists Complexity

Tell me about a data project that didn’t go the way you expected. What did you set out to do, what surprised you, and how did you handle it?

How would you explain what a p-value is to someone who is not technical?

What does a p-value in a statistical test represent?

What does a p-value in a statistical test represent?

P-value to a Layman I

In a statistical test, how does a low p-value (less than 0.05) influence our decision about the null hypothesis?

In a statistical test, how does a low p-value (less than 0.05) influence our decision about the null hypothesis?

P-value to a Layman II

Explain what a p-value is to someone who is not technical

P-value to a Layman

Statistics

Let’s say that you work for an E-commerce store. A new marketing manager joins the company and redesigns the existing new-user email journey to try and boost customer conversion rates. A few weeks after launching the new email journey, the new-user to customer conversion rate goes up from 40% to 43%.

Before you can celebrate, the company’s CMO points out a troubling fact. Just a few months prior to the new manager starting the conversion rate already stood at 45%, before slowly dropping down to the “starting” 40%.

How would you investigate if the redesigned email campaign actually led to the increase in the conversion rate, and that the increase wasn’t instead the result of other factors?

What would be an appropriate method to investigate whether the redesigned email campaign led to an increase in the conversion rate of an E-commerce store, in the absence of infrastructure for an AB test?

What would be an appropriate method to investigate whether the redesigned email campaign led to an increase in the conversion rate of an E-commerce store, in the absence of infrastructure for an AB test?

Causal Email Journey

How would you find out if an increase in user conversion rates after a new email journey is casual or just part of a wider trend?

Causal Email Journey 

Analytics

Given an array and a target integer, write a function <code>sum_pair_indices</code> that returns the indices of two integers in the array that add up to the target integer. If not found, just return an empty list.

Note: Can you do it on $O(n)$ time?

Note: Even though there could be many solutions, only one needs to be returned.

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>array = [1 2 3 4] 
target = 5 
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def sum_pair_indices(array, target) -&gt; [0 3] or [1 2]
</code></pre>

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>array = [3]
target = 6 
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>Do NOT return [0 0] as you can&#39;t use an index twice.
</code></pre>

Given a <code>users</code> table, write a query to return only its duplicate rows.

Example:

Input:

<code>users</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>

We have two models: one with 85% accuracy, one 82%. Which one do you pick?

Let’s say you’re a software engineer on the Amazon retail website team, and over the past hour, the site has experienced a surge in traffic from thousands of suspicious IP addresses, leading to frequent outages and slow page loads for normal shoppers.

How would you analyze and respond to this potential DDoS attack, and what steps would you take to prevent similar incidents in the future?

How would you investigate and mitigate a DDoS attack impacting Amazon's website?

DDoS Attack Response

Responsible AI & Security

When an interviewer asks you a question along the lines of:

<ul>
<li>Why did you apply to our company?</li>
<li>What are you looking for in your next job?</li>
<li>What makes you a good fit for our company?</li>
</ul>

How should you respond?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

Why Do You Want to Work With Us I

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

Why Do You Want to Work With Us II

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

Why Do You Want to Work With Us III

Let’s say you’re leading the analytics for a $100,000 digital marketing campaign to drive new signups for a subscription app. The campaign runs across both paid social and search channels over 30 days.

What metrics would you focus on to evaluate its effectiveness, and how would you use data to optimize performance during the campaign?

How would you use metrics and data to evaluate and improve a digital marketing campaign?

Digital Marketing Metrics

Marketing

Given a string, write a function to determine if it is palindrome or not.

Note: A palindrome is a word/string that is read the same way forward as it is backward, e.g. <code>&#39;reviver&#39;</code>, <code>&#39;madam&#39;</code>, <code>&#39;deified&#39;</code> and <code>&#39;civic&#39;</code> are all palindromes, while <code>&#39;tree&#39;</code>, <code>&#39;music&#39;</code> and <code>&#39;person&#39;</code> are not palindromes.

Example:

Input:

<pre tabindex="0" class="chroma"><code>word1 = &#34;tree&#34;
word2 = &#34;radar&#34;
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def is_palindrome(word1) -&gt; False
def is_palindrome(word2) -&gt; True
</code></pre>

Let’s say Accenture has a data pipeline that ingests raw sales data from multiple retail clients, processing 10 million records each night to generate daily sales dashboards for client teams. For the past week, the pipeline has been consistently failing at the data transformation stage.

How would you go about systematically diagnosing and resolving the root cause of these failures?

How would you systematically diagnose and resolve repeated failures in a nightly data transformation pipeline?

Pipeline Transformation Failures

Data Pipelines

Describe a time when you had to define a long-term vision for a project or team and move it from concept to reality.

Interviews for leadership or senior technical roles look for more than just “finishing a project.” Your answer should specifically address:

<ol>
<li>The “Why”: What data or organizational gap necessitated this vision?</li>
<li>The Framework: How did you translate a high-level goal into a roadmap?</li>
<li>The Friction: How did you handle stakeholders or team members who were skeptical of the new direction?</li>
</ol>

Vision Setting and Execution Strategy

Product Sense & Metrics

Let’s say we’re launching a new version of the PayPal app, but due to a tight deadline, we don’t have time to run the entire suite of 300 automated test cases before release.

How would you handle this situation?

How would you approach limited testing time before a major app release?

Testing Constraints

A/B Testing

Let’s say we’re working with an email marketing automation platform, and we notice that our current workflow sends out 10,000 emails per week but only achieves a 2% click-through rate, which is below industry benchmarks.

How would you analyze and optimize this workflow to improve either engagement rates or operational efficiency, and how would you measure the impact of your changes?

Say you’re running an e-commerce website. You want to get rid of duplicate products that may be listed under different sellers, names, etc… in a very large database.

For example, “iPhone X” and “Apple iPhone 10” are two names that mean the same iPhone.

How do you go about doing this?

Say you’re running an e-commerce website. You want to get rid of duplicate products that may be listed under different sellers, names, etc... in a very large database.

Duplicate Product Names

Data Modeling

Let’s say you work as a data scientist at DoorDash. 

You are tasked to build a machine learning system that minimizes missing or wrong orders placed on the app.

How would you go about designing this system?

Talk about a time when you had trouble communicating with stakeholders. How were you able to overcome it?

Let’s say we’ve proposed a new analytics dashboard to a client, but after reviewing our design and data sources, the client says the solution doesn’t meet their needs and pushes back on several key features.

How would you approach the conversation to negotiate alternative solutions, and what steps would you take to ensure disagreements are handled constructively so we can still reach a successful outcome?

How would you negotiate and resolve disagreements when a client rejects your proposed solution?

Client Solution Pushback

How comfortable are you presenting your insights?

Tell me about a project in which you had to clean and organize a large dataset.

Describing a real-world data cleaning and organization project

Data Cleaning Experiences

Let’s say Doordash is trying to launch their service in a new city.

How would you think about pricing delivery fees when launching a new market?

Let’s say you work at Meta (Facebook).

The company is looking to grow its userbase in an emerging market.

How would you approach promoting Meta’s products?

Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard

Insud pharma Interview Questions

Insud pharma Interview Guides

Insud pharma Interview Questions

Challenge

Discussion & Interview Experiences

Discussion & Interview Experiences