Salesforce Data Migration Specialist

Phoenix, AZ, US • Posted 13 hours ago • Updated 13 hours ago
Full Time
75% Travel Required
On-site
$65 - $70/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • salesforce
  • mulesoft
  • informatica

Summary

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 bypass and reactivate Salesforce automations (Apex Triggers, Record-Triggered Flows, Validation Rules) during bulk loads to optimize throughput and preserve historical audit timestamps.

Coordinate with the MuleSoft integration team to align data mapping schemas with active APIs and avoid payload conflicts during cutover windows.

5. Quality Assurance, Reconciliation & Cutover

 

 

Mandatory Technical Experience

 

Salesforce (5+ years):

Proven experience migrating complex case management data into Salesforce (Service Cloud or Custom Case Architecture).

In-depth expertise with Salesforce Bulk API / Bulk API 2.0, Data Loader, SOQL, and relational object modeling.

Practical knowledge of governor limits, bulk storage limits, and automation bypass techniques.

Informatica (5+ years): Extensive hands-on experience developing enterprise data conversion mappings and workflows using Informatica (Power Center or IICS)

Expertise with complex transformations, parameter files, performance tuning, and error recovery.

Atomics (Atomic) Scheduler (3+ years): Direct experience designing, configuring, and monitoring batch workflows, calendar schedules, and multi-systems dependencies with Atomic/UC4.

Database & SQL (5+ years): Advanced SQL skills, schema design, performance indexing, and transformation logic with relational database environments (SQL server, Oracle, PostgreSQL or DB2).

Mainframe AZCCATS Conversion: Direct experience working with mainframe extracts (EBCDIC conversion, sequential files, VSAM/DB2 data, and COBOL copybooks).

 

MuleSoft: Practical understanding of MuleSoft APIs, integration patterns, and data contract alignment between migration bathc process and real-time interfaces.

 

Required Skills:

 Salesforce 5+ years

 Informatica 5+ years

 MuleSoft.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91175610
  • Position Id: 9146909
  • Posted 13 hours ago
Contact the job poster
LA

Lana Anya

Recruiter @ TECHAGI SOLUTIONS LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.