Peoplesoft Analytics Developer
- Mississauga, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Experience
- 5+ years of experience in data integration architecture, preferably in Oracle Fusion environments.
- Posting language
- English
- Posted
Original job description
We are seeking a highly skilled Data Integration Architect to support Business As Usual (BAU) operations focused on legacy system integrations, data transformations, and conversions. This role will be responsible for designing, building, modifying, and supporting data integrations between Peoplesoft and legacy systems such as Workday, Veradigm, and Meperia. The ideal candidate will possess expertise in Peoplesoft, Oracle Data Integrator (ODI),, and a strong understanding of the Oracle Fusion data model and Workday.
Key Responsibilities:
Legacy System Data Conversions
Assist in mapping and crosswalking legacy data to Oracle Fusion data structures.
Develop tools and logging mechanisms to identify unmapped or unmatched data during conversion processes.
Support iterative data conversion runs with logging and reconciliation assistance.
Ad Hoc Data Requests & Solutions Fulfill programmatic data extraction or transformation requests that require legacy system expertise.
Provide innovative, repeatable, and maintainable data solutions leveraging deep understanding of source and target systems.
Work closely with the Customer to understand evolving needs and deliver tailored data services. Legacy Integrations – Build & Modify Design, develop, and implement 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. Work on Integration Issue for Workday using ODI and Workday internal integration
Ensure integration solutions are reliable, scalable, and well-documented.
Integration Support & Troubleshooting 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.
Collaborate with business users and technical teams to investigate and resolve data flow issues.
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.
Preferred Qualifications:
Prior experience working with Workday, Veradigm, or Meperia data formats and APIs.
Familiarity with Oracle Fusion Middleware components and integration frameworks.
Experience with data governance and auditing during transformation/conversion efforts.
Understanding of healthcare, finance, or supply chain business processes (if relevant to the customer’s industry).
Soft Skills:
Strong problem-solving and analytical mindset.
Ability to manage ambiguity and rapidly changing requirements.
Proactive communicator and cross-functional collaborator.
Detail-oriented with a focus on data accuracy and completeness.
More about this job
Responsibilities
The Peoplesoft Analytics Developer at Jade Global will design, build and fix data connections between Peoplesoft and legacy systems, and map legacy data into Oracle Fusion structures. The role also fulfills custom data requests and troubleshoots failed data jobs for business and technical teams.
Requirements
Candidates need a degree in Computer Science, Information Systems or a related field and 5+ years of data integration experience, ideally in Oracle Fusion. Strong hands-on skills in Peoplesoft, Oracle Data Integrator and SSIS, plus a deep understanding of the Peoplesoft data model, are required.
Skills
- PeopleSoft
- Oracle Data Integrator (ODI)
- SSIS
- PL/SQL
- SQL
- PS Query
- Oracle Fusion
- Workday integration
- Veradigm
- Meperia
- Oracle PSFT data model
- data mapping and crosswalking
- data conversion
- data transformation
- system-to-system integration
- ETL
- troubleshooting
- data reconciliation
- data governance and auditing
- API integration
- Oracle Fusion Middleware
- data integration architecture
- ERP data (Finance, SCM, HCM)
- documentation
Categories
- Software
- Technology
- Data & Analytics
Keywords
- Peoplesoft
- PeopleSoft Analytics
- Oracle Data Integrator
- ODI
- SSIS
- SQL Server Integration Services
- PL/SQL
- SQL
- PS Query
- Oracle Fusion
- Workday
- Veradigm
- Meperia
- data integration
- data conversion
- data migration
- data transformation
- ETL
- legacy systems
- integration developer
Seniority
Senior
Tools
- PeopleSoft
- Oracle Data Integrator
- SSIS
- PL/SQL
- SQL
- PS Query
- Workday
- Veradigm
- Meperia
- Oracle Fusion
Languages
- English
Fields of study
- Computer Science
- Information Systems