Report this Job
Hourly Rate: $61 W2; $70 CTC/1099
Job Description:
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
The client 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 Skills:
Substantial experience as a PL/SQL Developer in an Oracle 12 database environment (10 years) Experience defining Oracle database objects such as tables, triggers, indexes, and other objects using Oracle PL/SQL DDL (10 years) Substantial experience developing Oracle PL/SQL Procedures to perform ETL to reporting data mart tables (5 years) Substantial experience writing data migration stored procedures to move data from legacy tables and data structures into new application data struct (5 years) Experience doing performance tuning of PL/SQL queries and stored procedures (10 years) Experience building efficient and well documented Oracle procedures, functions, and packages (10 years)
Preferred Skills:
- Experience implementing error handling and logging in PL/SQL scripts (5 years)
- Experience developing and testing Oracle Forms and Reports applications (5 years)
Oracle SQL Developer PL/SQL, Oracle, ETL, Reporting Data Mart Tables, Data Migrations
Higher Competitive Rates will be considered for consultants with advanced skill set
Corp to Corp Resumes are welcome
Consultants may need a criminal background check
Chandra Technologies, Inc.