In this role you will have the opportunity to:
Design solutions in Data Warehouse to meet business requirements
Transform requirements to data models and designs based on analysis of data
Create prototypes/PLSQL specifications based on requirements and analysis of data
Works on production defect fixes.
Support UAT and SIT by preparing the test environment and providing defect fixes.
Production job monitoring
Ability to work multiple priority projects at the same time
Provides informal mentoring to less experienced colleagues.
Develops innovative and creative output based on interpretation and analysis.
Provides design and documentation at an application or function capability level.
Effectively communicates application and technical direction to the business and within the client's IT organization. Advises on issues of systems integration, compatibility, scalability and multiple platforms.
The ideal candidate will have the following qualifications:
• Minimum 5+ years of experience in Oracle-SQL
• Minimum 5+ years of experience in Oracle PLSQL programming language and experience in writing Packages/Functions/Procedures
•Minimum 3+ years of experience in Unix Shell Script and Autosys
•Minimum 3+ years of experience in performance tuning of database queries/ database schema
•Minimum 3+ years of experience in wring high level and low level design
Minimum Education and Certifications:
• Undergraduate degree or equivalent combination of education and work experience.
Minimum 5+ years of experience in Oracle-SQL
Minimum 5+ years of experience in Oracle PLSQL programming language and experience in writing Packages/Functions/Procedures