or email this job to apply later

VDACS - Oracle PL/SQL developer to work in support of ASP.Net project performing ETL, data migration, and reporting.
MAX VENDOR RATE: NA
Local RVA candidate preferred, some ON SITE required (see below)

Pls note: 6 month assignment expected, though it could extend. If selected, candidate will be required to pick up equipment and perform initial log in IN PERSON. No exceptions.

Local Richmond candidates preferred OR candidate must be close enough to pick up equipment in person and attend ON SITE meetings as requested by Mgr/Team Lead.

ABOUT THE ROLE

VDACS is looking for an experienced Oracle PL/SQL developer to write procedures, packages, functions, and SQL to perform ETL, data migration, and reporting functions.

KNOWLEDGE/SKILLS /EXPERIENCE

Required:

Substantial experience as a PL/SQL Developer in an Oracle 12 database environment
Experience defining Oracle database objects such as tables, triggers, indexes, and other objects using Oracle PL/SQL DDL
Substantial experience developing Oracle PL/SQL Procedures to perform ETL to reporting data mart tables
Substantial experience writing data migration stored procedures to move data from legacy tables and data structures into new application data structures
Experience doing performance tuning of PL/SQL queries and stored procedures
Experience building efficient and well documented Oracle procedures, functions, and packages

Preferred:
Experience implementing error handling and logging in PL/SQL scripts
Experience developing and testing Oracle Forms and Reports applications

DAY TO DAY

Perform data migration programming to migrate data from previous Oracle application tables into new Oracle tables for a new .Net application under development
Develop ETL procedures to take data from transactional tables and load into reporting tables for frequent refresh to support efficient use of business data
Write stored procedures to support reporting and other data query needs
Perform data updates for Oracle applications as needed

Required/Desired Skills

Skill	Required /Desired	Amount	of Experience
Substantial experience as a PL/SQL Developer in an Oracle 12 database environment	Required	10	Years
Experience defining Oracle database objects such as tables, triggers, indexes, and other objects using Oracle PL/SQL DDL	Required	10	Years
Substantial experience developing Oracle PL/SQL Procedures to perform ETL to reporting data mart tables	Required	5	Years
Substantial experience writing data migration stored procedures to move data from legacy tables and data structures into new application data struct	Required	5	Years
Experience doing performance tuning of PL/SQL queries and stored procedures	Required	10	Years
Experience building efficient and well documented Oracle procedures, functions, and packages	Required	10	Years
Experience implementing error handling and logging in PL/SQL scripts	Desired	5	Years
Experience developing and testing Oracle Forms and Reports applications	Nice to have	5	Years

Questions

No.	Question
Question1	Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question2	Please list candidate's email address for RTR
Question3	Please list city and state that your candidate CURRENTLY resides.
Question4	Does your candidate have the REQUIRED skills listed above?
Question5	Does your candidate have any of the Desired/Nice to Have skills listed above? If so please specify here:
Question6	Selected candidate must pick up equipment and perform initial log in IN PERSON. Some ON SITE meetings as requested. Does your candidate agree to this?

RICEFW Technologies Inc

Apply Online

or email this job to apply later

	Search millions of jobs
Jobvertise

Report this job