Job Seekers, Please send resumes to resumes@hireitpeople.com
Detailed Job Description:
- Develop and modify PL/SQL packages, functions, Procedures, Triggers as per requirement to make new enhancements or to resolve problems.
- Creation of External Tables to read files from the database file systems.
- TOAD/SQL Developer for day to day operations.
- Working on Data Extraction, Data Mapping, Data Conversion, and Data Loading process using UNIX Shell scripting, SQL, PL/SQL, and SQL Loader.
- Experience with Database SQL tuning and query optimization tools like Explain Plan.
- Experience in External table concepts, SQL*Loader & UTL File concepts.
- Hands on experience in UNIX shell scripting for basic commands and some complex scripting as required.
- Strong understanding relational database concept and well familiar with SQL and PLSQL (Oracle)
- Experience in Agile delivery Strong SQL skills, PLSQL and MS SQL
- Experience in Informatica Power Center and IICS Strong SQL skills, PLSQL and MS SQL
- Develop and modify PLSQL packages, functions, Procedures, Triggers as per requirement to make new enhancements or to resolve problems.
- Creation of External Tables to read files from the database file systems.TOADSQL Developer for day to day operations.
- Working on Data Extraction, Data Mapping, Data Conversion, and Data Loading process using UNIX Shell scripting, SQL, PLSQL, and SQL Loader.
- Experience with Database SQL tuning and query optimization tools like Explain Plan.
- Experience in External tab
Minimum years of experience*: 5+