Software Developer

The Software Developer is a technical role embedded within the Finance & Risk Systems Shared Data Ecosystem project team. The developer will directly support the deployment of the UniData project by delivering PL/SQL developments that enable new application functionalities, inter-layer data movements, and multi-tenant database compatibility. The role also covers ETL orchestration via JIL (AutoSys) and requires the ability to collaborate effectively with team members across different time zones and locations

Key Responsibilities

PL/SQL Development

• Design and implement PL/SQL developments to build new functionalities within the application
• Develop PL/SQL scripts to enable data movement between application layers
• Optimize and modify existing PL/SQL code to ensure compatibility with a multi-tenant database environment
• Conduct code reviews and performance tuning on high-volume transactional databases

ETL Orchestration

• Develop JIL scripts (AutoSys) to orchestrate ETL tasks in accordance with application guidelines and standards
• Ensure all ETL jobs are properly sequenced, monitored, and documented

Collaboration & Documentation

• Work with team members located in different time zones, receiving and interpreting instructions asynchronously
• Document code, stored procedures, and design artefacts to ensure maintainability and knowledge transfer
• Use version control (Git/SVN) and issue-tracking systems (JIRA, HP ALM) throughout the development lifecycle

Qualifications & Technical Skills

Technical Skills

• Minimum 5 years of hands-on PL/SQL development, including advanced query optimization, complex stored procedure design, and performance tuning of high-volume transactional databases
• Solid experience with multi-tenant Oracle database environments
• Experience with ETL orchestration tools, specifically JIL/AutoSys
• Proficiency in version control tools (Git or SVN)
• Familiarity with issue-tracking systems such as JIRA and/or HP ALM
• Knowledge of application layered architectures and data flow design

Behavioral Competencies

• Analytical Mindset — Strong debugging and problem-solving abilities on complex database environments
• Autonomous & Remote-Ready — Proven capacity to receive instructions and deliver quality work across time zones
• Documentation Discipline — Consistently documents code, design choices, and known issues
• Team Player — Collaborative attitude in distributed, multicultural engineering teams
• Rigorous — Applies high standards to code quality, naming conventions, and technical specifications