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, 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:
CEP IT – TM- Recon offer a framework enabling technical and functional standardization of reconciliations to maintain productivity and quality to the users. SSC Recon works for both CIB and BP2S métier for various department across globe to serve the reconciliation needs for both control and financial reconciliations.
Job Title:
Developer
Date:
Jan 1st, 2025
Department:
CEP-IT-TM-Recon
Location:
Mumbai / Bangalore
Business Line / Function:
CIB
Reports to:
(Direct)
ADM Manager
Grade:
(if applicable)
(Functional)
ADM Manager
Number of Direct Reports:
Directorship / Registration:
NA
Position Purpose
CEP IT – TM – Recon ADM team needs to hire resources to work on the projects approved by user to ensure the projects are completed on time without any impacts to user.
· This is a ETL developer position who can contribute to design, development, deployment and maintenance of solution, MS-SQL database, data preparation, data integration and data warehousing solutions.
· To take initiatives in development and enhancement of various projects.
· Provides technical expertise on related projects/JIRAs and delivery requests.
· Employs industry standard best practices for integration and interface patterns.
Responsibilities
Direct Responsibilities
· Propose and develop solutions using ETL tools and visualization tools, SQL/Oracle Servers/Databases for acquisition, storage and processing needs.
· Primarily responsible for designing and developing ETL workflows for reconciliation team.
· Optimization of performance of Tableau/Alteryx reports being deployed in a global environment.
· Analyze data and systems to identify data sourcing, structuring, modeling and transformation requirements.
· Develop prototypes using multiple sourcing, transformation, and storage tools.
· Present and explain functionalities, alternatives of different tools and applicability to specific situations and processes.
· Decode and document applications developed by the team or transferred to the team.
· Interface with users to understand requirements in a dynamic environment in an agile fashion.
· Support maintenance, troubleshooting and management application.
· Manage enhancement and update schedules for the application.
· Build automated reports and dashboards.
· Understand business requirements to set functional specifications for reporting applications.
· Establish row-level security on data and comprehend reporting application security layer models.
· Be experienced in tools and systems on MS SQL Server, BI stack including SSRS, Power query & POWER BI
· Be able to quickly shape data into reporting and analytics solutions.
· Have knowledge of database fundamentals such as multidimensional database design, relational database design and more.
· Involved in creating technical documentation in the work assignments.
· Study user requirement, develop specifications, design, program coding, test and implement systems in line with Group standards and regulatory requirements IN ORDER TO meet user (business) requirements.
· Work on development/ maintenance tasks using technology used in projects
· Liaises with Infrastructure teams to ensure proper system configurations and hardware performance efficiencies.
· Involved with the review and submission of all solution designs provided by Vendor or in-house development team.
· Establishes regular code reviews tied to on-going components / projects development.Develop stored procedures to build reports for the end users using SQL 2016
· Code optimization and should be able to mentor new team members.
· Flexible to learn, understand reconciliation concept and database structure of reconciliation tool
· Flexible to contribute to reconciliation development activities using IntelliMatch tool as required.
· Comprehensive understanding of SDLC and Jira. Involvement across all stages of Software Development life cycle (SDLC) including business requirement analysis, data mapping, validate data against requirement, build, unit testing, peer reviews, systems integration, and user acceptance testing.
· Analyze & develop Test Strategies, design Test Plans, & generate and execute Test Cases.
· Should be able to perform enhancements, whereby need to analyze existing set-up and understand the requirement by performing proper impact analysis, provide estimate and deliver quality code.
· Should have good understanding of DevSecOps platform and relevant Tools/applications to do customized automations at various stages of software lifecycle and for Process automation with Intellimatch set-up.
· Independent player - Should be able to liaise with different team to re-solve/get dependencies on time.
· Should be able to foresee issue/risk and intimate the same to team lead / project manager.
· Should be able to guide support team.
· Propose improvements related to the development and support activity.
Contributing Responsibilities
· Further enhance, Trouble-shoot, understand & resolve problems related to existing systems IN ORDER TO meet user requirements and ensure smooth functioning of IT systems
· To manage housekeeping, upgrades, installation, backup/restore & adherence to DR plans IN ORDER TO ensure smooth functioning of existing systems.
· Able to prepare the technical and functional documents for the project activities.
· Train users in using systems (wherever required) IN ORDER TO ensure effective use of the system.
Technical & Behavioral Competencies
· 6-8 years of experience in IT, with a minimum of 6 years of hands-on experience in ETL application .
· To understand business requirements in the ETL context and design data models to convert raw data to meaningful insights.
· To design, develop, and deploy ETL Workflows, Scripts & stored procedures and perform efficient detailed analysis.
· To create charts and document data with algorithms, parameters, models, and relations explanations.
· To perform SQL querying for best results
· To define and design new systems by analyzing current ETL processes.
· Strong understanding of relational database management systems (RDBMS) such as Oracle, MySQL, or SQL Server (Mandatory)
· SQL/PL-SQL Expertise: Advanced skills in SQL queries, stored procedures, packages, functions, and triggers (Mandatory)
· Performance Tuning: Experience with query optimization, indexing strategies, and analyzing execution plans (Mandatory)
· Analytical Skills: Ability to troubleshoot and problem-solve complex issues efficiently. (Mandatory)
· Knowledge of scheduling tool (Mandatory)
· ETL tools: Alteryx (Mandatory), Informatica (optional) & SSRS (optional)
· Unstructured data workflow: DataIQ (Optional)
· Working Knowledge on DevOps technologies such as Jenkins, Ansible, SonarQube, Bit Bucket, Artifactory etc., (Optional)
· Knowledge of any defect management tool (optional)
· Knowledge of Python, Perl or VB Script (optional)
Soft Skills and Additional Requirements:
· Must be able to work closely with end users and developers.
· Expected to work in European Business hours (Holidays and weekends)
· Willing to improve functional knowledge and technical skills.
· Strong organization and prioritization skills.
· Pragmatic approach to problem solving.
· Effective communication with all stakeholders/teams.
Specific Qualifications (if required)
• Years Of Exp: 6-8 years
• Qualification: B.E. (IT/ Comp. Sc.) or equivalent
Skills Referential
Behavioural Skills: (Please select up to 4 skills)
Ability to collaborate / Teamwork
Decision Making
Attention to detail / rigor
Ability to deliver / Results driven
Transversal Skills: (Please select up to 5 skills)
Analytical Ability
Ability to develop and adapt a process
Ability to manage / facilitate a meeting, seminar, committee, training…
Ability to set up relevant performance indicators
Ability to inspire others & generate people's commitment
Education Level:
Bachelor Degree or equivalent
Experience Level
At least 5 years
Other/Specific Qualifications (if required)
