VIVA USA Inc Prog Analyst 4 - ETL Developer in Richmond, Virginia
Req Ref No: SKVAD3P-34 Location: Richmond, VA Duration: 3 Months
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 client 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.
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 - Required - 10 Years Expert Oracle database application developer including PL/SQL - 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; DMExpress - Highly desired - 10 Years Experience with data quality tools applied to ETL applications; Experian Pandora - Desired - 4 Years
VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.