Lead Data Engineer - Data Migration

Covestic Inc; Ernakulam; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Covestic Inc. in India is seeking an experienced Lead Data Engineer to drive end-to-end data migration from ServiceNow ITSM to Salesforce Agentforce ITSM. You will define mappings, design scalable pipelines, and ensure data quality across the migration program.

You will lead analytics, data enrichment strategies, and collaborate with ServiceNow, Salesforce, and business stakeholders to deliver a seamless transition while mentoring junior engineers and coordinating deployment activities.

Qualifications

• 8–10 years of experience in Data Engineering, Data Integration, or Data Migration projects.
• Minimum 3+ years leading enterprise-scale migration initiatives.
• Strong experience with ServiceNow and Salesforce ecosystems.
• Proven experience migrating data across enterprise applications.

Responsibilities

• Lead design and execution of large-scale ServiceNow to Salesforce Agentforce ITSM data migration programs.
• Define migration strategy, waves, cutover plans, and rollback procedures.
• Establish data migration standards, frameworks, and best practices.
• Analyze ServiceNow ITSM data structures and design source-to-target mappings for Salesforce Agentforce ITSM objects.
• Document transformation, enrichment, and data validation rules.
• Design and develop scalable ETL/ELT pipelines and integrate ServiceNow with Salesforce ingestion mechanisms.
• Ensure data quality through profiling, cleansing, deduplication, and governance.
• Support migration of service operations data into Salesforce Service Cloud and Agentforce environments.
• Provide technical leadership, mentoring, and conduct design/code reviews.
• Lead testing, UAT, dashboards, and production cutovers.

Skills

Advanced SQL

Data modeling

ETL/ELT development

Cloud data integration

Education

Bachelor's or Master's in Computer Science / Information Systems / Data Engineering

Tools

Azure Data Factory

Informatica

Talend

SSIS

AWS Glue

MuleSoft

Job description

Role Overview

We are seeking an experienced Lead Data Engineer to lead the end-to-end data migration initiative from ServiceNow ITSM to Salesforce Agentforce ITSM. The ideal candidate will have deep expertise in enterprise data migration, ETL/ELT frameworks, data architecture, data governance, and cloud-based integration technologies.

The Lead Data Engineer will be responsible for designing migration strategies, defining source-to-target mappings, building scalable migration pipelines, ensuring data quality, and collaborating with business, ServiceNow, and Salesforce stakeholders to deliver a seamless transition.

Key Responsibilities

Data Migration Leadership

• Lead the design and execution of large-scale ServiceNow to Salesforce Agentforce ITSM data migration programs.
• Define migration strategy, migration waves, cutover plans, and rollback procedures.
• Establish data migration standards, frameworks, and best practices.

Data Analysis & Mapping

• Analyze ServiceNow ITSM data structures, including: Incidents Problems Changes Knowledge Articles CMDB Assets Service Catalog Requests & Tasks User and Group Data
• Design source-to-target mappings for Salesforce Agentforce ITSM objects.
• Document transformation, enrichment, and data validation rules.

ETL/ELT Development

• Design and develop scalable ETL/ELT pipelines for data extraction, transformation, and loading.
• Integrate ServiceNow APIs, databases, and exports with Salesforce data ingestion mechanisms.
• Leverage Salesforce Bulk APIs and data loading frameworks for high-volume data migration.

Data Quality & Governance

• Implement data profiling, cleansing, standardization, and deduplication processes.
• Develop reconciliation frameworks to ensure data completeness and accuracy.
• Monitor data validation metrics and address data anomalies proactively.
• Ensure compliance with enterprise data governance and security policies.

Salesforce Agentforce Data Enablement

• Support migration of service operations data into Salesforce Service Cloud and Agentforce environments.
• Optimize migrated data for Agentforce AI-driven support workflows and automations.
• Ensure relationships, hierarchies, and historical records are accurately migrated and maintained.

Technical Leadership

• Provide mentoring and technical guidance to data engineers and migration specialists.
• Conduct design reviews and code reviews.
• Collaborate with Salesforce Architects, ServiceNow SMEs, Product Owners, and Business Stakeholders.

Testing & Deployment

• Lead mock migrations, performance testing, UAT support, and production cutovers.
• Create migration dashboards, monitoring reports, and status communications.
• Drive issue resolution during deployment and hypercare phases.

Required Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or related field.
• 8-10 years of experience in Data Engineering, Data Integration, or Data Migration projects.
• Minimum 3+ years leading enterprise-scale migration initiatives.
• Strong experience with ServiceNow and Salesforce ecosystems.
• Proven experience migrating data across enterprise applications.

Required Technical Skills

Data Engineering

• Advanced SQL and data modeling expertise.
• Strong knowledge of ETL/ELT development patterns.
• Experience with: Azure Data Factory Informatica Talend SSIS AWS Glue MuleSoft

Programming

• Python
• SQL
• Shell Scripting

ServiceNow

• ServiceNow Data Model
• CMDB
• Incident, Change, Problem Management
• Service Catalog
• ServiceNow APIs and Data Export Frameworks

Salesforce Agentforce / Service Cloud

• Salesforce Data Model
• Service Cloud
• Agentforce
• Salesforce Bulk API
• Salesforce Data Loader
• Salesforce Integration Patterns

Database Technologies

• SQL Server
• Oracle
• PostgreSQL
• Snowflake
• Azure SQL

Preferred Qualifications

• Experience with Salesforce Agentforce implementations.
• Experience with AI-ready data architecture and knowledge management migration.
• Experience working in Agile and DevOps environments.
• Knowledge of Data Governance, MDM, and Metadata Management.
• Experience with cloud platforms: Microsoft Azure AWS Google Cloud Platform

Key Competencies

• Data Migration Strategy
• Stakeholder Management
• Technical Leadership
• Problem Solving
• Data Quality Management
• Architecture & Design
• Communication & Collaboration
• Risk Management