Salesforce Data Migration Specialist
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
By continuing, you agree to our Terms & Privacy Policy.
Job Title: Salesforce Data Migration Specialist
Location: Phoenix, AZ (Hybrid)
Key Roles & Responsibilities
1. Mainframe Data Extraction & Intermediate Staging
Decode and extract legacy case management records from AZCCATS (handling fixed-width files, EBCDIC formats, packed decimals, and COBOL copybook layouts).
Design and manage the relational database staging architecture:
Staging 0 (Raw Layer): Direct ingestion and structural alignment of raw mainframe extracts.
Staging 1 (Transformation Layer): Cleansing, standardization, de-duplication, cross-referencing legacy case IDs, and constructing target-ready data structures.
Write performant SQL transformations, stored procedures, and staging scripts to validate data sanity prior to target ingestion.
2. ETL Development with Informatica
Build, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform AZCCATS data structures into normalized Salesforce objects.
Implement error handling, surrogate key lookups, rejection routing, and audit-logging routines directly within Informatica.
Maintain field-level Source-to-Target Mapping (STTM) documentation, ensuring complete tracing from legacy AZCCATS case histories to Salesforce fields.
3. Workload Orchestration with Atomic Scheduler
Build, schedule, and maintain complex job chains, dependencies, and event triggers using Atomic Workload Automation.
Automate the sequence of operations: trigger mainframe file transfers, execute intermediate database staging scripts, run Informatica workflows, and initiate target load scripts.
Implement automated alerting, error monitoring, and checkpoint-restart procedures within Atomic to guarantee automated recovery of interrupted conversion jobs.
4. Target Ingestion & MuleSoft Coordination
Architect and execute high-volume data loads into Salesforce Case Management (Cases, Contacts, Accounts, Case History, Notes, Docket Records, and Custom Objects) using Salesforce Bulk API 2.0.
Establish and populate External ID fields across Salesforce objects to ensure idempotent, upsert-capable, and repeatable data conversions.
Temporarily bypas