Prepare for and practice interview questions from Novo Nordisk.

Novo Nordisk Interview Questions

Novo Nordisk Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<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>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Novo Nordisk Salaries by Position

The PositionAs an Advanced Business Analyst I for SAP FI Solutions at Novo Nordisk, you will be anchoring below responsibilities:<ul><li>Manage global application expectations, support system manager along with oversee daily operation and maintenance in SAP BTP platform.</li><li>Handle incident, problem and change management using ServiceNow, monitor process effectiveness, and maintain CI-CD pipeline in Azure DevOps.</li><li>Assist in budget\SLA management, ensure compliance with internal and external requirements, and GDPR regulations.</li><li>Represent the system in audits, update project documentation, and develop test cases and reports.</li><li>Support in managing application security, vulnerability, testing IT recovery procedure for Applications.</li></ul> Qualifications <ul><li>MSC, MBA, BA, or similar graduate degree in relevant field (Software Engineering, Economics, Computer Science, Business Administration.</li><li>Should have overall 10+ year of industry experience with relevant 8+years’ experience of financial services industry.</li><li>Experience with SAP BTP in finance domain.</li><li>Ability to collaborate and communicate with external parties and end- users.</li><li>Large degree of flexibility and ability to work under strong time pressure.</li><li>Capability to understand business needs quickly.</li><li>Excellent communication skills in written and verbal English.</li></ul>

Department: You will be organizationally placed in HR DD&IT in GBS, and you will report to the local Head of HR IT Business Solutions. The internal IT systems in Novo Nordisk support our 55,000 colleagues globally and our 5,000 managers. Our goal is to create intuitive user experience and business value for our colleagues using these systems. We are anchored in DD&IT Staffs in the global Digital, Data & IT organization. The Position<ul><li>Responsible for the operation & maintenance support that includes roll-over cycles, new compensation projects, change management and compliance of SuccessFactors Compensation system while adapting the feasible changes requested by stakeholders in the system.</li><li>Performing configuration and testing tasks to deliver fixes, changes, improvements, and compliance.</li><li>Provide solutions and suggestions to cater the need of the business without compromising system functionalities or performance.</li><li>Responsible for configuration management and testing the system and updating the change requests on a regular basis.</li><li>Be in touch with SAP to understand the changes in the system and act as a bridge between business and the implementation vendor to ensure the processes are in place for any new implementation and align with other module team members to understand the implications that can occur from other module implementations.</li></ul> Qualifications<ul><li>MSC, MBA, bachelor’s or similar graduate degree in relevant field (Software Engineering, Economics, Computer Science, Business Administration).</li><li>6+ years of experience with IT with relevant 4+ years of experience in SuccessFactors Compensation.</li><li>Should have 2+ years of experience configuring/implementing SAP.</li><li>Experience in vendors management with strong stakeholder management.</li><li>Experience of Pharmaceutical industry experience (working with GxP system) is a value add. Knowledge on Agile, Scrum, Safe would be an add-on. Knowledge on ServiceNow would be a value add.</li></ul> Working at Novo NordiskNovo Nordisk is a leading global healthcare company with a 100-year legacy of driving change to defeat serious chronic diseases. Building on our strong legacy within diabetes, we are growing massively and expanding our commitment, reaching millions around the world and impacting more than 40 million patient lives daily. All of this has made us one of the 20 most valuable companies in the world by market cap. Our success relies on the joint potential and collaboration of our more than 63,000 employees around the world. We recognize the importance of the unique skills and perspectives our people bring to the table, and we work continuously to bring out the best in them. Working at Novo Nordisk, we’re working toward something bigger than ourselves, and it’s a collective effort. Join us! Together, we go further. Together, we’re life changing.

Novo Nordisk Interview Questions

Novo Nordisk Interview Guides

Novo Nordisk Interview Questions

Novo Nordisk Salaries by Position

Novo Nordisk Opening Jobs