Data Architect

Brooksource

Arizona

On-site

USD 140,000 - 190,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Brooksource in Arizona seeks an experienced Salesforce Data Migration Architect/Conversion Lead to drive end-to-end data transformation from legacy mainframe sources into a modern Salesforce architecture.

You will design the conversion pipeline, encompassing mainframe staging, Informatica mappings, Atomic Scheduler workflows, and high‑volume Salesforce loads, coordinating with MuleSoft, ensuring data integrity and a smooth production cutover.

Qualifications

  • 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.

Responsibilities

  • Architect and drive end-to-end data migration from mainframe sources to Salesforce.
  • Design and manage mainframe staging (DB2, fixed-width, EBCDIC, COBOL copybooks) and relational staging layers.
  • Build and optimize Informatica mappings, sessions, and workflows for target loading.
  • Coordinate with MuleSoft to align data mapping schemas and APIs during cutover windows.
  • Develop automated reconciliation scripts and runbooks for production cutover.
  • Implement workload orchestration with Atomic Scheduler and robust error handling.

Skills

Salesforce Data Migration
Informatica
Atomic Scheduler
SQL & Databases
Mainframe Data Extraction

Tools

Salesforce Bulk API 2.0
Data Loader
SOQL
Automic UC4
MuleSoft
Informatica PowerCenter/IICS
DB2
ETL tooling

Job description

Salesforce Data Migration Architect / Lead (Mainframe to Salesforce)

Position Overview:

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 (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 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 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 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.
Atomic (Atomic) Scheduler (3+ years):
  • Direct experience designing, configuring, and monitoring batch workflows, calendar schedules, and multi‑system dependencies in Automic / UC4.
Database & SQL (5+ years):
  • Advanced SQL skills, schema design, performance indexing, and transformation logic within relational database environments (SQL Server, Oracle, PostgreSQL, or DB2).
Mainframe 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 batch processes and real‑time interfaces.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio, Inc • Washington

On-site
USD 140,000 - 190,000
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio Inc. • Washington

Hybrid
USD 140,000 - 190,000
Salesforce Data & File Migration Technical Lead
Salesforce Data & File Migration Technical Lead

Yudrio, Inc. • Washington

On-site
USD 140,000 - 190,000
Lead Mainframe-to-Salesforce Data Architect
Lead Mainframe-to-Salesforce Data Architect

Brooksource • Arizona

On-site
USD 140,000 - 190,000
Senior Technical Data Migration Lead – Salesforce & Azure
Senior Technical Data Migration Lead – Salesforce & Azure

NexTurn • King of Prussia (PA)

On-site
USD 150,000 - 190,000
Senior Technical Project Manager
Senior Technical Project Manager

Brooksource • Phoenix (AZ)

On-site
USD 140,000 - 190,000
Salesforce Tech Lead
Salesforce Tech Lead

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

On-site
USD 140,000 - 190,000
Data Architect
Data Architect

Stealth Solutions, Inc. • Sterling (VA)

Hybrid
USD 140,000 - 190,000
401(k)
401(k) matching
Health insurance
+1
Salesforce Architect
Salesforce Architect

TechDigital Group • Juno Beach (FL)

On-site
USD 140,000 - 200,000
Data Migration Lead
Data Migration Lead

Touchpoints • Sacramento (CA)

On-site
USD 150,000 - 190,000