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

Bnp Paribas Business Intelligence Interview Guide

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


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

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

Overview

Bnp Paribas 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.

Bnp Paribas 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

Bnp Paribas Business Intelligence Interview Questions

<p></p><p><strong>About the Company</strong></p><p><br></p><p>Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, European Union’s leading bank with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 10000 employees, to provide support and develop best-in-class solutions.</p><p><br></p><p><strong>Job Location - </strong>Mumbai / Chennai / Bengaluru</p><p><br></p><p><strong>About the Role</strong></p><p><br></p><p>The person will be responsible for analyzing requirements, developing an end-to-end solution for both frontend and backend including clean, efficient code, followed by writing unit and integration test cases with above average code coverage. It will also require them to inspect bugs across environments and assist in their resolution.</p><p><br></p><p><br></p><p><strong>Responsibilities</strong></p><p><br></p><ul><li>Design, develop, and maintain complex software applications using Java, Angular, Spring Boot,</li><li>Participate in code reviews and ensure that code meets quality standards.</li><li>Troubleshoot and debug software issues as needed.</li><li>Develop and maintain RESTful APIs using Spring Boot.</li><li>Develop and maintain front-end applications using any ONE of the Frontend Technologies like Angular/jQuery/React/GWT.</li><li>Implement security features such as authentication and authorization using Spring Security.</li><li>Implement database access and management using Hibernate and other ORM frameworks.</li><li>Stay up-to-date with emerging trends and technologies in software development, including cloud technologies and microservices architecture.</li><li>Write unit tests and integration tests to ensure code quality and maintainability.</li></ul><p><br></p><p><strong>Qualifications</strong></p><p><br></p><p>Education Level: Bachelor Degree or equivalent</p><p><br></p><p>Experience Level: 3 to 8yrs of experience.</p><p><br></p><p><strong>Required Skills</strong></p><p><br></p><ul><li>Expert in Java8 & above, Junit</li><li>Expert in experience in Web Technologies (Spring Boot and Spring related frameworks)</li><li>Expert in Oracle/ SQL (SQL queries, Packages, stored procedures, functions and database modeling)</li><li>Strong in Hibernate/JPA, Webservices (API)</li><li>Strong in any ONE of the Front End Technologies (Angular/jQuery/React/GWT)</li></ul><p><br></p><p><br></p><p><strong>Preferred Skills</strong></p><p><br></p><ul><li>Understanding of dependency management (Gradle/Maven), Event based frameworks (Kafka/IBM MQ), CI/CD platforms (Jenkins/TeamCity)</li><li>Some exposure to Performance tuning</li><li>Micro services such as multithreading, concurrency, and data structures</li></ul><p><br></p><p><br></p><p><strong>Equal Opportunity Statement</strong></p><p><br></p><p>At BNP Paribas, we passionately embrace diversity and are committed to fostering an inclusive workplace where all employees are valued, respected and can bring their authentic selves to work. We prohibit Discrimination and Harassment of any kind and our policies promote equal employment opportunity for all employees and applicants, irrespective of, but not limited to their gender, gender identity, sex, sexual orientation, ethnicity, race, color, national origin, age, religion, social status, mental or physical disabilities, veteran status etc. As a global Bank, we truly believe that inclusion and diversity of our teams is key to our success in serving our clients and the communities we operate in.</p><p></p>

Bnp Paribas Business Intelligence Interview Guide

Overview

Bnp Paribas Business Intelligence Salary

Bnp Paribas Business Intelligence Interview Process

Bnp Paribas Business Intelligence Interview Questions

Bnp Paribas Business Intelligence Jobs