ETL Architect (Jobs in Columbia, SC)   Requirement id 7957 Job title Architect Job location in Columbia, SC Skills required ETL, ETL Large Scale Conversion, Data Management Tools, Open Date 12-Jan-2012 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type Phone Screen and Face to Face interview    Email Recruiter: coolsoft Job Description Architect: ETL, ETL Large Scale Conversion, Data Management Tools, [Note: Start Date : 2/15/2012] [Note: Duration : 12+ Months] Description : SCOPE OF THE PROJECT : The Medicaid replacement projects (Medicaid Management Information System and the Eligibility & Enrollment Member Management) are among the most complex IT projects taken on by the SC Department of Health and Human Services in partnership with Clemson University. These projects are multi-year efforts to replace the States aging Medicaid systems with a multi-tier application environment that requires modern technologies, technical practices and substantial collaboration with a variety of stakeholders. Responsibilities : SCDHHS seeks a skilled technical professional with relevant experience on similar projects that can both complete the data conversions tasks required for this project while also providing recommendations for ETL, data profiling, data quality and data management best practices based on their experiences and expertise. The Data Conversion Lead will be focused on planning, converting and migrating data migration (including extraction, transformation and loading [ETL]) from legacy mainframe system(s) (IDMS and IDMS-R) to a modern relational database as part of the overall Medicaid replacement projects. The Data Conversion Lead will carry out the data management activities necessary to achieve the projects data migration strategic goals and objectives and work closely with the projects data architect, database administrators and technical leads. The Data Conversion Lead will create manual and/or automated procedures and/or custom configure data conversion software as required to perform the activities indentified in the data conversion plan. They may also assist with migration of As-is system data and external data to the new MMIS system and selected data administration tasks. Data conversion development tasks include: * Develop and manage data conversion rules and ETL process(es) * Validate pre-converted and post-converted data to ensure the data is consistent, well formed, and of high structural integrity * Create and manage a schedule of database conversion related tasks and events * Establish, test and execute reliable and repeatable process(es) for converting legacy data into a modern relational database that meets the projects functional and non-functional requirements * Use of appropriate data conversion tools, strategies, and methodologies that will meet the data conversion plan objectives Required Skills : * Significant experience with ETL activities * Demonstrated success in developing, documenting and managing ETL for large data sets * Experience working with commercial database solutions * Experience working with commercial ETL/data management tools * Ability to develop, propose and present solutions/approaches to data conversion activities, especially in light of a variety of possible approaches * Good written and oral communications skills, including the ability to give presentations to the management team. Strong proficiency in English is required. * Willingness and ability to effectively engage with people and organizations on a continuous basis. PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE) : * Oracle Database * Experience with MS-SQL server * Knowledge of IDMS/IDMS-R data structures and COBAL programming Medicaid Management Information System (MMIS) experience * Medicaid eligibility system/business operations experience. *Commercial insurance and/or health care data experience * Public sector experience is a plus. REQUIRED EDUCATION : Bachelors degree in a technical, business, or field. Masters degree is desirable. Years of experience can substitute for formal education.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 7957 while calling.   Other jobs in SC: Beaufort (1), Blythewod (2), Blythewood (3), Charleston (17), Columbia (37), Greenville (4), Hartsville (2), North Charleston (2), Overland Park (1), San Francisco (1), SENECA (4), South Carolina (1), Spartanburg (3), Unknown (2), ETL job openings in Columbia, SC Jobs List datawarehouse ETL SAP Consultant (Jobs in Columbia, South Carolina) Create date: 29-Mar-2011 [NOTE:A.HOW MANY RESUMES DO YOU WANT TO REVIEW AT ONE TIME?:All that qualify B.POSSIBILITY OF EXTENSION] DAILY DUTIES / RESPONSIBILITIES: Within project schedules and other defined deadlines, candidate will provide functional and technical services including: • The Data Architect / modeling expertise • Gather data inf.... (This job is for - datawarehouse ETL SAP Jobs in SC Columbia Consultant - (in Columbia, SC)) ETL datawarehouse SAP SQL Consultant (Jobs in Columbia, South Carolina) Create date: 29-Mar-2011 Organization: Department of Employment and Workforce NOTE:A.HOW MANY RESUMES DO YOU WANT TO REVIEW AT ONE TIME?:All that qualify B.POSSIBILITY OF EXTENSION DAILY DUTIES / RESPONSIBILITIES: Within project schedules and other defined deadlines, candidate will provide functional and technical services including: <.... (This job is for - ETL datawarehouse SAP Jobs in SC Columbia Consultant - (in Columbia, SC))    ETL job openings in other states Jobs List ETL Data Developer (Jobs in Raleigh, North Carolina) Create date: 15-May-2012 [**Note : Closing Date : 5/21/2012 5:00PM**] [Note : From Date: 6/1/2012 To Date: 12/1/2012] Description : Expectations/Duties include the following: ? Design and implement the dimensional data model for our medical, pharmacy and eligibility data files using SAS datasets ? Create and update the .... (This job is for - ETL Jobs in NC Raleigh Developer - (in Raleigh, NC)) SSIS ETL SQL Developer (Jobs in INVER GROVE, Minnesota) Create date: 10-May-2012 [**Note : Dead Line : 05/15/2012**] [Note : Start Date : 05-14-2012 End Date : 11-16-2012] Description : -------------LOCAL CANDIDATES ONLY----------------- Title: SSIS Developer Location: St. Paul, MN Duration: 6+ month contract Position Description Responsibilit.... (This job is for - SSIS ETL Jobs in MN INVERGROVE Developer - (in INVER GROVE, MN)) ETL Data Architect Developer (Jobs in OAKLAND, California) Create date: 24-Apr-2012 [**Note : Dead Line : 04/27/2012**] [Note : Start Date : 05-01-2012 End Date : 01-25-2013 ] Description : Build and Maintain ETL processes Working closely with Data Architect, data modelers, data analysts, business analysts and BI developers to understand requirements and using the InfoSphere to.... (This job is for - ETLData Architect Jobs in CA OAKLAND Developer - (in Oakland, CA)) SAP-ABAP ETL Teradata Developer (Jobs in DUBLIN, Ohio) Create date: 10-Apr-2012 [Note: Dead line: 4-13-2012] [Note : Start Date : 04-16-2012 End Date : 07-16-2012] Description: DESCRIPTION OF WORK: Assist business users with completion of functional specifications, with a focus on completing a source to target mapping between SAP and non-SAP source systems, and SAP BW and T.... (This job is for - SAP ABAP ETL Teradata Jobs in OH DUBLIN Developer - (in Dublin, OH)) ETL PeopleSoft Developer (Jobs in CLEVELAND, Ohio) Create date: 04-Apr-2012 [Note: Start Date : 04/04/2012 End Date : 12/04/2012] Description: - 5+ years of ETL development skills and experience (DataStage required) - Strong SQL skills - Knowledge of PeopleSoft Student, Financials, Human Capital Management source data - Familiarity with BusinessObjects XI (or other BI tools).... (This job is for - ETL Jobs in OH CLEVELAND Developer - (in Cleveland, OH))    ETL job openings in SC Jobs List ETL SDLC Developer (Jobs in Spartanburg, South Carolina) Create date: 02-Feb-2011 Rate will be commensurate with a candidates experience - please include their rate information Job Responsibilities: • Work closely with users, business analysts, systems analysts, and application developers to define and resolve information requirements, data flow and data content/quality issues • Transform business requirements into environ.... (This job is for - ETLSDLC Jobs in SC Spartanburg Developer - (in Spartanburg, SC)) ETL SDLC Developer (Jobs in Spartanburg, South Carolina) Create date: 01-Feb-2011 Target Start Date: Candidates will start either 2/14 or 2/21 Interview Process: Manager will interview candidates immediately (phone interview) and will have a decision by the end of this week. The ETL developer is able to design, document, develop, test, install and support complex data extract, transformation and load (ETL) programs. This per.... (This job is for - ETL SDLC Jobs in SC Spartanburg Developer - (in Spartanburg, SC)) (Architect: ETL, ETL Large Scale Conversion, Data Management Tools, in Columbia, SC)

Featured Jobs Visio Analyst (Jobs in MC LEAN, Virginia) RDBMS UNIX Developer (Jobs in FOSTER CITY, California) Administrator (Jobs in CINCINNATI, Ohio) RDBMS Oracle UNIX Developer (Jobs in JERSEY CITY, New Jersey) Java J2EE XML SQL Developer (Jobs in WARREN, New Jersey) ECC - Consultant (Jobs in HOUSTON, Texas) Consultant (Jobs in MINNEAPOLIS, Minnesota) Quality Assurance SQL Analyst (Jobs in WILMINGTON, Delaware) JQuery Oracle Developer (Jobs in ROCKVILLE, Maryland) Developer (Jobs in MANHATTAN, New York)