Salesforce Data Migration Architect
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.