Salesforce Data Migration Architect / Conversion Lead - Hybrid

Hybrid in Phoenix, AZ, US β€’ Posted 2 hours ago β€’ Updated 2 hours ago
Contract W2
6 Months
No Travel Required
Hybrid
$72 - $77/hr
Company Branding Image
Fitment

Dice Job Match Scoreβ„’

πŸ”’ Crunching numbers...

Job Details

Skills

  • Salesforce Data Migration
  • case management data
  • Salesforce
  • Service Cloud
  • Custom Case Architecture
  • Salesforce Bulk API
  • Data Loader
  • SOQL
  • relational object modeling
  • governor limits
  • bulk storage limits
  • automation bypass techniques
  • enterprise data conversion mappings
  • workflows
  • Informatica
  • PowerCenter
  • IICS
  • transformations
  • parameter files
  • performance tuning
  • error recovery
  • batch workflows
  • calendar schedules
  • SQL skills
  • schema design
  • performance indexing
  • transformation logic
  • SQL server
  • Oracle
  • PostgreSQL
  • DB2
  • Mainframe Automated Tracking System Conversion
  • EBCDIC conversion
  • sequential files
  • VSAM/DB2 data
  • COBOL copybooks
  • MuleSoft APIs
  • integration patterns
  • data contract alignment
  • end-to-end data transformation
  • SQL transformations
  • Informatica mappings
  • mapplets
  • ETL Development
  • Salesforce objects

Summary

𝐓𝐒𝐭π₯𝐞: Salesforce Data Migration Architect / Conversion Lead - Onsite
Β 
Β 
Β 
𝐌𝐚𝐧𝐝𝐚𝐭𝐨𝐫𝐲 𝐬𝐀𝐒π₯π₯𝐬:
Β 
Salesforce Data Migration, case management data,
Salesforce, Service Cloud, Custom Case Architecture,
Salesforce Bulk API, Data Loader, SOQL, relational object modeling,
governor limits, bulk storage limits, automation bypass techniques,
enterprise data conversion mappings, workflows, Informatica, PowerCenter, IICS,
transformations, parameter files, performance tuning, error recovery,
batch workflows, calendar schedules, SQL skills, schema design, performance indexing, transformation logic,
SQL server, Oracle, PostgreSQL, DB2,
Mainframe Automated Tracking System Conversion, EBCDIC conversion, sequential files, VSAM/DB2 data, COBOL copybooks,
MuleSoft APIs, integration patterns, data contract alignment, end-to-end data transformation,
SQL transformations, Informatica mappings, mapplets, ETL Development, Salesforce objects
Β 
Β 
πƒπžπ¬πœπ«π’π©π­π’π¨π§:
Β 
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
Β 
1. Mainframe Data Extraction & Intermediate Staging
Decode and extract legacy case management records from the client Automated Tracking System (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 client Automated Tracking System 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 client Automated Tracking System 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 client Automated Tracking System 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 Automated Tracking System 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 bathc process and real-time interfaces.
Β 
Required Skills
5+ years Salesforce experience
5+ years Informatica experience
MuleSoft experience
Β 
Β 
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.
Β 
Β 
π‚π¨π§π­πšπœπ­ πƒπžπ­πšπ’π₯𝐬 :
Β 
Account co-ordinator: Ramadas Kumaresan
Β 
Β 
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
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: vivausa
  • Position Id: RKAZPA170
  • Posted 2 hours ago

Company Info

About VIVA USA INC

VIVA is an Information Technology Management and Consulting services company with offices in the US and India.

Formed by some of the industry's most experienced and knowledgeable people, VIVA is growing to be one of the best-managed consulting companies in the world. VIVA has established itself as a reliable supplier of IT services. We specialize in IT staff augmentation, On-site and Off-site IT consulting, Turnkey Project Outsourcing, and eBusiness Solutions. Our software professionals have successfully worked on many on-site and off-site IT consulting engagements across the US.

Our business focus includes areas of on-site, off-site and offshore information technology consulting services and software development.

The software development centers in our corporate office at Rolling Meadows, IL and at Chennai, India are well equipped to undertake software development, maintenance and conversion activities.

VIVA has associated itself with leading software vendors such as Microsoft, Rational and COGNOS. VIVA is a Rational Unified Partner, a Microsoft Certified Solution Provider and a COGNOS premier partner.

About_Company_OneAbout_Company_Two
Contact the job poster
RK

Ramadas Kumaresan

Recruiter @ VIVA USA INC

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