IBM MDM ARCHITECT

This is a remote position.

Object Technology Solutions Inc (OTSI) has an immediate opening for an IBM MDM ARCHITECT

IBM MDM ARCHITECT (REMOTE )

MAJOR RESPONSIBILITES:

Own data quality matching logic and golden record creation

Strong experience in Master Data Management (MDM)

Hands-on with:

Matching & deduplication strategies

Golden record creation

Experience tuning:

False positives / false negatives

Knowledge of:

Phonetic matching (Soundex etc.)

Data quality rules

Key Responsibilities

Define and tune matching algorithms

Identify and fix:

Duplicate records

Data inconsistencies

Work with business teams to:

Define matching rules

Handle edge cases

Validate new data sources and ingestion logic

Define data quality metrics & SLAs

Good to Have

Experience with tools like:

Informatica MDM / Reltio / IBM MDM

Exposure to SQL

The right fit is looking for IBM MDM (virtual) guy who is able to move on-prem MDM to cloud with kubernetes and they would need Java knowledge

Conduct comprehensive reviews of the current MDM ecosystem including matching and linking algorithm performance duplicate and suspect processing and custom extensions.

Evaluate and enhance logging monitoring backup and recovery processes to ensure system reliability and resiliency.

Assess and optimize transaction/query SLAs and index performance identifying and addressing known issues such as bucket overflows and bulk-load mechanism gaps (including DataStage constraints).

Design develop and maintain Java code for MDM algorithms data processing and integration components ensuring code is performant scalable and maintainable.

Refactor and optimize existing Java code and write unit integration and system tests for all Java components.

Adjust matching algorithm thresholds to minimize false positives/negatives and add/test new matching attributes (e.g. email last name phone combinations).

Assess and implement phonetic matching techniques (e.g. Soundex) and lead feasibility studies to determine the need for single or multi-algorithm approaches for different business lines.

Perform sample pairing for new data sources collaborating with business teams to identify edge cases and refine algorithm behavior including store-identifier-based auto-matching where applicable.

Review and enhance frequency-based and dynamic bucketing strategies assess passive execution options to minimize production impact and validate interactions with STR tables and existing buckets.

Develop and document bulk load strategies including ingestion options with and without entity management/event handlers; explore disabling matching for high-volume ingestion scenarios (e.g. 200M records) and evaluate alternative ingestion patterns beyond API-only approaches.

Capture and report on metrics SLAs and trade-offs for each ingestion strategy.

Target <2 seconds for matching response time through iterative tuning must-gather data analysis and leveraging load testing tools (e.g. JMeter); review reconciliation SLAs as part of ongoing optimization.

Address deployment challenges such as outages and unpredictable environment behaviors; explore and implement CICD or improved deployment automation; review and optimize configuration code and deployment steps for efficiency.

Plan and implement Auth/PingFed-based authentication reduce reliance on process IDs and passwords automate credential rotation and maintain a dedicated Security category in the scope documentation.

Ensure all code adheres to coding standards and guidelines.

SKILLS AND ABILITIES REQUIRED

Java 21 (core and advanced) including object-oriented programming and multithreading

Master Data Management (MDM) platforms and tools

Algorithm development for data matching linking and deduplication (including phonetic algorithms like Soundex)

Data integration frameworks and ETL tools (e.g. DataStage)

SQL and database optimization (indexing query tuning bulk operations)

Performance tuning and system health monitoring for large-scale data systems

Logging monitoring backup and recovery solutions

Load testing tools ()

CI/CD pipeline tools and deployment automation (e.g. Jenkins GitHub)

Secure coding practices including Auth authentication and credential management

Micro services API development and integration (e.g. RESTful services)

Unit integration and system testing frameworks (e.g. JUnit Mockito)

Documentation tools (Confluence GitHub DX Guides)

MDM Modernization

Migration from on-premises infrastructure to the cloud

Adoption of containerization for deployment and scalability