Peoplesoft Analytics Developer

Key Responsibilities

• Affix legacy system data to Oracle Fusion data structures.
• Create tools and logging mechanisms to detect unmapped or unmatched data during conversion processes.
• Support iterative data conversion runs with logging and reconciliation assistance.
• Handle programmatic data extraction or transformation requests that require legacy system expertise.
• Deliver tailored data services by providing innovative, repeatable, and maintainable data solutions.
• Collaborate with the Customer to understand evolving needs and deliver tailored data services.
• Design, build, modify, and support data integrations between Oracle Fusion and legacy systems (e.g., Workday, Veradigm, Meperia).
• Modify existing integration workflows and scripts to align with evolving business requirements.
• Leverage PS query and PL SQL to transform data into formats compliant with target system data specifications.
• Provide Level 2/3 support for ongoing integration issues for Veradigm, Workday, PL/SQL and SQL.
• Troubleshoot data anomalies, connectivity issues, and job failures across integration landscapes.
• Investigate and resolve data flow issues by collaborating with business users and technical teams.

Required Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
• 5+ years of experience in data integration architecture, preferably in Oracle Fusion environments.
• Strong hands-on experience with Peoplesoft, ODI, and SSIS.
• Deep understanding of Oracle PSFT data model, particularly in ERP domains (Finance, SCM, HCM).
• Proven experience in building and modifying system-to-system integrations.
• Strong troubleshooting skills with an ability to work across multiple data systems and formats.
• Experience in supporting legacy system data conversions and complex transformation logic.
• Ability to collaborate across functional teams and communicate effectively with both technical and non-technical stakeholders.