Oracle Developer III

  • location: Washington, DC
  • type: Contract
easy apply

job description

Oracle Developer III

job summary:
Job Description:Position Overview:

The desired candidate will fill in the position of a PL/SQL developer. This person's primary responsibility will be to develop PL/SQL code - procedure, functions, and packages to transform the source data based on business rules and load them in to target tables in the warehouse. Other responsibilities include query analysis & optimization, and maintenance of the data models. Additional responsibilities will include working with Tableau, Business Objects and J2EE technologies.

 
location: Washington, Washington, D.C.
job type: Contract
work hours: 9am to 5pm
education: Bachelors
 
responsibilities:
Essential Job Functions:

- Conduct a detailed discussion with the SMEs and document the understanding of the business requirements

- Write Low Level Design, Unit Testing Plan, and Unit Test case documentation

- Troubleshoot performance related issues

- Support system and user acceptance testing activities, including issue resolution

- Research problems reported by clients and other stakeholders and recommend fixes and solutions to be implemented after review by SMEs

- Complete technical documentation to ensure system is fully documented

 
qualifications:
Educational Qualification and Experience:

- Bachelor's degree in Computer Science, Engineering, or related discipline, and 2+ years of experience in Oracle development environment

- Good PL SQL programming experience in Oracle 11g - creating procedure, packages, functions, and triggers

- Good experience in development of Data Warehouse, Operational Data Store, and ETL solutions

- Good experience with data storage and retrieval

- Good experience with SQL analysis and query optimization

- Good experience with Job Scheduling

- Good experience with Shell Scripting

- Basic experience with Agile/Scrum development methodology

Certification Requirements:

- Oracle Certification

Required Skills/Abilities:

- Good analytical and problem solving abilities

- Basic knowledge of data modeling concepts and methodologies (Kimball) used in a data warehousing environment

- Good communication and writing skills with the ability to work in challenging environment

- Ability to multi-task their workload assignments

- Good analytical, problem-identification/solving skills

- Self-starter who enjoys working in an international team

- Flexibility, creativity and initiative

- Good knowledge and experience in PL/SQL, Oracle 11x (latest DB version) and/or SQL server

Educational Qualifications and Experience:

-Bachelor's degree in Computer Science, Engineering, or related discipline, and 5+ years of experience in Oracle development environment

Required Skills/Abilities:

-Superb communication and writing skills with the ability to work in challenging environment and must be able to multi-task their workload assignments

Desired Skills/Abilities (not required but a plus):

-Informatica development experience

-Experience in maintaining data models using Erwin

-Familiarity with database administration activities - space management; Managing schema objects - Indexes, Materialized views, partitions ; Database Maintenance - Optimizer stats, rebuilding indexes, partition maintenance, data purging, table analysis; Data loading - using SQL loader

-Exposure to SAP BO or other BI/Visualization tools

-Exposure to Data Services Technology using tools such as Composite

 
skills: Level III:

-Educational Qualifications and Experience:

-Bachelor's degree in Computing Science, Engineering, or related discipline, and 10+ years of experience in Oracle development environment or Master's degree and 7+years of experience

Experience Matrix for Levels:

- Level III - 7+ years of experience


Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs


    Senior Software Developer

  • location: Fairfax, VA
  • job type: Permanent
  • salary: $115,000 - $140,000 per year
  • date posted: 9/19/2019

    Mid-Level Developer

  • location: Bethesda, MD
  • job type: Permanent
  • salary: $90,000 - $120,000 per year
  • date posted: 8/13/2019