Data Modeler - BD

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

Should be able handle independently implementation/Rollout/Support activities and support activities related to Oracle/MS data modeling and engineering projects.

Implement new data models or maintain existing ones in Oracle/MS databases to meet business requirements.

Design, build, and initially test data models and structures in Oracle/MS databases according to functional requirements.

Maintain close communication with business and functional teams to understand data requirements and ensure alignment with business objectives.

Provide technical expertise, guidance, and instruction on data modeling processes and best practices to clients and internal stakeholders.

Provide daily technical support for Oracle data modeling activities, including troubleshooting, debugging, and performance tuning.

Take responsibility for data migration, data exchanges, delta data mechanisms, and data accuracy testing on Oracle/MS data models and applications.

Perform all assigned duties related to data modeling projects and technical support tasks.

Ensure compliance with all company policies and procedures related to data modeling, database management, and technical support activities.

Qualifications

BE/BTECH/ME/MTECH/Equivalent

Additional Information

Candidate should have 4+ years of experience in data modeling, with at least 1-2 implementation projects.

Oracle Data Modeler, SQL, PL/SQL, and scripting languages for automation. Knowledge of Where scape is preferred.

Exposure in Azure data products is an added advantage.

Should have strong conceptual knowledge of modelling methods - dimensional, logical, physical and preferably data vault.Proficient in Oracle Data Dictionary objects, including tables, views, synonyms, sequences, and user-defined types.

Experience in designing and implementing data interfaces and exchange mechanisms, including ETL processes and file transfer protocols (e.g., SFTP/FTP).

Strong interpersonal skills with the ability to collaborate effectively in a team environment.

Develop enhancements and customization according to business requirements, utilizing Oracle features such as stored procedures, functions, and triggers.

Proficient in debugging techniques and performance tuning methodologies for Oracle databases.

Experience on dimensional modelling and Data warehousing concepts.

Strong expertise on RDBMS fundamentals.

Good knowledge in SQL loader, Data pump and Import/Export utilities.

Good oral communication skill.