Salesforce Data Migration Architect (Phoenix AZ)
Posted Updated
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.
2. 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.
3. 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.
4. 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.
5. 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
Skills
Sign in to read and join the discussion.