Oracle PLSQL Developer

Job description

**Job Title:** Software Engineer **Department** : 2S CHE – IFS **About Business line/Function:** Within CIB Securities Services, IFS – UK IDEA Team is mainly handling the Middle office Position Keeping services for providing the Security services & Reporting features to its client for across multiple locations. **Position Purpose** Drive the design, build, and maintenance of the project’s core data‑transformation and integration engines, delivering faster, more maintainable solutions. Deep Oracle **PL/SQL expertise and a solid background in data‑warehouse and BI reporting platforms** , adapting swiftly to evolving requirements and collaborating tightly with the IDEA Team Reporting squad as a core developer. **Responsibilities** Direct Responsibilities - Technical Design: Translate functional stories and data flow diagrams into logical/physical database designs. Create ER diagrams, data dictionary entries, change impact analyses and Analyse & estimate. - Development: - Write reusable PL/SQL packages, functions, procedures, and triggers. - Build and optimise complex SQL queries, analytic functions and Implement batch processing jobs. - Performance & Tuning, Data Integration - ETL pipelines (WTX, Data Stage, Informatica/Talend or custom PL/SQL) to move data between two endpoints. - Write detailed technical analysis with impacts (technical/functionally) - Unit testing, E2E Testing and provide support during implementation. - Bug fixing - Report & Dashboard development with DWH & BI reporting tools (Spotfire, Vermilion, Tableau, Power BI etc.) Contributing Responsibilities - APS & OPS Support & Ops - Own L3 incident resolution for database related production tickets. Create RCA documentation and preventive action plans. - Knowledge Sharing - Mentor junior developers, lead code review, and contribute to the team’s best practice repository. - DevOps - CI/CD pipelines, automated builds, static code analysis and contribute to process improvement initiatives with Agile approach. - Soft Skills – - Strong analytical and problem‑solving abilities. - Excellent communication and teamwork in a fast‑paced environment. - Ability to handle multiple priorities and deliver within sprint timelines. **Technical & Behavioral Competencies** **Proficiency In** - Oracle SQL and PL/SQL in 19c or latest version - Packages, Functions, Procedures, Triggers and Views - Scheduler concept - Performance Tuning - Unix Shell scripting - Storing Data Analytics & BI Reporting Tool: (Spotfire, Vermilion Reporting, Tableau, Power BI, Informatica, Streaming Ingestion, Snowflag) - DWH/ETL: Creating WTX Systems, Maps, Type trees and IBM WebSphere TX - Design Studio **Specific Qualifications** - Knowledge and experience in the financial services domain - Good understanding of software development life cycle and Agile/iterative methodology - Prior experience in offshore-onshore development/maintenance projects **Technical Skills** **Skills Referential** **(** **Required knowledge, skills and abilities)** - Oracle SQL and PL/SQL in 19c or latest version - Storing Data Analytics & BI Reporting Tool: (Spotfire, Vermilion Reporting, Tableau, Power BI, Informatica, Streaming Ingestion, Snowflag) - DWH/ETL: Creating WTX Systems, Maps, Type trees and IBM WebSphere TX - Design Studio, Data Stage **Behavioral Skills** - Ability to deliver / Results driven - Ability to collaborate / Teamwork - Creativity & Innovation / Problem solving - Analytical Ability - Ability to understand, explain and support change - Ability to develop others & improve their skills - Ability to anticipate business / strategic evolution - Ability to develop and adapt a process Skill 1 **Education Level:** Bachelor Degree or equivalent **Location:** Chennai **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 soluti