Salesforce Data Migration Architect

S R International•Phoenix, AZ
•Hybrid

About The Position

The State of Arizona’s Department of Economic Security, Department of Technology Services, is seeking a Salesforce Data Migration Architect / Conversion Lead to lead the end-to-end migration and transformation of legacy AZCCATS mainframe data into a modern Salesforce architecture. The role covers mainframe extraction, relational database staging, Informatica ETL transformations, Atomic Scheduler workload orchestration, and high-volume Salesforce data loading. The position is based in Phoenix, Arizona, with a hybrid arrangement of 80% onsite and 20% remote. The stated duration is six months from the projected start date. The architect will design and manage raw and transformation staging layers; develop SQL transformations and Informatica mappings and workflows; orchestrate conversion jobs; load case-management data into Salesforce; coordinate data contracts with MuleSoft integration teams; and oversee quality assurance, reconciliation, and production cutover. Data in scope includes Cases, Contacts, Accounts, Case History, Notes, Docket Records, and custom objects. The role also maintains source-to-target mapping documentation and supports traceability, repeatable loads, error recovery, and auditability.

Requirements

  • At least 5 years of Salesforce experience, including migration of complex case-management data into Salesforce Service Cloud or custom case architectures.
  • Strong knowledge of Salesforce Bulk API or Bulk API 2.0, Data Loader, SOQL, relational object modeling, and Salesforce governor limits.
  • At least 5 years of hands-on experience developing enterprise data-conversion mappings and workflows with Informatica PowerCenter or IICS.
  • Knowledge of Informatica complex transformations, parameter files, performance tuning, and error recovery.
  • At least 3 years of experience designing, configuring, and monitoring batch workflows, calendar schedules, job dependencies, and workload automation using Atomic Scheduler/UC4.
  • At least 5 years of database and SQL experience, including advanced SQL, relational database design, schema development, performance indexing, stored procedures, and transformation logic.
  • Experience with SQL Server, Oracle, PostgreSQL, or DB2.
  • Direct experience with mainframe extracts, EBCDIC conversion, sequential files, VSAM/DB2 data, and COBOL copybooks for AZCCATS conversion.
  • Practical understanding of MuleSoft APIs, integration patterns, and data-contract alignment between batch migration processes and real-time interfaces.
  • Ability to work at the Phoenix, Arizona location under the stated hybrid arrangement.

Responsibilities

  • Extract and decode legacy AZCCATS case-management records, including fixed-width files, EBCDIC formats, packed decimals, and COBOL copybook layouts.
  • Design and manage relational database staging architecture, including raw ingestion and transformation layers.
  • Develop optimized SQL transformations, stored procedures, and staging scripts for cleansing, standardization, deduplication, and cross-referencing legacy case IDs.
  • Develop, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform AZCCATS data into Salesforce objects.
  • Implement ETL error handling, surrogate-key lookups, rejection routing, and audit logging; maintain source-to-target mapping documentation and data traceability.
  • Build, schedule, and maintain Atomic Workload Automation job chains, dependencies, event triggers, and calendar schedules.
  • Automate file transfers, staging scripts, Informatica workflows, and Salesforce loading; implement alerts, error monitoring, checkpoint-restart procedures, and recovery for interrupted jobs.
  • Architect and execute high-volume Salesforce Case Management loads using Salesforce Bulk API 2.0.
  • Migrate Cases, Contacts, Accounts, Case History, Notes, Docket Records, and custom objects; establish External ID fields for repeatable, idempotent, upsert-capable conversions.
  • Manage bypass and reactivation of Salesforce Apex Triggers, Record-Triggered Flows, and Validation Rules during bulk loads.
  • Coordinate with MuleSoft integration teams to align migration schemas with active APIs and avoid payload conflicts during cutover.
  • Develop automated reconciliation scripts to compare source record counts and field checksums with Salesforce target records.
  • Run iterative mock conversions, validate data integrity, and collaborate with business and audit teams to verify migration accuracy.
  • Develop time-sequenced production cutover runbooks and ensure data quality, consistency, and successful migration execution.

Benefits

  • Flexible work from home options available.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service