US_East | Data Engineer_L4

Majesco Data Migration Lead

We are seeking a highly experienced Majesco Data Migration Lead to drive end-to-end data migration activities for insurance transformation programs involving Majesco platforms, including Policy, Billing, and Claims systems. The role involves defining migration strategy, leading data mapping and conversion activities, and ensuring high data quality and accuracy during system transitions. The ideal candidate combines strong data migration expertise, insurance domain knowledge, and hands-on experience with Majesco implementations or similar insurance platforms.

Key Responsibilities:

Data Migration Strategy & Planning

• Define end-to-end data migration strategy, approach, and roadmap.
• Analyze legacy data systems and identify migration scope.
• Establish data governance, cleansing, and validation frameworks.

Data Mapping & Transformation

• Lead data mapping workshops with business and technical teams.
• Define: source-to-target mappings, transformation rules, data enrichment strategies.
• Ensure alignment with Majesco data models.

Data Conversion Execution

• Oversee the design and execution of ETL processes and data conversion scripts.
• Coordinate multiple migration cycles, including mock runs, dress rehearsals, and final cutover activities.

Data Validation & Reconciliation

• Define validation frameworks and reconciliation strategies.
• Perform data quality checks for completeness, accuracy, and consistency.
• Ensure successful reconciliation between legacy and target systems.

Data Quality & Governance

• Establish data quality standards and controls.
• Identify data issues and define cleansing strategies.
• Ensure compliance with regulatory and audit requirements.

Collaboration & Stakeholder Engagement

• Partner closely with business SMEs, functional leads, architects, developers, and project managers.
• Communicate migration progress, risks, and dependencies effectively.

Tools & Environment Management

• Drive the use of ETL and data migration tools such as Informatica, Talend, SSIS, and similar ETL platforms.
• Support migration environments and infrastructure setup.

Risk & Issue Management

• Identify risks related to data loss, data inconsistencies, and downtime.
• Develop mitigation and contingency plans.
• Ensure smooth cutover with minimal business impact.

Required Qualifications:

Education

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

Experience

• 10+ years of IT experience with a strong focus on data migration.
• 4–6 years of experience in insurance domain projects (Property & Casualty, Life, or Health).
• Experience with Majesco implementations or similar insurance platforms such as Guidewire or Duck Creek.

Domain Expertise

Strong understanding of insurance data related to:

• Policy lifecycle
• Customer and account data
• Billing and financial transactions
• Claims data

Knowledge of regulatory and compliance requirements within the insurance industry.

Technical Skills:

• Strong experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or similar.
• Strong SQL and database expertise (Oracle, SQL Server, etc.).
• Data modeling and data architecture experience.
• Experience with APIs and data integration.
• Understanding of data warehousing concepts.
• Exposure to cloud platforms such as AWS or Azure is preferred.

Data Migration Expertise

• End-to-end migration lifecycle management.
• Data profiling.
• Data mapping and transformation.
• Data cleansing and validation.
• Large-scale data migration projects.
• Cutover planning and execution.

Soft Skills

• Excellent communication and stakeholder management skills.
• Strong analytical and problem-solving abilities.
• Leadership and team coordination skills.
• Ability to work effectively under tight migration timelines.

Preferred Qualifications

• Experience with large-scale insurance transformation programs.
• Knowledge of Agile and SAFe methodologies.
• Certifications in data management or cloud platforms.
• Familiarity with data governance tools such as Collibra, Alation, or similar solutions.

Top 5 Must-Have Skills:

• Majesco insurance platform experience
• End-to-end data migration leadership
• Insurance domain expertise (Policy, Billing, Claims)
• ETL tools (Informatica, Talend, SSIS, DataStage)
• SQL, data modeling, and data architecture

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.