The Fleetcor Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Fleetcor Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Fleetcor? The Fleetcor 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 Fleetcor Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Fleetcor.</li>
<li>Practice real Fleetcor 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 Fleetcor Business Intelligence interview.</p>


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

- Know what skills are necessary for Fleetcor Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Fleetcor.
- Practice real Fleetcor 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 Fleetcor Business Intelligence interview.
        

Overview

Fleetcor Business Intelligence Salary

<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.

Fleetcor 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>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

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

<table>
<thead>
<tr>
<th>Column</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>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

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


Manager Team Sizes

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

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

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

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Fleetcor Business Intelligence Interview Questions

<strong>Engineering Manager</strong><br><br><strong>What We Need</strong> <br><br>Corpay is currently looking to hire an Engineering Manager within our Lodging division. The Engineering Manager is a hands-on role responsible for leading a team of software developers and their projects. Candidate must have strong design, development and integration experience. The Engineering manager oversees the implementation of technology solutions aligned with company objectives. This includes leading multiple teams. <br><br>This individual will help manage the delivery of Implementation projects that may require Product customization, integrations, and migration, with a goal to drive the team to develop new system and business processes. This individual could work with the Business Analysts, Development, QA, and Engineering to prioritize projects and facilitate the project lifecycle. This position is based in the Atlanta area. <br><br><strong>How We Work</strong> <br><br>As an Engineering Manager, you will be expected to work in a Hybrid environment. Corpay will set you up for success by providing: <br><ul> <li>Assigned workspace in home office set up </li><li>Company-issued equipment + remote access </li><li>Formal, hands-on training </li><li>Monthly phone stipend </li></ul><strong>Role Responsibilities</strong> <br><br>The responsibilities of the role will include: <ul> <li>Develop an in-depth understanding of existing systems, processes, and future requirements to make recommendations for improvement </li><li>The selected individual must be able to interact with director or higher-level management and stakeholders with the ability to communicate effectively with both oral and written presentations and recommendations. </li><li>May work directly with business units to understand business requirements pertaining to application development and enhancements </li><li>Lead implementation of projects from beginning to completion on time and within budget </li><li>Help to develop metrics to measure efficiencies before and after implementation of new tools or processes </li><li>Could be asked to research software systems to understand existing functionalities and impact of potential changes </li><li>Collaborates with the team and validates all necessary requirements have been fulfilled </li><li>Participate and lead the day-to-day activities of implementation teams, inclusive of staff oversight, agile ceremonies, software design sessions etc. </li><li>Take ownership of projects, work closely with Business stakeholders, understand and fine-tune business requirements </li><li>Lead technical discussions, collaborate with other technologists, architects </li><li>Lead engineering teams from the frontlines, help remove roadblocks, adhere to Agile practices </li><li>Proactively identify system improvement opportunities, embrace innovation and continuous improvement </li></ul><strong>Qualifications & Skills</strong> <ul> <li>Bachelor's degree in Computer Science or related field or equivalent experience </li><li>6+ years of hands-on experience in software engineering, at least 2 years of people & project management experience </li><li>Design & development experience in multi-tiered client-server applications </li><li>Strong technical background, hands-on coding experience. </li><li>Experience preparing and presenting design diagrams. </li><li>Experience with cloud technologies preferred </li><li>Project and team management skills, familiarity with Scrum and Kanban practices. </li><li>Demonstrated ability to communicate and interact with a wide range of users ranging from very technical to non-technical. </li><li>Proven excellence in driving projects to implementation on time and within budget </li><li>Developed skills in examination and analysis </li><li>Proven excellence in communication, presentation, and organizational skills </li><li>Strong critical thinking, problem solving and decision-making skills </li><li>Ability to multi-task, work both independently and collaboratively with high attention to detail, and adapt to changing customer service needs </li><li>Approaches and solves problems with flexible, creative, and versatile thinking </li><li>Ability to take initiative and be self-motivated </li></ul><strong>Benefits & Perks</strong> <ul> <li>Medical, Dental & Vision benefits available the 1st month after hire </li></ul> <ul><li>Automatic enrollment into our 401k plan (subject to eligibility requirements) </li><li>Virtual fitness classes offered company-wide </li><li>Robust PTO offerings including: major holidays, vacation, sick, personal, & volunteer time </li><li>Employee discounts with major providers (i.e. wireless, gym, car rental, etc.) </li><li>Philanthropic support with both local and national organizations </li><li>Fun culture with company-wide contests and prizes </li></ul><strong>Equal Opportunity/Affirmative Action Employer</strong> <br><br>Corpay is an Equal Opportunity Employer. Corpay provides equal employment opportunities to all employees and applicants without regard to race, color, gender (including pregnancy), religion, national origin, ancestry, disability, age, sexual orientation, gender identity or expression, marital status, language, ancestry, genetic information, veteran and/or military status or any other group status protected by federal or local law. If you require reasonable accommodation for the application and/or interview process, please notify a representative of the Human Resources Department. <br><br>For more information about our commitment to equal employment opportunity and pay transparency, please click the following links: EEO and Pay Transparency <br><br>#LI-RG1 <br><br><strong>#LI-Hybrid</strong> <br><br>#LI- Corpay <br><br><strong>Other details</strong><ul><li> Job Family Managers</li> <li> Pay Type Salary</li> <li> Employment Indicator Employee</li> </ul> <br> <br>Apply Now

Fleetcor Business Intelligence Interview Guide

Overview

Fleetcor Business Intelligence Salary

Fleetcor Business Intelligence Interview Process

Fleetcor Business Intelligence Interview Questions

Fleetcor Business Intelligence Jobs