Salesforce Data Migration Architect

Access Data Consulting Corporation

Phoenix (AZ)

Hybrid

USD 85,000 - 121,000

Full time

18 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Access Data Consulting Corporation is seeking a Salesforce Data Migration Architect to lead a comprehensive conversion from legacy mainframe data to Salesforce Service Cloud. The role focuses on end-to-end architectural oversight for multi-tier data ingestion and cloud deployment, emphasizing performance and data integrity.

You will coordinate with MuleSoft and Automic teams to ensure seamless cutovers, while delivering meticulous data reconciliation and value-driven migration milestones for a

Qualifications

  • 5+ years migrating case management data to Salesforce (Service Cloud/Custom Objects).
  • Experience with Bulk API 2.0, SOQL, and Data Loader.
  • Advanced SQL and multi-tier staging design.
  • 3+ years orchestrating batch workflows with UC4 Scheduler.
  • Experience with legacy mainframe data (EBCDIC, COBOL copybooks) and MuleSoft APIs.

Responsibilities

  • Architect and manage a multi-tier staging environment for legacy data.
  • Decode and extract legacy records and write SQL validation scripts.
  • Design and optimize Informatica mappings, mapplets, and workflows.
  • Coordinate batch jobs using UC4 and ensure robust error handling.
  • Load data into Salesforce Service Cloud and custom objects using Bulk APIs.

Skills

Salesforce data migration
Bulk API 2.0
Informatica ETL
SQL
Automic UC4
MuleSoft
Mainframe data
Data reconciliation
Data loading
Cobol copies

Tools

Informatica PowerCenter
Informatica IICS
SQL Server
Oracle
-salesforce tools-

Job description

Job Title: Salesforce Data Migration Architect (Conversion Lead)

Location: Phoenix, AZ (must be a current resident)

Rate: Up to $75 per hour

Schedule: Hybrid (80% onsite, 20% remote)

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 extracts (EBCDIC, flat files, COBOL copybooks) and practical familiarity with MuleSoft API integration patterns.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Salesforce Data Migration Architect / Conversion Lead
Salesforce Data Migration Architect / Conversion Lead

VIVA USA Inc • Phoenix (AZ)

Hybrid
USD 140,000 - 180,000
Hybrid work model
Competitive compensation
Data Architect
Data Architect

Brooksource • Arizona

On-site
USD 140,000 - 190,000
Salesforce Data Migration Architect — Hybrid, Phoenix
Salesforce Data Migration Architect — Hybrid, Phoenix

Access Data Consulting Corporation • Phoenix (AZ)

Hybrid
USD 85,000 - 121,000
Salesforce Data Migration Architect | Hybrid Onsite 80%
Salesforce Data Migration Architect | Hybrid Onsite 80%

VIVA USA Inc • Phoenix (AZ)

Hybrid
USD 140,000 - 180,000
Hybrid work model
Competitive compensation
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio, Inc • Washington

On-site
USD 140,000 - 190,000
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio Inc. • Washington

Hybrid
USD 140,000 - 190,000
Lead Mainframe-to-Salesforce Data Architect
Lead Mainframe-to-Salesforce Data Architect

Brooksource • Arizona

On-site
USD 140,000 - 190,000
Senior Technical Data Migration Lead – Salesforce & Azure
Senior Technical Data Migration Lead – Salesforce & Azure

NexTurn • King of Prussia (PA)

On-site
USD 150,000 - 190,000
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio, Inc. • Washington

On-site
USD 140,000 - 190,000
Salesforce Technical Architect
Salesforce Technical Architect

AppLab Systems, Inc • Las Vegas (NV)

On-site
USD 180,000 - 240,000