Murex Datamart Developer

Two95 International Inc.; Kuala Lumpur; On-site; MYR 100,000 - 150,000; Full time

Job summary

Join a leading bank in Singapore as a key player in their Mx.3 migration journey. This role involves leveraging your expertise in Murex and MX reporting to develop essential reports across various user streams, including Front Office and Market Risk. You'll be at the forefront of enhancing reporting processes, collaborating with support teams, and mentoring junior members. If you're passionate about financial markets and have a strong background in SQL and reporting tools, this opportunity offers a dynamic environment to make a significant impact in the banking sector.

Qualifications

• 3-5 years of experience with MX3.1 Datamart and Murex system.
• Excellent SQL skills and knowledge of capital market products.

Responsibilities

• Understand the Murex system setup and report delivery process.
• Develop datamodels and create datamart objects for reports.
• Prepare and send effective periodic status reports.

Skills

MX3.1 Datamart

Murex system understanding

Capital market products knowledge

MX reporting architecture

SQL programming

Unix experience

RDBMS experience (Oracle, Sybase)

Financial instruments knowledge

Report development (Market risk, credit risk)

Shell programming

Tools

Actuate eRD Pro

Control-M

Job description

Project Description:

A leading bank of Singapore is continuing on its Mx.3 migration journey and incorporating the Bank's report development requirement to cover various user streams such as Front Office, Back Office, Market Risk, Finance, and credit risk related end user or interfaces reports.

Skills required:

1. 3-5 years of experience on MX3.1 Datamart
2. Understanding of the Murex system as a whole
3. Good understanding of capital market products
4. In-depth understanding of MX reporting architecture, MX datamodel, and MX Datamart configuration
5. Familiarity with mxres configuration files, and launcher flags
6. Thorough knowledge of Datamart objects - dynamic tables, feeders, batch of feeders, scanner templates etc.
7. Exposed to Mreports; Mreport to Datamart migration experience is desirable
8. Experience with Simulation and Risk Matrices
9. Experience with Market risk and credit risk report development
10. Experience with RDBMS, e.g. Oracle, Sybase
11. Excellent SQL programming skills
12. Unix experience necessary; shell programming experience highly desirable; awk, sed, and Perl scripting experience would be a bonus
13. Experience with at least one reporting tool, preferably Actuate eRD Pro
14. Other programming experience a plus, esp MS Excel VBA
15. Product knowledge (Any one or more, FX mandatory) - FX, IRD, FI, EQD, CRD
16. Technical skills - Very good knowledge of SQL (Sybase and Oracle), At least one reporting tool (Actuate, Crystal reports, Micro Strategy), Basic unix commands
17. Understanding of Trade Life Cycle
18. Should possess an understanding of financial markets
19. Basic knowledge on financial instruments such as Interest Rate Derivatives, Credit Derivatives, Currency Derivatives, Swaps, Futures, Options, FRA, etc.

Nice To Have:

1. Murex knowledge around - Pricing, Trade repository, Trade validation, MDCS, MxML exchange and workflows
2. Technical skills - PL/SQL, Shell scripting, Java, Excel VBA

Responsibilities:

1. Understand the Murex system setup at the client, organisation of the support teams, end of day procedures and the report delivery process
2. Collect and provide detailed technical specifications / business requirement specifications
3. Participate in peer review of requirements, technical and/or testing documentation and assist in mentoring junior members
4. Analyse datamart setup and the table structures for the purpose of identifying redundant objects, to minimise execution time of batches, and to seek possibility of reuse of objects
5. Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution
6. Develop a generic datamodel and then create datamart objects as required for the reports
7. Execute processing scripts and batches manually or through the use of a scheduling tool like Control-M
8. Reconcile report extraction output with the onscreen / mreport output
9. Analyse differences caused by adding or removing some filter conditions / dynamic table flags / launcher flags
10. Create and suggest processes, templates and tools to streamline the development, testing and implementation phases
11. Analyse issues during planning and test execution phases
12. Provide relevant and accurate information about defects and help the business reproduce errors
13. Prepare and send effective periodic and timely status reports
14. Track the testing progress and escalate the issue well in advance
15. Assist in the preparation and execution of test plans
16. Identify the conditions that create errors to occur and escalate outstanding issues for clarification and resolution
17. Escalate identified issues/risks in a timely fashion to the team lead
18. Assist team lead with effort estimation related to the development and UAT
19. Ensure test documentation and deliverables are consistent with defined standards
20. Coordinate with development and infrastructure team for availability of Mx environments and database
21. Create and maintain report delivery plan with relevant traceability
22. Have excellent communication skills, both written and oral