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