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 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
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
What people are saying about BNP Paribas
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
BNP Paribas interview questions for popular designations
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
Get interview-ready with Top BNP Paribas Interview Questions
I was interviewed 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 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
Basic accounting questions
Financial market is a platform where buyers and sellers trade financial securities, commodities, and other fungible items.
Financial markets facilitate the exchange of assets such as stocks, bonds, currencies, and derivatives.
They provide a platform for companies to raise capital through issuing stocks or bonds.
Financial markets can be categorized into primary markets (new securities are issued) and secondary markets (e...
Investment banking involves providing financial services to corporations, governments, and other institutions.
Facilitates mergers and acquisitions
Underwrites securities offerings
Provides financial advisory services
Assists with raising capital for clients
Engages in trading and market-making activities
Net Asset Value (NAV) is the value of a fund's assets minus its liabilities, divided by the number of shares outstanding.
NAV is calculated by subtracting the fund's liabilities from its assets.
The result is then divided by the number of shares outstanding to determine the NAV per share.
NAV is used to determine the price at which investors can buy or sell shares of the fund.
It is an important metric for investors to tra
I am a detail-oriented professional with a strong background in accounting and a passion for financial analysis.
I have a Bachelor's degree in Accounting and have worked in the finance industry for 5 years.
I am proficient in financial reporting, reconciliations, and fund accounting principles.
I have experience using accounting software such as QuickBooks and Excel to analyze financial data.
I am a team player and have ex...
I will discuss the impact of COVID-19 on the global economy and financial markets.
COVID-19 pandemic led to economic slowdown worldwide
Stock markets experienced volatility due to uncertainty
Central banks implemented stimulus measures to support economies
Remote work became the norm for many industries
Supply chain disruptions affected various sectors
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
Experienced Linux Administrator with 8+ years of hands-on experience in managing and troubleshooting Linux servers.
8+ years of experience in Linux system administration
Strong knowledge of server configuration, maintenance, and troubleshooting
Proficient in shell scripting and automation tools like Ansible
Experience with virtualization technologies such as VMware and KVM
Familiarity with networking protocols and security
The biggest issue facing in the real time work environment is managing system downtime effectively.
Implementing proper monitoring tools to detect issues early
Creating a detailed incident response plan
Regularly testing backups and disaster recovery procedures
Utilizing automation for routine tasks to reduce human error
Establishing clear communication channels for notifying stakeholders during downtime
I prioritize tasks, break them down into smaller steps, set milestones, and communicate effectively with team members to ensure timely completion.
Prioritize tasks based on importance and urgency
Break down tasks into smaller steps to make them more manageable
Set milestones to track progress and stay on schedule
Communicate effectively with team members to coordinate efforts and address any obstacles
Utilize time managemen...
Some tools used by Senior Linux Administrators include Ansible, Nagios, and Docker.
Ansible - used for automation of tasks and configuration management
Nagios - used for monitoring and alerting of system and network resources
Docker - used for containerization of applications for easy deployment and management
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 2-4 weeks to complete.
based on 157 interviews
Interview experience
based on 1.6k reviews
Rating in categories
Senior Associate
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate 1
998
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate
809
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
462
salaries
| ₹0 L/yr - ₹0 L/yr |
HSBC Group
Standard Chartered
ICICI Bank
HDFC Bank