Primary Skills:Triggers packages functions and stored procedures for data conversions and PL/SQL procedures
Secondary Skills:SQL PLus PL/SQL and SQL Loader scripts for data conversions
Job Location:
Hyderabad
Posted Date:
391 days ago
Job Description
Involvment in the full development cycle of PLanning, analysis, design, development, testing, and implementation.
Should have worked writing various and complex SQL's.
Should be able to write SQL PLus, PL/SQL and SQL Loader scripts for data conversions.
Hands on experience on triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on bussiness logic.
Should have worked on indexes to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
Should Coordinate with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Should have Used ref cursors and collections for accessing complex data resulted from joining of a large number of tables.