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