Willware Technologies - PL-SQL Developer - Oracle GTM

Role : Oracle PL/SQL Developer

We are looking for an experienced Oracle PL/SQL Developer with Global Trade Management (GTM) domain knowledge to design, develop, maintain, and support database applications related to global trade and supply chain processes.

Key Responsibilities :

• Develop, enhance, and maintain Oracle PL/SQL programs, including procedures, functions, packages, triggers, and cursors.
• Design and optimize complex SQL queries for data processing and reporting.
• Work on Global Trade Management (GTM) applications and support trade-related business processes.
• Develop and maintain database objects supporting import, export, trade compliance, and customs processes.
• Analyze business requirements and translate them into technical solutions.
• Perform query optimization, performance tuning, and database troubleshooting.
• Develop data validation, transformation, and reconciliation procedures.
• Support integration between GTM applications and other enterprise systems.
• Troubleshoot production issues and perform root cause analysis.
• Collaborate with functional consultants, business analysts, and application teams.
• Prepare technical documentation and participate in code reviews and testing activities.

Essential Skills :

• Strong hands-on experience in Oracle PL/SQL programming.
• Good knowledge of SQL, stored procedures, functions, packages, triggers, and cursors.
• Experience with Global Trade Management (GTM) applications and processes.
• Understanding of global trade compliance, import/export operations, and customs-related workflows.
• Experience in database performance tuning and query optimization.
• Good knowledge of relational database concepts.
• Strong debugging and problem-solving skills.

Good-to-Have Skills :

• Experience with Oracle Global Trade Management (Oracle GTM).
• Knowledge of Oracle Transportation Management (OTM) integration.
• Experience with XML, JSON, REST APIs, and web services.
• Knowledge of supply chain, logistics, and trade compliance systems.
• Experience with data migration, ETL processes, and enterprise application integrations.
• Familiarity with Unix/Linux scripting.
• Exposure to Agile development methodologies and tools such as Jira.