PL/SQL Developer

Kaav Inc - Mount Laurel, NJ (30+ days ago)

Apply Now

Job Title: PL/SQL Developer

Location: Mount Laurel, NJ

Duration: 12 months+

Primary Skills pl/sql, Data Modelling, OLAP,ETL, Performance Tuning, Agile

Experience: 7+ years

Need Green Card or Citizens only.

Job Description

Responsibilities:

· Develop complex PL/SQL data processes for large scale custom Oracle applications

· Develop understanding of client business processes, objectivesand solution requirements

· Participate in project work groups with subject matter expertsand stake holders to understand data specific needs

· Develop understanding of application processes, coding standardsand performance standards while learning existing and new processes andtechnologies

· Work with team lead/ solution architect on solution design

· Analyze and convert business requirements to technicalrequirements

· Create logical and physical ERD diagrams, process flow diagramsand related data processing design documentation

· Code per development and performance standards

· Resolve defects identified in testing and code reviews

· Execute performance test and code reviews

· Support production deployment and production support

· Investigate and resolve production Inquiries and issues.

Required skills:

· PL/SQL – programming language – bulk collections, dynamic SQLand parallel processing

· Transactional and BI reporting systems (e.g. OLAP and datawarehouse) – design, development, tuning and production support

· Database design and modeling – logical and physical

· ETL development

· Performance tuning – table partitioning and indexing, processthreading

· Database storage sizing and maintenance

· Agile development methodology

· Detail orientation with strong analytical and problem solvingskills

· Flexibility and ability to thrive in a dynamics environment

· Good Communication skills (both verbal and written)

Job Type: Contract

Salary: $60.00 to $65.00 /hour

Experience:

  • PL/SQL: 8 years (Required)
  • relevant: 10 years (Required)