Previous Job
Previous
ETL Developer
Ref No.: 14-01355
Location: Richmond, Virginia
Department of Health
Richmond, VA
8 months+

Either Phone or In Person

VDH ETL Developer


*local candidates strongly preferred


VDH IS IN NEED OF A HIGHLY SKILLED ETL DEVELOPER/SYSTEMS ANALYST WITH A STRONG BACKGROUND IN SCALABLE, HIGH QUALITY, AND HIGH PERFORMANCE BUSINESS INTELLIGENCE (BI) DASHBOARDS AND RELATED APPLICATIONS BUILT USING ORACLE AND OTHER BI TECHNOLOGIES.

AS AN ETL DEVELOPER/ANALYST THIS CANDIDATE WILL BE PRIMARILY RESPONSIBLE FOR DEVELOPING ETLS TO PERFORM LOADING, SANITIZATION, AND DIMENSIONAL MODELING OF DATA FROM MULTIPLE SOURCES. THE DEVELOPER WILL ALSO CONTRIBUTE TO BUILDING THE BI DASHBOARD AND ASSOCIATED REPORTS, REQUIRING WRITING SOPHISTICATED QUERIES AND UTILIZING AN UNDERSTANDING OF DATA PRESENTATION FUNDAMENTALS.
WORKS AS PART OF THE VIRGINIA DEPARTMENT OF HEALTH, OFFICE OF INFORMATION MANAGEMENT (OIM) DATA WAREHOUSE TEAM TO PROVIDE DEVELOPMENT, SYSTEM ANALYSIS, TECHNICAL SUPPORT AND PEER TROUBLESHOOTING ASSISTANCE TO HELP IMPROVE VDH DECISION MAKING, OPTIMIZE PERFORMANCE, AND ACHIEVE REPORTING REQUIREMENTS. THIS CANDIDATE WILL WORK WITH A TEAM OF ANALYSTS, DEVELOPERS, MANAGERS, AND BUSINESS RESOURCES TO BUILD HIGHLY PERFORMING SYSTEMS.
CODE SAMPLES REQUIRED
SPECIFIC TASK(S):
DEVELOPS ETL AND DIMENSIONAL MODELS TO PULL DATA FROM MULTIPLE SOURCES INTO DATA WAREHOUSE
CRITICALLY EVALUATES INFORMATION GATHERED FROM MULTIPLE SOURCES AND RECONCILES POTENTIAL CONFLICTS.
COMMUNICATE AND COLLABORATE WITH CUSTOMERS TO ANALYZE INFORMATION, BUSINESS PROBLEM AND AUTOMATION NEEDS.
CREATE REPORTS USING THE TOOLS SPECIFIED
ASSIST IN CREATING PRELIMINARY PROJECT PLAN, TEST PLAN AND TEST CASES.
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Dimensional modeling
Required
3
Years
Business and System Analysis
Required
3
Years
SQL development expertise using Oracle /SQL Server 2008 or higher
Required
4
Years
Data Analysis using advanced techniques
Required
4
Years
Experience with Extract, Transform, Load (ETL) systems
Required
4
Years
Experience in at least one report deployment solution (i.e., Tableau, Cognos, LogiXML, Crystal Reports or Reporting Services)
Desired
2
Years
Creating High Level Task Plan and Deliverables
Desired
3
Years
Must possess excellent Oral and Verbal Communication
Required
10
Years
Global Candidate Requirements
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Certification and Screening Criteria
Add
Remove
Description
Valid
Location(s)
Date Achieved
Expiration
Date
Cert #
Y/N
Comment
Show to
Required before Engagement
Questions
Add
Remove
Description
Question 1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2
Please list candidate's email address that will be used when submitting E-RTR.
Question 3
In what city/state does candidate reside?
Question 4
Does your candidate's experience match or exceed the skills listed above and the number of years of experience with each sklll?
Question 5
Does your contract agree to completing the entire engagement?
Question 6
How soon after an offer can your candidate start?