Filter interviews by
I am an experienced Informatica Developer with expertise in ETL processes, data integration, and data warehousing.
Developing ETL mappings using Informatica PowerCenter
Designing and implementing data integration solutions
Optimizing performance of ETL processes
Troubleshooting and resolving data quality issues
Collaborating with business analysts and stakeholders to gather requirements
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...
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.
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
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...
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.
Lists and tuples are both data structures in Python, but lists are mutable while tuples are immutable.
Lists are enclosed in square brackets [], while tuples are enclosed in parentheses ().
Lists can be modified after creation, while tuples cannot be modified (immutable).
Lists are typically used for collections of similar items, while tuples are used for fixed collections of items.
Example: list = [1, 2, 3] and tuple = (4
The area of a room can be calculated by multiplying the length by the width.
Calculate the area by multiplying the length and width of the room.
For example, if the length of the room is 10 feet and the width is 12 feet, the area would be 120 square feet.
Make sure to use the same units for length and width when calculating the area.
Getting caught cheating on a test in high school
Was copying answers from a classmate during a test
Teacher caught me and called me out in front of the whole class
Felt embarrassed and learned my lesson about cheating
I appeared for an interview in Feb 2025, where I was asked the following questions.
What people are saying about BNP Paribas
I applied via Approached by Company and was interviewed in Sep 2024. There were 5 interview rounds.
Use two threads to print odd and even numbers in sync
Create two threads, one for printing odd numbers and one for printing even numbers
Use synchronization mechanisms like mutex or semaphore to ensure output is in sync
Example: Thread 1 prints odd numbers (1, 3, 5, ...) and Thread 2 prints even numbers (2, 4, 6, ...)
Find the largest common prefix among an array of strings.
Iterate through the characters of the first string and compare with the corresponding characters of other strings.
Stop when a mismatch is found or when reaching the end of any string.
Return the prefix found so far.
Saga pattern is a design pattern used in microservices architecture to manage distributed transactions.
Saga pattern breaks down a transaction into a series of smaller, independent steps.
Each step in the saga is a separate transaction that can be rolled back if needed.
If one step fails, compensating transactions can be executed to undo the changes made by previous steps.
Saga pattern helps maintain data consistency in a ...
Hash map and hash set are data structures that use hashing to store key-value pairs and unique values respectively.
Hash map uses key-value pairs where keys are hashed to find the corresponding value
Hash set stores unique values using hashing to quickly check for duplicates
Example: HashMap<String, Integer> map = new HashMap<>(); HashSet<Integer> set = new HashSet<>();
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Singleton pattern involves a private constructor, a static method to access the instance, and a static variable to hold the instance.
To break the singleton pattern, one can use reflection to access the private constructor and create multiple instances.
Another way to break the singleton pattern is by using serialization a
I am excited about the innovative projects and collaborative team environment at this company.
Opportunity to work on cutting-edge projects
Collaborative team environment
Strong company culture and values
Room for growth and advancement
Positive reputation in the industry
BNP Paribas interview questions for popular designations
I appeared for an interview in Sep 2024.
Code reviews ensure code quality, maintainability, and knowledge sharing among team members.
Establish clear guidelines: Define coding standards and best practices for consistency.
Use tools: Leverage tools like GitHub or Bitbucket for pull requests and inline comments.
Focus on readability: Ensure code is easy to read and understand; for example, use meaningful variable names.
Check for functionality: Verify that the code...
Get interview-ready with Top BNP Paribas Interview Questions
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
The trade life cycle refers to the stages involved in the processing of a trade from initiation to settlement.
Initiation: Trade is proposed and agreed upon by parties involved.
Execution: Trade is executed on the agreed terms.
Confirmation: Parties confirm the details of the trade.
Clearing: Trade details are matched and processed for settlement.
Settlement: Actual exchange of funds and securities takes place.
Post-trade: A...
Prioritising issues involves assessing urgency, impact, and resources available to address them.
Assess urgency of each issue based on impact on business operations
Consider impact on customers or stakeholders
Evaluate resources available to address each issue
Prioritise issues based on urgency, impact, and available resources
Communicate priorities to stakeholders and team members
I appeared for an interview in Oct 2024.
JWT token is a JSON web token used for authentication and contains three parts: header, payload, and signature.
JWT token consists of three parts: header, payload, and signature.
Header contains the type of token and the signing algorithm used.
Payload contains claims about the user and additional data.
Signature is used to verify that the sender of the JWT is who it says it is.
JWT tokens are encoded and can be easily deco...
I appeared for an interview before Apr 2024, where I was asked the following questions.
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage.
Common types of derivatives include options, futures, forwards, and swaps.
For example, a call option gives the holder the right to buy an asset at a specified price within a certain time frame.
Derivatives are traded on exchanges or over-the-counter (OTC)
I handled operational risk in my current process.
Identifying potential risks in daily operations
Implementing controls to mitigate risks
Monitoring and evaluating the effectiveness of risk management strategies
Some of the top questions asked at the BNP Paribas interview -
The duration of BNP Paribas interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 165 interviews
Interview experience
based on 1.6k reviews
Rating in categories
Senior Associate
2.1k
salaries
| ₹3.6 L/yr - ₹14.8 L/yr |
Assistant Manager
1.4k
salaries
| ₹6 L/yr - ₹24 L/yr |
Associate 1
1k
salaries
| ₹2.5 L/yr - ₹9 L/yr |
Associate
841
salaries
| ₹2 L/yr - ₹8 L/yr |
Senior Software Engineer
502
salaries
| ₹7.8 L/yr - ₹30 L/yr |
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
Cholamandalam Investment & Finance