Analyst - SQL/API Developer ( Consultant ) — Union Bancaire Privée
- Location
- Genève
- Contract
- Full-time
- Posted
- 32 days ago
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.
Questions about this listing
What salary does Union Bancaire Privée offer for this role?
The original listing does not state a salary. Our estimate for this role and sector in Genève is CHF 63'000 - 107'500 gross per year — an estimate, not a figure communicated by Union Bancaire Privée. The calculator on this site converts a gross salary into your actual net take-home once cross-border tax and social contributions are applied.
Is this a full-time role, and what type of contract does Union Bancaire Privée offer?
This listing is a full-time position. The contract type shown here comes directly from the employer's original posting; always confirm exact hours, notice period and probation length with Union Bancaire Privée during the application process, since these details can vary by role even within the same contract category.
Do I need a cross-border work permit for a role in Geneva?
EU/EFTA citizens living in an EU/EFTA state can apply for a G permit and can work anywhere in Switzerland: border zones no longer apply to them, and they must return home at least once a week. The Swiss employer files the request with Canton Geneva's migration office after the contract is signed. Processing times vary by canton, so confirm the specifics with Geneva's cantonal migration office or with HR during the application.
How do I apply for this position at Union Bancaire Privée?
Use the "Apply now" button on this page — it links directly to Union Bancaire Privée's original listing at ubp.com, so your application goes straight to the employer's own applicant-tracking system. Frontaliere Ticino does not collect or forward applications itself.
