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

Bnp Paribas Business Intelligence Interview Guide

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


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

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Bnp Paribas Business Intelligence Interview Process

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.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

<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>
<code>users</code> table

<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>
 
Output:

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

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

You’ve been asked to analyze the player’s behaviors at a gaming company.

Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.

Example:

Input:

<code>players</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Obtain count of players based on games played.

Player Analysis

Bnp Paribas Business Intelligence Interview Questions

About BNP Paribas India Solutions: 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. About BNP Paribas Group: BNP Paribas is the European Union's leading bank and key player in international banking. It operates in 65 countries and has nearly 185,000 employees, including more than 145,000 in Europe. The Group has key positions in its three main fields of activity: Commercial, Personal Banking & Services for the Group's commercial & personal banking and several specialized businesses including BNP Paribas Personal Finance and Arval; Investment & Protection Services for savings, investment, and protection solutions; and Corporate & Institutional Banking, focused on corporate and institutional clients. Based on its strong diversified and integrated model, the Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporate and institutional clients) to realize their projects through solutions spanning financing, investment, savings and protection insurance. In Europe, BNP Paribas has four domestic markets: Belgium, France, Italy, and Luxembourg. The Group is rolling out its integrated commercial & personal banking model across several Mediterranean countries, Turkey, and Eastern Europe. As a key player in international banking, the Group has leading platforms and business lines in Europe, a strong presence in the Americas as well as a solid and fast-growing business in Asia-Pacific. BNP Paribas has implemented a Corporate Social Responsibility approach in all its activities, enabling it to contribute to the construction of a sustainable future, while ensuring the Group's performance and stability Commitment to Diversity and Inclusion 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. About Business line/Function: The Global Markets (GM) business of BNP Paribas helps its Corporate and Institutional clients leverage capital markets across the globe for their financing, risk management and investment needs. This encompasses a wide range of financial products ranging from foreign exchange to complex Equity Derivatives that are traded in financial markets across the globe 24/7. IT systems are integral to the business and are a key part of the value proposition to clients. These IT systems range from industry standard products for standard process automation to internally developed, often, market leading IT applications. The IT teams owning these IT systems are made up of functions that include Technical and Application production support, Business Analysis & Project Management, Development & Maintenance and Quality Control. BNP Paribas India Solutions is an equal partner in these IT functions along with colleagues in other locations including Paris, London, New York, Tokyo, Singapore & Hong Kong. This partnership ranges from sharing the IT workload, executing global strategy to owning global applications offshore. The technology and engineering landscape is wide, encompassing almost all techniques and platforms. It continues to evolve and transform with the market with the business continuing to invest in it. Job Title: Business Analyst Department: Global Markets ITLocation: BangaloreBusiness Line / Function: Trade Processing Position Purpose:- Documentation IT - The team is in charge of CIB's Back Office platforms that manages notably deals & associated documentation (e.g. Confirmations & Advices). Métiers covered are Interest Rates, Credit, Forex, Equity, Bonds, Commodities and Derivatives. <ul><li> The platform facilitates notably the following Functionality:</li><li>Automatic Document creation, sending & reception (fax, swifts & emails)</li><li>Document drafting and validation, indexing and matching,</li><li>Tracking/chasing and litigations management,</li><li>Deal-related communication.</li></ul> Responsibilities We have a requirement for a strong Business analyst, with rounded middle/back office experience in investment banking. The candidate should be able to demonstrate that they have delivered value on large projects in Capital Markets, preferably in the middle/back office area. Business knowledge: <ul><li> A strong appreciation of Middle/Back Office functions,Trade lifecycle</li><li>Product knowledge: Interest rates derivatives, Credit Derivatives, Options, Fx options (Knowledge is required more in how these products might be represented in a Front Office, Back office system)</li><li> Understands Back office Trade confirmation process and workflows.</li><li> An appreciation of Static data on Securities</li><li>Market data & prices</li><li>Regulatory initiatives such as Dodd Frank, EMIR, Clearing</li><li>Required Business Analysis skills in IT system design</li><li>IT system design and testing: Interfaces between systems (FO feeding Back offices)</li><li>Good understanding of data flowing between systems throughout the trade life cycle</li></ul> Direct Responsibilities Initial Analysis<ul><li>Feasibility studies</li><li>Initial estimations</li><li> Providing proposals, High level solutions</li><li>Working with Project Managers to identify target delivery dates</li><li> Implementation/Post Live Support</li><li> Provide support for new/changed functionality where required, producing:Release Notes</li><li>User Guides/documentation/Use case diagrams</li><li> Arranging Functional Demo's/Training</li></ul> Testing <ul><li> Produce and execute Functional Test Packs - or provide guidance where required to testing teams.</li><li>Regression Test Pack assessment</li><li>Organize and manage end User Testing where required</li><li>Escalation of environment issues preventing progress</li><li>Functional Design and Documentation</li><li>Obtaining/clarifying/elaborating business requirements</li><li>Functional solution design and documentation</li><li> Re-estimation throughout Project lifecycle when required</li></ul> 3rd Level Support<ul><li>Provide 3rd level support in line with defined Group process.</li><li>L3 technical support to production and UAT environments.</li></ul> Additional Responsibilities<ul><li>Template Design & development using in house document drafting tool.</li><li>Appropriate documentation to be provided for all deliveries.</li></ul> Good Essential technical skills: Experience with understanding complex systems, analyzing, and resolving issues and writing functional and technical specifications, and test plans. Experience in coordinating a dispersed set of stakeholders (functionally and geographically) Experience with having organized and conducted all types of testing in a Banking environment. Experience with structured project methodology. Understanding of business analysis and systems analysis Experience in drafting test plans, test scenario and test cases Experience in executing functional testing. Knowledge of analysis methodologies like entity-relation modelling, use cases, process / transformation analysis. Ability to work with technology to assist with analysis eg SQL, Access A good knowledge of Excel, Access, Visio, PowerPoint is requested. Worked on Thunderhead Tool or any other Tool related to Document Template Creation. Prior Experience in Automation Projects that has been E2E delivered. Hands on SQL and able to read/write SQL queries. Good interpersonal and communications skills to work effectively with representatives of a diverse range of departments located in various sites and locations (Collateral Management FO, IT, Operations, Credit Risk, Market Risk) and within various business lines (mainly Fixed Income, Equity Derivatives). Must be able to demonstrate that can communicate well in writing and orally and manage relationships. Being able to work under pressure, in a sometimes-challenging environment, and to deal with confrontational situations. Able to negotiate, to convince and find consensus. Pro-active in rearranging priorities and solving issues where requested. Being prepared to work long hours when necessary. Has to be hands on, rigorous and methodical Specific Qualifications (if required) MBA in Finance

About BNP Paribas India Solutions: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. About BNP Paribas Group:BNP Paribas is the European Union’s leading bank and key player in international banking. It operates in 65 countries and has nearly 185,000 employees, including more than 145,000 in Europe. The Group has key positions in its three main fields of activity: Commercial, Personal Banking & Services for the Group’s commercial & personal banking and several specialized businesses including BNP Paribas Personal Finance and Arval; Investment & Protection Services for savings, investment, and protection solutions; and Corporate & Institutional Banking, focused on corporate and institutional clients. Based on its strong diversified and integrated model, the Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporates and institutional clients) to realize their projects through solutions spanning financing, investment, savings and protection insurance. In Europe, BNP Paribas has four domestic markets: Belgium, France, Italy, and Luxembourg. The Group is rolling out its integrated commercial & personal banking model across several Mediterranean countries, Turkey, and Eastern Europe. As a key player in international banking, the Group has leading platforms and business lines in Europe, a strong presence in the Americas as well as a solid and fast-growing business in Asia-Pacific. BNP Paribas has implemented a Corporate Social Responsibility approach in all its activities, enabling it to contribute to the construction of a sustainable future, while ensuring the Group's performance and stability. Commitment to Diversity and InclusionAt 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, colour, 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. About Business line/Function:BNP Paribas CIB is a leading global financial services firm, offering you solutions in capital markets, securities services, advisory, finance and treasury. Job Title:Senior Software Engineer/ Technical Lead Department:CIB IT Location:Mumbai / Chennai / Bangalore Business Line / Function:CIB IT Reports to:Manager Position PurposeA Senior Java Developer is responsible for designing, developing, and maintaining Java-based applications. Must have extensive experience working with Java programming language and should also be well-versed with various Java-based frameworks and libraries. 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. The person should be able to work on POCs to establish new features to be tried out in applications Education Level:Bachelor Degree or equivalentExperience Level:3 to 10yrs of experience. Technical & Behavioral Competencies<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 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><li>Implement security features such as authentication and authorization using Spring Security.</li></ul> Good to have Skills<ul><li>Understanding of dependency management (Gradle/Maven), Event based frameworks (Kafka/IBM MQ)</li><li>Exposure to Performance tuning</li><li>Micro services such as multithreading, concurrency, and data structures</li><li>Exposure to Database Schema versioning tools like liquibase or flyway</li><li>Exposure to Devops platform(Jenkins/TeamCity), application metrics and monitoring platform(Dynatrace).</li></ul> Direct Responsibilities<ul><li>Design, develop, and maintain complex software using required technologies</li><li>Write unit tests and integration tests to ensure code quality and maintainability</li><li>Participate in code reviews and ensure that code meets quality standards.</li><li>Troubleshoot and debug software issues as needed. Provide L3 support if necessary</li><li>Escalation of barriers to progress via his/her team leader in a timely and succinct manner</li><li>Reviewing current project design, identify drawbacks and propose performant, scalable design</li></ul> Contributing Responsibilities<ul><li>To Train new comers for functional and technical knowledge</li><li>To improve the application performance</li><li>Provide technical leadership and mentoring to junior developers</li><li>Collaborate with cross-functional teams to identify and prioritize software features and enhancements</li></ul> Skills Referential<ul><li>Behavioral Skills:</li><li>Ability to collaborate / Teamwork</li><li>Adaptability</li><li>Communication skills - oral & written</li><li>Ability to deliver / Results driven</li></ul> <ul><li>Transversal Skills</li><li>Ability to understand, explain and support change</li><li>Ability to develop and adapt a process</li><li>Ability to develop others & improve their skills</li></ul>

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