Analyst 4, Programming

  • Full-time
  • Business Function: Programming
  • Work Location: Bangalore Hallmark Office (IBS)--LOC_WDT_IBS

Company Description

At Western Digital, our vision is to power global innovation and push the boundaries of technology to make what you thought was once impossible, possible.

At our core, Western Digital is a company of problem solvers. People achieve extraordinary things given the right technology. For decades, we’ve been doing just that. Our technology helped people put a man on the moon.

We are a key partner to some of the largest and highest growth organizations in the world. From energizing the most competitive gaming platforms, to enabling systems to make cities safer and cars smarter and more connected, to powering the data centers behind many of the world’s biggest companies and public cloud, Western Digital is fueling a brighter, smarter future.

Binge-watch any shows, use social media or shop online lately? You’ll find Western Digital supporting the storage infrastructure behind many of these platforms. And, that flash memory card that captures and preserves your most precious moments? That’s us, too.

We offer an expansive portfolio of technologies, storage devices and platforms for business and consumers alike. Our data-centric solutions are comprised of the Western Digital®, G-Technology™, SanDisk® and WD® brands.

Today’s exceptional challenges require your unique skills. It’s You & Western Digital. Together, we’re the next BIG thing in data.

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

Additional Information

Western Digital thrives on the power and potential of diversity. As a global company, we believe the most effective way to embrace the diversity of our customers and communities is to mirror it from within. We believe the fusion of various perspectives results in the best outcomes for our employees, our company, our customers, and the world around us. We are committed to an inclusive environment where every individual can thrive through a sense of belonging, respect and contribution.

Western Digital is committed to offering opportunities to applicants with disabilities and ensuring all candidates can successfully navigate our careers website and our hiring process. Please contact us at [email protected] to advise us of your accommodation request. In your email, please include a description of the specific accommodation you are requesting as well as the job title and requisition number of the position for which you are applying.

LI-RG1

Privacy Policy