Senior Data Modeler - Data warehousing

  • Full-time
  • Legal Entity: Bosch Global Software Technologies Private Limited

Company Description

Bosch Global Software Technologies Private Limited is a 100% owned subsidiary of Robert Bosch GmbH, one of the world's leading global supplier of technology and services, offering end-to-end Engineering, IT and Business Solutions. With over 28,200+ associates, it’s the largest software development center of Bosch, outside Germany, indicating that it is the Technology Powerhouse of Bosch in India with a global footprint and presence in the US, Europe and the Asia Pacific region.

Job Description

Skills:

  • Data/ Dimensional modelling in data warehousing

  • Oracle SQL PL/SQL views, procedures, functions

  • Experience extracting data (Oracle, SQL/ Excel) and creating data model as per customer requirement

  • Be proficient in SQL and ETL processes, ETL and DB performance tuning, table partitioning

  • Any Data Modelling tools (SAP PowerDesigner, ERWin, Oracle SQL data modeler etc.).

  • Experience working in DW projects, handling cross domain data models

  • Backend programs to be developed such as stored Procedures, Functions, Packages, cursors, collections and triggers and materialized views using SQL and PL/SQL. Know-how of Power BI reports.

Preferred: Azure Cloud fundamentals, Python.

 

Responsibilities:

  • Interact with customer to understand business requirement and build logical, conceptual and physical data models.

  • Work with requirements spec in preparing the dimensional models / DataVault modeling

  • Experience with any of Data Modelling tools – ERWIn, Oracle SQL data modeler, SAP Power designer etc..

  •  

     

    Work along with source system experts in finalize the source to report mapping

  • Coordinate with central team to replicate tables from source system to data lake

  • Convert business requirement to concept/ technical specification

  • Support Oracle developer in design and development

  •  

    Design, Develop and Deploy solution

  • Unit & Integration testing

  • Hand holding key users in report utilization

  •  

     

    Support customers during the stabilization phase

  • Create/ track open point list and co-ordinate with customer to clarify

Qualifications

Bachelor of Engineering / Computer science

I'm interested
Privacy PolicyImprint