Oracle Pl/Sql Developer

Location : St. Louis MO

City : Chesterfield

State : Missouri (US-MO)

Country : United States (US)

Requisition Number : 27732

Bunge has an exciting opportunity available for a Oracle PL/SQL Developer. In this role you will be part of a global
team 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:

• Do What's Right by acting safely, ethically, and sustainably
• Drive for Excellence by being agile, innovative and efficient
• Act as One Team by fostering inclusion, collaboration, and respect

Overview:
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:

• Analyse the incidents and issues identified in the processing or raised by the stakeholders, identify the root cause and implement fix
• Interact with Project Management, Business Stakeholders, Business Analysts, Architects, Developers and Database Administrators to clarify the needs
• Manage the queue of the data warehouse related incidents in ServiceNow
• Plan and keep track of development activities in project management software (e.g. Jira)
• Design and implement data warehouse ETL/ELT process improvements
• Monitor database processes execution and address processing errors and delays
• Support stakeholders in building optimal SQL queries
• Optimize existing solutions
• Coordinate bug fixes and improvements implementations with the business and technical stakeholders and development teams
• Attend and represent changes to environments in change management meetings.
• Analyse jobs execution patterns and suggest improvements

Qualifications/Requirements:

• Experience working on a collaborative Agile product team
• Experience with integrating various data sources
• Demonstrated strong number sense, intellectually curious and willing to adjust position based on additional information
• Conceptual knowledge of data and analytics, such as dimensional modeling, ETL, reporting tools, data governance, data warehousing, structured and unstructured data.
• Experience with processing big data sources in Oracle
• Focused on customer satisfaction
• Willingness to learn new tools and technologies
• Experience developing and maintaining data warehouses in big data solutions
• Expertise in relational and multidimensional databases as well as in queries optimization
• Excellent communication, listening, and influencing skills
• Strong work ethic; ability to work at an abstract level and gain consensus
• Familiarity with Oracle build-in dictionaries and packages
• 3 years of experience with Oracle SQL and PL-SQL programming, 5 preferred
• Flexibility to changes in work direction as the project develops
• Worked with BI tools such as Tableau, Power BI, Looker, Shiny (Preferred)
• Good knowledge of Oracle analytical functions
• Experience in monitoring Oracle DB (jobs, execution of queries, etc.)

Bunge (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