Analyst - SQL/API Developer ( Consultant ) — Union Bancaire Privée

This position is no longer active. Below you'll find the original details and other open positions.

Full description

Mission

  • We are looking for a Developer Analyst to join the IT HR team as part of a strategic project to integrate Oracle HCM Cloud.
  • You will intervene on the reconstruction of the HR ecosystem currently connected to OHRMS. You will be responsible for your end-to-end interfaces: analysis of the existing one, design of the target solution, writing specifications, development, testing, coordination of contributors, production and stabilization.
  • This position requires a strong dual competence in analysis/design and development, as well as an ability to understand the functional, technical and overall architecture issues. You will work closely with the architectural, security, Talend, Control-M, DBA, Oracle HCM and business teams.
  • Mastery of Oracle, PL/SQL and API technologies is essential. The autonomy, the ability to be a force for proposals, the spirit of synthesis, the rigor and the direction of results are essential to succeed in this role.

Main tasks

  • Understand the current functioning of the OHRMS interfaces: data flow, management rule, transformations and controls, dependencies, impacts related to OHRMS replacement with Oracle HCM, conditions allowing run and eventually OHRMS decommissioning and other tools.
  • Analyze functional needs, technical constraints, identify and propose relevant solutions in the Oracle HCM ecosystem taking into account the requirements for performance, overall HR IS consistency and maintenance.
  • Coordinate and communicate with the various technical and functional contributors, follow the prerequisites and blocking points.
  • Write and maintain the functional and technical specifications of the interfaces, document flows, management rules and share with all technical contributors.
  • Realize developments and participate in the review of the Oracle / PL/SQL environmental code, participate in the implementation of API-based integration and all in compliance with standards of development, safety performance and maintenance.
  • Organize and run unit tests, then integrate with the flows end to end (ctrl-M / Talend) and finally UAT tests with the trade. Document in Jira / XRay tool the test results. Correct and perform non-regression tests.
  • Prepare the deployment and proper functioning of the interfaces in production, health check and participate in the stabilization of the interfaces after production.
  • Regular communication and reporting, proactive to the project team and contributors.

Profile sought

  • Advanced computer training or equivalent.
  • Experience in analysis, design and development of interfaces for IT projects or projects involving PL/ SQL.
  • Significant experience in IT integration or transformation projects.
  • Experience in complex environments involving multiple applications and contributing teams.
  • Experience in Human Resources or Oracle HCM / OHRMS solutions is an asset.
  • Languages spoken: French, English

Technical expertise

  • Very good command of Oracle and PL/SQL, good knowledge of relational databases and data manipulation.
  • Experience in designing and implementing interfaces.
  • Mastery or understanding of REST and SOAP API technologies; JSON and XML formats and exchange security mechanisms.
  • Knowledge of data transformation mechanisms such as Talend, scheduling tools such as Control-M.
  • Knowledge of monitoring and documentation tools such as Jira, Confluence.

Personal skills

  • Spirit of analysis and synthesis.
  • Autonomy and ability to handle a subject from end to end.
  • Rigor in design, documentation and monitoring.
  • Relationship relationship, Team spirit.
  • Targeted results and commitments.

Key competencies: Adherence to corporate values: commitment, conviction, agility and accountability Compliance with internal regulations and directives.

Job details

  • Company: Union Bancaire Privée
  • Position: Analyst - SQL/API Developer ( Consultant )
  • Location: Geneva, Switzerland, Geneva
  • Salary: CHF 63'000 - 107'500 (source unverified)
  • Sector: Banca / Gestione patrimoniale
  • Posted on: 2026-10-02
  • Expired on: 2026-11-13

More jobs at Union Bancaire Privée

Find jobs in Geneva

Browse our complete job board.

Search for more jobs near Geneva, Switzerland: Jobs in Geneva

Find your next opportunity as a cross-border worker in Switzerland.

Browse open positions →