Oracle Data Integrator (ETL Tool) & SQL Developer(5-8yrs)

January 30, 2024

Oracle Data Integrator (ETL Tool) & SQL Developer(5-8yrs)

ReferenceCIB008196

  • Standard / Permanent
  • IN-MH-Mumbai
  • INFORMATION TECHNOLOGY
Apply for this job

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

About Business line/Function:

ALMT function is responsible for Asset Liabilities management and treasury activity of BNP Paribas. It also handles Bank’s funding needs and risk management activities. ALMT IT is a Deal Capture & Deal Processing Application catering to IT demands of ALMT functions within the bank.

ALMT IT Data Management Team is in charge of supporting all Reporting and Data Warehouse applications build using SAP BI4 Solution with Sybase IQ as Data warehouse. This is used by ALM-Treasury (Traders, Sales, MO, etc.)

Job Title:

Sr. Software Engineer

Date:

01-March-2024

Department:

ALMT IT

Location:

ISPL Mumbai

Business Line / Function:

ALMT IT

Reports to:

(Direct)

Team Lead/Project Manager

Grade:

(if applicable)

(Functional)

Number of Direct Reports:

NA

Directorship / Registration:

NA

Position Purpose

Current position is under ALMT IT Data Management Team scope to contribute in individual capacity on development, enhancements, and maintenance & support activities for multiple applications.

Responsibilities

 

Direct Responsibilities

·         Application designing / development / testing / support / enhancements / bug fixing.

·         Interact with functional and technical representatives of project teams in order to understand business functionalities, technical modules, integration mechanism and data sources.

·         Prepare test plans and conduct Unit & Regression Testing.

·         Create prototype for proof of concept and business requirements validations.

·         Ensure that the project and organization standards are followed during various phases of software development lifecycle and day-to-day development work.

·         Estimate efforts, schedule for various modules, and meet deadlines.

·         Technical and Release Documentation

·         To participate in out-of-hours / daytime support as required

·         To work with teams to help solve complex technical problems.

Contributing Responsibilities

·         Contribute towards innovation, suggest new technical practices to be implemented.

·         Contribute towards initiatives to improve processes and delivery efficiency.

·         Contribute towards recruitment efforts – both for the team as well as for the organization

Technical & Behavioral Competencies

Mandatory Technical Skills:

·         Strong knowledge on Oracle Data Integrator 12c (ODI) ETL tool.

·         Strong knowledge on implementation of data warehouse in ODI ETL (Worked extensively in developing Data Extraction, Data Import, Transformation and Loading using ODI tool )

·         Strong knowledge on Database SQL query writing (complex SQL queries with multiple joins, Procedural programming like Procedure & Functions, Performance tuning, etc.)

·         Experience in Technical analysis and Data warehouse designing.

·         Ability and willingness to learn and work on diverse technologies (languages, frameworks, and tools)

·         Good knowledge of version control tools, preferably Bitbucket

Nice to have Skills:

 

·         Experience on BI4 Webi Report Designer, BI4 Universe Designer

·         Experience on Linux/ Unix environment including Shell Scripting

·         Exposure to Financial Domain.

Specific Qualifications (if required)

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Ability to collaborate / Teamwork

Ability to deliver / Results driven

Critical thinking

Creativity & Innovation / Problem solving

Transversal Skills: (Please select up to 5 skills)

Ability to understand, explain and support change

Ability to develop others & improve their skills

Analytical Ability

Choose an item.

Choose an item.

Education Level:

Bachelor Degree or equivalent

Experience Level

At least 5 years

Other/Specific Qualifications (if required)

Offers you may be interested in