PLSQL Developer

Location - Mumbai, Pune, Chennai, Bangalore, Delhi

Notice Period - Immediate to 15 days

6+ years of experience in all phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation and

Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes and exception Create database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer,

Strong working knowledge of Loading Data using SQL* Loader and PL/SQL using different file

Strong experience to integrate data feeds to/from other applications using shell scripting and MFT

Experience to establish connectivity to MFT server to load/unload Troubleshoot issue with file

Extensive experience in trouble shooting, Query Optimization and performance tuning use of explain

Experience in using the features Ref-Cursors, PL/SQL Tables, Materialized Views, Dynamic SQL and Oracle

Experience to write scheduler jobs and Troubleshoot issue if any

Analyze application requirements and provide recommended Support code migration from development to staging

Write complex SQL queries and PL/SQL procedures to extract data from various source

Ability to work independently and as part of a team, deliver under pressure and tight

Experience in writing shell script for data integration and Ability to enhance/modify script for data Troubleshoot issue related to MFT connectivity, load data to database

Developers should have experience with basic web technologies, such as html, xml, CSS, Java

Good to have skills

Written mod-PL/SQL that has been used to provide front end web user interface using http

Remote Work :

No