Data Migration Engineer (MongoDB)

***Multiple Locations (HYBRID) role--Dallas, TX, Hartford, CT | Arizona | Chicago, IL | Pennsylvania | | Rhode Island.

We are seeking a Data Migration Engineer to support one of our Healthcare enterprise data modernization effort. 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, Ingress 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