Job Description
Looking for Sr. Data Warehouse Engineer with excellent track record in implementing data warehouse & 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
Qualifications
- Bachelor’s Degree in Engineering / IT (or) Equivalent
- 7 - 10 years of work experience involving Design and modelling of Data warehouse solutions
- 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, Core ERP Processes, 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, Power BI, Tableau
- 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
See more jobs at Western Digital
Apply for this job