Hello Dear, Greetings ,
This is Ratan from Nixsol Inc.
We have an Urgent Direct Client Requirement on SSIS with ETL Developer
Job Title : SSIS with ETL Developer
Location : Columbus, Ohio
Duration : 1 year
The Programmer is responsible for analysis, design, coding, component and assembly testing of all application code owned by the Application Team.
The Department of Developmental Disabilities (DODD) is the fourth largest state agency with over 3000 employees providing direct care to individuals. Over 300 staff located in central Ohio, provide oversight for almost 100,000 individuals receiving services from county boards; central office staff also administer 3 Medicaid waiver programs whose 8000 providers deliver service and supports to 27,000 individuals representing 1.2 billion dollars in claims. The data warehouse program was implemented to provide data integration using cutting edge technologies to support business process improvement. The data warehouse is built on cutting edge technologies and hardware with demonstrated cost benefits. The warehouse presents data in a common aggregated format supported by advanced ETL processes that allow users to do ad hoc reporting on data in order to allow for fresh perspectives on data while supporting common results. The approach also maintains access to historical data reporting. DODD has focused on multi-faceted approach to ensure success of the project. Efforts include infrastructure, ETL, and process.
DODD is currently seeking a senior level person with complete and demonstrable understanding of data warehousing concepts. Additionally, the candidate should possess a strong knowledge of ETL processes including a complete functional understanding with hands on experience using Microsoft SSIS packages for the migration of data between OLTP, staging and OLAP environments. This understanding would include hands on experience in control and data flow with SSIS. The candidate will also possess fluency in normalization of table structures and have demonstrated modeling experience with hub and spoke architectures. The candidate will be part of the DODD BI DW team working on support and continued enhancements of the aforementioned project.
1. 5 years of supporting ETL in a production environment
a. Understands and can independently setup/configure SISS packages to run in production
2. 4 years of senior level SSIS experience
a. Knows control flow and data flow items and can demonstrate usage of each
3. 4 years Senior level SQL skills that include database development activities
4. 5 years of data modeling experience (hub and spoke, dimensional, data vault)
5. Has a complete understanding of database normalization and can fluently speak about the various normal forms (1st – 6th)
6. 3 years of experience developing or supporting a hub and spoke database architecture, this person must have a complete and demonstrable understanding of data warehousing concepts.
Tentative Interviews 12/4-12/6
Skill Required
5 yr of supporting ETL in a production environment, (understands and can independently setup/configure SISS packages to run in production) Required 5 Years
4 yr of senior level SSIS experience, (knows control flow and data flow items and can demonstrate usage of each) Required 4 Years
4 yr of Senior level SQL skills that include database development activities Required 4 Years
5 yr of data modeling experience (hub and spoke, dimensional, data vault) Required 5 Years
Has a complete understanding of database normalization and can fluently speak about the various normal forms (1st – 6th) Required 5 Years
3yr experience developing/supporting a hub and spoke database architecture, person must have a complete and demonstrable understanding of DW concepts. Required 3 Years
Skill Matrix: Must and should fill the skill matrix
| Required Skills | Years of Experience | Last Used |
| supporting ETL in a production environment, (understands and can independently setup/configure SISS packages to run in production) |
|
|
| senior level SSIS experience, (knows control flow and data flow items and can demonstrate usage of each) |
|
|
| Senior level SQL skills that include database development activities |
|
|
| Has a complete understanding of database normalization and can fluently speak about the various normal forms (1st – 6th |
|
|
| data modeling experience (hub and spoke, dimensional, data vault) |
|
|
| experience developing/supporting a hub and spoke database architecture, person must have a complete and demonstrable understanding of DW concepts. |
|
|
Give me the details listed below:
Full Name:
Availability to start-----:
Availability for interview:
Visa Status (US Citizen, GC Holder, H1b or TN holder):
Contact Number:
E-mail Address:
Re-location:
Current Location (Place & State):
Last 4 SSN:
(Date of Birth) Date & Month:
2 Professional References (Name/ Project Name/ Title/Email ID/ Contact number):
Regards,
Ratan.B.
Nixsol Inc.,
53 Knightsbridge Road
Suite # 216
Piscataway, NJ 08854.
(:(732)-832-7935
6:(732)-909-2424
*:ratan@nixsol.com
YIM: ratan_nixsol . GTalk: ratan12786
Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with 'remove' and include your 'original email address / addresses' in the subject heading and Include complete address/addresses where our mail is received. We will immediately update it accordingly. We apologize for the inconvenience if any caused. Thank you.
"We treat others as we wish to be treated"
--
To post a job send email to: xrecnet@googlegroups.com.
To unsubscribe send email to: xrecnet+unsubscribe@googlegroups.com
___________________________________________________________________
Visit http://xrecnet.blogspot.com for IT Recruitment News, Articles, Recruiting Tools & Resources
No comments:
Post a Comment