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

Mapfre Business Intelligence Interview Guide

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


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

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

Overview

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

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

Mapfre Business Intelligence Interview Questions

<b>Job Summary</b><br><br><ul> <li>Augment and maintain the existing repositories and data structures within AWS (used to process and store large amounts of data from unrelated sources)</li> <li>Experience with several formats and means for data ingestion. Including, data types (structured, semi-structured, and unstructured), and sources (on premise, and in the cloud) using the most appropriate techniques in each case</li> <li>Continue to expand and enhance the model, utilizing best practices, in regards to the organization of data and the various relationships</li> <li>Optimize existing and future models for fast and scalable queries (while maintaining performance and related price thresholds)</li> <li>Work with the team to define, construct, and maintain self-service dashboards for the Business and Advanced Analytics teams within PowerBI</li> <li>Implement scalable and flexible, high performance data pipelines for AWS to support analytics</li> <li>Develop and maintain data maps and their relationships</li> <li>Generate associated technical documentation including follow-up reports</li> <li>Work with Data Governance to implement quality rules and data governance measures (data dictionary, metadata, traceability, ...)</li> <li>Propose improvements and actions based on provided results</li> <li>Communicate results effectively with required teams</li></ul><br><br><b>Knowledge, Skills and Abilities:</b><br><br><ul> <li>Bachelor's Degree with 6+ years of experience.</li> <li>Advanced knowledge and experience using Python, Airflow, Spark, AWS, and Snowflake</li> <li>Database architectures: SQL, NoSQL, graph databases</li> <li>CI/CD and Orchestration: Jira, Jenkins, Bit Bucket, Terraform, and Airflow</li> <li>Past experience with data modeling tools, ETL tools (e.g. Informatica Power Center)</li> <li>Computer languages, data query and transformation tools: AWS Athena, Jupyter notebooks, Spark, Pyspark, Python, and EMR Studio</li> <li>Algorithm analysis (for working with our Data Scientists)</li> <li>Understanding of multidimensional modeling for quantitative and fact related data storage</li> <li>OS: Linux, and MS Windows</li> <li>Code IDE: Microsoft Visual Code, Jupyter notebooks</li> <li>Artificial intelligence, machine learning, and deep learning are a plus</li></ul>

Mapfre Business Intelligence Interview Guide

Overview

Mapfre Business Intelligence Salary

Mapfre Business Intelligence Interview Process

Mapfre Business Intelligence Interview Questions

Mapfre Business Intelligence Jobs