Tech Evaluation Login
Tech Evaluation Signup
PasswordReset
Unsubscribe
PasswordReset
PasswordReset
PasswordReset
Register for Webinar
Register for Event
Job Channels
Skill Score
About Us
Contact Us
Our Blog
Toggle navigation
Home
Skill Score
DemandIndex
Jobs
FETCH Jobs
Java J2EE
Dot Net, C#
DBA
SAP
Admin, Networking
Datawarehousing
QA
Demo
Candidate
Recruiter
Services
Job Posting & Resume Access
Integrated Talent Sourcing
Sub Contractor Supply Chain
Merger & Acquisition
Candidate
Post Resume
Login
Create Job Alert
Recruiter
Login
Free Trial
Signup
Pricing
| Pricing
Dashboard
My Resumes
Resume List
Add Resume
Edit / Update Resume
My Jobs
Fetch Jobs
Matched Jobs
Applied Jobs
Product Specialist OR ETL Developer with SSIS
Columbus, OH
Columbus
OH
43287
Date
: Jul-20-17
2017-07-20
2018-07-20
Product Specialist OR ETL Developer with SSIS
Columbus, OH
Jul-20-17
Work Authorization
US Citizen
GC
H1B
GC EAD
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Architect, Midlevel
Rate/Salary ($)
:
Market
Duration
:
12 months
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
x-Other
Permanent Direct Hire
Consulting / Contract
Third Party OK
FULL_TIME, CONTRACTOR
Direct Client Requirement
Required Skills
:
ETL , SSIS Master Data Management, Data Dictionary, Data Cleansing, Data Integration, Data Flow Design, and Data Governance.
Preferred Skills
:
Domain
:
IT/Software, Financial, Government
Work Authorization
US Citizen
GC
GC EAD
H1B
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Architect, Midlevel
Rate/Salary ($)
:
Market
Duration
:
12 months
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
x-Other
Permanent Direct Hire
Consulting / Contract
Third Party OK
FULL_TIME, CONTRACTOR
Direct Client Requirement
Required Skills
:
ETL , SSIS Master Data Management, Data Dictionary, Data Cleansing, Data Integration, Data Flow Design, and Data Governance.
Preferred Skills
:
Domain
:
IT/Software, Financial, Government
Flairsoft
Ohio, IL
Post Resume to
View Contact Details &
Apply for Job
Job Description
:
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 OLTP/OLAP/Data warehouse modeling including multidimensional modeling 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.
Requirements:
Five years of experience with OLTP/OLAP/Data warehouse modeling
Multidimensional Model
Data Vault Model
Relational Model
Entity-relationship Model
Five years of experience with ETL/ETL using SSIS (Knows control flow and data flow items and can demonstrate usage of each. Understands and can independently setup/configure SISS packages to run in production)
Five years of experience with Master Data Management, Data Dictionary, Data Cleansing, Data Integration, Data Flow Design, and Data Governance.
kindly me your resume
Client :
State of Ohio
Turn OFF keyword highlights
Similar Jobs you may be interested in ..
Sr. Data Engineer
,
Columbus, OH
Apr-15-24
Accord Tecnologies.Inc
($) :
Market
Sr. Data Engineer Columbus, OH (look within OH who are interested in relocation) Duration: 12 months Position type: Hybrid (3 days onsite, 2 days offsite) Contract type: W2 contract 10+ year of exp. required Roles and Responsibilities: Python or Java is required Must be good with Microservices and API's THE PREFERENCE TO HIRE IS PYTHON WITH DATA BACKGROUND, the java is secondary There is lots of SQL involved, setting up data pipelines, etc Must be very strong in SQL Will
Apply
[Apply Individually]