Salesforce Data Migration Architect / Conversion Lead

VIVA USA Inc

Phoenix (AZ)

Híbrido

USD 140 000 - 180 000

Tempo integral

há 4 horas
Torna-te num dos primeiros candidatos

Recebe uma resposta deste recrutador

O teu currículo e carta de apresentação, adaptados exatamente ao que estão a contratar.

Ultrapassa os filtros ATS

Vantagens oferecidas por esta oferta de emprego

Hybrid work model
Competitive compensation

Resumo da oferta

VIVA USA Inc in Phoenix is seeking an experienced Salesforce Data Migration Architect / Conversion Lead to drive end-to-end data transformation from legacy mainframe systems into Salesforce. This role combines deep mainframe data expertise (DB2, fixed-width, COBOL copybooks) with on-the-ground experience in Salesforce data modeling, Bulk API usages, and ETL workflows using Informatica and Atomic Scheduler.

You will design and execute the conversion pipeline, manage staging layers, oversee

Qualificações

  • 5+ years Salesforce experience migrating complex case data into Salesforce
  • 5+ years Informatica experience with mappings and workflows
  • 3+ years Atomic Scheduler or UC4 batch workflow experience
  • Experience with mainframe data (DB2, EBCDIC, COBOL copybooks) is required

Responsabilidades

  • Lead mainframe data extraction and intermediate staging, define Staging 0 and Staging 1 schemas
  • Develop and maintain Informatica mappings, sessions, and workflows; implement error handling and audit logging
  • Orchestrate workloads with Atomic Scheduler; automate job chains and recovery procedures
  • Coordinate with MuleSoft and Salesforce teams for API alignment and cutover planning
  • Develop automated data reconciliation scripts and support production cutover runbooks

Conhecimentos

Salesforce
Informatica
MuleSoft
Mainframe data

Ferramentas

Informatica PowerCenter
IICS
Salesforce Bulk API 2.0

Descrição da oferta de emprego

80% onsite and 20% remote.

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.

Key Roles & Responsibilities
  • 1. Mainframe Data Extraction & Intermediate Staging
    • Decode and extract legacy case management records from the client Automated Tracking System (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 client Automated Tracking System 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 client Automated Tracking System 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 client Automated Tracking System 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 Automated Tracking System 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.
Required Skills
  • 5+ years Salesforce experience
  • 5+ years Informatica experience
  • MuleSoft experience
Notes

Position is hybrid - 80% onsite and 20% remote

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status

Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

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 | Hybrid Onsite 80%
Salesforce Data Migration Architect | Hybrid Onsite 80%

VIVA USA Inc • Phoenix (AZ)

Híbrido
USD 140 000 - 180 000
Hybrid work model
Competitive compensation
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 Business Analyst
Salesforce Business Analyst

MACHINE LEARNING TECHNOLOGIES LLC • Phoenix (AZ)

Presencial
USD 100 000 - 142 000
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio, Inc. • Washington

Presencial
USD 140 000 - 190 000
Lead Mainframe-to-Salesforce Data Architect
Lead Mainframe-to-Salesforce Data Architect

Brooksource • Arizona

Presencial
USD 140 000 - 190 000
Salesforce Tech Lead
Salesforce Tech Lead

TechDigital Group • Juno Beach (FL), Houston (TX)

Presencial
USD 140 000 - 190 000
Salesforce Business Analyst
Salesforce Business Analyst

Quantum Technologies LLC • Virginia

Presencial
USD 100 000 - 142 000