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

Exeter Finance Corp. Business Intelligence Interview Questions

<p>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. Every team member is integral to our success. Whether youre 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. Our vision is to be a premier finance company and lender of choice known for its People, Performance and Service. Job Description Job Summary The Database Developer III reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications, and constructions including stored procedures and SSIS packages. Job Duties Develops, maintains and implements operational and reporting database systems utilizing the latest techniques in data modeling and ETL concepts, from business requirements to technical design to final product. Implements database solutions and ensures quality assurance and timely delivery of data. Investigates, troubleshoots and corrects data and user related system errors, and ensures data integrity. Monitors and contributes to SQL Server in an enterprise environment, including installation, configuration, jobs, backup, recovery, upgrades and schema changes. 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. Promotes a constructive, positive team environment and maintains a spirit of openness, information sharing inquisitiveness, problem-solving and support for common goals. Ensures compliance with Exeters policies & procedures, safety, state and federal laws, regulations and standards. Other duties as assigned. Education and Work Experience Bachelor's Degree or equivalent in Computer Science or a related field of study. 2-4 years of job related experience. 4 years of job related experience preferred. Exeter Finance LLC is an Equal Opportunity Employer. Individual compensation packages are based on various factors unique to each candidate including skill set, experience, qualifications and other job-related reasons. 97,100.00 USD-$133,550.00 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 provide options that make sense, getting customers behind the wheel of their car. Every team member is integral to our success. Whether youre at a servicing center helping customers with their loans, in the field building relationships with auto dealers, or supporting the company from its corporate offices, you will enjoy a nurturing, invigorating and positive work environment. We offer individually tailored compensation packages with competitive salary and benefits, plus training and development opportunities, team member recognition and awards, and so much more. As an equal opportunity employer, were committed to hiring talented people, including veterans and military family members, who share our commitment to deliver outstanding customer service where we value our people, performance and service by exhibiting a Culture of Excellence. If you are a California consumer and would like information about our online and offline privacy practices, please see our California Consumer Privacy Statement available here (https://res.cloudinary.com/govimg/image/upload/v1670513113/5b74966e98f5e27ebbf48fa8/Exeter%20Finance_%20CPRA%20California%20Consumer%20Privacy%20Statement%20Final.pdf) .</p>

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