Req of ETL Developer/Analyst
Prabhdeep Tuteja
Hi,
This is Prabhdeep from cyber think we have an urgent req from our client.
Complete Description:
**local candidates strongly preferred
VDH is for an experience ETL/BI developer/analyst to help develop an architecture to support BI reporting.
VDH IS IN NEED OF A HIGHLY SKILLED ETL DEVELOPER/SYSTEMS ANALYST WITH A STRONG BACKGROUND IN DATA ANALYSIS, ETL DEVELOPMENT USING SQL AND DATA MODELING. ADDITIONAL EXPERIENCE IN REPORT DEVELOPMENT IS PREFERRED. EXPERIENCE IN OR EXPOSURE TO WHERESCAPE RED AND/OR LOGIXML IS A PLUS.
As an ETL developer/analyst this candidate will be responsible for analyzing new source system databases, developing complex ETL processes in SQL and Wherescape red and dimensionally modeling an architecture conducive to reporting. This candidate should also be experienced in documentation, change control, and promotion methodologies.
* Candidate will be required to demonstrate through interview questions a understanding of fundamental ETL principles, including various load strategies and types of loads.
The candidate will work 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.
The current technology infrastructure is based on ORACLE 11G, Wherescape Red, and LogiXML
Specific Task(s):
. Critically evaluates information gathered from multiple sources and reconciles potential conflicts.
. Communicate and collaborate with customers to analyze information, business problem and automation needs.
. Develops ETL and dimensional models to pull data from multiple sources into data warehouse.
. Create reports using the tools specified.
. Assist in creating preliminary project plan, test plan, test cases and documentation as required
. Other elicit requirements for BI reporting and dashboards
Skill Matrix:
|
Skill |
Required/Desired |
Amt. Of Exp. |
Your Exp. |
Last Used. | ||||||
|
Experience with Extract, Transform, Load (ETL) systems using oracle SQL Loader and PL/SQL |
Required |
5 Years |
|
| ||||||
|
Strong development skills in at least one report deployment solution (i.e., Cognos, LogiXML, Crystal Reports or Reporting Services |
Required |
2 Years |
|
| ||||||
|
Strong SQL Experience |
Required |
4 Years |
|
| ||||||
|
Oracle 9-11g experience |
Required |
4 Years |
|
| ||||||
|
Data Warehouse experience |
Required |
2 Years |
|
| ||||||
|
Data Analysis |
Required |
5 Years |
|
| ||||||
|
Promotion Change Control Methodology |
Required |
3 Years |
|
| ||||||
|
Good Oral and written communication |
Required |
20 Years |
|
| ||||||
Questions
|
Question 1 |
Can the candidate join within 2 weeks? | |||
|
Question 2 |
Does the candidate have strong SQL and database experience? | |||
|
Question 3 |
Does candidate live within a 50 mile radius of Richmond, VA? | |||
|
Question 4 |
If not, in what city/state does candidate reside? | |||
--
Prabhdeep Tuteja
Prabhdeep Tuteja
Hi,
This is Prabhdeep from cyber think we have an urgent req.
Position: ETL Developer/Analyst
Location: Richmond VA
Duration: 6 Months+
Client: Virginia Department of Health (VDH)
Rate: Open
VDH is in need of a highly skilled ETL Developer/Systems Analyst with a strong background in Data Analysis, ETL Development using SQL and Data Modeling. Additional experience in Report Development is preferred. Experience in or exposure to Wherescape Red and/or logixml is a plus.
As an ETL developer/analyst this candidate will be responsible for analyzing new source system databases, developing complex ETL processes in SQL and Wherescape red and dimensionally modeling an architecture conducive to reporting. This candidate should also be experienced in documentation, change control, and promotion methodologies.
* Candidate will be required to demonstrate through interview questions a understanding of fundamental ETL principles, including various load strategies and types of loads.
The candidate will work 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.
The current technology infrastructure is based on ORACLE 11G, Wherescape Red, and LogiXML
Specific Task(s):
. Critically evaluates information gathered from multiple sources and reconciles potential conflicts.
. Communicate and collaborate with customers to analyze information, business problem and automation needs.
. Develops ETL and dimensional models to pull data from multiple sources into datawarehouse.
. Create reports using the tools specified.
. Assist in creating preliminary project plan, test plan, test cases and documentation as required
. Other elicit requirements for BI reporting and dashboards
REQUIRED SKILL-SET
- Experience with Extract, Transform, Load (ETL) systems using oracle SQL Loader and PL/SQL – 5 Years
- Strong SQL Experience – 4 years
- Oracle 9-11g experience – 4 Years
- Data Warehouse experience – 2 Years
- Promotion Change Control Methodology – 3 years
- Strong development skills in at least one report deployment solution (i.e., Cognos, LogiXML, Crystal Reports or Reporting Services) – 2 Years
- Does the candidate have strong SQL and database experience?