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
- Business Analyst — Genève
- Network engineer - Consultant — Genève
- IT BA Compliance Risk — Genève
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.