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

Spectramedix Business Intelligence Interview Guide

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


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

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

Overview

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

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

Spectramedix Business Intelligence Interview Questions

<div>
<div>
<b>About SpectraMedix<br/> </b><br/>
</div>
<div>
  Healthcare is in a state of transition. There’s never been more pressure to improve clinical, operational, and financial performance across the entire healthcare ecosystem. It all begins with data—data that lets you demonstrate improvement, gain actionable insight, and thrive in this new paradigm of care. SpectraMedix mission to assist our clients in their transition to value-based care contracts.<br/> <br/>
</div>
<div>
  We combine cutting edge technology centered advanced data aggregation, contract modeling, quality & financial analytics, integration of social determinants of health and natural language processing with a team comprised of highly experienced clinicians & technologists.<br/> <br/>
</div>
<div>
  We have well positioned our platform to power the journey for health systems, accountable care organizations and health plans moving towards value-based payment initiatives.<br/> <br/>
</div>
<div>
<b>Role: Senior Software Engineer (Java/J2EE)<br/> </b><br/>
</div>
<div>
<b>Location: East Windsor, New Jersey<br/> </b><br/>
</div>
<div>
<b>Experience: 5 - 7 Years<br/> </b><br/>
</div>
<div>
<b>Description:<br/> </b><br/>
</div>
<div>
  Senior Software Engineer will work closely with lead developers, architects and data/business analyst. This person will implement, test and document as needed. Occasionally the developer will be client interacting, they should feel confident publicly speaking and explaining technical configurations. This person will also work with the client relations and project management teams insuring the SpectraMedix product is meeting the highest standards of quality and satisfying its customers.<br/> <br/>
</div>
<div>
<b>Job Description:<br/> </b><br/>
</div>
<ul>
<li>Design cloud-based applications including analyzing, designing, reviewing and building product in Java/J2EE development environment.<br/></li>
<li>Design, develop a software solution to address business requirements using JAVA/J2EE Object Oriented programming (OOPS) concepts, software design patterns and web security standards.<br/></li>
<li>Develop unit test cases, Integration test cases using Junit, Spring.<br/></li>
<li>Load, Analyze and map client data to Spectramedix’s Datawarehouse. Define and Setup Transformation rules.<br/></li>
<li>Implement Production/UAT Jobs and Portal for Client Implementations and complete them as per the Implementation schedule.<br/></li>
<li>Automate, Configure, deploy and test web-based applications. Support Client Implementation activities.<br/></li>
</ul>
<h3><b>Requirements </b></h3>
<ul>
<li>5+ years of hands-on experience in Java Development.<br/></li>
<li>Bachelor / Masters or equivalent degree in any engineering or technical / quantitative field.<br/></li>
</ul>
<div>
<b>Technical Expertise:<br/> </b><br/>
</div>
<ul>
<li>Java, J2EE (OOPS / Collections / multithreading).<br/></li>
<li>Servlets / Spring (MVC/Security) / Hibernate.<br/></li>
<li>Restful Web services (JAX-RS, JAX-WS).<br/></li>
<li>XML, JSON, JSP.<br/></li>
<li>SQL Server.<br/></li>
<li>Tomcat Server.<br/></li>
</ul>
<h3><b>Benefits </b></h3>
<ul>
<li>Competitive Base Salary.<br/></li>
<li>Monthly & Annual Bonuses.<br/></li>
<li>401K.<br/></li>
<li>Health & Dental Insurance.<br/></li>
<li>Paid Time Off.<br/></li>
<li>Free Gym Membership.<br/></li>
<li>Work/Life Balance.<br/></li>
</ul>
<div>
  And More!!!
 </div>
</div>
#J-18808-Ljbffr

Spectramedix Business Intelligence Interview Guide

Overview

Spectramedix Business Intelligence Salary

Spectramedix Business Intelligence Interview Process

Spectramedix Business Intelligence Interview Questions

Spectramedix Business Intelligence Jobs