*Hello,*
*Hope you are doing great!!!!!*
*Job Title: Product Specialist 5 / PS5 ETL Developer *
*Duration:6+Months*
*Location: Columbus, OH (Need Locals )*
*Interviews: First round onsite. Second round phone.*
*Mandatory skills: Data Modeling and SSIS and Data Warehousing*
*Prod Specialist 5 (ETL developer)*
DODD operates a significant enterprise suite of applications. Included
within this suite are Medicaid related applications and applications
supporting health, safety and welfare of DODD consumers. Many of these
applications support processes based on ORC statute and Administrative
rules as well. In order to have a strong enterprise application suite DODD
maintains a Microsoft SQL server environment. This environment supports
both the noted applications and associated reporting. In order to
maintain a robust database infrastructure DODD continues to optimize
existing data structures and provide a framework for migration of data
across transactional reporting environments to data warehouse
environments. Current ETL work is focused on supporting development of a
hub and spoke DW environment to support the DW pilot project within the
county boards. This project allows counties better access to key data and
maintains health and safety for consumers. DODD is proposing to retain key
modeling, and enterprise transformation experts in order to complete the
initiative.
Specific worker characteristics are:
The Product Specialist is the expert for a technical development or
execution environment product or set of products. The primary
responsibility of a Product Specialist is to ensure the availability and
facilitate the productive use of a product for Application Teams or end
users. The DODD Product Specialist for this engagement will be well
versed in COGNOS and standard ETL tools processes and databases associated
with BI/DW
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.
Please revert back with the below requested information along with a latest
copy of your profile.
Full Name:
Phone:
Email:
Location:
Availability:
Available for Face to Face:
Work Authorization:
Validity if H1b:
Skype:
Rate (Hourly):
Thanks and Regards,
*Kalyan Kumar*
*Data Systems Integration Group Inc, *5131 Post Rd, Suite 175,
Dublin, OH - 43017
Email : kal...@dsiginc.com
Gmail & Yahoo :* kalyankumar.recruiter*
Direct: 614-344-4600 x 113
<http://www.anveta.com/>
--
You received this message because you are subscribed to the Google Groups
"US_IT_ Jobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to chandrakants+unsubscr...@googlegroups.com.
To post to this group, send email to chandrakants@googlegroups.com.
Visit this group at https://groups.google.com/group/chandrakants.
For more options, visit https://groups.google.com/d/optout.
