Data Engineer (Oracle Data Integrator)

Company Description

ABOUT AVERY DENNISON

Avery Dennison Corporation (NYSE: AVY) is a global materials science and digital identification solutions company. We are Making Possible™ products and solutions that help advance the industries we serve, providing branding and information solutions that optimize labor and supply chain efficiency, reduce waste, advance sustainability, circularity and transparency, and better connect brands and consumers. We design and develop labeling and functional materials, radio-frequency identification (RFID) inlays and tags, software applications that connect the physical and digital, and offerings that enhance branded packaging and carry or display information that improves the customer experience. Serving industries worldwide — including home and personal care, apparel, general retail, e-commerce, logistics, food and grocery, pharmaceuticals and automotive — we employ approximately 35,000 employees in more than 50 countries. Our reported sales in 2024 were $8.8 billion. Learn more at www.averydennison.com.

AVERY DENNISON IS PROUD TO BE CERTIFIED GREAT PLACE TO WORK IN AUSTRALIA, CHINA, INDIA, INDONESIA,  SINGAPORE, THAILAND AND VIETNAM, AND RECOGNIZED AS ONE OF THE BEST COMPANIES TO WORK FOR IN ASIA IN GREATER CHINA AND VIETNAM.

Job Description

ABOUT YOUR ROLE

• You will be joining Avery’s Data & Analytics centralized team responsible for planning and executing the digital roadmap within Avery’s Solutions Group division. The D&A will be filled with digital talent that will be working on the most important initiatives within SG to increase operational efficiency and unlock value for our customers, in close collaboration with internal resources and external partners. ​
• You will design, build and manage the architecture that helps analyze and process data as required by the initiatives in the D&A team and make sure those systems are performing smoothly.
• You will also prepare the “big data” infrastructure to be analyzed by Data Scientists.

YOUR RESPONSIBILITIES WILL INCLUDE

• Design, develop, and deploy high-performance data pipeline frameworks for automated, high-volume, and real-time data delivery using Oracle Data Integrator (ODI) on OCI (PaaS/IaaS).
• Build robust systems with a strong focus on long-term maintainability and support.
• Develop data APIs and data delivery services to support critical operational and analytical applications for internal business operations, customers, and partners.
• Transform complex analytical models into scalable, production-ready solutions.
• Continuously integrate and deploy code into cloud production environments.
• Develop applications from the ground up using modern technology stacks.
• Collaborate directly with Business Analysts, internal and external stakeholders, Product Owners, and customers to deliver data products in agile/waterfall environments.
• Write test data scripts and execute formal test plans to ensure the quality of data-related projects.
• Identify and implement automation opportunities within software processes.
• Design and execute QA tests using automated functionality scripts.

Qualifications

WHAT WE WILL BE LOOKING FOR IN YOU

Mandatory Skills:

• 5+ years of experience as a Data Engineer, with a preference for Oracle Cloud and Azure.
• 5+ years of proven experience as a Data Engineer, focusing on Oracle databases and ODI ETL tools.
• 1-2 years of hands-on experience with Oracle GoldenGate in data replication and real-time data integration projects.
• 5+ years of hands-on experience with Oracle Autonomous Data Warehouse (ADW) and Oracle databases.
• Proficiency in developing and optimizing complex SQL and PL/SQL scripts for data extraction, transformation, and loading.
• Ability to implement data integration