Senior Data Engineer

Milestone Technologies, Inc.; Ernakulam; On-site; INR 1,600,000 - 2,600,000; Full time

Job summary

Milestone Technologies, Inc. is seeking a Senior Data Engineer to lead ServiceNow to Salesforce data migration. You will analyze data models, design end-to-end migration strategies, and build scalable pipelines to transform and move data efficiently.

The role emphasizes data quality, governance, and secure handling of large datasets, with collaboration across business and technical teams for successful cutovers and production deployments.

Qualifications

• 8+ years in data engineering and migration projects.
• Experience with ServiceNow and Salesforce integrations.
• Knowledge of Agile project delivery and DevOps practices.

Responsibilities

• Analyze ServiceNow and Salesforce data models.
• Design data migration strategy, mapping and transformation rules.
• Extract, cleanse, transform, and load data from ServiceNow into Salesforce.
• Build scalable migration pipelines using Azure Data Factory, Informatica, Talend, SSIS, Python, or MuleSoft.
• Ensure data quality, integrity, reconciliation and validation during migration.
• Handle large-volume data loads using Salesforce Bulk API and related mechanisms.
• Develop data migration scripts, automation frameworks and monitoring processes.
• Collaborate with stakeholders and architects to validate migrated data.
• Manage data security, governance, compliance and audit requirements.
• Troubleshoot migration issues and optimize performance.
• Support cutover planning, mock migrations and production deployments.

Skills

SQL and Relational DBs

ServiceNow integration

Salesforce integration

ETL/ELT design

Python / Spark

Data profiling & MDM

Cloud platforms (Azure/AWS/GCP)

Tools

Azure Data Factory

Informatica

Talend

SSIS

Salesforce Bulk API

MuleSoft

Job description

Senior Data Engineer – ServiceNow to Salesforce Data Migration

Key Responsibilities

• Analyze and understand ServiceNow and Salesforce data models.
• Design end-to-end data migration strategy, mapping, and transformation rules.
• Extract, cleanse, transform, and load (ETL/ELT) data from ServiceNow into Salesforce.
• Build scalable migration pipelines using tools such as Azure Data Factory, Informatica, Talend, SSIS, Python, or MuleSoft.
• Ensure data quality, integrity, reconciliation, and validation during migration.
• Handle large-volume data loads using Salesforce Bulk API and related integration mechanisms.
• Develop data migration scripts, automation frameworks, and monitoring processes.
• Collaborate with business stakeholders, Salesforce architects, and functional teams to validate migrated data.
• Manage data security, governance, compliance, and audit requirements.
• Troubleshoot migration issues and optimize performance.
• Support cutover planning, mock migrations, and production deployments.

Technical Skills

• Strong SQL and database expertise (SQL Server, Oracle, PostgreSQL, etc.).
• Experience with ServiceNow tables, CMDB, Incident, Change, Asset, and related modules.
• Experience with Salesforce objects, relationships, Data Loader, Bulk API, and Salesforce platform architecture.
• ETL/ELT tools and data integration frameworks.
• Python, Spark, or other data engineering technologies.
• Data profiling, cleansing, and master data management.
• Cloud platforms such as Azure, AWS, or GCP.

Preferred Experience

• 8+ years in data engineering and migration projects.
• Multiple large-scale enterprise data migration implementations.Experience with ServiceNow and Salesforce integrations.
• Knowledge of Agile project delivery and DevOps practices.