Data Modeler / PL/SQL Senior Developer - Oracle Data warehouse

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 24,000 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

• Convert business requirements to concept/ technical specification
• Develop PL/SQL based on technical specification
• Work along with source system experts in finalizing ETL and report design
• Work with other data modeler in preparing the data/ dimensional models
• Coordinate with central team to replicate tables from source system to data lake
• Support Oracle developer and Report designers in design and development
• Creation of activity plan as per the agreed concept with timelines
• Design, Develop and Deploy solution
• Unit & Integration testing
• Support customers during the stabilization phase

Qualifications

• Overall 8+ years of experience in IT Industry
• 4+ years experience on Oracle Database programming in Data Warehousing systems
• 4+ years experience on Dimensional Modelling in Data warehousing solutions
• Experience in working at least 2 end-to-end projects
• Rich Experience in with Database Packages, Stored procedure, Functions , procedures, Triggers and data transformation activities using SQL and PLSQL
• Strong expertise on RDBMS fundamentals
• Good knowledge in SQL loader, Data pump and Import/Export utilities
• Knowledge on Performance Tuning for Oracle RDBMS
• Good oral communication skill

Additional Information

• Good to have experience in building applications with Data Vault 2.0
• Experience with any data visualization or BI tools such as Tableau, PowerBI
• Experience in any ETL tools like BODS, SSIS

Strong customer & result orientation

Entrepreneurial mindset