Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

BNP Paribas

Compare button icon Compare button icon Compare
3.8

based on 1.5k Reviews

Play video Play video Video summary

Filter interviews by

BNP Paribas Informatica Developer Interview Questions, Process, and Tips

Updated 11 Sep 2020

BNP Paribas Informatica Developer Interview Experiences

1 interview found

Informatica Developer Interview Questions & Answers

user image Anonymous

posted on 11 Sep 2020

Interview Questionnaire 

7 Questions

  • Q1. 1. Brief about yourself. Roles and responsibilites
    • Add your answer
  • Q2. Types of transformations you have worked on
  • Ans. 

    I have worked on various types of transformations including Aggregator, Expression, Filter, Joiner, Lookup, Router, and Sorter.

    • Aggregator transformation for performing calculations on groups of data

    • Expression transformation for performing calculations and manipulating data

    • Filter transformation for filtering out unwanted data

    • Joiner transformation for joining data from multiple sources

    • Lookup transformation for retrieving...

    • Answered by AI
    Add your answer
  • Q3. Is sorter active?
  • Ans. 

    Sorter can be active or inactive depending on the configuration.

    • Sorter transformation can be configured to be active or passive.

    • If active, it sorts the data based on specified criteria.

    • If passive, it passes the data through without sorting.

    • Sorter can be used to remove duplicates from data.

    • Sorter can also be used to sort data in ascending or descending order.

    • Answered by AI
    Add your answer
  • Q4. What kind of transformation is update strategy? explain
  • Ans. 

    Update strategy is a transformation used to flag rows for insert, update, delete or reject.

    • Update strategy is used to control the flow of data in a mapping.

    • It is used to flag rows for insert, update, delete or reject.

    • It can be used to update a target table based on a source table.

    • It can be used to insert new rows into a target table.

    • It can be used to delete rows from a target table.

    • It can be used to reject rows that do

    • Answered by AI
    Add your answer
  • Q5. Types of caches. explain
  • Ans. 

    Caches are temporary storage areas that hold frequently accessed data for quick access.

    • There are several types of caches including CPU cache, disk cache, browser cache, and DNS cache.

    • CPU cache stores frequently accessed data from RAM for faster access.

    • Disk cache stores frequently accessed data from hard disk for faster access.

    • Browser cache stores frequently accessed web pages, images, and other resources for faster loa...

    • Answered by AI
    Add your answer
  • Q6. If we dont specify anything in group by aggregator what will happen
  • Ans. 

    If we don't specify anything in group by aggregator, it will return the result without any grouping.

    • The result will contain all the rows from the input without any aggregation.

    • The output will have the same number of rows as the input.

    • No grouping will be performed on any column.

    • The output will be similar to a select statement without a group by clause.

    • Answered by AI
    View 1 more answer
  • Q7. Performance tuning
    • Add your answer

Skills evaluated in this interview

Interview questions from similar companies

Information Security Analyst Interview Questions & Answers

Wells Fargo user image Anonymous

posted on 25 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What is RBAC and it’s principal
  • Ans. 

    RBAC stands for Role-Based Access Control, a method of restricting network access based on roles assigned to users.

    • RBAC assigns permissions to roles, and roles to users

    • It simplifies access management by grouping users with similar access needs

    • RBAC helps enforce the principle of least privilege, granting only necessary permissions

    • Example: Admin role has full access, while User role has limited access

    • Answered by AI
    Add your answer
  • Q2. Importance of cyber in application security
  • Ans. 

    Cybersecurity is crucial in application security to protect sensitive data and prevent cyber attacks.

    • Cybersecurity helps in identifying and mitigating vulnerabilities in applications.

    • It ensures the confidentiality, integrity, and availability of data within applications.

    • Implementing secure coding practices and regular security assessments are essential in application security.

    • Examples include using encryption to protec...

    • Answered by AI
    Add your answer
Round 2 - HR 

(2 Questions)

  • Q1. Salary expectations
    • Add your answer
  • Q2. Compensation structures
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through with the JD and understand what the team does then prepare for the jnterview.

Skills evaluated in this interview

Information Security Analyst Interview Questions & Answers

Wells Fargo user image Anonymous

posted on 4 Oct 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Active Directory related questions
    • Add your answer
Round 2 - HR 

(1 Question)

  • Q1. Was managerial , questions related to process and how well you handle situations of incidents
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing Fancy, Questions is mainly based on Active Directory and how well you will handle process's

ETL Developer Interview Questions & Answers

Citicorp user image Anonymous

posted on 29 Jul 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - Coding Test 

There was a small test which included few mcqs and one sql coding question. It was about 30 mins. It was fairly easy if you have knowledge on SQL.

Round 2 - Technical 

(2 Questions)

  • Q1. What is rollback and commit?
  • Ans. 

    Rollback and commit are database transactions used to manage changes made to the database.

    • Rollback is used to undo changes made in a transaction and restore the database to its previous state.

    • Commit is used to save the changes made in a transaction permanently to the database.

    • Rollback is typically used when an error occurs during a transaction, while commit is used when the transaction is successful.

    • Example: If a trans...

    • Answered by AI
    Add your answer
  • Q2. What are Transactions
  • Ans. 

    Transactions are a set of operations that are executed as a single unit of work, ensuring data integrity and consistency.

    • Transactions help maintain data integrity by ensuring all operations within the transaction are completed successfully or rolled back if any operation fails.

    • Transactions follow the ACID properties - Atomicity, Consistency, Isolation, and Durability.

    • Examples of transactions include transferring funds ...

    • Answered by AI
    Add your answer

Information Security Analyst Interview Questions & Answers

Wells Fargo user image Anonymous

posted on 1 Jun 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. What value can you add
  • Ans. 

    I can add value by identifying and mitigating security risks, implementing security measures, and ensuring compliance with regulations.

    • Identifying security risks and vulnerabilities in systems and networks

    • Implementing security measures such as firewalls, encryption, and access controls

    • Ensuring compliance with regulations and industry standards such as GDPR, HIPAA, and PCI DSS

    • Monitoring and responding to security incide...

    • Answered by AI
    Add your answer
Round 2 - One-on-one 

(1 Question)

  • Q1. What impactful event have you performe3ed in last job
    • Add your answer

Oracle Database Administrator Interview Questions & Answers

Fidelity Investments user image Abinaya N

posted on 15 Sep 2021

I applied via Naukri.com and was interviewed in Aug 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Data pump, golden gate and performs tuning
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Less than 3.5 exp they are expecting to know performance tuning.. even you have not worked please learn about it. Golden gate also. Oracle DBA whatever the interview prepare for golden gate data pump and performance tuning.

Oracle Database Administrator Interview Questions & Answers

JPMorgan Chase & Co. user image Anonymous

posted on 26 Oct 2021

I applied via Referral and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. DBA activities like Rman backup recovery,mount clearing,Delete obsolete, Dataguard, Db cloning, patching, Upgradation
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Understanding explain very clearly
More about working at BNP Paribas

BNP Paribas Interview FAQs

How to prepare for BNP Paribas Informatica Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at BNP Paribas. The most common topics and skills that interviewers at BNP Paribas expect are Informatica, SQL, Performance Tuning, Stored Procedures and Cobol.
What are the top questions asked in BNP Paribas Informatica Developer interview?

Some of the top questions asked at the BNP Paribas Informatica Developer interview -

  1. if we dont specify anything in group by aggregator what will hap...read more
  2. what kind of transformation is update strategy? expl...read more
  3. Types of transformations you have worked...read more

Tell us how to improve this page.

BNP Paribas Interviews By Designations

Interview Questions for Popular Designations

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
HDFC Bank Interview Questions
3.9
 • 2.1k Interviews
Axis Bank Interview Questions
3.8
 • 1.5k Interviews
Kotak Mahindra Bank Interview Questions
3.8
 • 1.1k Interviews
JPMorgan Chase & Co. Interview Questions
4.0
 • 761 Interviews
IndusInd Bank Interview Questions
3.5
 • 601 Interviews
Wells Fargo Interview Questions
3.9
 • 569 Interviews
Citicorp Interview Questions
3.7
 • 568 Interviews
HSBC Group Interview Questions
4.0
 • 491 Interviews
Yes Bank Interview Questions
3.7
 • 429 Interviews
View all

Fast track your campus placements

Mumbai University Placement Questions
1 Interview
Bharati Vidyapeeths Institute of Technology, Navi Mumbai Placement Questions
1 Interview
Dwarkadas J Sanghvi College of Engineering, Mumbai Placement Questions
1 Interview
Meerut Institute of Engineering and Technology, Meerut Placement Questions
1 Interview
MET Institute of Computer Science, Mumbai Placement Questions
1 Interview
PSG College of Arts & Science, Coimbatore Placement Questions
1 Interview
Ramakrishna Mission Vivekananda College, Chennai Placement Questions
1 Interview
View all
BNP Paribas Salaries in India
Senior Associate
2.1k salaries
unlock blur

₹3.6 L/yr - ₹14.3 L/yr

Assistant Manager
1.3k salaries
unlock blur

₹5.9 L/yr - ₹24 L/yr

Associate 1
1k salaries
unlock blur

₹2.5 L/yr - ₹9.3 L/yr

Associate
810 salaries
unlock blur

₹2 L/yr - ₹8 L/yr

Senior Software Engineer
460 salaries
unlock blur

₹7.5 L/yr - ₹28 L/yr

Explore more salaries
Compare BNP Paribas with

HSBC Group

4.0
Compare

Standard Chartered

3.7
Compare

ICICI Bank

4.0
Compare

HDFC Bank

3.9
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview