Salesforce Data Migration Architect/Conversion Lead

S R INTERNATIONAL INC•Phoenix, AZ
•$77 - $87•Hybrid

About The Position

The Salesforce Data Migration Architect/Conversion Lead will drive the end-to-end data transformation required to modernize the AZCCATS mainframe application into a modern Salesforce architecture. The role combines expertise in legacy mainframe data structures, relational database staging environments, and Salesforce data architecture. The position is responsible for designing and executing the conversion pipeline, from mainframe extraction through Staging 0 raw ingestion and Staging 1 transformations to Salesforce target loading. Work includes extracting AZCCATS case-management records, developing Informatica transformations, orchestrating batch workflows with Atomic Scheduler, coordinating with the MuleSoft integration team, and validating data through reconciliation and cutover activities. This role is hybrid, with 80% onsite work and 20% remote work. Applicants must currently reside in Arizona.

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 expertise with 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 with PowerCenter or IICS, including enterprise conversion mappings and workflows.
  • Expertise in 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 multi-system dependencies with Atomic/UC4.
  • 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.
  • Direct experience with mainframe extracts, 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 from fixed-width files, including EBCDIC formats, packed decimals, and COBOL copybook layouts.
  • Design and manage relational database staging architecture, including raw ingestion in Staging 0 and cleansing, standardization, deduplication, cross-referencing, and target-ready structures in Staging 1.
  • Write and maintain performant SQL transformations, stored procedures, and staging scripts to validate data before target ingestion.
  • Build, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform AZCCATS data into normalized 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.
  • Orchestrate mainframe file transfers, database staging scripts, Informatica workflows, and Salesforce target-load scripts.
  • Configure automated alerting, error monitoring, and checkpoint-restart procedures to recover 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 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 mappings with active APIs and avoid payload conflicts during cutover windows.
  • Develop automated reconciliation scripts comparing source record counts and field checksums with Salesforce target entities.
  • Execute 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