07 Nov
|
Innova Software Services
|
India
07 Nov
Innova Software Services
India
Job Title: QNXT Platform Architect Data Migration
Role Overview
We are looking for an experienced QNXT Platform Architect with strong expertise in healthcare payer systems, claims processing, enterprise data migration, and cloud-based data integration.
The ideal candidate will lead the architecture and technical strategy for migrating legacy claims processing systems to the QNXT platform. The role requires hands-on knowledge of QNXT, Snowflake, Azure Data Factory (ADF), SQL Server, SSIS, SSMA, and large-scale data migration methodologies.
The candidate should have a strong understanding of healthcare payer business processes, claims adjudication, data conversion, system integration, and hybrid cloud architecture.
Key Responsibilities
- Assess existing claims system architecture, business functionality, integrations, databases, and technical dependencies to define the current-state landscape.
- Define target-state architecture and end-to-end migration strategy for transitioning legacy claims processing capabilities to QNXT.
- Analyze claims adjudication workflows, benefit configuration, provider contracts, member eligibility, pricing, accumulators, payment processes, and related healthcare payer functions.
- Design and implement data migration and integration solutions using Azure Data Factory (ADF), SQL Server, SSIS, SSMA, Snowflake, and other Azure integration services.
- Configure and manage Self-Hosted Integration Runtime (SHIR) for secure connectivity between Azure Data Factory and on-premises data sources.
- Assess and migrate SQL Server databases using SSMA, including schema conversion, database object migration, compatibility assessment, and data validation.
- Develop, maintain, and migrate SSIS packages, leveraging Azure-SSIS Integration Runtime and ADF orchestration where applicable.
- Design and implement Snowflake-based data integration, migration, transformation, and validation solutions.
- Define source-to-target data mappings, transformation logic, integration patterns, and data conversion strategies across legacy systems, QNXT, Snowflake, and downstream applications.
- Configure and support Azure ExpressRoute connectivity for secure and reliable data transfers between on-premises infrastructure and Azure.
- Implement real-time data replication and Change Data Capture (CDC)
using Striim or comparable technologies to support continuous data synchronization during migration.
- Develop and execute data quality checks, reconciliation processes, historical claims migration, and parallel processing strategies to ensure data accuracy and completeness.
- Identify gaps between existing claims system functionality and QNXT capabilities, recommending configuration changes, customizations, or business process improvements.
- Define non-functional requirements covering performance, scalability, availability, security, auditability, and data integrity.
- Troubleshoot database compatibility issues, pipeline failures, connectivity problems, replication latency, and data discrepancies.
- Collaborate with business SMEs, solution architects, data engineers, application developers, QA teams, and infrastructure teams throughout migration execution.
- Review technical designs, migration plans, test strategies, reconciliation results, and production cutover readiness.
- Ensure compliance with healthcare data privacy, security, and audit requirements, including HIPAA.
Required Skills and Experience
- 10+ years of experience in healthcare payer technology, data engineering, database migration, or enterprise application modernization, preferably involving claims processing platforms.
- Strong hands-on knowledge of QNXT architecture, configuration, claims processing workflows, and healthcare payer business domains.
- Proven experience in legacy claims system modernization, database migration, and large-scale data conversion programs.
- Hands-on expertise in Azure Data Factory (ADF), SQL Server, ETL/ELT development, and data integration.
- Strong practical experience with Snowflake, including data migration, data integration, transformation, and data validation.
- Practical experience with Self-Hosted Integration Runtime (SHIR), SQL Server Migration Assistant (SSMA), SSIS, and Azure integration services.
- Solid SQL skills, including database schema assessment, stored procedures, data transformation, performance tuning,
and data validation.
- Knowledge of Azure networking and ExpressRoute connectivity for hybrid data migration architectures.
- Experience with Striim or comparable real-time replication and CDC technologies.
- Understanding of claims adjudication, membership, benefits, providers, pricing, accumulators, payments, and downstream claims integrations.
- Knowledge of EDI transactions, including 837 claims and 835 remittance advice, as applicable.
- Experience with APIs, batch processing, source-to-target mappings, data reconciliation, system integration testing, parallel runs, and production cutovers.
- Strong solution design, technical documentation, architecture review, stakeholder management, and problem-solving skills.
Preferred Qualifications
- Experience migrating a legacy healthcare claims administration platform to QNXT.
- Experience with SQL Server-to-SQL Server or Azure SQL database migrations.
- Familiarity with Azure Data Lake Storage and other Azure data services.
- Experience designing cloud-based and hybrid integration architectures for healthcare payer environments.
- Experience leading architecture reviews, data conversion and reconciliation strategies, and production cutover planning.
- Knowledge of healthcare regulatory requirements, data governance, and HIPAA compliance.
Key Deliverables
- Current-state and target-state claims architecture documentation.
- End-to-end QNXT migration, data conversion, and integration strategy.
- Source-to-target data mappings, transformation specifications, and database conversion design.
- ADF pipelines, SSIS package migration, database migration plans, and replication/CDC design, as applicable.
- Snowflake data integration and migration design, including transformation and validation specifications.
- Data quality, validation, reconciliation, and parallel processing strategy.
- Architecture decision records and detailed technical design specifications.
- Migration testing, defect resolution, cutover planning, and production readiness recommendations.
Key Technical Skills
QNXT | Snowflake | Azure Data Factory (ADF) | SQL Server | SSIS | SSMA | SHIR | Azure Integration Services | Azure ExpressRoute | Striim | CDC | ETL/ELT | SQL | EDI 837/835 | Healthcare Claims Processing | Data Migration | HIPAA
📌 QNXT Platform Architect – Data Migration (India)
🏢 Innova Software Services
📍 India