Software Developer - Oracle

ISG Search Inc; Toronto; On-site; CAD 120,000 - 150,000; Full time

Job summary

ISG Search Inc. is seeking an experienced Oracle Software Developer to design, develop, test, troubleshoot, and support enterprise applications and data solutions in Toronto, Canada.

The role emphasizes Oracle E-Business Suite, PL/SQL, SQL, Java, REST APIs, and data integration within an enterprise environment. You will translate requirements into production-ready software, optimize data processes, and collaborate with business teams throughout the SDLC while supporting deployments and

Qualifications

• 10+ years of software development experience, including large-scale enterprise applications.
• 10+ years of Java and Oracle/SQL development experience.
• 5+ years of experience with REST APIs and RESTful Web Services.
• Strong Oracle E-Business Suite experience, including GL, AR, Collections, AP, INV.
• Strong knowledge of Oracle E-Business Suite table structures, including GL, AR, Collections, AP, INV, and FND.
• Strong programming experience with PL/SQL, SQL, XML, Unix shell scripting, and ODI.
• Experience with SQL tuning and partitioned tables.
• Experience with data warehousing, ETL, and OBIEE.
• Knowledge of microservices and modern application architecture.
• Experience with Azure DevOps and Agile development.
• Knowledge of application security, including JWT, OAuth 2.0, and SSL certificates.
• Strong understanding of Object-Oriented Programming, design patterns, refactoring, and clean-code practices.

Responsibilities

• Translate technical requirements and specifications into tested, production-ready applications.
• Design, develop, test, debug, and maintain software and database solutions.
• Develop and optimize Oracle PL/SQL, SQL, XML, and Unix shell scripts.
• Support Oracle E-Business Suite customizations, extensions, conversions, and migrations.
• Conduct impact assessments and troubleshoot application and integration issues.
• Develop and support RESTful APIs and web services.
• Design and support data warehouse and ETL solutions.
• Perform SQL tuning and optimize database performance, including partitioned tables.
• Collaborate with technical and business teams throughout the SDLC.
• Support deployments, post-implementation activities, and technical documentation.

Skills

Java

Oracle SQL

PL/SQL

REST APIs

Object-Oriented Programming

Design patterns

Unix shell scripting

Oracle E-Business Suite

Data integration

Data warehousing

OBIEE

Azure DevOps

Security: JWT/OAuth/SSL

ODI (Oracle Data Integrator)

Agile development

Tools

Oracle Data Integrator (ODI)

OBIEE

Job description

Software Developer - Oracle (BBBH12155) Toronto, Canada

Our Government client is seeking an experienced Oracle Software Developer with strong expertise in Oracle E-Business Suite, PL/SQL, SQL, Java, REST APIs, and data integration. The successful candidate will design, develop, test, troubleshoot, and support enterprise applications and data solutions.

Key Responsibilities

• Translate technical requirements and specifications into tested, production-ready applications.
• Design, develop, test, debug, and maintain software and database solutions.
• Develop and optimize Oracle PL/SQL, SQL, XML, and Unix shell scripts.
• Support Oracle E-Business Suite customizations, extensions, conversions, and migrations.
• Conduct impact assessments and troubleshoot application and integration issues.
• Develop and support RESTful APIs and web services.
• Design and support data warehouse and ETL solutions.
• Perform SQL tuning and optimize database performance, including partitioned tables.
• Collaborate with technical and business teams throughout the SDLC.
• Support deployments, post-implementation activities, and technical documentation.

Required Skills

• 10+ years of software development experience, including large-scale enterprise applications.
• 10+ years of hands-on Java and Oracle/SQL development experience.
• 5+ years of experience with REST APIs and RESTful Web Services.
• Strong Oracle E-Business Suite experience, including:
  • General Ledger (GL)
  • Accounts Receivable (AR)
  • Collections
  • Accounts Payable (AP)
  • Inventory (INV)
• Strong knowledge of Oracle E-Business Suite table structures, including GL, AR, Collections, AP, INV, and FND.
• Strong programming experience with PL/SQL, SQL, XML, Unix shell scripting, and Oracle Data Integrator (ODI).
• Experience with SQL tuning and partitioned tables.
• Experience with data warehousing, ETL, and OBIEE.
• Knowledge of microservices and modern application architecture.
• Experience with Azure DevOps and Agile development.
• Knowledge of application security, including JWT, OAuth 2.0, and SSL certificates.
• Strong understanding of Object-Oriented Programming, design patterns, refactoring, and clean-code practices.

Nice to Have

• Experience with Java and Oracle Application Development Framework (ADF).
• Experience with Oracle E-Business Suite Accounts Receivable/Collections conversions.
• Experience with middleware and application gateways.
• Knowledge of Rapid Application Development (RAD) methodologies.
• Experience with Internet-based applications.