Senior Data Engineer (Hyderabad)

Senior Data Engineer (Hyderabad)

17 Nov
|
Cloud Peritus
|
Hyderabad

17 Nov

Cloud Peritus

Hyderabad

Job Summary

We are seeking an experienced Senior AWS & Salesforce Data Migration Developer with strong expertise in AWS data migration, Salesforce data migration, ETL development, data integration, data transformation, and cloud data engineering. The ideal candidate should possess extensive hands-on experience migrating enterprise data between legacy/on-

premises systems, AWS cloud platforms, and Salesforce.

The candidate will be responsible for designing, developing, and implementing scalable data migration solutions using AWS DMS, AWS Glue, S3, Python, SQL, Salesforce APIs,

Salesforce Data Loader, and ETL tools. The role requires strong experience in Salesforce data modeling, bulk data migration, data cleansing, transformation, validation,

reconciliation, and integration with AWS services.

The candidate will work closely with Solution Architects, Salesforce Architects, Data

Architects, Business Analysts, Application Teams, and cross-functional teams to deliver secure, reliable, and high-performance migration solutions with minimal business disruption.

Salesforce Data Migration

Salesforce Data Model

Understand and work with Salesforce standard and custom objects, relationships,

external IDs, lookup relationships, master-detail relationships, record types, and dependent data structures.

Design migration approaches that maintain Salesforce data integrity and correctly handle parent-child relationships and object dependencies.

Salesforce Data Migration

Perform high-volume data migration into and out of Salesforce using Salesforce

Data Loader, Salesforce APIs, Bulk API, Bulk API 2.0, REST API, and ETL tools.

Develop migration strategies for Accounts, Contacts, Leads, Opportunities, Cases,

Products, Assets, Users, and custom objects.

Salesforce Data Loader

Use Salesforce Data Loader for bulk insert, update, upsert, delete, export, and hard-

delete operations.

Configure appropriate batch sizes, external IDs, CSV mappings, and migration sequences for large-volume data loads.

Salesforce Bulk API

Use Salesforce Bulk API and Bulk API 2.0 for high-volume data migration and integration scenarios.

Design asynchronous migration processes capable of processing large datasets while minimizing Salesforce API consumption and processing time.

Salesforce API Integration

Develop integrations between Salesforce and AWS/enterprise systems using REST

API, SOAP API, Bulk API, and other Salesforce integration mechanisms.

Implement authentication, error handling, retry mechanisms, logging, and monitoring for Salesforce integrations.

Salesforce Data Transformation & Cleansing

Data Mapping

Create detailed source-to-Salesforce mapping documents covering source fields,

Salesforce target fields, data types, transformation rules, default values, external

IDs, and lookup relationships.

Data Transformation

Transform legacy and AWS data into Salesforce-compatible formats and structures.

Implement business rules for data standardization, normalization, enrichment,

deduplication, and relationship mapping.

Data Cleansing

Identify and resolve duplicate, incomplete, invalid, and inconsistent customer records before loading data into Salesforce.

Implement data-quality checks to ensure migrated records meet Salesforce validation and business requirements.

Data Standardization

Standardize addresses, phone numbers, email addresses, customer identifiers,

account names, product information, and other master-data attributes before migration.

Salesforce & AWS Integration

AWS to Salesforce

Design and implement data pipelines to extract data from Amazon S3, RDS,

Redshift, AWS Glue, or other AWS services and load transformed data into

Salesforce.

Salesforce to AWS

Extract Salesforce data using APIs, Bulk API, or ETL tools and load it into AWS S3,

Redshift, RDS, or other AWS data platforms for analytics, reporting, archival, or downstream processing.





AWS Glue & Salesforce

Develop AWS Glue jobs to extract, transform, validate, and load Salesforce data.

Implement reusable Glue-based frameworks for Salesforce-to-AWS and AWS-to-

Salesforce data integration.

Python & Salesforce

Develop Python-based utilities using libraries such as Boto3 and Salesforce API clients to automate data extraction, transformation, migration, validation, and reconciliation.

Middleware Integration

Work with integration platforms such as MuleSoft, Informatica, Boomi, Talend, or similar technologies to integrate Salesforce with AWS and enterprise applications.

Salesforce Data Validation & Reconciliation

Record-Level Validation

Validate migrated Salesforce records against source data to ensure accuracy and completeness.

Record Count Reconciliation

Compare source and target record counts across objects, migration batches, and migration waves.

Field-Level Validation

Validate critical fields, data types, transformations, relationships, and business rules after migration.

Relationship Validation

Verify Salesforce parent-child relationships, lookup relationships, master-detail relationships, and external ID mappings.

Migration Audit

Maintain migration logs, error records, rejected records, retry information, and reconciliation reports to provide end-to-end migration traceability.

Salesforce Data Migration Strategy

Migration Sequencing

Define migration sequences based on Salesforce object dependencies.

For example, migrate Users and reference/master data before Accounts and

Contacts, followed by transactional and dependent objects where applicable.

Incremental Migration

Implement incremental and delta migration strategies to migrate only newly created or modified records between migration cycles.

Full Load & Delta Load

Support initial full migration followed by incremental/delta loads leading up to production cutover.

Cutover

Develop and execute Salesforce migration cutover plans including data freeze,

final extraction, transformation, loading, validation, reconciliation, and application enablement.

Rollback

Define rollback and recovery procedures for migration failures, data discrepancies,

or unexpected production issues.

Salesforce Performance & Limits

Governor Limits

Design migration and integration solutions that account for Salesforce governor limits, API limits, heap size, CPU time, and transaction limits.

API Optimization

Optimize Salesforce API usage through Bulk API, batching, asynchronous processing, incremental extraction, and appropriate batch sizes.

Large Data Volumes

Develop migration strategies for Salesforce Large Data Volume (LDV)

environments.

Optimize queries, data loads, indexing, external IDs, and migration sequencing for large Salesforce datasets.

Salesforce Security

Authentication

Implement secure Salesforce authentication using OAuth 2.0, Connected Apps,

Named Credentials, External Credentials, JWT, or other approved mechanisms.

Data Security

Ensure sensitive Salesforce data is securely transferred between Salesforce, AWS,

and enterprise systems.

Encryption

Implement appropriate encryption mechanisms for data at rest and in transit using Salesforce and AWS security capabilities.

Access Control

Work with Salesforce security teams to ensure appropriate permissions, profiles,

permission sets, sharing rules, and integration-user access are configured for migration activities.

Salesforce Development

Apex

Develop Apex classes, batch jobs,



schedulable classes, and utility components when custom Salesforce logic is required to support migration or integration activities.

Batch Apex

Use Batch Apex for processing large datasets where appropriate, while considering

Salesforce governor limits and performance requirements.

SOQL

Develop optimized SOQL queries for data extraction, validation, and migration support.

Triggers & Automation

Understand Salesforce triggers, Flows, validation rules, and other automation that may affect data migration.

Identify and manage automation that could impact bulk data loads and migration performance.

Migration Tools & Technologies The candidate should have hands-on experience with several of the following:

- AWS DMS

- AWS Schema Conversion Tool

- AWS Glue

- Amazon S3

- Amazon RDS

- Amazon Redshift

- AWS Lambda

- Amazon CloudWatch

- Salesforce Data Loader
- Salesforce Bulk API / Bulk API 2.0
- Salesforce REST API / SOAP API

- Salesforce Workbench
- Salesforce Inspector or equivalent data tools

- Informatica

- MuleSoft

- Boomi

- Talend

- Python

- SQL

- PySpark

- Git
- Jenkins / GitHub Actions / Azure DevOps

- Terraform / CloudFormation

Salesforce & AWS DevOps

Version Control

Maintain Salesforce Apex, configuration, Python scripts, ETL code, AWS Glue jobs,

and migration utilities in Git-based repositories.

CI/CD

Support automated deployment pipelines for Salesforce and AWS components using tools such as GitHub Actions, Jenkins, Azure DevOps, Salesforce CLI, or equivalent technologies.

Salesforce DX

Use Salesforce CLI and Salesforce DX practices for managing Salesforce metadata,

Apex code, deployment packages, and setting management.

Environment Management

Support migration across Salesforce environments such as Development, QA, UAT,

Full/Partial Sandbox, and Production.

Development Best Practices

Migration Framework

Develop reusable and configuration-driven migration frameworks that support multiple migration projects, objects, environments, and data sources.

Error Handling

Implement robust error handling, retry mechanisms, rejected-record processing,

and exception management across AWS and Salesforce migration processes.

Logging & Monitoring

Implement comprehensive logging and monitoring across AWS pipelines, ETL jobs,

Salesforce API integrations, and migration processes.

Documentation

Create technical design documents, source-to-target mappings, migration runbooks, data dictionaries, validation reports, deployment guides, and operational documentation.

Testing

Develop unit, integration, system, performance, data-quality, and migration-

validation test cases.

Soft Skills

- Excellent analytical and problem-solving skills with strong attention to data

accuracy and migration quality.
- Strong understanding of both AWS cloud data services and Salesforce data

architecture.
- Strong verbal and written communication skills with the ability to collaborate with

Salesforce, AWS, data, and business teams.
- Proven ability to manage complex data migration projects involving multiple

source and target systems.
- Strong troubleshooting and debugging skills across AWS, Salesforce, ETL, API, and

database environments.
- Ability to translate business requirements into scalable data migration and

integration solutions.
- Strong ownership of migration deliverables, testing, documentation, and

production support.

Preferred Certifications

- AWS Certified Data Engineer Associate
- AWS Certified Solutions Architect – Associate
- AWS Certified Developer – Associate
- Salesforce Certified Platform Developer I
- Salesforce Certified Platform Developer II

- Salesforce Certified Administrator
- Salesforce Certified Data Cloud Consultant
- Salesforce Certified Integration Architect
- MuleSoft Certified Developer – Level 1

📌 Senior Data Engineer (Hyderabad)
🏢 Cloud Peritus
📍 Hyderabad

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior data engineer (hyderabad) / hyderabad

Subscribe to this job alert:

Get the latest job offers by email for: senior data engineer (hyderabad) / hyderabad