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 ETL Developer - 7328-1 Create date: 04-May-2017 Start date : 06/01/2017 Deadline : 05/11/2017 Client : Department of Employment and Workforce Description : SCOPE OF THE PROJECT: PERFORM DATA CONVERSION AND INTERFACE DEVELOPMENT FOR LARGE ENTERPRISE PROJECT. DAILY DUTIES / RESPONSIBILITIES: RESPONSIBLE FOR THE ANALYSIS, DESIGN, DEVELOPMEN.... (This job is for - ETL Jobs in SC COLUMBIA Developer - (in Columbia, SC)) BI ETL Specialist / System Software Programmer - 5332-1 Create date: 22-Dec-2013 [Note : Deadline 26th Dec 2013, Skype video interviews] Job Description: Daily Duties / Responsibilities: Candidate will be responsible for creating, designing and developing the process to extract and transform data from OLTP data source and load aggregated data into OLAP environment. The ETL process should utilize the M.... (This job is for - ETL SSAS SSIS Jobs in SC Columbia Specialist - (in Columbia, SC)) 4119-1-SAP Technical Team Ld Consultant 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)) 4118-1-SAP Functional Team Ld Consultant 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 Data Warehouse Developer III -129720 Create date: 24-Apr-2024 No of Submissions : 2 Start date : 06/03/2024 End Date : 06/30/2024 Submission deadline : 5/1/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. * Duration: 6/30/2024, likely to extend. * Onsite or Remote? No.... (This job is for - ETL Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III - 128748 Create date: 28-Mar-2024 Start date : 05/20/2024 End date : 06/30/2024 Submission deadline : 4/4/2024 at 4:00PM CST. Client info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. * Duration: 6/30/2024, likely to extend. * Onsite or Remote? No WI residency required. Open to n.... (This job is for - ETL CDC Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Architect 3 - 128536 Create date: 27-Mar-2024 Start date : 04/22/2024 End Date : 09/30/2024 Submission deadline : 4/1/2024 at 10am EST. Client Info : DHHS Note : * Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discouraged. A screensho.... (This job is for - ETL Jobs in MI Lansing Architect - (in Lansing, MI)) Data Warehouse Developer III -128359 Create date: 18-Mar-2024 Start date : 04/08/2024 End Date : 06/30/2024 Submission deadline : 3/20/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. * Duration: 6/30/2024, likely to extend. * Onsite or Remote? Candidates MUST be WI residents or willing to r.... (This job is for - ETL Alteryx Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III - 128031 Create date: 07-Mar-2024 Start date : 04/22/2024 End date : 06/30/2024 Submission deadline : 3/14/2024 at 4:00PM CST. Client info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. * Duration: 6/30/2024, likely to extend. * Onsite or Remote? Candidates MUST be WI residents or .... (This job is for - ETL CDC Jobs in WI Madison Developer - (in Madison, WI))    ETL job openings in SC Jobs List Datastage Developer - 70626 Create date: 06-Jan-2021 Job Description: We have an urgent need for a DataStage ETL Senior Developer. This persons task is to extract relational data base data from a mainframe, transforming the data to flat files, in some cases encrypting and/or compressing the data and loading that data onto DataStage (Infosphere) server. From there t.... (This job is for - ETL Datastage Jobs in SC Greenville Developer - (in Greenville, SC)) ETL / Datastage - 69035 Create date: 02-Nov-2020 Candidate must be our W2 Employee. Job Description : High Level DataStage experience - DataStage is an ETL (Extract/Transform/Load) tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. Must be great at coding and analysis resource Retail Data base experience is a plus. .... (This job is for - ETL Analysis Coding Jobs in SC Greenville Consultant - (in Greenville, SC)) DataStage ETL Sr. Developer - 66354 Create date: 01-Sep-2020 Candidate must be our W2 Employee. Job Description : U Urgent need for a DataStage ETL Senior Developer. This persons task is to extract relational data base data from a mainframe, transforming the data to flat files, in some cases encrypting and/or compressing the data and loading that data onto DataStage (Infosphere) server..... (This job is for - ETL InfoSphere Analysis Jobs in SC Greenville Developer - (in Greenville, SC)) DataStage ETL Sr. Developer - 61487 Create date: 24-Mar-2020 Note: * Candidate must be your W2 Employee. * We should take signed RTR form from the candidate (Candidate RTR form should be only on the name of Apex Systems) Job Description : Location: Greenville, SC (first 2 months 100% remote) Retail Business Services has an urgent need for a DataSta.... (This job is for - Datastage ETL InfoSphere Jobs in SC Greenville Developer - (in Greenville, SC)) ETL/Datawarehouse Developer - 38092 Create date: 30-Aug-2018 Candidate must be our W2 Employee Job Description : Minimum Qualifications: · Proven or Extensive Experience/Background with the following systems/technologies. - Teradata - ETL/SAS - SQL ETL - Korn Shell scripting .... (This job is for - Teradata ETL Jobs in SC FortMill Developer - (in Fort Mill, SC)) (Architect: ETL, ETL Large Scale Conversion, Data Management Tools, in Columbia, SC)

Featured Jobs SDLC Developer (Jobs in Denver, Colorado) Help Desk Detail Engineer (Jobs in Columbus, Ohio) Groovy CI/CD Critical Developer (Jobs in Des Moines, Iowa) Oral Manager (Jobs in Raleigh, North Carolina) Auditing Testing Written Analyst (Jobs in Madison, Wisconsin) Supervision Consultant (Jobs in Nashville, Tennessee) TOGAF REST Architect (Jobs in Denver, Colorado) Hipaa Communication Architect (Jobs in Chesterfield, Virginia) Help Consultant (Jobs in Madison, Wisconsin) Kanban WIP Problem Consultant (Jobs in Cincinnati, Ohio)