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

Modis Business Intelligence Interview Guide

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


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

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

Overview

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

Modis 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

Modis Business Intelligence Interview Questions

<p><em>Akkodis is seeking a Big Data Engineer for a contract position with our Fortune 500 banking client.</em></p><p><br></p><p><strong>Rate Up To: </strong>$65.46/hr W2</p><p><br></p><p><strong>Location:</strong> Hopkins, MN</p><p><br></p><p><strong>Can you please provide a summary of the project/initiatives which describes what’s being done?</strong></p><p>The Customer Profile Product team will build and centralize customer profile and preference data in a unified data platform where information is synchronized for the purpose of operational and analytics use across the bank’s application systems and channels.</p><p> </p><p><strong>What are the top 5-10 responsibilities for this position?</strong></p><p>• Experience in batch & real time data processing using Scala, Spark , Kafka & Cassandra.</p><p>• Exposure to Hadoop, Hive DB, Unix Shell scripting, Relational Database & using the DevOps tools.</p><p>• Experience in using the IDEs to build the applications with Java or Scala or Python.</p><p>• Should have good communication skills to co-ordinate with different teams and update the stake holders with any blockers.</p><p>• Proactively identify and resolve any issues or roadblocks that may hinder the success of projects.</p><p>• Experience in Cloud native development in Azure is preferred (or AWS or GCP).</p><p> </p><p><strong>What skills/technologies are required?</strong></p><p>5 to 8 years hands on experience in things like: </p><p><br></p><p>o Spark /PySpark</p><p>o Kafka</p><p>o NoSQL databased (Casandra / Mongo DB etc)</p><p>o Azure cloud CI/CD and Azure Synapse.</p><p> </p><p><strong>What skills/attributes are preferred?</strong></p><p>o Primary Skill Set: Spark, Scala, Python, Cassandra, Kafka, Hive DB & Airflow</p><p>o Secondary Skill Set: DevOps (Jenkins, Rancher, Schedule Jobs), Azure</p><p> </p><p><em>***Equal Opportunity Employer/Veterans/Disabled</em></p><p><br></p><p><strong>Benefit offerings include medical, dental, vision, term life insurance, short-term disability insurance, additional voluntary benefits, commuter benefits and 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State or local law; and Holiday pay upon meeting eligibility criteria. </strong><em>Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs which are direct hire to a client</em></p><p><br></p><p><strong>To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.modis.com/en-us/candidate-privacy/</strong></p><p><br></p><p><strong>The Company will consider qualified applicants with arrest and conviction records.</strong></p>

<p>Akkodis is seeking a Big Data Engineer for a Contract job with a client in Charlotte NC (Hybrid) . You will translate technical and functional requirements into detailed designs and mentor junior staff through technical training sessions. Rate Range: $54/hour to $64/hour; The rate may be negotiable based on experience, education, geographic location, and other factors. Big Data Engineer job responsibilities include: Design, implement, and manage ETL processes to extract, transform, and load data into information products that support business objectives. Oversee the development and implementation of Apache Hadoop frameworks to ensure efficient data storage and processing. Work closely with data scientists to implement data analytics pipelines, facilitating the integration of advanced analytics into business processes. Convert complex technical and functional requirements into detailed system designs for data processing and storage solutions. Provide guidance and mentorship to junior staff by conducting training sessions and reviewing their project outputs. Investigate and evaluate alternative data storage and processing options to ensure streamlined and effective solutions. Analyze vast datasets to uncover insights and trends that drive informed business decisions and strategies. Desired Qualifications: Bachelor’s degree in computer science, Engineering, or a related field. Minimum of 5 years of experience in Big Data engineering or a related role. Knowledge of Core Java, Linux, SQL, and any scripting language. Proven experience with Python, Spark, and Hive for data processing and analytics. Familiarity with data warehousing, data modeling techniques, and industry-standard visualization tools (e.g., Tableau). Pay Details: $54.00 to $64.00 per hour Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Equal Opportunity Employer/Veterans/Disabled The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable: The California Fair Chance Act Los Angeles City Fair Chance Ordinance Los Angeles County Fair Chance Ordinance for Employers San Francisco Fair Chance Ordinance</p>

Modis Business Intelligence Interview Guide

Overview

Modis Business Intelligence Salary

Modis Business Intelligence Interview Process

Modis Business Intelligence Interview Questions

Modis Business Intelligence Jobs