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