Location:

Raleigh, NC

Essential Job Duties:

The Integration Developer is responsible for designing, building, and maintaining integrations across University Advancement's ecosystem, with a primary focus on integrations between our Salesforce CRM and on-premise PeopleSoft ERP and Oracle databases. This role owns the full lifecycle of data movement and interoperability requirements, design, development, testing, deployment, and ongoing support.

The Integration Developer ensures that data flows are reliable, secure, performant, and aligned with business and architectural standards. The ideal candidate brings the technical expertise required to deliver scalable, high-performance solutions for our CRM ecosystem. This role reports directly to the Director of Application Services within Advancement Services.

Other Work/Responsibilities:

Key Responsibilities will include, but are not limited to, the following:

Integration Architecture and Design

• Design integration solutions connecting our Salesforce CRM with PeopleSoft module data (SIS, HR, and Finance).
• Evaluate and select suitable integration patterns, including batch processes, API integration, event-driven, real-time, and file-based data exchanges.
• Translate business requirements into technical integration specifications and data flow diagrams.

Integration Development

• Develop PL/SQL packages, procedures, and scripts to extract, transform, and load data from Oracle/PeopleSoft to Salesforce CRM.
• Build and consume REST/SOAP APIs for Salesforce CRM and other systems.
• Create and maintain file-based interfaces (CSV, XML, JSON) for batch integrations.
• Implement integration logic using scripting languages and ETL tools as needed.
• Develop reconciliation logic, error handling, and retrying mechanisms.

Data Modeling, Mapping, and Transformation

• Analyze Salesforce CRM objects, Oracle schemas, and PeopleSoft record structures to define integration mappings.
• Create transformation rules, validation logic, and data quality checks.
• Ensure referential integrity and consistency across systems.

Testing and Quality Assurance

• Write and execute unit, system, and end-to-end integration tests.
• Validate data accuracy, completeness, and performance across interfaces.
• Collaborate with sprint teams, Salesforce Administrators, and Salesforce Developers in supporting UAT activities.
• Prepare deployment scripts and documentation for production releases.

Minimum Experience/Education:

• Bachelor's degree with a preference in Computer Science, Information Technology, or a related field/discipline.
• 5+ years of hands-on experience in integration development and configurations.
• All degrees must be received from appropriately accredited institutions.

Required Qualifications:

• High proficiency in PL/SQL and SQL.
• High proficiency in REST/SOAP API development and consumption.
• Experience with structured data formats such as XML and JSON for integrations.
• Experience with Oracle schema design, indexing, and performance tuning.
• Experience integration ERP (PeopleSoft, Workday, SAP, Banner, etc.) with a cloud platform such as Salesforce.
• Experience with a cloud platform data model, APIs, authentications, and integration constraints.
• Experience with DevOps and source control solutions, such as GitHub.

Preferred Qualifications:

• Experience with financial system general ledger integration (i.e., PeopleSoft, SAP, Banner, Workday, etc.).
• Experience with the Salesforce platform.
• Familiarity with a middleware (MuleSoft, Boomi, Informatica, or custom frameworks).
• Exposure to CI/CD pipelines for integration deployments.
• Experience in higher education and/or not-for-profit organizations.

Required License or Certification:

N/A

Apply Now