Oracle PL/SQL Developer

Company: Bunge North America
Location: Chesterfield
Posted on: September 11, 2023

Job Description:

Location :St. Louis MOCity :ChesterfieldState :Missouri (US-MO)Country :United States (US)Requisition Number :27732Bunge has an exciting opportunity available for a Oracle PL/SQL Developer. In this role you will be part of a globalteam working on challenging, meaningful projects impacting core business activities.Since 1818, Bunge has been connecting farmers to consumers to deliver essential food, feed, and fuel to the world. Looking to the future, our ambition is to continuously reinvent ourselves, leveraging data to be at the forefront of analytics, technology and talent to accomplish our purpose in a better, faster and simpler way. Bunge is committed to operating and thriving in the digital world
creating world class agile teams where teammates are empowered and encouraged to collaborate and test and learn to succeed.At Bunge, people don t just come here to work, they come here to grow
solving challenges that directly impact the world with a diverse team of thinkers and doers. Bunge offers a strong compensation and benefits package, generous paid time off program, flexible work arrangements, and opportunity to progress. Our hybrid work environment provides a balance of in office and remote work.Most importantly, in all we do we live our values:Act as One Team by fostering inclusion, collaboration, and respectDrive for Excellence by being agile, innovative and efficientDo What's Right by acting safely, ethically, and sustainablyOverview:Oracle PL/SQL Developer will join distributed Data Warehouse Maintenance and Support Team. This role will be responsible for designing and maintaining the Global BI database to ensure its stability, reliability and performance, implement improvements and provide day-to-day support for data warehouse stakeholders. The role will work closely with development teams to understand the existing solutions, identify the root cause of the observed and reported issues and come up with the solutions to meet stakeholders
needs. The role will be improving ETL/ELT pipelines, SQL queries and helping stakeholders with SQL queries optimizations; analyse, monitor, and optimize existing solutions; ensure compliance of deliverables to quality standards.Essential functions:Interact with Project Management, Business Stakeholders, Business Analysts, Architects, Developers and Database Administrators to clarify the needsMonitor database processes execution and address processing errors and delaysAnalyse jobs execution patterns and suggest improvementsDesign and implement data warehouse ETL/ELT process improvementsAnalyse the incidents and issues identified in the processing or raised by the stakeholders, identify the root cause and implement fixCoordinate bug fixes and improvements implementations with the business and technical stakeholders and development teamsSupport stakeholders in building optimal SQL queriesOptimize existing solutionsManage the queue of the data warehouse related incidents in ServiceNowPlan and keep track of development activities in project management software (e.g. Jira)Attend and represent changes to environments in change management meetings.Qualifications/Requirements:3 years of experience with Oracle SQL and PL-SQL programming, 5 preferredExperience developing and maintaining data warehouses in big data solutionsFamiliarity with Oracle build-in dictionaries and packagesGood knowledge of Oracle analytical functionsExpertise in relational and multidimensional databases as well as in queries optimizationExperience with processing big data sources in OracleExperience with integrating various data sourcesExperience in monitoring Oracle DB (jobs, execution of queries, etc.)Focused on customer satisfactionWillingness to learn new tools and technologiesWorked with BI tools such as Tableau, Power BI, Looker, Shiny (Preferred)Conceptual knowledge of data and analytics, such as dimensional modeling, ETL, reporting tools, data governance, data warehousing, structured and unstructured data.Experience working on a collaborative Agile product teamFlexibility to changes in work direction as the project developsExcellent communication, listening, and influencing skillsDemonstrated strong number sense, intellectually curious and willing to adjust position based on additional informationStrong work ethic; ability to work at an abstract level and gain consensusBunge (NYSE: BG) is a world leader in sourcing, processing and supplying oilseed and grain products and ingredients. Founded in 1818, Bunge s expansive network feeds and fuels a growing world, creating sustainable products and opportunities for more than 70,000 farmers and the consumers they serve across the globe. The company is headquartered in St. Louis, Missouri and has 25,000 employees worldwide who stand behind more than 350 port terminals, oilseed processing plants, grain facilities, and food and ingredient production and packaging facilities around the world.Bunge is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, transgender status, national origin, citizenship, age, disability or military or veteran status, or any other legally protected status. Bunge is an Equal Opportunity Employer. Minorities/Women/Veterans/Disabled

Keywords: Bunge North America, Chesterfield , Oracle PL/SQL Developer, IT / Software / Systems , Chesterfield, Missouri