Quick overview
Job description
- We are seeking an experienced Salesforce Data Migration Architect / Conversion Lead to drive the end-to-end data transformation for modernizing our core mainframe application, into a modern Salesforce architecture.
- This role requires a hybrid skill set:
- deep technical understanding of legacy mainframe data structures (DB2, flat files) paired with hands-on expertise in relational database staging environments and modern Salesforce data architecture (Bulk API 2.0, complex relational modeling, and data loading best practices).
- You will be responsible for designing and executing the entire conversion pipeline-from mainframe staging extraction through intermediate staging transformations (Staging 0 to Staging 1) to target loading in Salesforce.
Key Roles & Responsibilities
- Mainframe Data Extraction & Intermediate Staging
- Decode and extract legacy case management records from (handling fixed-width files, EBCDIC formats, packed decimals, and COBOL copybook layouts).
- Design and manage the relational database staging architecture:
- Staging 0 (Raw Layer): Direct ingestion and structural alignment of raw mainframe extracts.
- Staging 1 (Transformation Layer): Cleansing, standardization, de-duplication, cross-referencing legacy case IDs, and constructing target-ready data structures.
- Write performant SQL transformations, stored procedures, and staging scripts to validate data sanity prior to target ingestion.
ETL Development with Informatica
- Build, optimize, and maintain Informatica mappings, mapplets, sessions, and workflows to transform data structures into normalized Salesforce objects.
- Implement error handling, surrogate key lookups, rejection routing, and audit-logging routines directly within Informatica.
- Maintain field-level Source-to-Target Mapping (STTM) documentation, ensuring complete tracing 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 the sequence of operations: trigger mainframe file transfers, execute intermediate database staging scripts, run Informatica workflows, and initiate target load scripts.
- Implement automated alerting, error monitoring, and checkpoint-restart procedures within Atomic to guarantee automated recovery of interrupted conversion jobs.
Target Ingestion & MuleSoft Coordination
- Architect and execute high-volume data loads into Salesforce Case Management (Cases, Contacts, Accounts, Case History, Notes, Docket Records, and Custom Objects) using Salesforce Bulk API 2.0.
- Establish and populate External ID fields across Salesforce objects to ensure idempotent, upsert-capable, and repeatable data conversions.
- Temporarily bypass and reactivate Salesforce automations (Apex Triggers, Record-Triggered Flows, Validation Rules) during bulk loads to optimize throughput and preserve historical audit timestamps.
- Coordinate with the MuleSoft integration team to align data mapping schemas with active APIs and avoid payload conflicts during cutover windows.
Quality Assurance, Reconciliation & Cutover
- Develop automated data reconciliation scripts comparing source AZCCATS record counts and field checksums against target Salesforce entities.
- Execute iterative mock conversions, validate data integrity with business and audit teams, and build a time-sequenced production cutover runbook.
Mandatory Technical Experience
- Salesforce (5+ years):
- Proven experience migrating complex case management data into Salesforce (Service Cloud or Custom Case Architecture).
- In-depth expertise with Salesforce Bulk API / Bulk API 2.0, Data Loader, SOQL, and relational object modeling.
- Practical knowledge of governor limits, bulk storage limits, and automation bypass techniques.
- Informatica (5+ years):Extensive hands-on experience developing enterprise data conversion mappings and workflows using Informatica (PowerCenter Or IICS)
- Expertise with complex transformations, parameter files, performance tuning, and error recovery.
- Atomics (Atomic) Scheduler (3+ years): Direct experience designing, configuring, and monitoring batch workflows, calendar schedules, and multi-systems dependencies with Atomic/UC4.
- Database & SQL (5+ years): Advanced SQL skills, schema design, performance indexing, and transformation logic with relational database environments (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 migration Batch process and real-time interfaces.
Required Skills
- 5+ years Salesforce experience
- 5+ years Informatica experience
- MuleSoft experience
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- ME
Full Stack Java DeveloperRecently posted
Menzo · Tampa, FL · On-site · Posted 20 Nov 2026 🇺🇸
DockerMicroservicesMySQL+26TechnologySalary not listed - RR

PACS Integration EngineerRecently posted
Real Radiology LLC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLTCP/IPDNS+2TechnologySalary not listed - DH

Healthcare/Medicaid Solutions ArchitectRecently posted
Digital Health Links · Columbus, OH · On-site · Posted 20 Nov 2026 🇺🇸
MicroservicesAWSETL+8TechnologySalary not listed - LB

Dev Ops Software Engineer_ W2Recently posted
Learn Beyond Consulting LLC · Irvine, CA · On-site · Posted 20 Nov 2026 🇺🇸
SQLAWSC#+4TechnologySalary not listed - CB
Salesforce DeveloperRecently posted
Code Beacons Inc · Columbus, OH · On-site · Posted 20 Nov 2026 🇺🇸
ScrumJavaREST+2TechnologySalary not listed - CR

Service Desk Manager with Security ClearanceRecently posted
Caelum Research Corporation · Fort Liberty, NC · Hybrid · Posted 20 Nov 2026 🇺🇸
TechnologySalary not listed - SA

Looking for SDET Engineer in Austin, TX – OnsiteRecently posted
Saksoft · Austin, TX · On-site · Posted 20 Nov 2026 🇺🇸
SeleniumJavaPlaywright+1TechnologySalary not listed - AC
AI Platform Engineer 100% REmoteRecently posted
Apetan Consulting · United States · Remote · Posted 20 Nov 2026 🇺🇸
MLflowGoogle CloudJava+10TechnologySalary not listed - GA

In-Vehicle Infotainment System EngineerRecently posted
Galent · Plano, TX · On-site · Posted 20 Nov 2026 🇺🇸
Stakeholder ManagementMicrosoft PowerPointTechnologySalary not listed - NG

Systems Engineer - Level 4Recently posted
Northrop Grumman · Dulles, VA · Hybrid · Posted 20 Nov 2026 🇺🇸
MATLABTechnology$122.8k - $184.2k/yr - IG

AI Developer with Security ClearanceRecently posted
Insight Global, Inc. · Fort Meade, MD · Remote · Posted 20 Nov 2026 🇺🇸
LLMPythonSystem DesignTechnologySalary not listed - IT

CXone Lead Developer – NICE CXone (Onshore)Recently posted
Ideate Technologies LLC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
Stakeholder ManagementRESTSOAP+2Technology$55/hr
