Job Details: Oracle Database Developer Date: Mar 16 2023

Job Tools

This individual will be responsible for helping the design, development and implementation of new and existing applications.

Extensive background in the development and testing of complex queries in Oracle SQL and PL/SQL as well as on T-SQL.

Need to develop stored functions, Procedures, Packages and, triggers using SQL and Scripts as part of our application needs.

Candidate needs consult with the data architect, tech lead and participate in Application design and development.

Perform code reviews, unit testing and prepare the build bundle scripts.

Candidates should have excellent oral and written communication skills.

Will have to do the support work to business owners as well as application support.


Required

Candidate must have at least 4+ years of professional development experience with Oracle databases and 1+ year on SQL Server.·
Candidate should be highly proficient in SQL, PLSQL, and TSQL Programming.·

Proficient with DDL, DML operations and working with it.·

Practical experience of developing a data warehouse using dimensional modeling techniques·

Proficient with developing methods of loading large volumes of data automatically into a database·

Capable of working independently or with minimal guidance.·

Experience with Agile development practices and Scrum methodology Preferred

Experience with dimensional database design, online analytical processing, and business Intelligence tools and/or technologies such as Business Objects, Brio etc. is a plus.
·Familiarity with data modeling design (CASE) tools (Erwin, Toad Schema Modeler, etc)
Experience in design, deploy and manage SSIS and SSRS packages
Experience with source control and change control and be able to generate creation, upgrade, and maintain scripts