Salesforce Data Migration Architect

Access Data Consulting Corporation · Phoenix, AZ
Work typeHybrid · Temporary
Pay$75/hr
PostedNov 20, 2026
LevelMid level
In short We are partnering with an organization currently undergoing a major multi-year digital modernization initiative.
SQLSALESFORCE

📋 About the job

LocationPhoenix, AZ (must be a current resident)
PayUp to $75 per hour
ScheduleHybrid (80% onsite, 20% remote)

Job Title: Salesforce Data Migration Architect (Conversion Lead)

We are partnering with an organization currently undergoing a major multi-year digital modernization initiative. This is an opportunity to serve as the end-to-end architectural lead on a modernization project migrating millions of records off a legacy mainframe environment into a modern Salesforce architecture.

Here’s what you’ll be doing

  • Architecting and managing a multi-tier relational database staging environment (Raw Ingestion Layer moving into a Cleansed Transformation Layer) to prepare legacy mainframe extracts for cloud ingestion.
  • Decoding and extracting legacy case management records (handling fixed-width layouts, EBCDIC formats, packed decimals, and COBOL copybooks) and writing performant SQL validation scripts.
  • Designing and optimizing enterprise Informatica mappings, mapplets, and workflows with robust error handling, surrogate key lookups, and Source-to-Target Mapping (STTM) documentation.
  • Orchestrating cross-platform batch job chains, dependencies, alerting, and checkpoint-restart routines using Automic (UC4) Workload Automation.
  • Executing high-volume data loads into Salesforce Service Cloud and custom objects using Bulk API 2.0, External IDs, and temporary automation bypass protocols (triggers, flows, and validation rules).
  • Coordinating closely with MuleSoft integration engineers to align batch data schemas with active APIs and prevent payload conflicts during cutover windows.
  • Leading automated data reconciliation checks, iterative mock conversions, and minute-by-minute production cutover runbooks with audit and business stakeholders.

Here’s what our ideal candidate has

  • 5+ years of hands-on experience architecting and executing case management data migrations into Salesforce (Service Cloud/Custom Objects) using Bulk API / Bulk API 2.0, SOQL, and Data Loader.
  • 5+ years of enterprise ETL development experience building and tuning conversion mappings and workflows in Informatica (PowerCenter or IICS).
  • Advanced SQL and relational database experience (SQL Server, Oracle, PostgreSQL, or DB2), including multi-tier staging design and data reconciliation.
  • 3+ years of direct experience designing and monitoring batch workflows and dependencies using Automic / UC4 Scheduler.
  • Proven background working with legacy mainframe data extrac…
📄 Read the full description → The rest of this listing is on the hiring partner’s site.
Interested in this role?Apply in one click — no JobQ account needed.
Apply now →
Salesforce Data Migration ArchitectAccess Data Consulting Corporation
Apply now