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

Independently handle implementation, rollout, and support activities related to Oracle/MS data modeling 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 6+ years of experience in data modeling, with at least 1-2 implementation projects. • Deliver solutions in technical areas such as Oracle Data Modeler, SQL, PL/SQL, and scripting languages for automation. Knowledge of Wherescape is preferred. . Should have strong conceptual knowledge of modelling methods - dimensional, logical, physical and preferably data vault. • 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 customizations 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