Senior Data Warehouse Engineer

Adobe Systems India Pvt. Ltd.
  • Bangalore
  • Confidential
  • 5-10 years
  • 20 Feb 2015

  • Project/ Program Management IT

  • IT/ Technology - Software/ Services, IT/ Technology - Data Center/ Manage Infrastructure Services
Job Description


As a specialist you will be working in a fast-paced technical environment with other developers, product managers, consultants, and Business Users (Customers) . It will be your job to bring in, share, and apply your data modeling expertise and creativity to respond quickly to newly emerging business requirements. You will be sharing your findings openly in a team environment at Adobe. You must possess outstanding communication skills and be willing to plan, develop and deliver Models on SAP HANA, Hadoop platforms. Its a perfect world for Creative, innovative product engineering oriented thinking in the Enterprise Data warehousing space

What you need to succeed:

Demonstrated experience in the development of an overall design, development and implementation of SQL scripts, stored procedures, cursors and triggers.
Proven experience in development of conceptual, logical, and physical data models for OLTP, DSS relational, EDW (enterprise data warehouse) and OLAP database solutions)
Familiarity with at least one family of SAP Reporting/Analytics solutions.
Must have proven experience with development of Microstrategy or Tableau dashboards and data marts in the previous projects.
Lead or actively managed team of EDW engineers on Projects
Solve complex business and technical problems involving "big data" and large-scale data aggregation and transformation.
Evaluate and test new technologies as candidates to improve our existing software and systems.
Facilitate modeling sessions and design walk-throughs with the development team members.
Proven ability to work across business/technology teams to ensure alignment between business solution definition & technical architecture to meet project requirements.
Experience with any of the Relational Database Data Modeling tools (Powerdesigner, ERWin, ER/Studio, Oracle SQL Developer)
Ability to drive technical discussions and implementation decision process.
Good communication skills, collaborative team player and strong individual contributor to take lead on key technical drives of a customer project are expected.
Implementation experience with SAP HANA/BW / Oracle PLSQL / MS SQL Server Modeling concepts.
Experience with OLAP tool cube/report design/deployment
5 to 7 years of relevant software development / consulting experience with strong skill on database modeling and architecture.
Skills on Enterprise Business Intelligence Platform/Universe/Semantic Layer sizing, tuning, optimization and system landscape integration in large-scale, enterprise deployments.
Skills on OLAP tool cube/report design/deployment considered a plus.
Agile product development methodologies (SCRUM) is required.
Working in a fast-paced startup like environment is required.
Working in a matrix environment with solution management, architects and "virtual" team members.
Ability to understand Business Scenarios and translate it into data models with business logic
Experience with various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical Views and Calculation Views.
Previous exposure to ETL tools such as SAP Business Objects Data Services would be a plus.

Job Posted By

About Organisation

Adobe Systems India Pvt. Ltd.