SALESFORCE DEVELOPER – DATA MIGRATION SPECIALIST

CMA; City of Albany (NY); On-site; USD 50,000 - 100,000; Full time

Job summary

CMA in Albany, NY is seeking an experienced Salesforce Developer – Data Migration Specialist to lead end-to-end data migrations across multiple Salesforce orgs and legacy systems.

The role focuses on designing data models, mappings, and integration with REST/SOAP APIs; you will build ETL processes using Apex, LWC, and Data Loader, while ensuring data quality and performance.

Qualifications

• 5+ years of hands-on Salesforce development experience.
• Experience in service cloud/Experience Cloud external portal development and implementation.
• Strong knowledge of Apex, SOQL/SOSL, and Lightning Web Components (LWC).
• Experience with Salesforce APIs (REST, Bulk, Metadata, Tooling).
• Familiarity with CI/CD pipelines and version control (Git).
• Knowledge of Salesforce security model (profiles, permission sets, sharing rules, FLS).

Responsibilities

• Lead end-to-end data migrations across multiple Salesforce orgs and legacy systems.
• Design and optimize data models, field mappings, deduplication rules, and validation logic.
• Build custom ETL scripts using Apex, API calls, external ETL tools, or MuleSoft DataWeave.
• Experience with historical data archiving strategies, incremental and delta load processing and data validation.
• Work with stakeholders to define transformation rules, cleansing logic, and test plans.
• Manage bulk API operations, parallel processing, and handling of governor limits.
• Create reusable frameworks: staging tables, delta load logic, and error retries.
• Collaborate with QA to validate migration accuracy and volume tests.
• Tunnne performance for large-scale, multi-million record loads.
• Document all migration artifacts and technical designs.
• Design, develop, and implement robust, scalable Salesforce solutions (Apex, LWC, Visualforce, Flows).
• Develop and maintain integration between Salesforce and external systems using REST/SOAP APIs, Platform Events, and outbound messages.
• Create and optimize Lightning Components (Aura and LWC), custom UI/UX experiences, and responsive designs.
• Perform unit testing, code reviews, and support deployment activities using Gearset, Copado, Salesforce DX, or Change Sets.
• Troubleshoot and resolve production issues, root-cause analysis, and optimize performance (SOQL).
• Collaborate with business analysts, administrators, architects, and stakeholders to gather requirements and translate them into technical solutions.
• Implement SSO integrations using SAML 2.0, OAuth 2.0, and OpenID Connect protocols.
• Create and manage sandbox environments across development, testing, UAT, and staging

Skills

Apex

SOQL/SOSL

Lightning Web Components

Salesforce APIs

CI/CD

Git

Security model

Tools

Gearset

Copado

Salesforce DX

Change Sets

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

SALESFORCE DEVELOPER – DATA MIGRATION SPECIALIST

Albany, NY, US

Salary Range: $50,000.00 To $100,000.00 Annually

Primary Responsibilities:

• Lead end-to-end data migrations across multiple Salesforce orgs and legacy systems.
• Design and optimize data models, field mappings, deduplication rules, and validation logic.
• Build custom ETL scripts using Apex, API calls, external ETL tools, or MuleSoft DataWeave. Experience with Salesforce Data Loader (CLI and GUI).
• Experience with historical data archiving strategies, Incremental and delta load processing and Data validation and reconciliation.
• Work with stakeholders to define transformation rules, cleansing logic, and test plans.
• Manage bulk API operations, parallel processing, and handling of governor limits.
• Create reusable frameworks: staging tables, delta load logic, and error retries.
• Collaborate with QA to validate migration accuracy and volume tests.
• Tune performance for large-scale, multi-million record loads.
• Document all migration artifacts and technical designs.
• Design, develop, and implement robust, scalable, and secure solutions on the Salesforce platform (primarily using Apex, Lightning Web Components (LWC), Visualforce, and Flows).
• Build custom applications, objects, workflows, validation rules, process builder flows, and approval processes.
• Develop and maintain integration between Salesforce and external systems using REST/SOAP APIs, Platform Events, and outbound messages.
• Create and optimize Lightning Components (Aura and LWC), custom UI/UX experiences, and responsive designs.
• Perform unit testing, code reviews, and support deployment activities using tools such as Gearset, Copado, Salesforce DX, or Change Sets.
• Troubleshoot and resolve production issues, perform root-cause analysis, and optimize performance (SOQL).
• Collaborate with business analysts, administrators, architects, and stakeholders to gather requirements and translate them into technical solutions.
• Implement Single Sign-On (SSO) integrations using SAML 2.0, OAuth 2.0, and OpenID Connect protocols.
• Create and manage sandbox environments across development, testing, UAT, and staging

Required Skills & Experience:

• 5+ years of hands-on Salesforce development experience especially in service cloud (Experience Cloud/Community Cloud – External portal development and implementation).
• Strong proficiency in Apex (triggers, batch, queueable, schedulable), SOQL/SOSL, and Lightning Web Components (LWC).
• Experience with Salesforce APIs (REST, Bulk, Metadata, Tooling).
• Experience with CI/CD pipelines and version control (Git).
• Knowledge of Salesforce security model (profiles, permission sets, sharing rules, FLS).
• Familiarity with AppExchange products and managed packages is a plus.
• Excellent problem-solving, communication, and teamwork skills.