Moody's Developer

Project description

Role is for an experienced Regulatory Reporting Developer to join their Finance Technology department which resides within Middle Office, Risk & Back Office Technology in with this Global Financial Institution
Responsibilities

• Develop efficient ETL routines using stored procedures and external tables to load the bank's data into the Moody's RAY datamart
• Aggregate large datasets using database technologies to load the data needed for risk computations
• Build batch processes using schedule software such as Control-M
• Provide support on the overnight batch and develop enhancements and improve efficiency where required.
• Collaborate with Business Analysts helping to define the solution, testing strategies and ensuring technical requirements have been incorporated into Functional Design Documents
• Work as part of the Finance Technology team providing day-to-day support of the Moody's Risk Authority investigating issues and resolving defects in a timely manner
• Work closely with the Regulatory Reporting team, Finance and Treasury to help answer adhoc queries/questions
• Have experience around regulatory reporting, BASEL III / IV regulation and appreciate components such as Liquidity Coverage Ratio, Counterparty Credit Risk, ALMM, PRA110 etc.
• Work closely with IT team on technical specifications & delivering software to the business. Carry out testing running end of day processing in Moody's Risk Authority to produce regulatory reports and work closely with end users in interpreting and validating test results
• Provide timely updates to stakeholders in terms of progress and status of issues
• Ensure change is compliant with strict change control policies and system changes are subjected to rigorous testing
• Work with the wider Technology support teams and ensure best practices are followed in design and architecture
• Help define test strategy and undertake unit and systems integration testing. Assist UAT testing and helping the user base to complete their tests and provide any summary or management KPI's
• Test functionality using Moody's RAY software and Control-M ensuring due diligence has been carried out prior to engaging user acceptance testing
• Package up artifacts using industry standard repositories such as SVN, SDA & TeamCity
• Work with BaU teams to ensure project changes are released to live in a co-ordinated manner
• Provide a level of post live support and remediate changes

Skills

Must have

• You will be working within Technology working alongside a number of IT teams and supporting the application. Key skills required include :
• Experienced Developer who has solid Oracle and Moody's application experience as well as some exposure and understanding of Regulation rules /templates and Moody's capability. Need to demonstrate a good understanding of Moodys RAY platform - for example: the underlying database tables used in Capital and Liquidity reporting.
• Experience working in Moody's Production BAU support team (the team need to manage batches , answer technical queries and support release management on weekly basis - raising cases to Moody's Client engagement team on bugs and defect that require additional support from Vendor)
• Worked with Oracle databases and be considered an expert in this field
• A strong understanding of database languages including SQL*Plus & PL/SQL
• Strong experience working with interfaces and have a good appreciation of ETL techniques and reporting technologies
• Experience of working in investment banking with an understanding of trade and instrument data
• In-depth knowledge of performance tuning Oracle database queries and processes
• Experience with other regulatory application software such as Axiom, Vermeg, Abacus 360 etc
• Experience of working on scheduling software such as Control-M, Autosys, Tivoli etc
• Manage enhancement requests through writing specifications for the technical development team
• Test the software either through Systems Integration Testing or through working with the business on User Acceptance Testing. This includes all phases of the test cycle including writing test scripts, executing tests, capturing defects, re-testing etc...
• Have experience working with interfaces, understanding the challenges around data flow, transformation, transportation, reconciliation etc...
• Understand the project life cycle with a clear appreciation of scope and be adept at understanding the different approaches and methodologies used to deliver large scale change in manner which minimises business disruption
• Provide timely updates to stakeholders in terms of progress and status of issues
• Understanding of the BASEL regulatory framework including COREP reporting and Liquidity reporting.
• 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 experience working on test strategies, test plans, test scripts and documenting test cases used to ensure software is rigorously tested and fit for release to production