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

Factset Business Intelligence Interview Guide

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


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

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

Overview

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

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

Factset Business Intelligence Interview Questions

<p>The Trading Solutions - Engineering team is modernizing the front end and back end infrastructure of our Portware Enterprise trading platform while simultaneously integrating FactSet’s best of breed product suites to empower client workflows.</p><p><br></p><p><br></p><p><strong>SUB-PROCESS BRIEF</strong> :-</p><p><br></p><p>The Front Office Solutions team provides market-leading solutions for Portfolio Managers and Traders that span the Portfolio Lifecycle. Our products, Portfolio Management Platform (PMP), FactSet OMS, Portware/FactSet EMS, and Analytics APIs, can be integrated or used individually with other products that clients are using. From analysis through execution, we build solutions that power the front-office.</p><p><br></p><p>We are currently seeking a ‘<strong>Software Engineer</strong>’ to be part of our team responsible for this major rewrite effort to migrate from the current monolithic server infrastructure to modern cloud native micro services that are multi tenant, auto scalable and distributed.</p><p><br></p><p><br></p><p><strong>RESPONSIBILITIES:-</strong></p><p><br></p><ul><li>Design and develop software programs to meet business requirements</li><li>Work closely with product team to understand the requirements and come up with technical solutions</li><li>Adopt test driven development methodologies and write automated unit and integration tests</li><li>Work in agile team environment and coordinate with architects, engineering leads, managers, and product managers</li><li>Mentor and assist other junior engineers in design, implementation, and code reviews</li></ul><p><br></p><p><br></p><p><strong>REQUIREMENTS:-</strong></p><ul><li>Bachelor’s degree or higher in Computer Science or related technical field</li><li><strong>5 - 8 years of Core Java programming experience</strong> in building server-side platform for real time enterprise-wide applications</li><li><strong>Firm understanding of Java core APIs, including collections, multi-threading, and real time messaging technologies</strong></li><li>Familiarity with Google Protobuf, Microservices is desirable.</li><li>Experience in using AWS cloud tech stack is a plus.</li><li>Knowledge of financial equity or derivatives products, market data feeds, trade lifecycle and post trade processing, portfolio management, order and execution management systems.</li><li>Excellent written and verbal communication skills are a must.</li></ul><p></p>

Factset Business Intelligence Interview Guide

Overview

Factset Business Intelligence Salary

Factset Business Intelligence Interview Process

Factset Business Intelligence Interview Questions

Factset Business Intelligence Jobs