Western Digital Hiring for Analyst 4, Business Applications at Bengaluru, India Full Time

_Summary_: Looking for Oracle Technical Consultant with excellent track record in implementing data ware house ETL solutions using ODI. _Core Tech Skills:_ ODI, PL/SQL, Data warehouse Role & Responsibilities: * As part of Devops team, he/she will be involved in design, architect and implement ETL solutions using Oracle Data Integrator application. * Work with Devops team to manage installed applications & Support existing daily data loads. * Reengineer and automate processes. * Work on user requirements and enhance installed base. Required: * Bachelor’s Degree in Engineering / IT (or) Equivalent. * 11 – 14 years of work experience involving Oracle E-Business Suite & Design and modelling of Data warehouse. * 7+ years of hands-on ODI implementation experience * Experience in supporting large Data Warehouses. Very strong in DW and Dimensional Model Concepts. * Improves BI Solutions by studying current practices; designing modifications. * Solid understanding of Business Intelligence (BI) tools, Data Warehouse (DW), Data Modeling, Master Data Management (MDM) concepts, and SQL * 5+ years of Implementation experience on ODI 11g and/or 12c * Proficient in ETL design, star schema creation, building hierarchies, dimensions, measures and subject areas, and federation * Expertise using Topology, Knowledge Modules, Change Data Capture, Metadata, Web Services * Experience in performance tuning, partitioning strategies. * Good understanding of Oracle database management such materialized view, explain plan etc. * Exposure to OLAP/BI tools such as OBIEE * Experience creating and reviewing ETL design and mapping specifications documents * Expertise in Advanced PL/SQL * Excellent analytical and problem-solving skills * Experienced with multi-national and distributed development environments All your information will be kept confidential according to EEO guidelines.