RQ09096 - Software Developer - ETL - Senior

Rubicon Path; Toronto; Hybrid; CAD 85,000 - 110,000; Full time

Job summary

A leading technology firm in Toronto is seeking a Senior Software Developer to design and enhance ETL data pipelines within a hybrid work environment. The candidate should have extensive knowledge of PeopleSoft HCM systems and significant experience in system development and integration. Key responsibilities include providing technical expertise, translating specifications into applications, and supporting clients in information technology utilization. This role offers a balance of onsite and remote work opportunities.

Qualifications

• Knowledge of PeopleSoft HCM operating systems including configurations and application integration.
• Experience developing systems modifications and evaluating application acquisition.
• Knowledge of Oracle database management systems and application database administration.
• Experience with unit testing and supporting user acceptance testing.

Responsibilities

• Design, implement, and continuously expand data pipelines for ETL activities.
• Translate technical specifications into working applications including unit testing.
• Provide clients with consulting expertise on information technology.
• Recommend system development solutions to meet client needs.

Skills

PeopleSoft HCM Knowledge and Integration

PeopleSoft System Development and Tools Expertise

Oracle Database Management Knowledge

Testing and Technical Support Experience

Analytical and Interpersonal Skills

Tools

PeopleSoft

App Engine

SQRs

PS tools

Linux scripting

Job description

RQ09096 - Software Developer - ETL - Senior

About the job RQ09096 - Software Developer - ETL - Senior

Description

Hybrid Work Environment: The successful candidate is expected to work onsite at 222 Jarvis St 3 days per week, and may work remotely up to 2 days per week.

Responsibilities:

• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
• Translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
• Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations.

Description

Work with project teams to develop integration in or outbound interfaces between Oracle recruitment system and Peoplesoft to meet business needs and priorities.

Analyze business needs in relation to Human Resources clients' programs and service delivery requirements.

Provide clients with business systems consulting expertise on the use of information technology, such as PeopleSoft, to meet business goals and objectives.

Recommend systems development solutions and configuration which meet clients' needs.

Provide technical expertise and advice in complex systems analysis and design.

• Knowledge and experience with programming Internet-ready applications.
• Knowledge and experience in rapid application development (RAD) methodologies.
• Knowledge and understanding of Information Management principles, concepts, policies, and practices.
• Experience with middleware and gateways.
• Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, and debugging.
• Ability to provide post-implementation support and resolve any post-implementation technical issues.
• Experience conducting design walkthrough sessions with project team.
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
• Ability to provide user and system documentation as required.

SkillsExperience and Skill Set Requirements

Description

Work with project teams to develop integration in or outbound interfaces between Oracle recruitment system and Peoplesoft to meet business needs and priorities.

Analyze business needs in relation to Human Resources clients' programs and service delivery requirements.

Provide clients with business systems consulting expertise on the use of information technology, such as PeopleSoft, to meet business goals and objectives.

Recommend systems development solutions and configuration which meet clients' needs.

Provide technical expertise and advice in complex systems analysis and design.

Evaluation CriteriaWeightPeopleSoft HCM Knowledge and Integration: Knowledge of PeopleSoft HCM operating systems, delivered application functionality, configurations and packaged application integration, focus on modules Workforce Administration and Position management as well as Benefit and payroll.25%PeopleSoft System Development and Tools Expertise: In-depth knowledge and experience of PeopleSoft system development and tools including App Engine, SQRs, PS tools etc., working experience with Fluid an asset, ability to develop new systems or systems modifications and evaluate and recommend acquisition of applications, experience to develop Linux script an asset.25%Oracle Database Management Knowledge: Knowledge of Oracle database management systems and application database administration.15%Testing and Technical Support Experience: Experience of unit test, supporting system integration and user acceptance testing from technical perspectives, technical spec, walkthrough unit test results with testers and clients.20%Analytical and Interpersonal Skills: Excellent analytical, problem-solving and decision-making skills; organizational, creativity and perseverance skills; verbal and written communication skills; and interpersonal skills, team player to work effectively with colleagues and clients.15%

Must haves:

Knowledge of PeopleSoft HCM operating systems, delivered application functionality , configurations and packaged application integration, focus on modules Workforce Administration and Position management as well as Benefit and payroll

In-depth knowledge and experience of PeopleSoft system development and tools including App Engine, SQRs , PS tools etc , working experience with Fluid an asset , Ability to develop new systems or systems modifications and evaluate and recommend acquisition of applications , experience to develop Linux script an asset

Knowledge of Oracle database management systems and application database administration

Experience of unit test, supporting system integration and user acceptance testing from technical perspectives , Technical spec, walkthrough unit test results with testers and clients

Excellent analytical, problem-solving and decision making skills; organizational, creativity and perseverance skills; verbal and written communication skills; and interpersonal skills , team player to work effectively with colleagues and clients