Job ID :
28781
Company :
Internal Postings
Location :
Alpharetta, GA
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
10 Nov 2020
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+