Salesforce Data Migration Architect

Novalink Solutions

Phoenix (AZ)

Híbrido

USD 120.000 - 160.000

Jornada completa

Hace 5 días
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Descripción de la vacante

Novalink Solutions is seeking an experienced Salesforce Data Migration Architect to lead end-to-end data transformation from legacy mainframe (AZCCATS) into Salesforce. You will architect, implement, and optimize the conversion pipeline across mainframe extraction, staging, Informatica transformations, and bulk data loads using Salesforce Bulk API 2.0.

The role requires hands-on experience with ETL development, atomic workload orchestration, and MuleSoft integrations, plus strong SQL and

Formación

  • 5+ years Salesforce experience.
  • In-depth Salesforce Bulk API 2.0, Data Loader, SOQL, and relational object modeling.
  • Expertise with mainframe AZCCATS conversion and COBOL copybooks.
  • Proven Informatica mappings and workflows development.

Responsabilidades

  • Migrate and transform legacy mainframe AZCCATS data into Salesforce.
  • Design and maintain Informatica mappings, sessions, and workflows.
  • Orchestrate job sequences with Atomic Scheduler across systems.
  • Coordinate with MuleSoft for data mapping and APIs during cutover.
  • Develop automated reconciliation scripts and runbooks for production cutover.

Conocimientos

Salesforce
Informatica
Atomic Scheduler
MuleSoft
SQL
Mainframe data

Herramientas

Bulk API 2.0
Data Loader
SOQL
MuleSoft

Descripción del empleo

Phoenix, United States | Posted on 11/17/2026

  • Actual Job Title Salesforce Data Migration Architect
  • Job Type FT Contract
  • Date Opened 11/17/2026
  • Target Date 11/19/2026
  • City Phoenix
  • State/Province Arizona
  • Country United States
  • Number of Positions 1
Job Description

We are seeking an experienced Salesforce Data Migration Architect / Conversion Lead to drive the end-to-end data transformation for modernizing our core mainframe application, into a modern Salesforce architecture.

This role requires a hybrid skill set: deep technical understanding of legacy mainframe data structures (DB2, flat files) paired with hands-on expertise in relational database staging environments and modern Salesforce data architecture (Bulk API 2.0, complex relational modeling, and data loading best practices). You will be responsible for designing and executing the entire conversion pipeline—from mainframe staging extraction through intermediate staging transformations (Staging 0 to Staging 1) to target loading in Salesforce.

Mainframe Data Extraction & Intermediate Staging

Decode and extract legacy case management records from AZCCATS (handling fixed-width files, EBCDIC formats, packed decimals, and COBOL copybook layouts).

Design and manage the relational database staging architecture:

Staging 0 (Raw Layer): Direct ingestion and structural alignment of raw mainframe extracts.

Staging 1 (Transformation Layer): Cleansing, standardization, de-duplication, cross-referencing legacy case IDs, and constructing target-ready data structures.

Write performant SQL transformations, stored procedures, and staging scripts to validate data sanity prior to target ingestion.

2. ETL Development with Informatica

Build, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform AZCCATS data structures into normalized Salesforce objects.

Implement error handling, surrogate key lookups, rejection routing, and audit-logging routines directly within Informatica.

Maintain field-level Source-to-Target Mapping (STTM) documentation, ensuring complete tracing from legacy AZCCATS case histories to Salesforce fields.

3. Workload Orchestration with Atomic Scheduler

Build, schedule, and maintain complex job chains, dependencies, and event triggers using Atomic Workload Automation.

Automate the sequence of operations: trigger mainframe file transfers, execute intermediate database staging scripts, run Informatica workflows, and initiate target load scripts.

Implement automated alerting, error monitoring, and checkpoint-restart procedures within Atomic to guarantee automated recovery of interrupted conversion jobs.

4. Target Ingestion & MuleSoft Coordination

Architect and execute high-volume data loads into Salesforce Case Management (Cases, Contacts, Accounts, Case History, Notes, Docket Records, and Custom Objects) using Salesforce Bulk API 2.0.

Establish and populate External ID fields across Salesforce objects to ensure idempotent, upsert-capable, and repeatable data conversions.

Temporarily bypass and reactivate Salesforce automations (Apex Triggers, Record-Triggered Flows, Validation Rules) during bulk loads to optimize throughput and preserve historical audit timestamps.

Coordinate with the MuleSoft integration team to align data mapping schemas with active APIs and avoid payload conflicts during cutover windows.

5. Quality Assurance, Reconciliation & Cutover

Develop automated data reconciliation scripts comparing source AZCCATS record counts and field checksums against target Salesforce entities.

Execute iterative mock conversions, validate data integrity with business and audit teams, and build a time-sequenced production cutover runbook.

Mandatory Technical Experience
Salesforce (5+ years):

Proven experience migrating complex case management data into Salesforce (Service Cloud or Custom Case Architecture).

In-depth expertise with Salesforce Bulk API / Bulk API 2.0, Data Loader, SOQL, and relational object modeling.

Practical knowledge of governor limits, bulk storage limits, and automation bypass techniques.

Informatica (5+ years):Extensive hands-on experience developing enterprise data conversion mappings and workflows using Informatica (PowerCenter Or IICS)

Expertise with complex transformations, parameter files, performance tuning, and error recovery.

Atomics (Atomic) Scheduler (3+ years): Direct experience designing, configuring, and monitoring batch workflows, calendar schedules, and multi-systems dependencies with Atomic/UC4.

Database & SQL (5+ years): Advanced SQL skills, schema design, performance indexing, and transformation logic with relational database environments (SQL server, Oracle, PostgreSQL or DB2).

Mainframe AZCCATS Conversion: Direct experience working with mainframe extracts (EBCDIC conversion, sequential files, VSAM/DB2 data, and COBOL copybooks).

MuleSoft: Practical understanding of MuleSoft APIs, integration patterns, and data contract alignment between migration bathc process and real-time interfaces.

Requirements
Required Skills

Skill Type

Skill Name

5+ years Salesforce experience

Preferred Skills

There are currently no preferred skills to display. Please review job description.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Salesforce Data Migration Architect/Conversion Lead
Salesforce Data Migration Architect/Conversion Lead

S R International Inc • Phoenix (AZ)

Híbrido
USD 140.000 - 210.000
Flexible work options
Data Architect
Data Architect

Brooksource • Arizona

Presencial
USD 140.000 - 190.000
Salesforce Data Migration Architect
Salesforce Data Migration Architect

Access Data Consulting Corporation • Phoenix (AZ)

Híbrido
USD 85.000 - 121.000
Salesforce Data Migration Architect / Conversion Lead
Salesforce Data Migration Architect / Conversion Lead

VIVA • Phoenix (AZ)

Híbrido
USD 140.000 - 180.000
Hybrid work model
Competitive compensation
Hybrid Salesforce Data Migration Architect: Mainframe Modernization
Hybrid Salesforce Data Migration Architect: Mainframe Modernization

S R International Inc • Phoenix (AZ)

Híbrido
USD 140.000 - 210.000
Flexible work options
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio, Inc • Washington

Presencial
USD 140.000 - 190.000
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio Inc. • Washington

Híbrido
USD 140.000 - 190.000
Salesforce Data Migration Architect: Mainframe Modernization
Salesforce Data Migration Architect: Mainframe Modernization

Novalink Solutions • Phoenix (AZ)

Híbrido
USD 120.000 - 160.000
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio, Inc. • Washington

Presencial
USD 140.000 - 190.000
Salesforce Data Migration Architect — Hybrid, Phoenix
Salesforce Data Migration Architect — Hybrid, Phoenix

Access Data Consulting Corporation • Phoenix (AZ)

Híbrido
USD 85.000 - 121.000