Oracle Developer

Project descriptionWe 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 searchCustomer detail viewAccounts/products viewConfidential research and access managementReport generationResponsibilitiesSupport 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 databasesComprehensive and well-founded knowledge and experience in the areas of SQL, PL/SQLKnowledge and experience with AWR and ASHYou 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 environmentSkillsMust haveOracle (EXADATA RAC DB with 2 Nodes)SQLETLJavaNice to haveWith 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 environmentExperience in technologies: Shell scripting, JSON / XML

Key Skills

• Java