Description

Experience

3-6 Years

Location

Mumbai, Pune

Job Description :

  • Strong Experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle 10G, 11G, 12C and 19C
  • Expertise in SQL and PL/SQL programming, developing complex code units.
  • Experience in data migration/conversation using SQL*Loader.
  • Experience in Data Migration using import and export.
  • Expertise in creating the indexes on tables and partitioning the table for SQL tuning purposes.
  • Responsible for performance-tuning activities in the project.
  • Creating complex views, materialized views on multiple tables as per customer requirements.
  • Use PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass updates as a performance improvement process.
  • Ability to write complex SQL queries for reporting purposes.
  • Support the users of the application by using multiple SQL and PL SQL techniques.
  • Providing technical assistance, problem resolution and troubleshooting support.
  • Should have good experience in Client Interaction and Presentation Skills.


 

Education

Any Gradute