The Genuine Parts Company Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Genuine Parts Company Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Genuine Parts Company? The Genuine Parts Company Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Genuine Parts Company Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Genuine Parts Company.</li>
<li>Practice real Genuine Parts Company Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Genuine Parts Company Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Genuine Parts Company? The Genuine Parts Company Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Genuine Parts Company Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Genuine Parts Company.
- Practice real Genuine Parts Company Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Genuine Parts Company Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Genuine Parts Company Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

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

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

<p><code>bank_transactions</code> table</p>

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

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

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

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

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


Rolling Bank Transactions

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

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

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

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

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

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


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Genuine Parts Company Business Intelligence Interview Questions

<b>Company Background:</b><br><br>Established in 1928, Genuine Parts Company is a leading global service organization specializing in the distribution of automotive and industrial replacement parts. Our Automotive Parts Group operates across the U.S., Canada, Mexico, Australasia, France, the U.K., Ireland, Germany, Poland, the Netherlands, Belgium, Spain and Portugal, while our Industrial Parts Group serves customers in the U.S., Canada, Mexico and Australasia. We keep the world moving with a vast network of over 10,700 locations spanning 17 countries supported by more than 60,000 teammates. <br><br><b>Position Purpose</b>:<br><br>Seeking world-class talent to join the world's leading distributor of automotive and industrial replacement parts and value-added services operating 5,500+ locations and servicing more than 20,000 locations in the U.S and Canada. Specifically, this role will function as the Manager, Product Team of the Supply Chain Technology team, building the next generation Supply Chain technology products and services at GPC. Working with an incredibly talented team, you will play a key role in building and running one of the world's largest automotive and industrial replacement parts operations. <br><br>The Product Manager-WMS is a key member of the GPC Supply Chain Product Management team, championing the strategy and roadmap planning for the Supply Chain and Fulfillment capabilities. Product Management is responsible for making sure we build the right products and features for our customers and business. To accomplish that, product managers plan the product roadmap and prioritize the applicable technology backlog, lead product discovery, and measure and communicate results of the feature portfolio in production, all while ensuring stakeholder alignment. The Sr. Product Manager in this role must have a strong background in Warehouse Management (WMS, WES, WCS), Inventory Management, Labor Management and Fulfillment Automation including experience implementing Material Handling Equipment (MHEs) in warehouses.<br><br><b>Responsibilities:</b><br><ul><li>Regularly collaborate with Business to identify and define new capability requirements and sequencing based on business value</li></ul><ul><li>Develops a complete vision for a new or changing feature, including how it will perform, how performance will be measures, and how it will continue to evolve</li></ul><ul><li>Maintain Global Product Roadmaps for Warehouse Management Products, including introduction of new products as proofs of concept, upgrading from old to new product and divesting of products at end of life</li></ul><ul><li>Make proposals that consider exciting tradeoffs - such as, between the needs of different customer types, or critical metrics</li></ul><ul><li>Ability to identify when functionality does not have desired affect and adjust roadmaps, expectations and plans appropriately</li></ul><ul><li>Consistently lead cross-functional, cross-Geography partner communication, including operations and business process impacts/ value adds of features updates</li></ul><ul><li>Mentor and develop junior product management talent</li></ul><ul><li>Work with significant degree of autonomy</li><li>Other duties as assigned</li></ul><br><br><b>Location:</b><br><ul><li>GPC has two work locations to choose from, Duluth or Atlanta office.</li><li>We offer a Flexible Work Policy that permits eligible employees to work a hybrid remote schedule.</li></ul><br><br><b>Desired Qualifications & Experiences: </b><br><ul><li>Bachelor's degree in engineering, related field, or equivalent experience</li><li>8 years (10+ preferred) of professional experience as a Technical Product Manager/ Business Systems Analyst supporting enterprise Supply Chain/ Warehouse Management Systems</li><li>Proficiency in Supply Chain processes and technology, in Fulfillment (ex. Warehouse Management Systems, Labor Management Systems, Yard Management Systems)</li><li>Ability to build and optimize global product roadmaps based on business value</li><li>Demonstrated ability to work in a large, matrixed organization, successfully influencing others and establishing relationships</li><li>Proven record of accomplishment of implementing W*S (WMS/WEC/WCS) solutions at scale, preferably in Retail/e-Commerce space</li><li>Experience with "Source to Target" mapping for integration work between WMS and complex enterprise retail/ supply chain applications</li><li>Good understanding of Retail, Distribution and Transportation domain</li><li>Proficiency in working as part of a collaborative, cross-functional, modern software design, and development team</li><li>Proficiency in creating, prioritizing, and accepting epics and user stories</li><li>Proficiency in conducting user research and testing to understand needs</li><li>Proficiency in identifying goals, metrics, and analytics to measure product value</li><li>Proficiency in active listening and communicating at all levels</li><li>Experience with Jira or Confluence</li></ul><br><br>Not the right fit? Let us know you're interested in a future opportunity by joining our Talent Community on jobs.genpt.com or create an account to set up email alerts as new job postings become available that meet your interest!<br><br>GPC conducts its business without regard to sex, race, creed, color, religion, marital status, national origin, citizenship status, age, pregnancy, sexual orientation, gender identity or expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. GPC's policy is to recruit, hire, train, promote, assign, transfer and terminate employees based on their own ability, achievement, experience and conduct and other legitimate business reasons.

Genuine Parts Company Business Intelligence Interview Guide

Overview

Genuine Parts Company Business Intelligence Interview Process

Genuine Parts Company Business Intelligence Interview Questions

Genuine Parts Company Business Intelligence Jobs