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

Connectiverx Business Intelligence Interview Guide

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


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

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

Overview

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

Connectiverx 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

Connectiverx Business Intelligence Interview Questions

Overview:<br/><p style="margin: 0px;">The Senior Business Analyst position will be responsible for defining requirements for a business-driven data warehouse supported by policies, principles and guidelines that are aligned with data management and data governance.</p><br/><br/>Responsibilities:<br/><ul><li>Work within the Product Team to help create an industry-leading data warehouse that measures performance of all operational aspects;</li><li>Translate business requirements into usable enterprise information which may include an enterprise data model, common business vocabulary, taxonomies to be used to guide enterprise solution development, and achieve consistency of information assets across the application portfolio;</li><li>Develop and maintain a formal description of data and data structures including data models, data flow diagrams, data dictionaries and technical metadata;</li><li>Create source-to-target mapping documents to capture application data elements for loading into data warehouse using deep knowledge of ConnectiveRx platforms and services;</li><li>Develop and implement strategies in collaboration with development and architecture teams for data acquisitions, archive recovery, and implementation of a database;</li><li>Collaborate with EDW Team on data model, its maintenance and optimization as well as end-to-end data driven integration strategy;</li><li>Monitor and guide design of semantically rich business model of enterprise domain, independent of any technology solution; and</li><li>Work directly with application development teams to ensure that data is aligned between systems.</li><li>Work from home benefit available.</li><li>10% domestic travel required.</li></ul><br/><br/>Qualifications:<br/><ul><li>Requires a Masters degree (or foreign equivalent) in Computer Science, Software Engineering, or a related field;</li><li>2 years of experience as a QA Analyst, Software Engineer, or a related occupation;</li><li>Experience working in data warehouse space (1 yr);</li><li>Experience generating SQL scripts;</li><li>Experience with Agile methodology/scrum;</li><li>Experience testing REST API web services using Postman; and</li><li>Experience using: Dynamo, SQL Server, AWS services (i.e. DynamoDB, CloudWatch, S3 Cloud Storage), and JIRA.</li></ul>

Connectiverx Business Intelligence Interview Guide

Overview

Connectiverx Business Intelligence Salary

Connectiverx Business Intelligence Interview Process

Connectiverx Business Intelligence Interview Questions

Connectiverx Business Intelligence Jobs