Senior Data Modeler - Data warehousing

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