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

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.

Position Purpose

The Senior Developer will be a part of the ISPL Chennai – IHC ETL projects team.  The developer position will primarily work on PL/SQL, Unix shell scripting, ETL and data warehousing tools and Autosys  

Responsibilities

Direct Responsibilities

• Design, develop, test, and implement ETL processes using PL/SQL 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 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. 

Technical & Behavioral Competencies

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

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

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

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

•         Experience with ETL tools, such as Informatica, Oracle OFSAA, 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.

Behavioral Competencies

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

Specific Qualifications (if required)

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Communication skills - oral & written

Ability to synthetize / simplify

Attention to detail / rigor

Organizational skills

Transversal Skills: (Please select up to 5 skills)

Analytical Ability

Ability to understand, explain and support change

Ability to develop and adapt a process 

Ability to manage / facilitate a meeting, seminar, committee, training…

Ability to develop and leverage networks

Education Level: 

 Bachelor Degree or equivalent

Experience Level

At least 5 years

Other/Specific Qualifications (if required)

Additional knowledge of reporting tools is advantage