Data Warehouse Developer-Oracle PL/SQL 120K No C2C in Nashville, TN at Vaco

Date Posted: 6/24/2019

Job Snapshot

Job Description

We are looking for a senior data warehouse programmer (PL/SQL Developer) to join one of our clients. This is a Full Time Role. No 3rd parties please.

Duties:

  • Provides Oracle PLSQL development for enterprise application that integrates data from multiple data sources into a cohesive analytical data warehouse to support business intelligence applications;
  • Develop complex database processes with PL/SQL containing batch or ETL functionality;
  • Develop and enhance an existing Data Mart in an OLAP schema;
  • Gather requirements and design, develop, test and document solution;
  • Design logical and physical ERD diagrams, process flow diagrams, or related data processing documentation;
  • Leverage Oracle 11G/12C features to their fullest on a large-scale multi-terabyte system;
  • Assist Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements;
  • Participate in project work groups with Subject Matter Experts and stakeholders to understand data specific needs;
  • Provide production deployment and production support as needed;
  • Analyze and convert business requirements to technical requirements, followed by designing and implementing the solutions;
  • Be involved in all aspects of the software development life cycle;
  • Demonstrate abilities to learn both the business processes as well as new and existing technologies;
  • Work on sprint team in agile, rapid development and deployment environment; and
  • Support production application by investigating and resolving production inquiries and issues.
Required Skills/Experience:
  • 5+ years of experience in designing, creating and developing Oracle database systems;
  • Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing;
  • Solid experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance;
  • Experience in developing logical and physical data models;
  • Experience designing OLAP systems;
  • Strong SQL development, SQL analytics and tuning skills;
  • Excellent analytic, troubleshooting and performance tuning skills;
  • Detail orientation with strong problem solving skills;
  • Ability to analyze large amounts of complex data;