Oracle PL/SQL Developer

WillWare Technologies; Bengaluru; In loco; INR 1.800.000 - 2.800.000; Tempo pieno

Descrizione del lavoro

WillwareTechnologies in Bangalore is seeking an experienced Oracle PL/SQL Developer with GTM domain knowledge to design, develop, maintain, and support database applications for global trade and supply chain processes.

The candidate should have strong Oracle PL/SQL expertise, GTM experience, and a solid understanding of trade compliance, import/export operations, and related integrations. Onsite role with collaboration across teams.

Competenze

• Strong Oracle PL/SQL programming expertise required.
• Experience with GTM applications and trade compliance processes.
• Proficient in writing complex SQL queries and optimizing performance.
• Familiar with import/export and customs workflows.

Mansioni

• Develop, maintain, and support Oracle PL/SQL programs (procedures, functions, packages, triggers).
• Design and optimize complex SQL queries for data processing and reporting.
• Work on GTM applications and support trade-related business processes.
• Develop database objects for import/export, trade compliance, and customs.
• Analyze requirements and translate to technical solutions.
• Perform query optimization, performance tuning, and troubleshooting.
• Collaborate with analysts and application teams; document work and participate in reviews.

Conoscenze

Oracle PL/SQL

SQL

Stored Procedures

Packages

Triggers

GTM

Trade Compliance

Performance Tuning

Debugging

Problem Solving

Strumenti

XML

JSON

REST APIs

Unix/Linux scripting

Descrizione del lavoro

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.