About the Role :The MEDITECH Integration & Data Extraction Specialist serves as the primary technical expert responsible for designing, building, and maintaining data pipelines that connect MEDITECH Magic and MEDITECH Client/Server (CS) electronic health record platforms to downstream analytics, reporting, and enterprise systems.Essential Duties & Responsibilities :MEDITECH Platform Integration :- Design and implement end-to-end integration solutions for both MEDITECH Magic and MEDITECH CS/Expanse platforms.- Configure and manage HL7 v2.x interfaces (ADT, ORM, ORU, MDM, DFT) using MEDITECH's Interface Engine and third-party middleware such as Mirth Connect, Rhapsody, or Microsoft BizTalk.- Extract data directly from the Database Application and provide data as SQL backup.- Ensure real-time synchronization to capture CRUD operations.- Build integration leveraging MEDITECH CS FHIR R4 APIs, REST web services, and the Expanse Integration Platform.- Troubleshoot and resolve interface failures, data mismatches, and connectivity issues.Data Extraction & Transformation :- Extract clinical and administrative data from MEDITECH Magic's proprietary file system and MEDITECH CS's relational database layer (MS SQL Server).- Develop SQL queries, stored procedures,



and ETL pipelines to pull structured data from MEDITECH data warehouses including Data Repository (DR) and MEDITECH's Expanse Data Repository (EDR).- Build and maintain validation scripts and mappings between MEDITECH proprietary codes and standard terminologies (ICD-10, SNOMED CT, LOINC, CPT, RxNorm).Technical Skills :- MUMPS / M Language - Reading and writing MUMPS routines for MEDITECH Magic data access.- MEDITECH Magic File Structures - In-depth knowledge of Magic's proprietary hierarchical globals and folder architecture.- Relational Databases - Microsoft SQL Server (T-SQL, stored procedures, views, indexing, query optimization).- Interface Standards - HL7 v2.x, FHIR R4, CDA/C-CDA, X12 EDI.- Data Formats - XML, JSON, CSV, pipe-delimited; XPath/XSLT transformation.Qualifications :- 5+ years of hands-on experience with MEDITECH Magic (specifically NPR, BAR, LAB, PHA, and ADM modules).- 3+ years of experience with MEDITECH Client/Server (CS) or MEDITECH Expanse, including its SQL-accessible Data Repository.- Demonstrated experience reading, writing, and debugging MUMPS / M language.- Proficiency in SQL Server T-SQL for complex querying and performance tuning.- Working experience with at least one ETL/integration tool (SSIS, Informatica, Mirth Connect, or equivalent). (ref:hirist.tech)

📌 ELLKAY - Data Extraction Specialist/MUMPS (India)
🏢 ELLKAY
📍 India