Lead Datamart Developer

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/business requirement specifications
• Participates in peer review of requirements, technical and/or 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 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 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 team s domain and application knowledge through formal/informal sessions or discussion

Must have

• 8+ years of Murex Development experience
• Minimum 6 Years of Murex Data Mart experience on 3.1
• Knowledge of Sybase DB
• Expert understanding of Murex DataModel, Dynamic Tables, and Viewers
• Knowledgeable in Unix shell scripting on Solaris
• Experience in applying MX.3 DataMart and SQL optimization techniques
• Experience in MX.3 DataMart batch creation and scheduling
• Experience in creating test cases for SIT and UAT Testing
• Experience in Datamart/EOD solution design and effort estimation with limited support required

Nice to have

• Functional understanding of capital markets
• Experience in other Murex modules