In short
We are partnering with an organization currently undergoing a major multi-year digital modernization initiative.
SQLSALESFORCE
📋 About the job
📍
LocationPhoenix, AZ (must be a current resident)
💰
PayUp to $75 per hour
🕒
ScheduleHybrid (80% onsite, 20% remote)
Job Title: Salesforce Data Migration Architect (Conversion Lead)
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 extrac…