Oracle PL/SQL Developer

WillWare Technologies

Company Name: WillwareTechnologies

Role:Oracle PL/SQL Developer

Experience:5+ Years

Location: Bangalore

WorkMode:Onsite

Job Description:

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.

The ideal candidate should have strong expertise in Oracle PL/SQL programming and experience working on Global Trade Management applications, trade compliance, import/export processes, and related integrations.

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.