Us Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 26th Jul 2021
VDACS - Oracle PL/SQL developer to work in support of ASP.Net project performing ETL, data migration, and reporting.
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
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
Question 6
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?