Oracle PL SQL Developer

Reposted 6 Days Ago
Be an Early Applicant
Raleigh, NC
In-Office
Entry level
Information Technology • Software • Consulting
The Role
The Oracle PL SQL Developer will focus on PL/SQL and SQL programming, business analysis, integration design, documentation, and technical deliverables while assisting in application architecture and data model enhancements.
Summary Generated by Built In
Company Description

Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with focus on providing paramount and unsurpassed services combined with cost saving solutions to the clients
We understand the business requirements in the present day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemas and unconventional channels to provide one-stop solutions for all your workforce needs.
our Team is an exquisite amalgamation of vast experiences of over 30 years in IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.
We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software development, Web Development providing unexcelled services and focusing on both the employers and employees.

Job Description

Description: Oracle Developer responsible for PL/SQL and SQL programming, development, business analysis. Requires working knowledge of application architecture, analysis and design.

Specific tasks/deliverables and skills for this position include the following:

1. Review Functional and Technical requirements for clarity.

2. Research and analyze existing business documents and processes, including forms and reports, and assist in making recommendations about improvements to processes.

3. Business Rule identification and validation.

4. Assist with the Application design and analysis as well as provide input to the Database design.

5. Document application design and system architecture in accordance with NC DPI standards.

6. PL/SQL development and SQL programming, code documentation and unit testing.

7. Web development experience required.

8. Integration design for data exchange, import and export.

9. Enhance the data model and write stored procedures.

10. Build technical deliverables as directed by Project Manager and the Applications Development/Data Management Team Manager.

11. Report creation and validation (including record control counts, validation checks, etc. per specifications).

12. Resolve any issues found in functional, performance, regression or acceptance testing.

13. Document all technical deliverables (e.g. database schemas, file extracts, intermediate tables/files, reports, processes, procedures, scripts, etc.) as built.

14. Document the data retrieval methods via ETL, FTP and other means utilized to include source, destination, schedule and job controls.

15. Perform training to NC DPI support staff for the maintenance/support of technical deliverables built.

16. Any other duties as determined needed by the Project Manager and/or the Applications Development/Data Management Team Manager with regards to developing data extracts, ETL processes, reports, etc.

Application Developer and DBA tasks completed in accordance with DPI’s project methodology and to the satisfaction of the Project Manager and Applications Development/Data Management Team Manager.

Assignments are completed accurately and in a timely manner as determined and agreed to by management involved with the assignment of the tasks/deliverables.

Skills Required

Solid developer - Oracle database development, code documentation and unit testing. PL/SQL development and SQL programming. Web development.

Enhance the data model and write stored procedures. Report creation and validation.

Strong support experience with ability to resolve application issues found during testing or in production.

Integration design for data exchange, import and export. Familiar with ETL and FTP to include source, destination, schedule and job controls.

Design application framework based on requirements documentation utilizing Oracle Database.

“As Built” application analysis/design and system architecture documentation including database schemas and data retrieval methods.

Transitioning application maintenance/support to others including providing PL SQL training and support to technical staff.

Researching/analyzing Functional requirements including Business Rule identification and validation, business documents and process improvements.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Top Skills

ETL
Ftp
Oracle
Pl/Sql
SQL
Web Development
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Cary, NC
55 Employees

What We Do

Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with focus on providing paramount and unsurpassed services combined with cost saving solutions to the clients.
Specialties--
At Arete Technologies, Inc., our Team is an exquisite amalgamation of vast experiences of over 30 years in IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.

We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software development, Web Development providing unexcelled services and focusing on both the employers and employees.

Similar Jobs

Allen Lund Company Logo Allen Lund Company

Sql Engineer

Logistics • Software
In-Office
Charlotte, NC, USA
661 Employees

PwC Logo PwC

Designer

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
67 Locations
370000 Employees
212K-244K Annually

PwC Logo PwC

Systems Engineer

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
64 Locations
370000 Employees
99K-232K Annually

Ahold Delhaize USA Logo Ahold Delhaize USA

Platform Engineer

AdTech • eCommerce • Food • Marketing Tech • Retail
In-Office
Salisbury, NC, USA
10000 Employees
125K-188K Annually

Similar Companies Hiring

Standard Template Labs Thumbnail
Software • Information Technology • Artificial Intelligence
New York, NY
10 Employees
PRIMA Thumbnail
Travel • Software • Marketing Tech • Hospitality • eCommerce
US
15 Employees
Scotch Thumbnail
Software • Retail • Payments • Fintech • eCommerce • Artificial Intelligence • Analytics
US
25 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account