It Oracle Developer Cum Application Analyst

Experience Required: Bachelor's degree in IT or IT related field . 5 years' experience in developing software applications, preferably, out of which at least 2 years with insurance applications. . Excellent programming skills in Oracle forms, reports and BI in all versions . Experience of using Business Objects and report building functions from User through to Admin. . Experience of BI reports creation and publishing, Reporting tools such as EPM / ECC/ Analytic Server / BI Publisher . Designing and development in forms and reports 10G+, In-depth knowledge and experience in Oracle 9i/10g+,12c . In-depth knowledge and experience in SQL and PL/SQL including tuning. . Writing ad-hoc queries based on schema knowledge for various reporting requirements. . Experience with Unix / Linux / Windows Server 2003 including basic commands and shell scripting. . In-depth knowledge and experience in Import/Export, SQL*Loader planning. . Oracle OCP Certification is a plus. . Familiarity with Oracle specific tools and utilities. . Knowledge of Quest TOAD . Knowledge of open source web development and Java is a plus . Excellent Business intelligent and dashboard . Release Management and version control knowledge . Excellent Business and system analysis skills . Project management skills . Designing and development in forms and reports 12C+, BI Publisher 12C+. . Excellent knowledge and skill in system integrations and APIs Responsibilities: ERP / EBS excellent knowledge - mainly Finance, but also HR, PRO . SDLC full project cycle experience . System requirements gathering, Analysis, Design, Development & Implementation . Solution Architectures and design with align to the enterprise architecture . Writing technical specifications documents and designing solutions resulted from the BRDs and Functional specifications documents and develop the solution/application . Functional and business knowledge in Finance and Insurance business . Excellent skill and knowledge of budgeting and board reporting and dashboards . Knowledge of the Project Management and in the preparation of the document like Project Plans, WBS and Project Status reports. . Data structure design, development and creation of packages, procedures and functions based on business requirements in Oracle Database 10G+. . Ensures that data structure design is scalable and maintainable. . Performance monitoring, reporting, and tuning of Oracle reporting databases. . Provision of support and assistance in the design, testing, tuning and implementation of database applications . Writing / Tuning data ingestion procedures from external suppliers and partners using PL/SQL, SQL loader, 3rd party tools like Toad etc. Terms and conditions Joining time frame: 2 weeks (maximum 1 month)