Fusion Practices - Reporting Developer - Oracle DB/PL-SQL

About Us

Responsibilities

• Work within a project team to help deliver IT change within the regulatory accounting space.
• Work closely with the project team and Finance on change and development tasks .
• Develop new functionality or enhancements using Oracle database technologies including PL/SQL based packaged procedures, functions, VPD, views, materialised views, common database APIs, SQL-Loader routines etc
• Ensure database development is in-line with modern Oracle database development practices and database optimisation, throughput, scale and efficiency have been factored in the design of the build.
• Have a willingness and skills to analyse financial data, run queries and provide summarised extracts to business analysts.
• Documenting development through technical design documents, installation documents, unit test cases etc
• Provide timely updates to stakeholders in terms of progress and status of issues.
• Work with Oracle support, raising SRs if required and providing diagnostic information when required.
• Ensure all development is compliant with MUSI change control and information risk policies.
• Communicate with wider technology teams to ensure fixes or enhancements are executed in a controlled and co-ordinated :
• Extensively worked with database management systems such as Oracle and be considered an expert in this field.
• A strong understanding of database languages including SQL-Plus & PL/SQL.
• Ideally have experience with working on Financial accounting systems.
• Strong experience working with interfaces and have a good appreciation of ETL techniques, ideally Informatica.
• Have been involved with project implementations with a solid understanding of the project life cycle and different implementation techniques.
• Pay great attention to detail and be client driven with a focus on delivery and milestones.
• Have exceptional communication skills, being able to converse with a wide variety of stakeholders including department heads.
• Have exposure working with scheduling software such as Control-M, Autosys, Tivoli etc.