Data Engineer (Oracle Data Integrator)

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.

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 solutions, connecting diverse data sources such as cloud databases, on-premise systems, flat files, and XML files.
• Experience with SQL performance tuning and optimization techniques for Oracle databases.
• Strong ability to prepare and maintain detailed technical documentation for developed solutions.
• Adherence to data security and compliance standards, particularly in cloud-based environments.
• Ability to work collaboratively in a team environment and communicate effectively with technical and non-technical stakeholders.
• In-depth knowledge of data warehousing concepts and best practices.
• Excellent communication and troubleshooting skills, with the ability to work independently.
• Fluency and excellent writing skills in English.

Nice-to-Have:

• Experience in building ETL pipelines with one or more tools like Informatica, Azure Data Factory
• Experience or Knowledge in building pipelines with Phyton
• Experience with Azure DataBricks
• Experience with Oracle FDI (Fusion Data Intelligence) is plus.
• Familiarity with one or more BI Tools, like OAC (Oracle Analytics Cloud), Qlik, Power BI.
• Domain expertise in Manufacturing.
• Data engineering certifications from Oracle Cloud or Microsoft Azure.

AVERY DENNISON IS AN EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veteran status or other protected status.

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.