Ispl - Itg Fresh - Ofsaa Dev

About BNP Paribas Group:
BNP Paribas is a top-ranking bank in Europe with an international profile. It operates in 71 countries and has almost 199000 employees. The Group ranks highly in its three core areas of activity: Domestic Markets and International FinancialServices (whose retail banking networks and financial services are grouped together under Retail Banking & Services)and Corporate & Institutional Banking, centred on corporate and institutional clients. The Group helps all of its clients(retail, associations, businesses, SMEs, large corporates and institutional) to implement their projects by providing them with services in financing, investment, savings and protection. In its Corporate & Institutional Banking and International Financial Services activities, BNP Paribas enjoys leading positions in Europe, a strong presence in the Americas and has a solid and fast-growing network in the Asia/Pacific region.
About BNP Paribas India Solutions:
Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, a leading bank in

Europe 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 6000 employees, to provide support and develop best-in-class solutions
About Business line/Function:
The Intermediate Holding Company (“IHC”) program structured at the U.S. level across poles of activities of BNP Paribas provides guidance, supports the analysis, impact assessment and drives adjustments of the U.S. platform’s operating model due to the drastic changes introduced by the Enhanced Prudential Standards (“EPS”) for Foreign Banking Organizations (“FBOs”) finalized by the Federal Reserve in February 2014, implementing Section 165 of U.S. Dodd-Frank Act.

Job Title:
OFSAA Developer

Date:
13/04/2020

Department:
ITG - FRESH

**Location**:
Mumbai

Business Line / Function:
IHC

Reports to:
(Direct)

Grade:
(if applicable)

(Functional)

Number of Direct Reports:
Directorship / Registration:
NA

**Position Purpose**:
OFSAA Developer is required for IHC OFSAA platform.

The person would be coordinating with North America Onshore Team consisting of Developers and Business Analysts.

**Responsibilities**

**Direct Responsibilities**:

- Work with OFSAA development team to implement the OFSAA and DB objects.
- Write technical specs related to this implementation
- Work closely with other development teams and other DB architect and developers to set up interfaces and procedures by following the best practices / conventions within the team (including peer code review).
- Consult with users, management, and technical personnel to clarify business requirements, identify problems, and suggest changes / best practices.
- Write / analyze functional requirements, then propose reporting solutions to them based on BNPP standard systems. Write technical specifications and perform workload and risk analysis related to these solutions

**Technical & Behavioral Competencies**:
**Primary skills (mandatory)**
- Implementation experience with OFSAA solutions.
- Data warehousing Implementation with dimensional data modeling skills on at least one of the following databases : Oracle, MS SQL-Server, DB2
- Understanding of standard n-tier systems architecture systems processes and principles
- Ability to read and edit Unix shell script files
Ability to read and edit XML and properties files
- Experience with Unix (Solaris, Linux, AIX) operating systems and associated hardware platforms and peripherals
- Working knowledge of Oracle databases and data warehouses
- Strong Programming work experience in PL/SQL
- Understanding of dimensionality and normality database concepts
- Understanding of system security principles, specifically around user authorization and authentication methods and technologies
- Strong customer interaction skills and the ability to assess a client’s IT processes and strategies. In addition, must be able to lead clients through the process of integrating the OFSAA suite solutions into their operational environment.
- Mature, self-starting, self-motivating, and capable of making decisions independently

**Secondary skills / knowledge (desirable)**
- Exposure to any of the following tools Informatica, Datastage, Abinitio, Oracle BI Tools, PL/SQL Server BI tool set, Business Objects, Cognos, ERWIN
- Good understanding of Databases (Oracle, DB2, Exa Data)
- Working knowledge of job scheduling products such as AutoSys and ControlM with Oracle database.
- Knowledge of any of the Web Servers like Websphere, Weblogic etc
- Exposure in BFSI Domain.
- Excellent English written and oral communication skills.

**Specific Qualifications (if required)**:

- Bachelor's or Master's de