Oracle SQL Plus PLSQL Data Modeling Linux OS And Shell Scripting Medicaid Healthca   Requirement id 102558 Job title Architect Job location in Quincy, MA Skills required Data Warehouse Architecture, ETL Architecture, SQL Code, Oracle SQL Plus PLSQL Data Modeling Linu Open Date 27-Jan-2020 Close Date Job type Not specified Duration 6 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Architect: Data Warehouse Architecture, ETL Architecture, SQL Code, Oracle SQL Plus PLSQL Data Modeling Linu Note: Email Submission Note: Interview requirements: _MUST BE IN PERSON and person must be local Note: This positon May be filled PRIOR TO CLOSE DATE Note: Maximum number of resumes per ITS63 Vendors: __2 Note: Resumes must be emailed to: EOHHS ITContractorResumes@state.ma.us Submission Deadline: 1/30/2020 Start Date: 2/10/2020 End Date: 8/9/2020 Client: EOHHS Description: Rate Card Title: Data Warehouse Architect/Developer As a member of the Executive Office of Health and Human Services, (EOHHS), data warehouse, (DW), team, The Data Warehouse Architect, DWA, will be responsible for analysis, design, coding, and testing of moderate to extremely complex data extraction routines and report development. The DWA will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a Business Analyst. The DWA will also support existing warehouse infrastructure and provide input on best practices and potential efficiencies. The DWA will work on multiple assignments concurrently and be required to complete work by aggressive due dates. This DWA / Developer role may work in both the Architect capacity as well as an ETL Developer capacity. This role uses a range of expert technical skills based on a keen knowledge of data warehouse concepts and must be highly proficient with Oracle SQL. The Architect will help identify and implement continuous improvement opportunities. The Architect is responsible for regular peer code reviews and frequently mentors others. The ideal candidate must demonstrate that they have relevant experience, creativity, a keen problem-solving ability along with collaboration and facilitation skills to work with a broad range of people while keeping projects on track. DUTIES: • Creates data models and designs to meet specific business needs • Determines appropriate sourcing and storage of data from multiple source systems • Understands and is able to translate business requirements into Data Warehouse solutions • Codes Oracle ETL scripts that will extract data from an operational database 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 ADDITIONAL EXPERIENCE which 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: 102558 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),    Data Warehouse Architecture job openings in other states Jobs List ELECT - Data Warehouse-BI Developer 3 - REMOTE (700810) Create date: 25-Jan-2023 start date : 01/03/2023 End date : 12/29/2023 submission deadline : 1/30/2023 client info : ELECT Note : * REMOTE * Web Cam Interview Only Description : Responsible for designing, developing, and maintaining data .... (This job is for - Testing Jobs in VA Richmond Developer - (in Richmond, VA)) Senior Data Warehouse Architect - 4158 Create date: 18-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/30/20. Responsibilities TVT is a NYS HBITS Prime Vendor! Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Menands.... (This job is for - Communication Jobs in NY Menands Architect - (in Menands, NY)) Senior Data Warehouse Architect - 4156 Create date: 18-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/30/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Menands, NY that requires a Senior Data .... (This job is for - ETL Jobs in NY Menands Architect - (in Menands, NY)) Data Warehouse Architect - 4145 Create date: 17-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/28/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 30-month project with our client in New York, NY that requires a Data Wareho.... (This job is for - Python Jobs in NY NewYork Architect - (in New York, NY)) Architect - 53570 Create date: 20-Jun-2018 Description: Data Warehouse Architect The Data Warehouse Architect is responsible for the architectural design, development and maintenance of complex, enterprise-wide data warehousing systems. Provides leadership and direction including long and short-range planning of data warehouse architecture, ETL processes, and data mode.... (This job is for - Architect Jobs in GA Atlanta Architect - (in Atlanta, GA))     (Architect: Data Warehouse Architecture, ETL Architecture, SQL Code, Oracle SQL Plus PLSQL Data Modeling Linu in Quincy, MA)

Featured Jobs QoS Analyst (Jobs in Dauphin County, Pennsylvania) Team Work Written Consultant (Jobs in Nashville, Tennessee) ASP.Net&C# Typescript MS SQL Server Specialist (Jobs in Raleigh, North Caro Project Manager Interpersonal Expert (Jobs in Raleigh, North Carolina) ASP.Net Typescript Web Specialist (Jobs in Raleigh, North Carolina) Tableau Consultant (Jobs in Dauphin County, Pennsylvania) Middleware C++ Expert (Jobs in Raleigh, North Carolina) BRD RTM SCRUM Analyst (Jobs in Richmond, Virginia) Documentation TechLead (Jobs in Madison, Wisconsin) ITSM Interpersonal Consultant (Jobs in Madison, Wisconsin)