Company DescriptionBosch 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 DescriptionSkills:Data/ Dimensional modelling in data warehousingOracle SQL PL/SQL views, procedures, functionsExperience extracting data (Oracle, SQL/ Excel) and creating data model as per customer requirementBe proficient in SQL and ETL processes, ETL and DB performance tuning, table partitioningAny Data Modelling tools (SAP PowerDesigner, ERWin, Oracle SQL data modeler etc.).Experience working in DW projects, handling cross domain data modelsBackend 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 modelingExperience 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 mappingCoordinate with central team to replicate tables from source system to data lakeConvert business requirement to concept/ technical specificationSupport Oracle developer in design and developmentDesign, Develop and Deploy solutionUnit & Integration testingHand holding key users in report utilizationSupport customers during the stabilization phaseCreate/ track open point list and co-ordinate with customer to clarifyQualificationsBachelor of Engineering / Computer science
