Job Title

Mandatory Skills Description: − Avaloq Certified Professional (ACP) with 6-10 years' experience in customisation and implementation of Avaloq Banking System. − Good understanding of banking operations, trade lifecycle and investment/ superannuation products. − Good understanding of relational databases (preferably Oracle and PL/SQL) − Subject matter expert of several Avaloq modules (Functional and Technical) − Lead Avaloq deliveries of a specific stream adhering to Avaloq standards, best practices and quality guidelines. − Lead Avaloq solution design and program initiatives of the platform. − Perform Avaloq design review and code audits. − Expert skills with Avaloq development tools ICE and SQL Developer as well as Avaloq change life cycle. Prior Experience working with Avaloq Database Automation and Integration (ADAI) will be advantageous. − Expert parameterisation skills in core Avaloq concepts: Avaloq scripts, Cost & Fees, Order Validations & workflow management, Book and Balance engines, Avaloq messaging interface (AMI), Task and Reporting framework etc.. − Strong Understanding of Avaloq concepts such as EOD, Pillars and Rule loading. − Experience with Avaloq smart client and functional understanding of various modules (Forms, Task and reporting desk, Central Services, Portfolio desk etc.) − Hands on experience with SQL tuning and performance tuning of Avaloq codes through SQL Trace and PL/SQL Hierarchical Profile (HPROF) − Review codes of more junior Avaloq developers. Ability to validate end to end solution design and impact to various Avaloq modules. − Strong understanding of Avaloq release management processes such as creating streams/releases and creating Avaloq packages for installation. Hands on experience in Avaloq release management processes and Unix scripting will be advantageous for an Avaloq release management role. − Expert problem solving and troubleshooting skills of Avaloq banking system. Ability analyse Avaloq installation logs and underlying Oracle schema of ABS. − Experience in raising / managing Avaloq kernel issues through Avaloq issue management tool.