Job Description :
Experience with various technologies such as Oracle, SQL, PL/SQL, SQL*Loader, Dynamic SQL, TOAD, PL/SQL Developer, SQL Navigator
Extensive experience in developing complex SQL Queries, Triggers, Materialized Views, Stored Procedures, Functions, Packages and other database objects
Convert the Logical/Physical data models into Oracle schema objects scripts, built the database schemas for application code development and database code migration
Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, Record Types and Dynamic SQL for DML operations for better performance.
Experience in copying production data into development and System Testing and User Testing environments by Oracle’s Export/Import Data Pump utility
Experience in Tuning SQL queries
Experience in batch processing’s, debugging for Extraction, Transformation and Loading processes.