Data Analyst - Oracle Data Integrator (ODI)

As a Data Analyst, you will be responsible for participating in IT projects that consist of data modeling, application development, maintenance, and improvements. You will provide specialized technical knowledge.

Key Responsibilities

• Oracle Data Integrator (ODI) new development, enhancements, bug fixes and performance tuning
• Develop ETL processes using ODI including error trapping routines and alerts based on business requirements provided by Systems Analysts
• Support existing ETL processes accessing our different source systems : POS system, SAP (ECC and BW), flat files and others
• Responsible for daily ETL jobs monitoring and issues resolution as the primary resource
• Responsible for extending the Data Warehouse model based on business requirements provided by Systems Analysts.
• Support existing database objects including Tables, Indexes, Constraints, Materialized Views, Views, Procedures, Functions and others

Qualifications

• Proven ability in Oracle Database 11g and Oracle ETL tool ODI 11.1+
• Data Warehouse Design (Facts / Dimensions) / Modeling
• Comprehensive understanding of techniques like slowly changing dimensions
• Solid grasp of PL/SQL and experience in working with Oracle 11g+ and Microsoft SQL Server databases
• Good understanding of SQL performance tuning / optimization techniques
• Strong organizational skills and ability to work in a decentralized and virtual environment
• Advanced level of English

Here at PPG we make it happen, and we seek candidates of the highest integrity and professionalism who share our values, with the commitment and drive to strive today to do better than yesterday – everyday.

Through leadership in innovation, sustainability and color, PPG helps customers in industrial, transportation, consumer products, and construction markets and aftermarkets to enhance more surfaces in more ways than does any other company.. To learn more, visit www.ppg.com and follow @ PPG on Twitter.

We partner with customers to create mutual value.

We are insightful, dedicated and proactive. We have intimate knowledge of the market and our customers. We focus on practical solutions that make a difference.

We are better and stronger together. We leverage our scale to reach new markets and introduce innovative technologies as we differentiate and disrupt our markets.

We trust our people every day, in every way.

We enable and empower our people to make the right decisions. We are inclusive, transparent and respectful. Our feedback is clear and actionable.

We have a passion for winning. We achieve. We deliver with discipline and integrity. We bring our best energy to our work. We decide and act intelligently and quickly.

We respect one another by being responsible and accountable. We always act in the best interest of our company, customers, shareholders and our communities.

We do better today than yesterday – everyday.

We continuously learn. We develop our people to grow our businesses.

PPG Way: (Click here to learn more about the PPG Way)

PPG provides equal opportunity to all candidates and employees. We offer an opportunity to grow and develop your career in an environment that provides a fulfilling workplace for employees, creates an environment for continuous learning, and embraces the ideas and diversity of others. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, color, creed, religion, national origin, age, disability status, marital status, sexual orientation, gender identity or expression. If you need assistance to complete your application due to a disability, please email

PPG values your feedback on our recruiting process. We encourage you to visit Glassdoor.com and provide feedback on the process, so that we can do better today than yesterday.

Benefits will be discussed with you by your recruiter during the hiring process.