Salesforce Data Migration Architect--Phoenix, AZ(Hybrid)(Only locals to Arizona & F2F Interview)
Hybrid in Phoenix, AZ, US • Posted 2 hours ago • Updated 2 hours ago
Contract Corp To Corp
Contract W2
Contract Independent
12 Months
No Travel Required
Hybrid
Depends on Experience
Fitment
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
Oracle
Management
Microsoft SQL Server
Microsoft Windows
Informatica PowerCenter
Interfaces
Mainframe
Extraction
IBM DB2
IDS
Informatica
Mapping
Database
Documentation
Extract, Transform, Load
Flat File
Data Loading
Data Mapping
Data Migration
Data Structure
Data Conversion
Data Extraction
Data Integrity
CheckPoint
Cloud Computing
PostgreSQL
Quality Assurance
Oracle Application Express
Recovery
Routing
Orchestration
Performance Tuning
RDBMS
Real-time
Data Architecture
Migration
Modeling
MuleSoft
API
Apex
Auditing
Automic
COBOL
SOQL
SQL
Salesforce.com
Scripting
Storage
Stored Procedures
VSAM
Workflow
Oracle
Management
Microsoft SQL Server
Microsoft Windows
Informatica PowerCenter
Interfaces
Mainframe
Extraction
IBM DB2
IDS
Informatica
Mapping
Database
Documentation
Extract, Transform, Load
Flat File
Data Loading
Data Mapping
Data Migration
Data Structure
Data Conversion
Data Extraction
Data Integrity
CheckPoint
Cloud Computing
PostgreSQL
Quality Assurance
Oracle Application Express
Recovery
Routing
Orchestration
Performance Tuning
RDBMS
Real-time
Data Architecture
Migration
Modeling
MuleSoft
API
Apex
Auditing
Automic
COBOL
SOQL
SQL
Salesforce.com
Scripting
Storage
Stored Procedures
VSAM
Workflow
Summary
Hello Friends,
I Hope you are doing well.
This is Surya from Humac Inc., Please check the following job description. If you are interested, or know someone who might be interested, please share your updated resume.
Role: Salesforce Data Migration Architect
Location: Phoenix, AZ(Hybrid)
Note: Only locals to Arizona & F2F Interview needed.
Position is hybrid - 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 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.
Required Skills
Skill Type
Skill Name
5+ years Salesforce experience
5+ years Informatica experience
MuleSoft experience
--
Best Regards,
Sai Surya Teja| Sr. IT Talent Acquisition
4
Humac Inc.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Title:Salesforce Data Migration Architect - Hybrid; Local to AZ candidates only Location:Phoenix,AZLength: Long termRestriction:w2 or c2cDescription: Job Description: Job OverviewThe client is 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 str
LOOKING FOR ONLY CURRENT ARIZONA RESIDENTS Job Title: Salesforce Data Migration Architect/Conversion Lead Job ID: 14570 - Hybrid Client: State of arizona - AZDES - DTS Closing Date & Time:11/20/2026 3:00:00 PM Position is hybrid - 80% onsite and 20% remote 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 AP
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
Idealforce has contract position available immediately for a Salesforce Data Migration Architect to join our customer in Phoenix,AZ. This a Hybrid Position Please find below additional details about this job. Only Local Candidates are considered for this role. LOCAL TO PHOENIX ONLY 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 Salesforc