The Exeter Finance Corp. Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Exeter Finance Corp. Business Intelligence Interview Guide

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


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

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

Overview

Exeter Finance Corp. 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.

Exeter Finance Corp. 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 customers who placed more than three transactions each in both 2019 and 2020.</p>

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

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

<p><code>transactions</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>user_id</code></td>
<td>INTEGER</td>
</tr>

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

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</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>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

<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

Exeter Finance Corp. Business Intelligence Interview Questions

At Exeter Finance, we are committed to helping customers find the right financing for their next vehicle purchase. By building strong relationships with our customers and network of dealer partners we are able to give options that make sense, getting customers behind the wheel of their car. <br><br>Every team member is integral to our success. Whether you're at a servicing center helping customers with their loans, in the field building relationships with dealers, or supporting the company from its corporate offices, you'll enjoy a nurturing, invigorating and positive work environment.<br><br>Our vision is to be a premier finance company and lender of choice known for its People, Performance and Service.<br><br><b>Job Description</b><br><br>This position is hybrid and will be required to be in office two times per month for collaboration working sessions.<br><br><strong>Job Summary</strong><br><br>The Senior Data Engineer is responsible for the design, implementation and maintenance of all operational and reporting database systems. The Senior Data Engineer constructs conceptual, logical, and physical data models and develops and maintains business logic within stored procedures and ETL transformations.<br><br><strong>Job Duties</strong><br><ul><li>Designs and develops operational and reporting database systems utilizing the latest techniques in data modeling and ETL concepts.</li><li>Models database solutions and ensure quality assurance and timely delivery of data.</li><li>Investigates, troubleshoots and corrects data and user related system errors, and ensures data integrity.</li><li>Manages SQL Server in enterprise environment, including installation, configuration, backup, recovery, upgrades and schema changes.</li><li>Translates stakeholder requirements from formal requirements document into database design.</li><li>Contributes to support an IT roadmap that is forward thinking and sets the ground work for reducing maintenance cost while meeting or exceeding business objectives.</li><li>Promotes a constructive, positive team environment and maintains a spirit of openness, information sharing inquisitiveness, problem-solving and support for common goals.</li><li>Ensures compliance with Exeter's policies & procedures, safety, state and federal laws, regulations and standards.</li><li>Other duties as assigned.</li></ul><br><br><strong>Education and Work Experience</strong><br><ul><li>Bachelor's Degree or equivalent in Computer Science or a related field of study.</li><li>Six (6) or more years of job related experience. </li></ul><br>#LI-Hybrid<br><br>Exeter Finance LLC is an Equal Opportunity Employer.<br><br>Individual compensation packages are based on various factors unique to each candidate including<br><br>skill set, experience, qualifications and other job-related reasons.<br>109,400.00 USD-$150,350.00

Exeter Finance Corp. Business Intelligence Interview Guide

Overview

Exeter Finance Corp. Business Intelligence Salary

Exeter Finance Corp. Business Intelligence Interview Process

Exeter Finance Corp. Business Intelligence Interview Questions

Exeter Finance Corp. Business Intelligence Jobs