Skip to content
×

Data Architect

Job in Gilbert, Maricopa County, Arizona, 85233, USA
Listing for: Brooksource
Full Time position Listed on 2026-11-15
Job specializations:
Salary/Wage Range or Industry Benchmark: 140000 - 190000 USD Yearly USD 140000.00 190000.00 YEAR

Job Description & How to Apply Below

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 & Mule Soft 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
    ** 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
    ** Mule Soft
    * * 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…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Education Level
Experience Level (years)
Posted in last:
Salary