SR
Salesforce Data Migration Architect
- Hiring from
- United States
- Work type
- Hybrid
- Posted
626,918 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
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
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
1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
About SR International INC.
SR International has been a leading name among the IT consulting companies with offices in US and India. For past 16 years, our industry experience and domain knowledge have enabled us to provide innovative solutions to our customers.
Who We Are
Who We Are
We Are Leading IT Based Solution Providers
Today, the world of business information represents the realization of our collective efforts toward improving the future. Held only by the limits of our imagination, the business world is accelerating at an ever-increasing pace. Imagine a better way of doing business, of implementing the perfect software, of refining practice or business integration. All it takes are benchmark standards in service, support, and technical know-how, which have been our bread and butter.
Our Vision.
Our Vision.
Established in 2002, SR International Inc is one of the fastest growing and reputed provider of Information Technology Services and Solutions in the USA. Since our inception, we have been a trusted IT partner for our clients. We take pride in our highly skilled IT Resources and unique engagement model. We have been consistently delivering on our promises as a high-performance team. Our expertise in Cloud Computing, Mobility, Web Technologies, ERP and CRM are second to none. Our industry-leading flagship product iMathSmart is re-defining math learning experience for school students.
Career At SR International
At SR International, we treat our consultants like family. Our business and our reputation have been built and maintained by quality resources working onboard, so it’s important for us to maintain the quality resource pool.