LTIMindtree Limited Hiring For PL-SQL Developer at Chennai Full Time

Location:Chennai.

Essential Responsibilities:

5+ 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.
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.