Job Title: Developer

Department: ISPL F&RS 

About Business line/Function: Under BNP Paribas IT Group, FRS is the IT framework encompassing Projects & Systems of Finance and RISK functions, with a strong focus on efficiency, proximity, agility and time-to-market.

FRS is a worldwide organizational model that will contribute to tackle major challenges of the Group’s transformation of today and tomorrow, building the best offering to the Finance and Risk Community through a progressive rotation to new technologies and best practices. The FRS organization is the outcome of several convergences: between the Project & Systems teams of Group Finance, CIB Finance and RISK and their related IT teams.

FRS is part of the IT Group organization (ITG in Europe and ITO overseas) with a threefold sponsorship by ITG, Finance and RISK (CIB-ITO; RISK Solutions and ITG-FIT)

Position Purpose: The Developer will be a part of the ISPL Mumbai – IHC ETL projects team. The developer position will primarily work on ETL & Data warehousing project using PL/SQL, Python, PySpark, Unix shell scripting, Airflow and Autosys

Responsibilities

Direct Responsibilities

• Design, develop, test, and implement ETL processes using PL/SQL, Python, PySpark and Unix shell scripting to extract data from various sources, transform it into a suitable format, and load it into target systems.
• Develop and maintain complex SQL scripts, stored procedures, and functions to support ETL processes.
• Write Python and Unix shell scripts to automate ETL tasks, such as data file transfers, data validation, and error handling.
• Collaborate with data architects, business analysts, and other stakeholders to understand data requirements and develop ETL solutions that meet business needs.
• Troubleshoot ETL issues, identify root causes, and implement fixes to ensure data integrity and system reliability.
• Optimize ETL processes for performance, scalability, and reliability, and implement data quality checks to ensure data accuracy and consistency.
• Develop and maintain documentation of ETL processes, including data flow diagrams, data dictionaries, and technical notes.
• Participate in code reviews and contribute to the improvement of the overall quality of the codebase.
• Stay up-to-date with new technologies and trends in ETL development and apply this knowledge to continuously improve ETL processes and systems. 

Contributing Responsibilities

•         Apply AI‑based query‑optimization or performance‑tuning suggestions where available in your database platform.

•         Use AI‑assisted code‑completion or code‑review tools to increase productivity when writing PL/SQL or data‑pipeline scripts.

•         Participate in architecture roadmap discussions, providing input on scalability, cost‑optimization, and emerging data‑platform technologies.

•         Mentor junior developers on PL/SQL best practices, data‑modelling concepts, and ETL design patterns.

•         Contribute to the continuous‑integration/continuous‑deployment (CI/CD) pipeline, scripting automated build and deployment steps for database objects.

•         Evaluate and prototype new tools or frameworks that could enhance the ETL ecosystem.

•         Engage in cross‑functional agile ceremonies (scrum, sprint planning, retrospectives) to ensure alignment with the broader delivery team.

•         Support data‑visualization and reporting teams by delivering clean, well‑documented data‑sets and assisting with ad‑hoc data extracts for reporting needs.

•         Drive knowledge‑sharing by presenting lessons learned, optimization case studies to the wider data community.

•         Participate in audit and compliance reviews, supplying required artefacts and explanations for data‑pipeline controls.

Technical & Behavioral Competencies

•         At least 5 years of experience in ETL development, with a focus on PL/SQL, Python, PySpark and Unix shell scripting for ETL projects.

•         Strong knowledge of PL/SQL, including SQL, stored procedures, functions, and packages.

•         Experience with Python and Unix shell scripting, including shell scripts, cron jobs, and automation tools.

•         Familiarity with data warehousing concepts, data modeling, and data governance.

•         Good to have experience with ETL tools, such as Informatica, Oracle SQL Loader, Oracle Data Integrator or Talend.

•         Strong problem-solving skills, with the ability to analyze complex issues and develop creative solutions.

•         Excellent communication and collaboration skills, with the ability to work effectively with technical and non-technical stakeholders.

•         Ability to work in a fast-paced environment, with multiple priorities and deadlines.

•         Excellent verbal and written communication skills.

•         Conduct meetings with global stakeholders, prepare minutes & summaries.

•         Assertiveness, Negotiation, Proactiveness & Prioritization skills are important.

•         Discipline in documenting, following up on issues and changes.

•         Experience in interacting with global stakeholders and independently managing discussions

Skills Referential (Required knowledge, skills and abilities)

Technical Skills:

• Oracle PL-SQL
• Python and PySpark
• Unix shell
• Autosys or any other scheduling tools
• ETL & Data warehousing 

Behavioral Skills: 

• Communication skills - oral & written
• Ability to synthetize / simplify
• Attention to detail / rigor
• Organizational skills

Education Level: Bachelor Degree or equivalent

Location: Mumbai, India

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.

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.

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