AI & Data - Data Architect (Murex)

ZENITH INFOTECH (S) PTE LTD.; Singapore; On-site; SGD 89,000 - 134,000; Full time

Job summary

Zenith Infotech (S) Pte Ltd. seeks a Murex Migration Specialist to support end-to-end data migration for MX.3 based banking transformations. You will perform data extraction, mapping, ETL scripting, loading into MX.3, reconciliation and testing under the Migration Lead.

The role requires hands-on delivery across the migration lifecycle, including source data profiling, data quality checks, and issue triage in collaboration with stakeholders.

Qualifications

• Experience with MX.3 migration and data loading processes.
• Proficient in SQL/PL-SQL for data manipulation and testing.
• Ability to profile source data and document mapping rules.
• Develops and runs ETL scripts for data extraction, transformation and load.
• Performs data reconciliation and issue resolution with stakeholders.

Responsibilities

• Extract data from legacy systems per migration plan.
• Profile data quality and document findings for review.
• Maintain source-to-target data mappings and mapping docs.
• Develop ETL scripts and load data into MX.3 staging areas.
• Monitor jobs, log errors, and resolve or escalate issues.
• Perform reconciliation between migrated MX.3 data and source records.

Skills

MX.3 migration

SQL/PL-SQL

ETL scripting

Data reconciliation

Data mapping

Python

Shell scripting

Source system analysis

Stakeholder support

Tools

MxML Exchange

Bulk loading utilities

Sybase

Oracle

Job description

Zenith Infotech (S) Pte Ltd. was started in 1997, primarily with the vision of offering state-of-the-art IT Professionals and solutions to various organizations and thereby helping them increase their productivity and competitiveness. From the deployment of one person to formation of whole IT teams, Zenith Infotech has helped clients with their staff augmentation needs. Zenith offers the opportunity to be engaged in long term projects with large IT savvy companies, Consulting organizations, System Integrators, Government, and MNCs.

Roles and Responsibilities:

The Murex Migration Specialist works within the Migration workstream to support the end-to-end delivery of data migration activities on a Murex MX.3 banking transformation programme. Reporting directly to the Migration Lead, the role covers hands-on execution across the migration lifecycle - source data extraction, mapping, ETL scripting, data loading into MX.3, reconciliation, and testing.

This is a delivery role.

KEY SKILLS AT A GLANCE

• MX.3 Trade History Loading - Data Reconciliation & Break Investigation
• Static Data Migration (Counterparty, Instrument) - ETL Script Execution & Monitoring
• SQL / PL-SQL (Sybase & Oracle) - SIT / UAT Migration Testing
• Data Mapping & Transformation Logic - Issue Logging & Triage
• Source System Data Extraction - Requirements Documentation
• Data Quality & Cleansing - Stakeholder Support & Reporting

MIGRATION DATA SCOPE COVERAGE

• Trade History Loading - open positions, historical trades, and book-level balances across all asset classes into MX.3
• Static & Reference Data - counterparties, legal entities, portfolios, books, instruments, and standing settlement instructions (SSIs)
• Market Data Seeding - rate curves, volatility surfaces, FX spot rates, credit spreads, and dividend schedules needed for valuation at the migration date
• Limit & Credit Data - credit line structures, counterparty limit configurations, and utilisation data required for MX.3 Credit Risk at go-live
• P&L Baseline - migrated P&L positions, accrual balances, and mark-to-market values required by Finance for continuity of accounting records at cutover
• Interface Reconciliation - validating that data flowing from external systems (nostro, cash, collateral) into MX.3 via interfaces is complete, timely, and correctly mapped

KEY RESPONSIBILITIES

• Data Extraction & Source System Analysis
  • Extract data from legacy source systems under the direction of the Migration Lead, working to agreed extraction schedules and formats across all in-scope data tracks.
  • Profile source data to identify quality issues, missing fields, duplicates, and format inconsistencies, and document findings clearly for review by the Migration Lead.
  • Maintain source-to-target data mapping documentation, keeping it up to date as configuration decisions are made in MX.3 or as source system data changes.
  • Liaise with legacy system owners and data custodians to understand data structures, resolve extraction questions, and obtain data samples needed for mapping and testing.
• ETL Development & Migration Loading
  • Write and maintain SQL scripts, Shell scripts, and Python routines for data extraction, transformation, cleansing, and loading tasks across assigned migration tracks.
  • Execute migration loads into MX.3 staging environments using MxML Exchange import workflows and bulk loading utilities, following the runbook and escalating errors to the Migration Lead.
  • Monitor migration job execution, capture error logs, and investigate failed records - categorising issues by root cause and either resolving them directly or escalating with a clear summary.
  • Implement data transformation logic as defined in mapping specifications, including cleansing rules, format conversions, defaulting logic, and enrichment from reference data.
  • Maintain migration control tables and audit logs to track record-level load status, error counts, and resolution outcomes across each batch run.
• Data Reconciliation & Quality Checks
  • Run reconciliation checks between migrated MX.3 data and source system records at each migration milestone - trade counts, notional values, market values, P&L figures, and static data attributes.
  • Investigate reconciliation breaks, trace them back to their source (mapping error, transformation gap, MX.3 configuration issue, or source data problem), and document findings with proposed fixes.
  • Apply data quality validation rules within the migration pipeline to catch records that fail business rule checks before they are loaded into MX.3.
  • Support the interface reconciliation workstream by validating that data arriving in MX.3 from external systems (nostro, cash positions, collateral) is correctly received, mapped, and represented in MX.3 - noting that these flows are owned by the Integration workstream, not migrated directly.
  • Keep the reconciliation log and issues tracker up to date, flagging unresolved breaks to the Migration Lead with enough context for them to ma