Salesforce Data Migration Architect

S R INTERNATIONAL INC•Phoenix, AZ
•Hybrid

About The Position

The State of Arizona – Arizona Department of Economic Security (AZDES), Department of Technology Services (DTS), is seeking a Salesforce Data Migration Architect / Conversion Lead to lead the end-to-end migration and transformation of the legacy AZCCATS mainframe application into a modern Salesforce architecture. The role designs and executes the data conversion pipeline, covering mainframe extraction, relational database staging, Informatica ETL transformations, workload orchestration, and high-volume Salesforce data loading. The architect extracts and decodes legacy case-management records, creates raw and transformation staging layers, and develops SQL transformations and Informatica workflows to convert AZCCATS data into Salesforce objects. The role also orchestrates batch jobs with Atomic Scheduler, loads and reconciles Salesforce data, coordinates data contracts with MuleSoft integration teams, and supports quality assurance, mock conversions, and production cutover.

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 Informatica experience using PowerCenter or IICS, including enterprise conversion mappings and workflows, 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 with 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.
  • Practical understanding of MuleSoft APIs, integration patterns, and data contract alignment between batch migration processes and real-time interfaces.

Responsibilities

  • Extract and decode AZCCATS case-management data, 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 SQL transformations, stored procedures, staging scripts, data cleansing, standardization, deduplication, and legacy case ID cross-referencing.
  • Develop, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform AZCCATS structures 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 loads; implement alerts, error monitoring, checkpoint-restart procedures, and job recovery.
  • 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 upserts.
  • Manage Salesforce automation bypass and reactivation during bulk loads, including Apex Triggers, Record-Triggered Flows, and Validation Rules.
  • Coordinate with MuleSoft integration teams to align data mappings with active APIs and avoid payload conflicts during cutover.
  • Develop reconciliation scripts to compare AZCCATS source counts and field checksums with Salesforce target records.
  • Execute iterative mock conversions and validate data integrity in collaboration with business and audit teams.
  • Develop time-sequenced production cutover runbooks and ensure data quality, consistency, and successful migration execution.

Benefits

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