Senior Datamart Developer

General Responsibility:

Self-driven and able to delegate work to team members

Able to review work from team members

Strong analytical 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 the 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 the 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 discussions