Salesforce Data Migration Architect/Conversion Lead

S R International•Phoenix, AZ
•Hybrid

About The Position

SR International is seeking a Salesforce Data Migration Architect / Conversion Lead to drive end-to-end data transformation for modernizing the State of Arizona AZDES core mainframe application into a Salesforce architecture. The role covers the full conversion pipeline, from mainframe extraction and intermediate database staging through transformation and target loading in Salesforce. It combines knowledge of legacy mainframe data structures with hands-on experience in relational database staging and Salesforce data architecture. The position is hybrid, with 80% onsite and 20% remote work, and is limited to current Arizona residents. Flexible work-from-home options are available. Compensation is $77.00–$87.00 per hour. The role includes extracting AZCCATS case-management data; designing and managing raw and transformation staging layers; developing Informatica ETL mappings and workflows; orchestrating conversion jobs with Atomic Workload Automation; loading and reconciling data in Salesforce; coordinating data mappings with the MuleSoft integration team; and preparing mock conversions and production cutover plans. The position is listed by SR International, an IT services and solutions provider.

Requirements

  • At least 5 years of Salesforce experience, including migration of complex case-management data into Salesforce Service Cloud or a custom case architecture.
  • In-depth knowledge of Salesforce Bulk API or Bulk API 2.0, Data Loader, SOQL, and relational object modeling.
  • Practical knowledge of Salesforce governor limits, bulk storage limits, and automation-bypass techniques.
  • At least 5 years of hands-on Informatica experience developing enterprise data-conversion mappings and workflows using PowerCenter or IICS.
  • Experience with Informatica complex transformations, parameter files, performance tuning, and error recovery.
  • At least 3 years of direct experience designing, configuring, and monitoring batch workflows, calendar schedules, and multisystem dependencies with Atomic/UC4 Scheduler.
  • At least 5 years of advanced SQL and relational database experience, including schema design, performance indexing, and transformation logic in SQL Server, Oracle, PostgreSQL, or DB2 environments.
  • Direct experience with mainframe AZCCATS conversion, including 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.
  • Must currently reside in Arizona.

Responsibilities

  • Decode and extract 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 in Staging 0 and cleansing, standardization, de-duplication, cross-referencing, and target-ready structures in Staging 1.
  • Write performant SQL transformations, stored procedures, and staging scripts to validate data before ingestion.
  • Build, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform AZCCATS data into Salesforce objects.
  • Implement Informatica error handling, surrogate-key lookups, rejection routing, and audit logging.
  • Maintain field-level Source-to-Target Mapping documentation tracing legacy case histories to Salesforce fields.
  • Build, schedule, and maintain Atomic Workload Automation job chains, dependencies, and event triggers.
  • Automate the sequence of file transfers, database staging scripts, Informatica workflows, and Salesforce target-load scripts.
  • Implement Atomic alerting, error monitoring, and checkpoint-restart procedures for recovery of interrupted conversion jobs.
  • Architect and execute high-volume Salesforce Bulk API 2.0 loads for Cases, Contacts, Accounts, Case History, Notes, Docket Records, and Custom Objects.
  • Establish and populate Salesforce External ID fields to support idempotent, upsert-capable, repeatable conversions.
  • Temporarily bypass and reactivate Salesforce automations, including Apex Triggers, record-triggered Flows, and Validation Rules, during bulk loads.
  • Coordinate with the MuleSoft integration team to align data mapping schemas with active APIs and avoid payload conflicts during cutover windows.
  • Develop automated reconciliation scripts comparing source AZCCATS record counts and field checksums with Salesforce target entities.
  • Run iterative mock conversions, validate data integrity with business and audit teams, and prepare a time-sequenced production cutover runbook.

Benefits

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