Prepare for and practice interview questions from Republic National Distributing Company.

Republic National Distributing Company Interview Questions

Republic National Distributing Company 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

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?

Republic National Distributing Company Salaries by Position

Republic National Distributing Company (RNDC) is a family-owned business with roots extending before Prohibition that has evolved into one of the nation's largest wine and spirits wholesalers. Our success is grounded in our core values of Family, Service, Accountability, Honesty, and Professionalism. We offer a vibrant, inclusive culture and workplace experience for individuals who want a career that makes them feel accomplished and engaged. RNDC values the health and well-being of our associates, inside and outside the office, offering dynamic health and wellness benefits that supply exceptional care and value. RNDC is geared toward growing our footprint and our people. Join our team of energetic professionals who believe in many happy hours and are experts in our craft. Summary The Pricing Analyst plays a vital role in executing pricing procedures tailored to unique systems or state regulations, crucially supporting business operations between Pricing and Sales Execution. This position collaborates closely with the Pricing Execution Team and sales to ensure accurate pricing, credits, and rebates for customers in states with distinct systems. Through meticulous execution of duties, the Pricing Analyst contributes to surpassing objectives and enhancing customer satisfaction. In this role, you will <ul> <li>Manage State Dedicated Systems: Oversee technical processes associated with state dedicated systems concerning credits, rebates, and allowances.</li> <li>Ensure Accuracy in Pricing Procedures: Execute credits, rebates, and allowances in a consistent and accurate manner, minimizing errors and enhancing customer satisfaction.</li> <li>Utilize Technology Effectively: Demonstrate strong technological capabilities to learn and troubleshoot within unique processing systems, ensuring accurate billing execution.</li> <li>Support Supplier Programs: Assist with other supplier-related Vistaar reimbursement programs, particularly regarding depletion allowances.</li> <li>Continuous Improvement: Conduct periodic evaluations to troubleshoot and identify more efficient methods, minimizing pricing and billing issues.</li> <li>Provide Analytical Support: Offer analytics support on a monthly basis for the pricing execution team as needed.</li> <li>Cross-Training and Backup: Cross-train and serve as a backup for other pricing-related positions as necessary.</li></ul> What you bring to RNDC <ul> <li>Bachelor's degree from a four-year college preferred.</li> <li>5 or more years of related experience in the industry with 2 years of experience within the pricing department.</li> <li>Equivalent combination of education and experience considered.</li></ul> What's in it for you <ul> <li>401(k) with company matching </li> <li>Medical, dental and vision benefits* </li> <li>Generous paid time off program - work your way up to 5 weeks of PTO a year with the ability to carryover unused PTO </li> <li>Paid volunteer time </li> <li>Paid parental leave </li> <li>Paid caregiver leave </li> <li>Fertility benefits </li> <li>Paid training </li> <li>Company paid life insurance, short-term disability, and company-paid holidays </li> <li>Associate resource groups, and diversity, equity, and inclusion programs available for all associates</li></ul> *Participation in these programs are subject to applicable wait periods and all plan and program terms and eligibility COVID-19 considerations: We follow CDC Guidelines and have a fun and safe environment for our teams. Bonus if you bring <ul> <li>Previous experience in the Wine and Spirits industry </li></ul> Compensation This compensation information is a good faith estimate and provided in accordance with California's state law. Similar positions located outside of this jurisdiction may not necessarily receive the same compensation. The salary generally starts at 52,000.00 up to 74,300.00, and is a combination of base salary plus monthly earned commissions if applicable. The salary is an estimate based on an applicant's skills and experience. Salary/Hourly: Salaried Republic National Distributing Company and National Distributing Company are Equal Opportunity/Affirmative Action employers. It is our policy not to discriminate against any Employee or Applicant. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, age, status as a protected veteran, among other things, or status as a qualified individual with disability. This policy of nondiscrimination in employment includes but is not limited to: recruitment, hiring, placement, promotion, transfer, employment advertising or solicitations, compensation, layoff or termination of employment. For candidates applying to a job in California, please refer to the California Consumer Privacy Act (CCPA). To learn about the CCPA click here. RNDC is committed to providing reasonable accommodation to people with disabilities throughout the job application and interview process, to the point of undue hardship. If you require an accommodation during the application or interview process, please email applicantaccommodation@rndc-usa.com.

Republic National Distributing Company Interview Questions

Republic National Distributing Company Interview Guides

Republic National Distributing Company Interview Questions

Republic National Distributing Company Salaries by Position

Republic National Distributing Company Opening Jobs