Sign upLog in

Salesforce PSS Developer w/Data Migration Exp

Sunrise Systems Inc

Remote, NH(remote)

Apply
JOB DETAILS
SALARY
$75–$80 Per Hour
SKILLS
Agile Programming Methodologies, Analysis Skills, Application Programming Interface (API), Automation, Best Practices, Business Processes, Coding Standards, Communication Skills, Component Assembly, Data Import/Export, Data Mapping, Data Migration, Data Modeling, Database Extract Transform and Load (ETL), Email Protocols/Standards, Government, Informatica, Licensing, PCI, Performance Testing, Public/Media/Press/Analyst Relations, Resource Utilization, Risk, SQL (Structured Query Language), Salesforce.com, Scalable System Development, Scrum Project Management and Software Development, Software Administration, Software Development, Software Development Lifecycle (SDLC), State Laws and Regulations, System Integration (SI), System Migration, Systems Analysis, Test Driven Development (TDD), Testing
LOCATION
Remote, NH
POSTED
30+ days ago
Job Title: Salesforce PSS Developer w/Data Migration Exp
Job ID: 26-02079
Location: Remote
Duration: 06 months of contract
 
The Salesforce Application Developer (AD) is responsible for analysis, design, coding, component and assembly testing of all Public Sector Solutions application code owned by the Application Team.
 
JOB DETAILS / RESPONSIBILITIES:
 
  • Create integrations using Salesforce APIs to integrate with other systems used in the State, including legacy systems. This role will focus heavily on licensing, permitting, and inspections PSS (Public Sector Solutions) data model expertise.
  • Creates tables, data models, dimension models utilizing Informatica ETL tools.
  • Produce estimates of time and resources required to perform various tasks as part of a team. Reviews estimates for accuracy and completeness composed by other team members.
  • Work as directed by DoIT management to meet DoIT coding standards and best practices and should be familiar with test-driven development and “no code, low code, custom” maxim.
  • Collaborate with Salesforce administrators on release cycles to deploy new functionality and updates to existing applications, objects, and code.
  • Data migration Specialty to include Assess source systems: Profile legacy data, schemas, volumes, quality issues, and integration points.
  • Define migration approach: Choose ETL/ELT methods, waves (accounts/contacts → opportunities → cases → activities), full vs. incremental loads, and cutover strategy
  • Estimation & risk planning: Size effort, identify blockers (duplicates, missing keys, orphan records), and prepare mitigation plans.
  • Map legacy entities to Salesforce objects (Standard & Custom), including Master-Detail vs. Lookup relationships, External IDs & Natural Keys, Record Types, Business Processes, and picklist value harmonization
  • Define transformation rules: Normalize addresses, standardize phone/email, units, time zones, and product catalogs.
  • Handle hierarchy & referential integrity: Parent account trees, contact-account links, case relationships.
  • Stage & transform data in landing zones; implement dedupe logic and survivorship rules.
  • Profile & remediate missing values, invalid formats, inconsistent reference data, apply dedupe rules using Matching Rules/Duplicate Rules; implement fuzzy matching when needed.
  • Config as code to store mappings, transformations, validation queries, and runbooks in repo.
  • Performance testing to include dry runs with realistic volumes to validate timing and resource utilization.
  • Orchestrate final loads, post-load fixes, and index updates
  • •Validation of rules automation to ensure migrated data won’t break triggers, flows, validations.
  • Utilize existing migration pipelines with tools like Data Loader / Data Import Wizard
  • Must be comfortable taking appropriate steps to protect PHI/PII/PCI.
 
Skills and technologies:
 
  • 6-8 years’ Experience designing and implementing Licensing, Permitting, & Inspections data model solutions using Salesforce Public Sector Solutions, including application intake, approvals, inspections, and compliance workflows.
  • 5-8 years’ experience Hands-on expertise with Omnistudio (Omniscripts, Dataraptor, Integration Procedures) to build scalable, user-friendly digital experiences and automate complex business processes
  • 4 years’ end-to-end data migration (mapping, transformation, load, validation) migrating data from legacy systems to Salesforce
  • 4 years’ experience configuring complex sharing models leveraging combinations of the following: sharing sets, sharing rules, roles, queues, public groups, case teams, and/or territories.
  • 4 years' experience working with Salesforce Public Sector Solutions application intake, approvals, inspection, and compliance workflows
  • 5-8  years of experience with APEX, SOQL, Creating Workflows, SDLC, Agile SCRUM.
 
Additional Preferred Experience:
 
  • 4 years’ experience bulk data loading via Data Loader / CLI Data Loader
  • 4 years’ experience profiling legacy data (SQL queries, profiling tools) and Data cleansing, normalization, dedupe methodologies
  • 4 years’ experience executing migration runbooks in production.
  • Highly Preferred experience:  Copado, SAFe Agile
  • Preferred certifications: Certified Salesforce Developer and Certified Salesforce Administrator.
 
Skill Matrix:
 
SkillRequired / DesiredAmountof Experience
Experience designing and implementing Licensing, Permitting & Inspections solutions using Salesforce Public Sector Solutions (PSS)Required6Years
Hands-on expertise w/ Omnistudio; Omniscripts, Dataraptor, Integration Procedures to build scalable, user-friendly digital experiences and automationRequired5Years
Exp w/ complex sharing models leveraging the following: sharing sets, sharing rules, roles, queues, public groups, case teams, and/or territoriesRequired4Years
End-to-end data migration (mapping, transformation, load, validation) migrating data from legacy systems to SalesforceRequired5Years
Salesforce Public Sector Solutions application intake, approvals, inspections, and compliance workflowsRequired4Years
Experience w/data loading via Data Loader / CLI Data LoaderDesired  
Experience profiling legacy data (SQL queries, profiling tools) and Data cleansing, normalization, dedupe methodologiesDesired  
Experience executing migration runbooks in production.Desired  
Experience with Copado, SAFe AgileDesired  
Certifications: Certified Salesforce Developer and Certified Salesforce AdministratorDesired  
Exceptional communication skills are required for this roleRequired  
 
Compensation:
 
The hourly rate for this position is between $75.00-$80.00 per hour.  
 
Factors which may affect starting pay within this range may include [geography/market, skills, education, experience and other qualifications of the successful candidate].
 
Benefits:
 
Sunrise offers ACA compliant medical coverage/dental insurance/vision insurance to all employees. We also offer Sick time benefits as required per State regulations.
 
Contact:
Jaya Balaji: jayabalaji.s@sunrisesys.com | (732) 515-5373 | URL: www.sunrisesys.com

About the Company

S

Sunrise Systems Inc

Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.

We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.

Our collective business experience spans over two and a half decades and ranges from:

  • Business, management, and technical fields
  • Information technology consulting and software solutions.
  • Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
  • Motivating technology staff and establishing partnerships with Fortune 500 companies

Sunrise Systems has a vast range of competence in:

  • Design, development, and support of cloud-based solutions from simple to highly complexed
  • Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
  • Data processing and data migration
  • Application re-engineering and platform migration
  • Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.
COMPANY SIZE
100 to 499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1990
WEBSITE
http://www.sunrisesys.com/

Resume Resources

Free Resume TemplatesFree Resume Builder