Job Summary
Sr Product Integrator ISG will design build and optimize integrated solutions using Oracle Apex PL SQL and Unix Shell scripting to support complex enterprise applications in a hybrid work model. The role focuses on stable product integration high quality data flows and robust application performance that enable efficient merchandising finance and accounting operations while aligning with global business standards and compliance.
Responsibilities
Collaborate with cross functional teams to design integrated application solutions using Oracle Apex PL SQL and Unix Shell scripting that ensure reliable data flow and consistent business outcomes across enterprise systemsDevelop and optimize PL SQL procedures packages and functions to support high volume transactional processing and reporting needs for merchandising and financial operations with strong focus on performance and maintainabilityConfigure and extend Oracle Apex components to create user centric interfaces and workflows that simplify complex financial and merchandising processes while maintaining security scalability and alignment with organizational standardsCreate and maintain Unix Shell scripts to automate batch jobs data transfers and system monitoring activities ensuring stable execution windows accurate logs and minimal manual intervention in day shift hybrid modelAnalyze integration issues across application layers by reviewing logs tracing data paths and validating configurations to provide timely resolution and prevent downstream impacts on finance accounting and merchandising functionsCoordinate product integration activities across development testing and deployment environments by preparing detailed technical plans performing integration checks and validating successful rollout for each release cycleDocument integration designs code structures configuration parameters and operational procedures in clear technical artifacts to support future enhancements audits and smooth knowledge transfer within global product teamsCollaborate with business analysts and product owners to translate merchandising finance and accounting requirements into technical integration solutions that deliver measurable business value and improved process efficiencyPerform root cause analysis for integration and performance incidents by examining database queries scripts and Apex components and implement targeted improvements that enhance system stability and user experienceSupport regression and integration testing cycles by preparing test data validating end to end scenarios and resolving defects so that integrated applications meet functional quality and compliance expectations before production deploymentEngage in continuous improvement of integration frameworks by assessing existing scripts queries and Apex modules and proposing refactoring or optimization opportunities that increase reliability and reduce long term maintenance effortProvide production support for integrated solutions by monitoring critical jobs addressing incidents and communicating status updates to stakeholders while ensuring adherence to incident management and change control practicesContribute to organizational objectives by ensuring that integrated technology solutions enable accurate reporting efficient operations and trustworthy data for decision making which supports sustainable growth and positive impact on customers and societyQualifications
Demonstrate strong proficiency in Oracle Apex including building forms reports interactive components and secure workflows tailored to complex merchandising and financial use casesExhibit advanced skills in PL SQL with ability to design efficient queries tune database interactions and implement robust error handling suitable for high volume enterprise environmentsApply practical experience with Unix Shell scripting to automate file handling job scheduling and system monitoring in support of dependable integration and operational processesLeverage solid understanding of merchandising practices to align technical integrations with inventory pricing and product lifecycle requirements when such domain exposure is availableUtilize knowledge of finance and accounting concepts to design integrations that maintain data integrity for ledgers invoices reconciliations and compliance reporting where prior domain experience existsOperate effectively within a hybrid work model by using collaborative tools structured documentation and proactive communication to coordinate integration activities across onsite and remote stakeholdersDraw on six to eight years of relevant professional experience to make sound technical decisions estimate effort accurately and deliver integration solutions that meet enterprise quality and reliability expectations
