Analysis of business requirements and convert business rules into design software to meet the requirements. Create SQL*Loader control files for loading the data from flat files to staging area tables. Develop SQL and PL/ SQL scripts for migration of data between databases. Involve in Database Testing (Oracle), load the test data into Oracle database by writing SQL queries and PL/SQL procedures. Program using PL/SQL stored procedures, triggers, views, user-defined functions. Create Policies, Validate XML files against application and DB tables. Optimize the SQL statements, PL/SQL programs. Use Oracle 11g, SQL, PL/SQL, SQL developer, Informatica 9.x, TOAD, UNIX, Perl, Forms 10g, Reports 10g and SQL Plus. Primary worksite is Edison, NJ, but relocation is possible.
Requirements: Master degree in Computer Science or related with 6 months experience as Programmer Analyst or Software Engineer or Consultant.
Any Graduate