PeopleSoft Campus Solutions Developer with Informatica Development expertise

Overview

Remote
Depends on Experience
Part Time

Skills

PeopleSoft Campus Solutions
SQL
Informatica
Salesforce
Oracle

Job Details

PeopleSoft Campus Solutions Developer with Informatica Development experience

Looking for Peoplesoft Campus Solutions Developer with Informatica development experience to support Data Warehouse to integrate data from various sources including PeopleSoft

Duties & Responsibilities:

  • Assist in supporting the nightly ETL jobs already in production to ensure seamless data integration and availability.
  • Design, create, and review dimensional data models to support data warehousing and reporting needs.
  • Write and optimize complex SQL queries to extract data from Campus Solutions and potentially Salesforce, ensuring efficient data retrieval.
  • Act as an ETL consultant for other areas or teams, providing guidance and expertise on ETL processes and best practices.
  • Resolve Helpdesk tickets in a timely manner, addressing issues related to ETL processes and data integration.

Knowledge, Skills, & Abilities:

  • Experience in using scheduling tools to schedule ETL/ELT jobs, ensuring timely and accurate data processing.
  • Ability to communicate complicated technical knowledge in a way that non-technical data roles can understand, facilitating cross-functional collaboration.
  • Ensure data accuracy and integrity through data validation, cleansing, and error handling, maintaining high-quality data standards.
  • Ability to work in a highly collaborative and inclusive environment, contributing to team success and fostering a positive work culture.

Qualifications:

  • Proven experience in PeopleSoft Campus Solutions and Informatica ETL development.
  • Proficiency in SQL, data modeling, and ETL processes.
  • Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve complex data issues.
  • Excellent verbal and written communication skills, with the ability to convey technical concepts to non-technical stakeholders.

Preferred Qualifications:

  • Salesforce Experience: Experience with Salesforce data extraction and integration is a plus.
  • Certifications: Relevant certifications in PeopleSoft, Informatica, or data warehousing technologies.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Universal Consulting Partner