Oracle Programmer

Vinosha Pvt ltd

-8+ years of experience in all phases of sdlc including requirement gathering, analysis, application design, development, testing, implementation and maintenance.

• extensive sql and pl/sql programming experience including packages, stored procedures, functions, triggers, indexes and exception handling. create database objects like tables, views, sequences, synonyms, indexes using oracle tools like sql*plus, sql developer, toad.

• strong working knowledge of loading data using sql* loader and pl/sql using different file format.

• strong experience to integrate data feeds to/from other applications using shell scripting and mft servers.

• experience to establish connectivity to mft server to load/unload files. troubleshoot issue with file receive/send.

• extensive experience in trouble shooting, query optimization and performance tuning use of explain plans.

• experience in using the features ref-cursors, pl/sql tables, materialized views, dynamic sql and oracle rac.

• experience to write scheduler jobs and troubleshoot issue if any failures.

• analyze application requirements and provide recommended design. support code migration from development to staging environment.

• write complex sql queries and pl/sql procedures to extract data from various source tables.

• ability to work independently and as part of a team, deliver under pressure and tight deadlines.

• experience in writing shell script for data integration and configuration. ability to enhance/modify script for data loading. troubleshoot issue related to mft connectivity, load data to database etc.

• developers should have experience with basic web technologies, such as html, xml, css, java script.

• good to have skills

• written mod-pl/sql that has been used to provide front end web user interface using http commands

• Experience

  6 - 12 Years

• No. of Openings

  20

• Education

  Any Bachelor Degree

• Role

  Oracle Programmer

• Industry Type

  IT-Hardware & Networking / IT-Software / Software Services

• Gender

  [ Male / Female ]

• Job Country

  India

• Type of Job

  Full Time

• Work Location Type

  Work from Office