> Markdown version of [/jobs/ext/4822145-salesforce-data-migration-architect-conversion-lead](https://www.wearedevelopers.com/jobs/ext/4822145-salesforce-data-migration-architect-conversion-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Salesforce Data Migration Architect / Conversion Lead - **Company:** Seer Solutions Inc. - **Location:** Phoenix, AZ, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** 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, 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 - **Published:** November 21, 2026 - **Apply:** https://www.dice.com/job-detail/84452198-4e44-4503-98ca-aba929b96055 ## About the Role * 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. ## 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.