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 Chesterfield County Data Warehouse Architect 4 (743061) Create date: 24-Jul-2024 Hybrid No of Submissions : 3 start date :08/05/2024 End date :07/31/2025 submission deadline : 7/29/2024 client info : Chesterfield County Note: * Agency Interview Type: Both Web Cam and In Person Interview Descript.... (This job is for - job Jobs in VA Chesterfield Architect - (in Chesterfield, VA)) 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: Data Warehouse Architecture, ETL Architecture, SQL Code, Oracle SQL Plus PLSQL Data Modeling Linu in Quincy, MA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)