DataMart Developer

Job Description

General Responsibility: Self-driven and able to delegate work to team members Able to review work from team members Strong analytic and technical skills Good understanding of the usage of various dynamic tables Good knowledge of one or more development tools Able to configure, execute, and troubleshoot batch reports in MXG Able to design and optimize the usage of dynamic tables Able to guide team members Ensure all deliverables are good and timely Able to escalate issues/risks in a timely manner to the supervisor Good communication skills Able to work with both technical and business stakeholders Murex Application Responsibility: Understand the Murex system set up at the client, organization of the support teams, end-of-day procedures, and the report delivery process Collect and provide detailed technical specifications and business requirement specifications Participates in peer review of requirements, technical, and/or testing documentation and assists mentor 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 seeking the 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 / report 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 to occur 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 Have excellent communication skills, both written and oral Try to increase the teams domain and application knowledge through formal/informal sessions or discussion Skills Must have Minimum 8-10 Years of Murex Datamart experience on Murex 3.1 8+ years of Murex Development experience Good exposure to Datamart architecture and solution design Some experience with EOD/CTRL-M or Autosys scheduling Advanced SQL Advanced financial market understanding covering different asset classes Unix Nice to have DevOps on Murex experience (GIT, Jenkins, JIRA, etc). Technical solution design experience and start-to-end solution ownership Understanding of other Murex modules and/or other financial markets applications.