Job Title: Salesforce Data Migration Architect
Job Code: AZ 14570 Client: State of Arizona – Arizona Department of Economic Security (AZDES), DTS Location: Phoenix, Arizona Duration: 6 Months from Projected Start Date Work Hours: Monday–Friday, 8:00 AM–5:00 PM (40 Hours/Week) Work Location: 1400 W Washington St, Phoenix, AZ 85007 Work Arrangement: Hybrid – 80% Onsite / 20% Remote Closing Date: 11/20/2026 at 3:00 PM
Position Overview
The State of Arizona – AZDES, Department of Technology Services (DTS), is seeking an experienced Salesforce Data Migration Architect / Conversion Lead to lead the end-to-end data migration and transformation of its legacy mainframe application (AZCCATS) into a modern Salesforce architecture.
The selected candidate will be responsible for designing and executing the complete data conversion pipeline, including mainframe data extraction, relational database staging, Informatica ETL transformations, workload orchestration, and high-volume Salesforce data loading.
The ideal candidate must have strong hands-on experience with Salesforce data migration, Informatica, Atomic Scheduler, SQL databases, and legacy mainframe data structures.
Required Skills & Experience
• Salesforce – 5+ Years: Experience migrating complex case management data into Salesforce Service Cloud or custom case architectures. Strong knowledge of Bulk API / Bulk API 2.0, Data Loader, SOQL, relational object modeling, and Salesforce governor limits.
• Informatica – 5+ Years: Hands-on experience developing enterprise data conversion mappings and workflows using Informatica PowerCenter or IICS. Knowledge of complex transformations, parameter files, performance tuning, and error recovery.
• Atomic Scheduler – 3+ Years: Experience designing, configuring, and monitoring batch workflows, calendar schedules, job dependencies, and workload automation using Atomic/UC4.
• Database & SQL – 5+ Years: Advanced SQL skills, relational database design, schema development, performance indexing, stored procedures, and transformation logic. Experience with 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 batch migration processes and real-time interfaces.
Key Responsibilities
- Mainframe Data Extraction & Staging
- Extract and decode legacy case management records from AZCCATS.
- Work with fixed-width files, EBCDIC formats, packed decimals, and COBOL copybook layouts.
- Design and manage relational database staging architecture.
- Develop Staging 0 (Raw Layer) for ingestion and structural alignment of mainframe extracts.
- Develop Staging 1 (Transformation Layer) for data cleansing, standardization, de-duplication, and cross-referencing legacy case IDs.
- Write optimized SQL transformations, stored procedures, and staging scripts.
- ETL Development with Informatica
- Develop, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows.
- Transform AZCCATS data structures into normalized Salesforce objects.
- Implement error handling, surrogate key lookups, rejection routing, and audit logging.
- Maintain Source-to-Target Mapping (STTM) documentation.
- Ensure complete data traceability from legacy case histories to Salesforce fields.
- Workload Orchestration with Atomic Scheduler
- Build, schedule, and maintain complex job chains, dependencies, and event triggers using Atomic Workload Automation.
- Automate mainframe file transfers, database staging scripts, Informatica workflows, and Salesforce load processes.
- Implement automated alerts, error monitoring, and checkpoint-restart procedures.
- Ensure reliable execution and recovery of interrupted conversion jobs.
- Salesforce Data Loading & MuleSoft Coordination
- Architect and execute high-volume data loads into Salesforce Case Management using Salesforce Bulk API 2.0.
- Migrate Cases, Contacts, Accounts, Case History, Notes, Docket Records, and Custom Objects.
- Establish External ID fields to support repeatable, idempotent, and upsert-capable data conversions.
- Manage Salesforce automation bypass and reactivation during bulk loads, including Apex Triggers, Record-Triggered Flows, and Validation Rules.
- Coordinate with MuleSoft integration teams to align data mapping schemas with active APIs and avoid payload conflicts during cutover.
- Quality Assurance, Reconciliation & Cutover
- Develop automated data reconciliation scripts to compare source AZCCATS record counts and field checksums against Salesforce target records.
- Execute iterative mock conversions and validate data integrity.
- Collaborate with business and audit teams to verify migration accuracy.
- Develop time-sequenced production cutover runbooks.
- Ensure data quality, consistency, and successful migration execution.
Technical Skills & Tools
• Salesforce: Salesforce Service Cloud, Bulk API 2.0, Data Loader, SOQL, Salesforce Object Modeling.
• ETL: Informatica PowerCenter, Informatica IICS.
• Scheduling: Atomic Scheduler / UC4.
• Databases: Microsoft SQL Server, Oracle, PostgreSQL, IBM DB2.
• Mainframe: AZCCATS, EBCDIC, COBOL Copybooks, VSAM, Sequential Files.
• Integration: MuleSoft, REST APIs, Data Contracts.
• Data Migration: Data Mapping, Data Transformation, Data Cleansing, De-duplication, Data Reconciliation.
• SQL: Stored Procedures, SQL Optimization, Schema Design, Indexing.
Primary Skills Salesforce Data Migration, Salesforce Bulk API 2.0, Salesforce Service Cloud, Informatica PowerCenter, Informatica IICS, Atomic Scheduler, UC4, SQL Server, Oracle, PostgreSQL, IBM DB2, AZCCATS, Mainframe Data Conversion, EBCDIC, COBOL Copybooks, VSAM, MuleSoft, ETL, Data Mapping, Data Transformation, Data Reconciliation, SQL Optimization, Relational Database Modeling.
Flexible work from home options available.