Job Title: Salesforce Data Migration Architect (Conversion Lead)
Location: Phoenix, AZ (must be a current resident)
Rate: Up to $75 per hour
Schedule: Hybrid (80% onsite, 20% remote)
We are partnering with an organization currently undergoing a major multi-year digital modernization initiative. This is an opportunity to serve as the end-to-end architectural lead on a modernization project migrating millions of records off a legacy mainframe environment into a modern Salesforce architecture.
Here’s what you’ll be doing:
- Architecting and managing a multi-tier relational database staging environment (Raw Ingestion Layer moving into a Cleansed Transformation Layer) to prepare legacy mainframe extracts for cloud ingestion.
- Decoding and extracting legacy case management records (handling fixed-width layouts, EBCDIC formats, packed decimals, and COBOL copybooks) and writing performant SQL validation scripts.
- Designing and optimizing enterprise Informatica mappings, mapplets, and workflows with robust error handling, surrogate key lookups, and Source-to-Target Mapping (STTM) documentation.
- Orchestrating cross-platform batch job chains, dependencies, alerting, and checkpoint-restart routines using Automic (UC4) Workload Automation.
- Executing high-volume data loads into Salesforce Service Cloud and custom objects using Bulk API 2.0, External IDs, and temporary automation bypass protocols (triggers, flows, and validation rules).
- Coordinating closely with MuleSoft integration engineers to align batch data schemas with active APIs and prevent payload conflicts during cutover windows.
- Leading automated data reconciliation checks, iterative mock conversions, and minute-by-minute production cutover runbooks with audit and business stakeholders.
Here’s what our ideal candidate has:
- 5+ years of hands-on experience architecting and executing case management data migrations into Salesforce (Service Cloud/Custom Objects) using Bulk API / Bulk API 2.0, SOQL, and Data Loader.
- 5+ years of enterprise ETL development experience building and tuning conversion mappings and workflows in Informatica (PowerCenter or IICS).
- Advanced SQL and relational database experience (SQL Server, Oracle, PostgreSQL, or DB2), including multi-tier staging design and data reconciliation.
- 3+ years of direct experience designing and monitoring batch workflows and dependencies using Automic / UC4 Scheduler.
- Proven background working with legacy mainframe data extracts (EBCDIC, flat files, COBOL copybooks) and practical familiarity with MuleSoft API integration patterns.