Prepare for and practice interview questions from Nagarro.

Nagarro Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Nagarro Interview Guides

<p>Given the two tables, write a SQL query that creates a cumulative distribution of the number of comments per user. Assume bin buckets class intervals of one.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Columns</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>

<tr>
<td><code>neighborhood_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>sex</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><code>comments</code> table</p>

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

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

<tr>
<td><code>body</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

<tr>
<td><code>cum_total</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Cumulative Distribution

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Nagarro Salaries by Position

<p>Employer Industry: Technology Solutions </p><h5>Why Consider this Job Opportunity: </h5><br> <ul><li>Opportunity for career advancement and growth within the organization </li><li>Work remotely with flexibility in your schedule </li><li>Competitive salary based on experience </li><li>Supportive and collaborative work environment </li><li>Chance to lead innovative digital product development </li><br> </ul><h5>What to Expect (Job Responsibilities): </h5><ul><li>Develop product vision, roadmap, and feature prioritization aligned with business goals </li><li>Lead the full product lifecycle from requirements to release, ensuring timely delivery of product increments </li><li>Manage product backlog, sprint planning, and cross-functional coordination with engineering and design teams </li><li>Analyze customer needs and market trends to shape product enhancements </li><li>Collaborate with engineering teams to evaluate solutions and improve system performance </li><br> </ul><h5>What is Required (Qualifications): </h5><ul><li>10+ years of experience in product management, project/delivery management, or related roles </li><li>Strong understanding of software development and modern cloud/application architectures </li><li>Experience working in Agile (Scrum/Kanban) delivery environments </li><li>Proficiency with tools such as JIRA, Confluence, Figma, Power BI, SQL, and Postman </li><li>Excellent communication, problem-solving, and stakeholder management skills </li><br> </ul><h5>How to Stand Out (Preferred Qualifications): </h5><ul><li>Experience managing delivery in an agile environment </li><li>Ability to communicate in English and Mandarin </li><li>Strong technical understanding and hands-on product execution skills </li><br> </ul><p>#TechnologySolutions #ProductManagement #AgileDevelopment #CareerOpportunity #RemoteWork </p><p>We prioritize candidate privacy and champion equal-opportunity employment. Central to our mission is our partnership with companies that share this commitment. We aim to foster a fair, transparent, and secure hiring environment for all. If you encounter any employer not adhering to these principles, please bring it to our attention immediately. We are not the EOR (Employer of Record) for this position. Our role in this specific opportunity is to connect outstanding candidates with a top-tier employer. </p>#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Cumulative Distribution	SQL	Hard	Very High
Boarding Times Bias	Statistics	Medium	High
Hundreds of Hypotheses	Statistics	Medium	High

Nagarro Interview Questions

Nagarro Interview Guides

Nagarro Interview Questions

Nagarro Salaries by Position

Nagarro Opening Jobs