Understand the Murex system setup at the client, organisation 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- 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- 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 Control-M- 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**Requirements**:- At least 6+ 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, 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- Technical skills - Very good knowledge of SQL (Sybase and Oracle), Atleast one reporting tool (Actuate, Crystal reports, Micro Strategy), 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, Credit Derivatives,Currency Derivatives,Swaps, Futures, Options, FRA, etc.
