Datamart Streamlead

Project Description**:

We've been engaged by a large Australian financial institution to provide resources to their Murex Testing team working on a wide range of projects from regulatory engagements, to binary upgrades.

We require an experienced Murex Datamart Streamlead to be part of the upcoming Murex Binary Upgrade project with the bank to work.

The role will suit a technical resource with extensive knowledge of Datamart.

Responsibilities:

• Understand the Murex system set up at the client, organization of the support teams, endofday procedures, and the report delivery process
• Collect and provide detailed technical specifications/business requirement specifications
• Participates in peer review of requirements, technical and testing documentation and assists mentors junior members with the same
• Analyse the datamart setup and the table structures for the purpose of identifying redundant objects, minimizing the execution time of batches, and to seek the possibility of reuse of objects
• Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution
• Develop a generic datamodel 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 Autosys
• Reconcile report extraction output with the onscreen / mreport output
• Analyse 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 escalate the issue well in advance
• Assists in the preparation and execution of test plans
• Identifies the conditions that create errors and escalate 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
• Coordinate with the development and infrastructure team for the availability of Mx environments and database
• Create and maintain a report delivery plan with relevant traceability

Skills:

Must have

• Total years of experience around 1012 years
• At least 810 years of experience on MX3.1 Datamart
• Previous experience in Murex binary upgrade implementation
• Understanding of the Murex system as a whole
• Good understanding of capital market products
• Indepth 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, a 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, preferably 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
• Very good knowledge of SQL (Sybase and Oracle), at least one reporting tool (Actuate, Crystal reports, Micro Strategy), Basic unix commands
• Understanding of the Trade Life Cycle
• Should possess an understanding of financial markets
• Basic knowledge of financial instruments such as Interest Rate Derivatives, Credit Derivatives, Currency Derivatives, Swaps, Futures, Options, FRA, etc.

Nice to have

• Murex knowledge around
• Pricing, Trade repository, Trade validation, MDCS, MxML exchange and workflows

Languages:

English:
C1 Advanced

Seniority:

Regular

Relocation package:

If needed, we can help you with relocation process.

Vacancy Specialization

Murex

Ref Number

VR-99788

---