PeopleSoft Campus Solutions Developer with ETL Exp

Overview

Remote
$80 - $80
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

PeopleSoft
ETL
warehousing
Data
Campus

Job Details

Title: PeopleSoft Campus Solutions Developer

Location: 100% REMOTE
Duration: 12+ months

PeopleSoft Campus Solutions Developer with Informatica ETL Development Experience
Project Description:
To operate, maintain, sustain, and perform system changes for the Cadet Operational Management Planning and Admission Support System (COMPASS) for the client.
Day-to-day Responsibilities: Support Production Jobs:

  • Assist in supporting the nightly ETL jobs already in production to ensure seamless data integration and availability.

Dimensional Data Modeling:

  • Design, create, and review dimensional data models to support data warehousing and reporting needs.

Complex SQL Queries:

  • Write and optimize complex SQL queries to extract data from Campus Solutions and potentially Salesforce, ensuring efficient data retrieval.

ETL Consulting:

  • Act as an ETL consultant for other areas or teams, providing guidance and expertise on ETL processes and best practices.

Helpdesk Resolution:

  • Resolve Helpdesk tickets in a timely manner, addressing issues related to ETL processes and data integration.

Required Skills:

  • 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 Skills:

  • Salesforce Experience: Experience with Salesforce data extraction and integration is a plus.

Certifications:

  • Relevant certifications in PeopleSoft, Informatica, or data warehousing technologies.

Expected Deliverables:

  • Change Request Support development for the data warehouse and data warehouse ETL management
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.