Overview
Skills
Job Details
We are seeking a Data Migration Engineer to support one of our Healthcare enterprise data modernization efforts. The role focuses on migrating healthcare data from MarkLogic (XML) to MongoDB Atlas (JSON) using Ingress ingestion, AWS Glue, and custom microservices. The ideal candidate will have experience with Java XPath for XML parsing and transformation. A strong understanding of healthcare data standards and HIPAA compliance will be a plus.
Key Responsibilities:
Lead the migration of XML-based data from MarkLogic to MongoDB Atlas, ensuring accurate XML to JSON transformation using XPath and business rule mapping.
Develop ETL pipelines using Ingress and AWS Glue to ingest, clean, and transform healthcare datasets (e.g., members, providers, claims).
Create custom microservices in Java, Node.js, or Python to perform data transformation, leveraging Java s inbuilt XPath API for XML parsing.
Design and implement secure RESTful APIs to expose ingested data, in alignment with Aetna s internal API and compliance standards.
Work closely with data governance, security, and DevOps teams to ensure HIPAA-compliant data handling and scalable architecture.
Tech Stack:
Databases: MarkLogic (XML), MongoDB Atlas (JSON)
ETL Tools: AWS Glue, Ingestion
Languages: Java (XPath APIs), Node.js, Python
APIs: RESTful APIs, OpenAPI/Swagger
XML Handling: Java DOM, SAX, XPath (javax.xml.xpath)
Security/Compliance: HIPAA, OAuth2/JWT, PHI/PII handling
Tools: Git, Docker, Postman, Jenkins/GitHub Actions