Penn State is looking to design, develop, test, debug, implement, enhance, and support integrations for their enterprise constituent relationship management (ECRM) program to change the way data is captured, accessed, and processed for data-driven insightful decisions.
Requirements
- Experience designing and development with Informatica Intelligent Cloud Services (IICS).
- Experience with data and application integrations.
- Strong software and system architecture 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).
- 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.
Responsibilities
- 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.
- Coordinate and develop all ETL (extract, transform, load) processes to support system interoperability and data consistency.
- Leverage Salesforce APIs (REST, SOAP, Bulk, Streaming) and external APIs to enable real-time and batch integrations.
- Prepare and execute test plans to validate that integrations meet business, functional, and performance requirements.
- Monitor daily integration processes and troubleshoot issues to ensure high data quality and reliability.
- Provide production support for existing integrations, identify opportunities for automation or enhancement, and implement changes as needed.
Other
- 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.
- Ability to adapt to a changing environment and handle multiple priorities.
- Strong business analysis skills.
- Applicants must be authorized to work in the U.S.
