Murex Datamart Consultant

DA SOFTWARE PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

DA SOFTWARE PTE. LTD. is seeking an experienced MX3.1 Datamart specialist to join our Murex reporting team in Singapore.

You will understand the Murex setup, collaborate with client teams, and contribute to the design of Datamart objects and reports. The role requires strong SQL skills, familiarity with reporting tools, and a solid grasp of capital markets products. You will mentor juniors, review requirements, and optimize batch processing with Control-M.

Qualifications

• 7+ years of MX3.1 Datamart experience.
• Deep understanding of the Murex system and capital markets.
• In-depth knowledge of MX reporting architecture, MX datamodel, and MX Datamart configuration.
• Familiarity with MXRes configuration files and launcher flags.
• Thorough knowledge of Datamart objects—dynamic tables, feeders, batch of feeders, scanner templates.
• Exposure to Mreports; migration from Mreport to Datamart is desirable.
• Experience with Simulation and Risk Matrices.
• Experience with Market risk and credit risk report development; experience with Oracle and Sybase.

Responsibilities

• Understand the Murex system setup, client teams, end of day procedures, and the report delivery process.
• Collect and provide detailed technical specifications and business requirement specifications.
• Participate in peer review of requirements, technical and testing docs, and mentor juniors.
• Analyze Datamart setup and table structures to minimize batch execution time and promote reuse.
• Segregate reports by users, products, creation classes, fields, complexity and frequency.
• Develop a generic data model and create Datamart objects as required for reports.
• Execute processing scripts and batches manually or via Control-M.
• Reconcile report outputs with onscreen and MReport outputs.
• Analyze differences from filters/flags and launcher changes.
• Create templates and tools to streamline development, testing and implementation.
• Analyze issues during planning and test phases.
• Provide accurate defect info and help reproduce errors.
• Prepare and send timely status reports and track testing progress.
• Escalate issues/risks to team lead promptly.
• Assist team lead with effort estimation for development and UAT.
• Ensure test documentation aligns with defined standards.

Skills

MX3.1 Datamart

Murex system knowledge

SQL (Sybase/Oracle)

Unix shell scripting

Risk/Market data reporting

Actuate eRD Pro / reporting tools

Datamart data modeling

Financial instruments (FX/Derivatives)

Tools

Control-M

Oracle

Sybase

Actuate eRD Pro

Crystal Reports

MicroStrategy

Job description

Responsibilities:

• - Understand the Murex system setup at the client, organization of the support teams, end of day procedures and the report delivery process
• - Collect and provide detailed technical specifications/business requirement specifications
• - Participates in peer review of requirements, technical, and/or testing documentation and assists mentors junior members with same
• - Analyze Datamart setup and the table structures for the purpose of identifying redundant objects, to minimize execution time of batches, and to seek possibility of reuse of objects
• - Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution
• - Develop a generic data model and then create Datamart objects as required for the reports
• - Execute processing scripts and batches manually or through the use of a scheduling tool like Control-M
• - Reconcile report extraction output with the onscreen / mreport output
• - Analyze differences caused by adding or removing some filter conditions / dynamic table flags/launcher flags
• - Create and suggest processes, templates and tools to streamline the development, testing and implementation phases
• - Analyses issues during planning and test execution phases
• - Provide relevant and accurate information about defects and help the business reproduce errors
• - Prepare and send effective periodic and timely status reports
• - Track the testing progress and escalates outstanding issues for clarification and resolution
• - Escalates identified issues/risks in a timely fashion to the team lead.
• - Assist team lead with effort estimation related to the development and UAT
• - Ensures test documentation and deliverables are consistent with defined standards

Mandatory Skills Description:

• - 7+ years of experience on MX3.1 Datamart
• - Understanding of the Murex system as a whole
• - Good understanding of capital market products
• - In-depth understanding of MX reporting architecture, MX datamodel, and MX Datamart configuration
• - Familiarity with MXRes configuration files, and launcher flags
• - Thorough knowledge of Datamart objects - dynamic tables, feeders, batch of feeders, scanner templates etc.
• - Exposed to Mreports; Mreport to Datamart migration experience is desirable
• - Experience with Simulation and Risk Matrices
• - Experience with Market risk and credit risk report development- Experience with RDBMS, e.g., Oracle, Sybase
• - Excellent SQL programming skills
• - Unix experience necessary; shell programming experience highly desirable; awk, sed, and Perl scripting experience would be a bonus
• - Experience with at least one reporting tool, preferentially Actuate eRD Pro
• - Other programming experience a plus, esp MS Excel VBA
• Product knowledge (Any one or more, FX mandatory) - FX, IRD, FI, EQD, CRD

Technical skills

• - Very good knowledge of SQL (Sybase and Oracle), at least one reporting tool (Actuate, Crystal Reports, MicroStrategy), basic Unix commands
• - Understanding of Trade Life Cycle
• - Should possess an understanding of financial markets
• - Basic knowledge on financial instruments such as Interest Rate Derivatives