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