OTSI

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 QUALIFICATIONS AND EXPERIENCE · 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 (e.g.,JMeter) · 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

Role Description We are seeking a Solutions Architect with deep hands-on expertise across software engineering, data platforms, AI and ML, and cloud architecture. This role blends technical leadership, presales strategy, and hands-on solution design, partnering closely with Sales, Product, and Delivery teams to shape high value customer opportunities and modernize enterprise data and AI ecosystems. - Design end-to-end software solutions including application architecture, integration patterns, and cloud native design for client projects and in-house R&D initiatives. - Architect and deliver modern data platforms using Microsoft Fabric, Databricks, Snowflake, or hybrid combinations, including data warehouses, semantic models, and enterprise data architectures aligned to analytics and AI use cases. - Develop cloud architectures across Azure, AWS, and GCP balancing innovation, scalability, and cost efficiency. - Provide hands-on technical leadership across development, data engineering, AI and ML, and analytics workloads. - Architect and implement AI/ML solutions using popular LLM ecosystems including building/fine-tuning models, developing AI-powered applications, and integrating generative AI into enterprise workflows. - Lead the technical evaluation phase during sales cycles partnering with Sales and Presales to shape deal strategy, define solution scope, and build compelling technical narratives. Qualifications - 5+ years designing cloud-native software solutions and architectures on Azure, AWS, or GCP. - 6+ years working with Big Data technologies such as Apache Spark, Hadoop, Cassandra, and distributed compute frameworks. - Hands-on experience designing data platforms using Databricks, Microsoft Fabric, and Snowflake (emphasis on Fabric and Databricks), including data modeling, data warehousing, and enterprise data architecture. - Deep knowledge of the SDLC, engineering best practices, and modern development patterns. - Technical experience designing, developing, and integrating AI/ML solutions including large language models (OpenAI, Llama, custom models), vector search, prompt engineering, and building AI-powered applications. Requirements - 5+ years in client-facing presales, consulting, or solution architecture roles. - Strong ability to translate complex technical concepts into clear, compelling business value with executive presence across technical and business stakeholders. - Experience collaborating with Sales and Presales to shape opportunities, define architectures, and support deal strategy. - Strong storytelling, communication, and whiteboarding skills. Benefits - Technical experience with Power Platform (Power Apps, Power Automate, governance) and Power BI (data modeling, DAX, semantic models). - Coding experience in Python, Spark, or Scala. What You Bring - A blend of software engineering depth, data platform expertise, and hands-on AI and ML capability. - A consultative mindset with the ability to influence strategy, architecture, and customer outcomes. - Comfort operating across presales, architecture, hands-on development, and customer advocacy. - Passion for modern data, AI, and cloud technologies.