AML Oracle Developer

Undelucram.ro on behalf of:

Luxoft Romania

Project description

We are building an AML Dashboard for customer compliance, transaction monitoring etc. Other teams inside Commerzbank need to gather information about their clients, needed for anti-money laundering verifications. In order to obtain the information needed, currently they are requesting data from different systems and this process is time-consuming.

To help them on their way to innovation and replace this “expensive” procedure, our team is developing this AML Dashboard. A high-level description of the use case is :

The analyst accesses the Financial Crime Manager with the need to gather information about a customer. The analyst can search for a customer using the name, customer id or account number and will receive information about the customer, its relation to other customers and products he is related to , transactions etc.

The following use cases are being implemented:

Customer search

Customer detail view

Accounts/products view

Confidential research and access management

Report generation

Responsibilities

Support the team and develop the functionalities mentioned in the Project Description. The Business requirements are very complex and as a team, we need to find the best solutions to implement them.

Ensure maximum resiliency, optimal performance, and constant availability of customer databases

Comprehensive and well-founded knowledge and experience in the areas of SQL, PL/SQL

Knowledge and experience with AWR and ASH

You develop IT concepts based on business specifications and implement them in an agile development process.

With an audit-proof documentation of your work (GIT, Jira and Confluence), you ensure a sustainable benefit for the company.

Ideally experience with Java in a JEE environment, in particular with regard to Java connections to a PL/SQL service environment

Skills

Must have

Oracle (EXADATA RAC DB with 2 Nodes)

SQL

ETL

Java

Nice to have

With an audit-proof documentation of your work (GIT, Jira and Confluence), you ensure a sustainable benefit for the company.

Ideally experience with Java in a JEE environment, in particular with regard to Java connections to a PL/SQL service environment

Experience in technologies: Shell scripting, JSON / XML

Other

Languages

English: B2 Upper Intermediate

Seniority

Senior

Key Skills

• Java
• SQL