Role: Sr. Data Migration Engineer (Data Migration / ETL & Scripting / Salesforce Data Structures / SOQL & SQL / Ab Initio / Oracle SQL / API Data Exchange)
Location: San Jose, CA (100% Onsite — Local Candidates Preferred)
Duration: 6 Months Contract
Pay Rate: $60.00/hr W2 | $70.00/hr C2C Max
Professional Job Description
Seeking a senior-level Sr. Data Migration Engineer with 10+ years of dedicated experience in large-scale enterprise data migration, ETL processing, and data engineering for a 6-month contract role located in San Jose, CA (100% Onsite; local candidates preferred).
The ideal candidate will possess deep technical expertise in data mapping, complex transformations, and validation techniques, with specialized hands-on knowledge of Salesforce data structures, SOQL, Oracle SQL, Ab Initio, and API-based data exchange. This role is responsible for executing large-scale migrations while maintaining strict compliance with data privacy regulations (GDPR, HIPAA) and ensuring high data quality standards.
#Key Responsibilities
Enterprise Data Migration Execution: Lead end-to-end data extraction, mapping, transformation, loading, and validation for large-scale enterprise application and database migration initiatives.
Salesforce & Relational Data Engineering: Construct complex SQL and SOQL queries to extract, transform, and reconcile data objects across Salesforce orgs, Oracle databases, and cloud repositories.
ETL Pipeline & Scripting Automation: Develop, optimize, and maintain ETL workflows and data pipelines using Ab Initio, custom scripting languages, and automated validation scripts.
API & System Integration: Engineer API-based data exchange models and payload transformations for smooth interoperability during transitional and cutover migration phases.
Data Quality & Compliance Governance: Enforce data cleansing, deduplication, audit reporting, and data governance frameworks aligned with privacy mandates (GDPR, HIPAA).
#Required Qualifications
Core Tenure: 10+ years of progressive experience in Data Migration, ETL Engineering, or Data Architecture roles.
Salesforce & Query Stack: Strong expertise in Salesforce data models/structures, SOQL, Oracle SQL, and Ab Initio or enterprise ETL platforms.
Engineering Techniques: Advanced proficiency in data mapping, transformation, data modeling, database design, and API integration.
Project Track Record: Demonstrated delivery on large-scale enterprise application migrations with strict attention to data reconciliation and privacy compliance.
Work Setup & Location: 100% Onsite commitment in San Jose, CA (Local San Jose/Bay Area candidates strongly preferred).
