Salesforce Data Migration Architect / Conversion Lead

Hybrid in Phoenix, AZ, US • Posted 4 hours ago • Updated 4 hours ago
Full Time
No Travel Required
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Salesforce Data Migration
  • Salesforce Architect
  • Informatica PowerCenter
  • IICS
  • Atomic Scheduler
  • UC4
  • Mainframe
  • DB2
  • EBCDIC
  • COBOL
  • Bulk API 2.0
  • MuleSoft
  • SQL.

Summary

Salesforce Data Migration Architect / Conversion Lead

Location: Phoenix, AZ
Work Mode: Hybrid – 80% Onsite / 20% Remote

Job Overview

We are urgently seeking an experienced Salesforce Data Migration Architect / Conversion Lead to lead end-to-end data migration and transformation for modernizing a legacy mainframe application into a modern Salesforce architecture.

The ideal candidate must have strong hands-on experience with Salesforce data migration, Informatica ETL development, Atomic Workload Automation, advanced SQL, and mainframe data conversion (DB2, EBCDIC, flat files, and COBOL copybooks).

Key Responsibilities

Mainframe Data Extraction & Database Staging

  • Extract and transform legacy AZCCATS case management data from mainframe systems.

  • Work with fixed-width files, EBCDIC formats, packed decimals, and COBOL copybook layouts.

  • Design and manage raw (Staging 0) and transformation (Staging 1) database layers.

  • Develop SQL queries, stored procedures, and scripts for data cleansing, validation, de-duplication, and transformation.

Informatica ETL Development

  • Develop and maintain Informatica mappings, mapplets, sessions, and workflows.

  • Build data transformation processes to convert legacy mainframe data into Salesforce objects.

  • Implement error handling, surrogate key lookups, audit logging, and rejection handling.

  • Maintain Source-to-Target Mapping (STTM) documentation.

Atomic Workload Automation

  • Design and manage batch workflows, job dependencies, schedules, and event triggers using Atomic Scheduler.

  • Automate file transfers, database staging, Informatica workflows, and Salesforce loading processes.

  • Implement monitoring, alerts, error handling, and recovery mechanisms.

Salesforce Data Migration & MuleSoft Integration

  • Design and execute high-volume Salesforce data migrations using Bulk API 2.0.

  • Migrate Cases, Contacts, Accounts, Case History, Notes, Docket Records, and custom objects.

  • Configure External IDs to support reliable upsert and repeatable migration processes.

  • Coordinate with MuleSoft teams to align API schemas and integration requirements.

Data Validation & Production Cutover

  • Develop data reconciliation scripts to validate source and target records.

  • Perform mock conversions and data integrity checks.

  • Collaborate with business and audit teams.

  • Prepare production cutover plans and migration runbooks.

Mandatory Technical Skills

  • Salesforce – 5+ Years: Service Cloud, Bulk API 2.0, Data Loader, SOQL, relational data modeling, and complex data migration.

  • Informatica – 5+ Years: Informatica PowerCenter or IICS, ETL mappings, workflows, transformations, and performance tuning.

  • Atomic Scheduler – 3+ Years: Atomic Workload Automation, batch scheduling, job dependencies, and workflow monitoring.

  • Database & SQL – 5+ Years: Advanced SQL, stored procedures, database schema design, indexing, and performance optimization.

  • Mainframe Data Conversion: Hands-on experience with DB2, EBCDIC, sequential files, VSAM, packed decimals, and COBOL copybooks.

  • MuleSoft: Understanding of MuleSoft APIs, integration patterns, and data contract alignment.

Ideal Candidate Profile

  • Strong experience leading enterprise-level data migration projects.

  • Ability to manage end-to-end conversion pipelines from legacy mainframe systems to Salesforce.

  • Excellent troubleshooting, analytical, and communication skills.

  • Experience coordinating with cross-functional technical and business teams.

Interested candidates: Please share your updated resume along with your contact details, current location, work authorization, and availability.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91094776
  • Position Id: 9148546
  • Posted 4 hours ago

Company Info

About SeersolutionsInc

Seer Solutions Inc is an innovative, end-to-end IT Solutions and Services Company specializing in Cloud, Process Automation, Al-ML, Data Engineering, Predictive Analytics Cybersecurity, and IT staff augmentation, among others. We are catalysts of digital transformation, empowering clients to effectively accomplish their mission objectives by combining seamless efficiency with unmatched innovation.

Contact the job poster
TK

Tabitha Kagitha

Recruiter @ SeersolutionsInc

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.