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