Database Architecture PLSQL Linux Shell Scripting Data Warehouse AWS Cloud Informa   Requirement id 102784 Job title Developer Job location in Quincy, MA Skills required Healthcare Experience, ETL Solutions, ETL Scripts, Database Architecture PLSQL Linux Shell Open Date 29-Jan-2020 Close Date Job type Not specified Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Healthcare Experience, ETL Solutions, ETL Scripts, Database Architecture PLSQL Linux Shell Note: RTR form must be submitted. Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 2/10/2020 Start Date: 2/20/2020 End Date: 8/19/2020 Client: EOHHS Description: As a member of the Executive Office of Health and Human Services, (EOHHS), data warehouse, (DW), team, The Data Warehouse Developer, will be responsible for analysis, design, coding, and testing of moderate to extremely complex data warehouse development. The DWD will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a Business Analyst. The role will also support existing warehouse infrastructure and provide input on best practices and potential efficiencies. The DWD will be expected to work on multiple assignments concurrently and be required to complete work by aggressive due dates. The role uses a range of their expert technical skills based on keen knowledge of data warehouse concepts and must be highly proficient with Oracle SQL. The DWD is expected to participate in all meetings they are invited to as part of the project management office and create and deliver deliverables and/or review materials as expected. DUTIES: • Design and Develop ETL solutions in an Oracle Exadata environment based on specifications • Determine appropriate sourcing and storage of data from multiple source systems • Codes Oracle ETL scripts that will extract data from an operational database as well as other external data sources and populate the staging and target data warehouse schemas • Documents code and processes for distribution to all interested parties • Documents design using industry standards including ERWIN diagramming • Provides query writing support and tuning expertise to analysts and end users • Develops shell scripts for production job automation • Work in a 24x7 environment which requires on-call rotation QUALIFICATIONS: • 5+ years of experience in database architecture and development including analyzing, designing, documenting, coding, testing and implementing primarily SQL code • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data architecture modeling • Exceptional Oracle SQL skills and PL/SQL skills • Hands on experience with set based operations, analytic functions and query hints • Command of data warehouse modeling concepts is required • Strong problem solving and analytical skills • Strong ERD modeling • Proficiency with Linux and shell scripting • Experience working with a large, multi-terabyte data warehouse • The ideal candidate must demonstrate that they have relevant experience, creativity, a keen problem-solving ability. • Excellent interpersonal skills for collaboration and facilitation work with a broad range of people while keeping projects on track. EXPERIENCE that will distinguish candidates: • BS in Computer Science or related degree, or equivalent experience • Medicaid or other healthcare or claims processing experience • AWS (Cloud) Experience • Informatica ETL experience   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 102784 while calling.   Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1), Healthcare Experience job openings in Quincy, MA Jobs List ITS63 EHS FY21 Business Analyst 002-OPS-DWbfng -SP Create date: 01-Oct-2020 Note: Email Submission Note: RTR form must be submitted Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 10/8/2020 Start Date: 10/19/2020 End Date: 6/30/2021 Client: EHS Description: The Business Analyst, will be responsible for working with internal and extern.... (This job is for - job Jobs in MA Quincy Analyst - (in Quincy, MA)) ITS63 FY20 EHS Business Analyst 006- Bfjm -MMIS -SP Create date: 26-Feb-2020 Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 3/5/2020 Start Date: 3/16/2020 End Date: 9/15/2020 Client: EOHHS Description: This position is a Business Analyst on the Member/Managed Care team at MassHealth. .... (This job is for - Medicaid Medicare Jobs in MA Quincy Analyst - (in Quincy, MA)) ITS63 FY20 EHS Business Analyst 004-HIX -SP Create date: 20-Feb-2020 Note: Email Submission Note: RTR form must be submitted Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 2/27/2020 Start Date: 3/9/2020 End Date: 9/8/2020 Client: EOHHS Description: EOHHS is seeking an exceptional “Business.... (This job is for - job Jobs in MA Quincy Analyst - (in Quincy, MA)) ITS63 EHS FY20 Senior Project Manager 015-MMIS -SP Create date: 29-Jan-2020 Note: RTR form must be submitted Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 2/10/2020 Start Date: 2/20/2020 End Date: 8/19/2020 Client: EOHHS Description: The ideal candidate must possess strong.... (This job is for - SDLC Jobs in MA Quincy Manager - (in Quincy, MA)) ITS63 EHS Data Warehouse Architect/Dev 004-DW-REPOST-2 -SP Create date: 29-Jan-2020 Note: RTR form must be submitted Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 2/7/2020 Start Date: 2/17/2020 End Date: 8/16/2020 Client: Executive Office of Health and Human Services (EOHHS) Description: job Jobs in MA Quincy Architect - (in Quincy, MA))    Healthcare Experience job openings in other states Jobs List Social Worker 2 - 62355 Create date: 14-Mar-2024 start date : 03/11/2024 End date :06/30/2024 submission deadline :03/22/2024 client info : TN DOH Note: * Position Location: Hybrid Description : The Clinical Care Team will take referrals from primary care providers and.... (This job is for - Jobs in TN Knoxville Consultant - (in Knoxville, TN)) Social Worker 2 -62365 Create date: 14-Mar-2024 start date : 03/11/2024 End date :06/30/2024 submission deadline :03/22/2024 client info : TN DOH Note: * Position Location: Hybrid Description : Social Worker Supervisor · Team Lead: Funct.... (This job is for - Jobs in TN Jackson Consultant - (in Jackson, TN)) Social Worker 2 - 62366 Create date: 14-Mar-2024 start date : 03/11/2024 End date :06/30/2024 submission deadline : 03/22/2024 client info : TN DOH Note: * Position Location: Hybrid Description : The Clinical Care Team will take referrals from primary care providers and.... (This job is for - Jobs in TN Jackson Consultant - (in Jackson, TN)) Social Worker 2 - 62368 Create date: 14-Mar-2024 start date : 03/11/2024 End date :06/30/2024 submission deadline :03/22/2024 client info : TN DOH Note: * Position Location: Hybrid Description : The Clinical Care Team will take referrals from primary care providers and .... (This job is for - Jobs in TN Elizabethton Consultant - (in Elizabethton, TN)) Social Worker 2 -62367 Create date: 14-Mar-2024 start date : 03/11/2024 End date :06/30/2024 submission deadline :03/22/2024 client info : TN DOH Note: * Position Location: Hybrid Description : The Clinical Care Team will take referrals from primary care providers and .... (This job is for - Jobs in TN Greeneville Consultant - (in Greeneville, TN))    Healthcare Experience job openings in MA Jobs List ITS63 EHS FY20 Data Analyst 003 -DSRIP -SP Create date: 05-Mar-2020 Note: Email Submission Note: RTR form must be submitted Note: Total number of positions sought: 1 Note: Maximum number of resumes per ITS63 Vendor: 3 Submission Deadline: 3/12/2020 Start Date: 3/23/2020 End Date: 9/22/2020 Client: EOHHS Description: Under the general directi.... (This job is for - job Jobs in MA Boston Analyst - (in Boston, MA)) ITS63 FY20 EHS Business Analyst 005-HIX -Op Specialist -SP Create date: 21-Feb-2020 Note: RTR form must be submitted. Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 3/5/2020 Start Date: 3/16/2020 End Date: 9/15/2020 Client: EOHHS Description: The Massachusetts Health Insurance Exch.... (This job is for - Implementation Jobs in MA Boston Analyst - (in Boston, MA)) Healthcare Business Analyst Create date: 22-Jun-2015 NOTE : START DATE : 07/02/2015 SUBMISSION DEADLINE : 06/26/2015 CLIENT INFO : Winter Wyman Companies DESCRIPTION : -Location- Worcester -Rate- 60 (flex) -Duration- 6-12 mo -Must be able to interview in person -Must currently be on your payroll -Must have excellent commu.... (This job is for - ICD 10 ICD9 Jobs in MA Worcester Analyst - (in Worcester, MA)) (Developer: Healthcare Experience, ETL Solutions, ETL Scripts, Database Architecture PLSQL Linux Shell in Quincy, MA)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)