Edtech.com's Summary

The Pennsylvania State University is hiring an Integration Developer to design, develop, test, implement, and support data integrations for the enterprise constituent relationship management (ECRM) program. This role involves working with Informatica Intelligent Cloud Services (IICS) to create and maintain data pipelines, coordinate ETL processes, and ensure secure API integrations between systems such as ERPs and Salesforce, while collaborating closely with stakeholders across the software development lifecycle.

Highlights

Design, develop, modify, and implement data integration solutions using Informatica Intelligent Cloud Services (IICS).
Develop and maintain data pipelines, mappings, transformations, and workflows.
Coordinate ETL processes to support system interoperability and data consistency.
Define data mapping requirements and logic; collaborate with business analysts to translate requirements into integration logic.
Leverage Salesforce APIs (REST, SOAP, Bulk, Streaming) and external APIs for real-time and batch integrations.
Prepare and execute test plans; conduct peer reviews to ensure quality and compliance.
Monitor integration performance; troubleshoot issues and communicate incidents to stakeholders.
Partner with ECRM, IT Security, and Governance teams to ensure compliance with data security and privacy policies (e.g., FERPA).
Maintain comprehensive documentation and participate in project planning to meet scope and timelines.
Minimum qualifications: Bachelor's Degree, 8+ years relevant experience, strong skills with Informatica IICS, API development, relational/non-relational databases (MSSQL, Oracle, flat files).
Preferred experience includes Salesforce integrations, and working with SAP and Workday systems.
Salary range: $76,700 - $115,100, with a competitive benefits package including medical, dental, vision, retirement plans, paid time off, and tuition discounts.

Integration Developer Full Description

APPLICATION INSTRUCTIONS:

CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please login to Workday to complete the internal application process. Please do not apply here, apply internally through Workday.
CURRENT PENN STATE STUDENT (not employed previously at the university) and seeking employment with Penn State, please login to Workday to complete the student application process. Please do not apply here, apply internally through Workday.
If you are NOT a current employee or student, please click "Apply" and complete the application process for external applicants.

Approval of remote and hybrid work is not guaranteed regardless of work location. For additional information on remote work at Penn State, see Notice to Out of State Applicants.

POSITION SPECIFICS

We are looking for a talented and driven Informatica Developer (IICS) to design, develop, test, debug, implement, enhance, and support integrations for our enterprise constituent relationship management (ECRM) program. We are seeking passionate applicants to work with us to change the way data is captured, accessed, and processed, to make data-driven insightful decisions. The position will be responsible for interfacing with key stakeholders and applying technical proficiency across different stages of the Software Development Life Cycle including requirements elicitation, design, coding, testing, and delivery. This position will deliver high-quality code, lead validation for all types of testing and support activities related to implementation, transition, and operations. This position will be part of a learning culture, where teamwork, collaboration, and building on each other's skillsets are highly encouraged, and diversity is respected and valued.

RESPONSIBILITIES

Integration Development

Design, develop, modify, and implement data integration solutions using Informatica Intelligent Cloud Services (IICS) to facilitate directional and bi-directional data flows between source systems (e.g., ERPs - SIMBA, LionPATH, Workday) and Salesforce (Education Cloud and Service Cloud).
Develop and maintain data pipelines, mappings, transformations, and workflows.
Maintain and ensure integrity of all connected data sources and storage environments.
Coordinate and develop all ETL (extract, transform, load) processes to support system interoperability and data consistency.

Data Mapping & Transformation

Define and document data mapping requirements and logic to transform data formats and structures between systems.
Work with business analysts to interpret business requirements and translate them into integration logic.
Analyze functional requirements to support the design, coding, testing, and deployment of data and application integrations across Informatica Orgs.

API & Web Services Integration

Leverage Salesforce APIs (REST, SOAP, Bulk, Streaming) and external APIs to enable real-time and batch integrations.
Ensure secure, scalable, and performant API integrations between platforms.

Testing & Quality Assurance

Prepare and execute test plans to validate that integrations meet business, functional, and performance requirements.
Conduct technical walkthroughs and peer reviews to ensure accuracy, compliance, and maintainability.
Identify and resolve integration defects and data quality issues in collaboration with partner teams.

Performance Monitoring & Incident Resolution

Monitor daily integration processes and troubleshoot issues to ensure high data quality and reliability.
Optimize performance of integrations and resolve bottlenecks or data latency concerns.
Communicate and escalate system degradations, outages, or critical incidents to appropriate stakeholders in a timely manner.

Data Governance & Security

Partner with the ECRM, IT Security, and Governance teams to ensure integrations comply with university policies and regulations related to data security, privacy, and compliance (e.g., FERPA).
Adhere to institutional standards, best practices, accessibility requirements, and coding/security guidelines.

Collaboration & Documentation

Collaborate with ECRM, functional, and IT teams to align on requirements, configurations, and change management processes.
Maintain comprehensive documentation for integration designs, data mappings, technical configurations, and support procedures.
Participate in project planning and estimation activities to ensure integrations are delivered within defined scope, timelines, and quality expectations.

Support & Continuous Improvement

Provide production support for existing integrations, identify opportunities for automation or enhancement, and implement changes as needed.
Participate in code reviews and contribute to integration standards and best practices.
Identify innovative solutions and process improvements to increase efficiency and effectiveness across the integration environment.

QUALIFICATIONS

Experience designing and development with Informatica Intelligent Cloud Services (IICS).
Experience collaborating effectively with team members and partners in a project environment.
Excellent communication skills and ability to successfully articulate technology concepts to both business and technology audience.
Experience with data and application integrations.
Ability to adapt to a changing environment and handle multiple priorities.
Strong software and system architecture skills.
Strong business analysis skills.
Create REST API's using Informatica IICS for real-time application integrations.
Relational databases and non-relational data sources (MSSQL, Oracle, and flat files).

MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONSBachelor's Degree8+ years of relevant

experienceRequired Certifications:None

PREFERRED SKILLS

Experience with integrations for the Salesforce platform, relational databases and non-relational data sources (MSSQL, Oracle, and flat files).
Experience working with SAP and workday systems is preferred.

This position is open to a remote work arrangement, the details of which can be discussed with the hiring manager during the interview process.

BACKGROUND CHECKS/CLEARANCESEmployment with the University will require successful completion of background check(s) in accordance with University policies.

Penn State does not sponsor or take over sponsorship of a staff employment Visa. Applicants must be authorized to work in the U.S.

SALARY & BENEFITS
The salary range for this position, including all possible grades, is $76,700.00 - $115,100.00.

Salary Structure - Information on Penn State's salary structure

Penn State provides a competitive benefits package for full-time employees designed to support both personal and professional well-being. In addition to comprehensive medical, dental, and vision coverage, employees enjoy robust retirement plans and substantial paid time off which includes holidays, vacation and sick time. One of the standout benefits is the generous 75% tuition discount, available to employees as well as eligible spouses and children. For more detailed information, please visit our Benefits Page.

CAMPUS SECURITY CRIME STATISTICS

Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act and the Pennsylvania Act of 1988, Penn State publishes a combined Annual Security and Annual Fire Safety Report (ASR). The ASR includes crime statistics and institutional policies concerning campus security, such as those concerning alcohol and drug use, crime prevention, the reporting of crimes, sexual assault, and other matters. The ASR is available for review here.

EEO IS THE LAW

Penn State is an equal opportunity employer and is committed to providing employment opportunities to all qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. If you are unable to use our online application process due to an impairment or disability, please contact 814-865-1473.The Pennsylvania State University is committed to and accountable for advancing equity, respect, and belonging. We embrace individual uniqueness, as well as a culture of belonging that supports equity initiatives, leverages the educational and institutional benefits of inclusion in society, and provides opportunities for engagement intended to help all members of the community thrive. We value belonging as a core strength and an essential element of the university's teaching, research, and service mission.

Federal Contractors Labor Law Poster

PA State Labor Law Poster

Penn State Policies

Hotlines

Original Job Description