PL/SQL Developer

Job Role : IBM Sterling OMS Solution Architect

Experience : 15+ Years

Notice period : Immediate

Location : Trivandrum / Kochi / Remote

Note : OMS & Retail domain Experience is mandatory

Job Description :

As a Software Architect – IBM Sterling OMS, you will lead the design and delivery of high-quality enterprise-class OMS solutions and play a crucial role in guiding teams through architecture, implementation, and optimization of the Sterling platform

Mandatory Skills :

IBM Sterling OMS Architecture, Retail Domain Experience, Advanced Java, Sterling OMS Configuration & Customization, APIs (REST/WebServices), DB2/Oracle, XML/JSON, MQ Integration.

Responsibilities include :

• Define solution architecture and detailed technical design for IBM Sterling OMS initiatives across programs and projects.
• Lead and mentor development teams in designing, coding, customizing, and deploying Sterling OMS solutions.
• Translate functional requirements into scalable, resilient, and maintainable Sterling OMS architecture.
• Oversee end-to-end development for IBM OMS including design, development, deployment, debugging, and documentation.
• Ensure all OMS enhancements meet performance, scalability, and security standards aligned with stakeholder KPIs.
• Manage and evaluate technical requirements related to Sterling OMS (v10.0) including configurations, APIs, workflows, and database extensions.
• Estimate effort, cost, dependencies, and timelines for new features and architectural components.
• Provide architectural governance and conduct design and code reviews to ensure consistency with best practices.
• Lead integration architecture involving OMS and external systems (WMS, ERP, Commerce, TMS, Inventory).
• Guide OMS implementation efforts (across SL, BT, or custom OMS setups) and ensure the adoption of best practices.
• Collaborate with cross-functional IT teams across logistics, order orchestration, and fulfillment applications.]
• Drive secure, scalable, cloud-ready OMS development aligned with Agile methodologies.
• Contribute to continuous improvements through automation, reusable components, and standardized technical artifacts.

Primary Skills :

Experience :

• 15+ years of IT experience, including significant hands-on architecture and solution design experience with IBM Sterling OMS.
• Strong background in Java development at an advanced level.

Technical Skills :

• Advanced expertise in IBM Sterling Order Management System including configurations, customizations, workflows, SDF, DB extensions, and APIs.
• Strong experience with DB2 and Oracle databases, including performance tuning, indexing, and complex queries.
• Proficiency in XML, JSON, and integration patterns involving MQ, WebServices, and REST APIs.
• Experience with Linux/Unix environments (Intermediate/Advanced).
• Hands-on exposure to GCP (GKE, Artifact Registry, Compute Engine) or equivalent cloud platforms.
• Strong knowledge of Git and modern DevOps practices.

Secondary Skills :

• Experience integrating Sterling OMS with MQ, WebServices, and cloud-native components.
• Knowledge of Kubernetes and Docker for OMS deployment and troubleshooting.
• Familiarity with CI/CD pipelines using GitHub Actions, Jenkins, or similar tools.
• Strong soft skills : Self-learning, collaboration, planning, and organization. 

Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.

Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.

Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL

Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.

Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.

Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.

Create technical designs to support business requirements.

Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.

Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.

Assist in developing baseline datasets and reports to support testing of technical solutions.

Job Description:  

As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.

The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.

• Accountability and primary responsibility/duties:
• A typical day would look like as follows: -
  • 40% support issues.
  • 40% configuration/development work.
  • 20% continuous improvement, automation, CICD, so on.
• Activities would range across the lifecycle from discovery to post-implementation support.
• Understanding client’s requirement, replicate the problem and providing the solution
• Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
• Update the existing functionality based on client needs.
• Develop changes that cater to enhancing the product and/or fixing production issues
• Prepare product releases of software components. (Java/SQL-PLSQL)
• Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
• Create technical document for all changes made.

Required Qualifications/Knowledge/Skills

• Bachelor’s degree in Computer Science or related field
• Strong basics and working experience in following technologies: -
  • Core Java.
  • SQL / PLSQL coding.
  • Object Oriented Programming concepts and data structures.
• Working knowledge on Unix platform
• Working knowledge on XSLT and XML handling
• Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
• Advantageous to have:
  • Working understanding on CICD, Dev-ops technologies.
  • Queuing technologies including Kafka, MQ, Solace.
  • Scripting including Python, Unix, java.
• Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
  
  

Java Developer Job Description

We are looking for a Java developer responsible for building Java applications.

Responsibilities

• Design, build and maintain efficient, reusable, and reliable Java code
• Identify bottlenecks and bugs, and devise solutions to these problems
• Help maintain code quality, organization, and automatization.

Skill Set:

• Proficient in Java, with a good knowledge of its ecosystems
• Java, Rest API integration, JSON, XML, Oracle, Microservices, Agile Scrum.
• Experience in developing large-scale distributed systems.
• API knowledge
• Solid understanding of object-oriented programming
• Familiar with various design and architectural patterns
• Skill for writing reusable Java libraries
• Spring, Spring Boot, Spring Cloud, React native
• Experience: 04 to 10 years
• Salary: As Per Market

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills