Salesforce Data Migration Architect

Novalink Solutions LLC•Phoenix, AZ

About The Position

The Salesforce Data Migration Architect / Conversion Lead will drive the end-to-end data transformation required to modernize a core mainframe application into a modern Salesforce architecture. The role combines expertise in legacy mainframe data structures, relational database staging, Informatica ETL, workload orchestration, and Salesforce data architecture. The architect will design and execute the conversion pipeline from mainframe extraction through Staging 0 and Staging 1 transformations to Salesforce loading, while coordinating with the MuleSoft integration team and business and audit stakeholders.

Requirements

  • At least 5 years of Salesforce experience.
  • Experience migrating 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 with PowerCenter or IICS, including enterprise data 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 with SQL Server, Oracle, PostgreSQL, or DB2.
  • Direct experience working with AZCCATS 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.

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 staging architecture, including raw Staging 0 ingestion and Staging 1 cleansing, standardization, de-duplication, cross-referencing, and target-ready data structures.
  • Develop 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 structures 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 AZCCATS case histories to Salesforce fields.
  • Build, schedule, and maintain Atomic Workload Automation job chains, dependencies, and event triggers.
  • Orchestrate file transfers, database staging scripts, Informatica workflows, and Salesforce target-load scripts through Atomic.
  • Configure automated alerting, error monitoring, and checkpoint-restart procedures for recovery of interrupted conversion jobs.
  • Architect and execute high-volume Salesforce loads for Cases, Contacts, Accounts, Case History, Notes, Docket Records, and custom objects using Bulk API 2.0.
  • Establish and populate External ID fields to support idempotent, upsert-capable, repeatable conversions.
  • Temporarily bypass and reactivate Salesforce Apex Triggers, Record-Triggered Flows, and Validation Rules during bulk loads to optimize throughput and preserve historical audit timestamps.
  • Coordinate with the MuleSoft integration team to align migration mappings with active APIs and prevent payload conflicts during cutover windows.
  • Develop automated reconciliation scripts comparing source record counts and field checksums with target Salesforce entities.
  • Run iterative mock conversions, validate data integrity with business and audit teams, and prepare a time-sequenced production cutover runbook.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service