Data Modeller 2021

  • Electronic City Phase I, Electronics City Phase 1, Electronic City, Bengaluru, Karnataka 560100, India
  • Full-time
  • Legal Entity: Robert Bosch Engineering and Business Solutions Private Ltd.

Company Description

Robert Bosch Engineering and Business Solutions 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 19,500 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

Data  Expertise in below Technical skills

  • Experience in RDBMS programming(Oracle) (addition MSSQL nice to have)
  •  Experience in modelling (mandatory)
  • Experience in Data Vault 2.0 (nice to have)
  • Data Modelling

Qualifications

Responsible for Oracle development tasks which includes:

  • Creation of complex Queries to retrieving data from database using joins, Sub Queries, Correlated Sub-queries and Hierarchical queries for data retrieval operations and converting into Views and materialized views based on business requirement.
  • Creation of database objects like table, indexes, views, Sequences, Synonyms and constraints.
  • Backend application programs to be developed. Application programs such as stored Procedures, Functions, Packages, cursors, collections and triggers and materialized views using SQL and PL/SQL with exception handling.
  • Develop Packages (Sql loader, Data pump and Import/Export utilities) each to import data to Oracle base tables from external files like csv, excel, Json and xml.
  • Develop Shell Scripts for invoking SQL scripts and scheduled in using jobs.
  • Performing Unit Testing and Performance Tuning for each program developed.
  • Coding and scripts documentations
  • Preparing Unit test cases
  • Adherence to KPI as per the definition from RBEI and follow the process as per RBEI guidelines.

Additional Information

 

  • Data Vault 2.0 Certification (Nice to have)
  • Experience in Data Vault 2.0 (Nice to have)

 

 

Privacy PolicyImprint