Centraprise
Oracle Developer
Centraprise, Dallas, Texas, United States, 75215
Role- Oracle Developer
Location -Charlotte, NC HIGHLY PREFERRED*** or Dallas, TX is a back up
Jobtype ::Contract 12 month
Top 3 requirements:• Oracle PL/SQL Programming - 7+ years - Critical• Oracle SQL - 7+ years - Critical• Data Warehouse and Large data processing - 5+ years - Critical• Unix Shell Scripting - Important• Autosys or any Job Scheduler - 3+ years - Important (Autosys preferred)• Python programming - 1-3 years - Desirable
Notes from Call:
PL/SQL (package, procedures, functions, triggers, indexing)
Outdated ETL process right now
Autosys for parallel processing- run jobs here
Dynamic SQL
Bulk collections
Explain plan in SQL for performance tuning
This position would be a part of the Small Business Space- Oracle Datawarehouse Dev Team
Small business is going through a mainframe migration to cloud Ncino (one product at a time). Any product that is being moved into ncino all the screens data needs to come into their database first. All stories on upstream system go downstream to analytics space. Also feed data for dashboards to the business based on reporting needs: analytic use cases.
Location -Charlotte, NC HIGHLY PREFERRED*** or Dallas, TX is a back up
Jobtype ::Contract 12 month
Top 3 requirements:• Oracle PL/SQL Programming - 7+ years - Critical• Oracle SQL - 7+ years - Critical• Data Warehouse and Large data processing - 5+ years - Critical• Unix Shell Scripting - Important• Autosys or any Job Scheduler - 3+ years - Important (Autosys preferred)• Python programming - 1-3 years - Desirable
Notes from Call:
PL/SQL (package, procedures, functions, triggers, indexing)
Outdated ETL process right now
Autosys for parallel processing- run jobs here
Dynamic SQL
Bulk collections
Explain plan in SQL for performance tuning
This position would be a part of the Small Business Space- Oracle Datawarehouse Dev Team
Small business is going through a mainframe migration to cloud Ncino (one product at a time). Any product that is being moved into ncino all the screens data needs to come into their database first. All stories on upstream system go downstream to analytics space. Also feed data for dashboards to the business based on reporting needs: analytic use cases.