Prepare for and practice interview questions from Basf.

Basf Interview Questions

Basf 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

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

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

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?

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?

Basf Salaries by Position

**Now hiring! Product Manager-Basecoat & Primer** **Southfield, MI** As Product Manager for Basecoat and Primer you will set strategic directions for your portfolio in the NA region to enable growth and to improve our profitability. In close collaboration with Technology and Account you will manage product development activities and be responsible for the commercialization of our product solutions. This role sits in our Coating headquarters in Southfield, MI where we are in the office at least 3 days per week. **Come create chemistry with us!** BASFs Coatings division is a global expert in the development, production and marketing of innovative and sustainable automotive OEM and refinish coatings, decorative paints as well as applied surface treatments for metal, plastic and glass substrates in a wide range of industries. This portfolio is supplemented by "Beyond Paint Solutions", which enable new applications with innovative surfaces. **As a Product Manager for Basecoat and Primer, you create chemistry by...** + Developing and executing the layer strategy for basecoat and primer in the NA region + Managing prices and margins following our global pricing strategy + Collecting & analyzing product related market, customer and competitor intelligence + Collaborating with Technology and Account teams to analyze market demands and to initiate & manage development topics for your portfolio including the launch of new products + Continuously analyzing the portfolio to initiate and mange measures to optimize product costs + Reducing complexity via technological synergies between customers, business rules, raw material consolidation, and active product & portfolio pruning. **If you...** + Masters degree with several years of professional experience, ideally in the field of marketing, sales or technology within the Coatings industry + Strong project management skills with proven experience in strategy and pricing + High experience in commercial and P&L analysis + Experienced in handling of MS Office, affinity for data analysis + Teamplayer with excellent communicative abilities in English and an entrepreneurial mindset **Create your own chemistry with you@BASF** At BASF, you will have the chance to do meaningful work towards building a more sustainable future. In addition to competitive compensation and benefits, BASF provides you with access to a wide range of elements to help you be your best. Its what we call **you@BASF** . We are committed to providing benefits, programs, and opportunities that support our employees overall well-being, personal growth, and a safe, collaborative, and inclusive work environment. Just some of the many benefits we offer include: + Flexible work arrangements whenever possible + Highly competitive retirement savings plan with company match and investment options + Well-being programs that include comprehensive mental health support for you and your household family members + Family forming benefits (fertility, adoption and surrogacy reimbursement, maternity/parental leave, and more) + Back-up child and elder care with discount programs for families of all ages and stages + Mentoring and career development opportunities that allow you to share, learn, and thrive + Matching gifts program that allows you to deepen the impact of your contributions to qualified charities. + Employee crisis support for when the unexpected happens + Access to our BASF wine cellar, employee discounts, and much more! **About us** As one of the largest chemical companies in North America we have been finding solutions for your everyday needs and addressing the most complex economic, environmental, and sustainability challenges for more than 150 years! At BASF we empower our employees with the tools, guidance and opportunities they need to advance and succeed in work and life. Giving you the support you need to be your best and fulfill your personal ambitions is what helps us create chemistry. After all, our success is linked to yours. Whatever path you envision, BASF is a great place to build a rewarding, successful career. Belong to Something Bigger. #belongatBASF **Privacy statement** BASF takes security & data privacy very seriously. We will never request financial information of any kind via email, private text message or direct message on any social medial platform or job board. Furthermore, we will never send a candidate a check for equipment or request any type of payment during the job application process. If you have experienced any of the above, please contact myhr@basf.com to report fraud. **Equal employment opportunities** We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, age, citizenship, color, religion, sex, marital status, national origin, disability status, gender identity or expression, protected veteran status, or any other characteristic protected by law. Applicants must be currently authorized to work in the United States on a full-time basis.

Basf Interview Questions

Basf Interview Guides

Basf Interview Questions

Basf Salaries by Position

Basf Opening Jobs