Salesforce Data Migration Architect / Conversion Lead
Seer Solutions Inc.
Phoenix, AZ, United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Working hours
Regular working hours
Job source
Tech stack
Application Programming Interfaces (APIs)
Audit Trail
COBOL (Programming Language)
Databases
Customer Data Management
Data Validation
Data Cleansing
Data Conversion
Data Integrity
Extract Transform Load (ETL)
Data Mapping
Data Transformation
+21 more
Data Migration
Data Mining
IBM DB2
Relational Databases
Database Schema
File Systems
File Transfer
Intrusion Detection Systems
Mainframes
Performance Tuning
Cloud Services
Salesforce.Com
SQL Stored Procedures
SQL Databases
Virtual Storage Access Methods
Sql Optimization
Informatica Powercenter
Indexer
Data Loader
Salesforce Object Query Language (SOQL)
Mulesoft
Job description
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)., 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.
Requirements
- 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., * 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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦