Job Description :
ETL Developer (530993) / F2F
3 Months
Richmond, Virginia 23219
Complete Description:
local candidates strongly preferred
ONLY in-person interviews will be conducted, NO Skype, NO exceptions
position will be extended beyond 6/30/18 end date on req, possibly 6-12 months
please do NOT submit candidates who have been submitted to previous DSS ETL reqs or DSS DM Express reqs.
Analysis of source system data and business reporting requirements, design of staging area and presentation layer objects in Oracle, ETL software design, development and testing, documentation, and maintenance work. Sources of data for the project will be Oracle primarily but not exclusively. The goal is to build and populate a new dimensional data mart for Child Welfare services reporting.
Plans, develops, tests, and documents data warehouse ETL computer programs and jobs. Evaluates user requests for new or modified application software to determine feasibility, cost and time required, and compatibility with current system & computer capabilities. Consults with team members and business users to identify current operating procedures and clarify objectives. Formulates plans outlining steps required to develop programs using structured analysis & design, agile, or other suitable method.
The contractor will work with business stakeholders, business analysts, BI architect, ETL team lead, and potentially other developers. The tools and technologies used for this work are specialized, and the contractor will have the responsibility to develop, recommend, and communicate their best practices.
Skills:
Expert designer, coder and tester for data warehouse programming ETL Tools and UNIX shell scripts (Required 10 Years)
Expert Oracle database application developer including SQL Years (Required 10 Years)
Expert Oracle database application developer including PL/SQL Years (Required 10 Years)
Expert Oracle database application developer including Materialized Views (Required 10 Years)
Expert Oracle database application developer including Performance Tuning (Required 10 Years)
Expert Oracle database application developer including DDL Operations (Required 10 Years)
Advanced skills defining business data requirements and the characteristics of source system data (Required 10 Years)
Data modeling and dimensional data warehouse schema design experience (Required 10 Years)
Must be able to demonstrate ETL skills and capabilities; DM Express (Required 10 Years)
Experience with data quality tools applied to ETL applications; Experian Pandora (Required 10 Years)