Sql Skills PLSQL Linux OS Analytical Skills Shell Scripting Data Warehouse AWS Clo   Requirement id 100353 Job title Developer Job location in Quincy, MA Skills required ETL Solutions, ETL Scripts, Database Architecture, Sql Skills PLSQL Linux OS Analytical Ski Open Date 15-Nov-2019 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 Developer: ETL Solutions, ETL Scripts, Database Architecture, Sql Skills PLSQL Linux OS Analytical Ski 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: 11/25/2019 Start Date: 12/5/2019 End Date: 5/4/2020 Client: Executive Office of Health and Human Services (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: 100353 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), ETL Solutions job openings in Quincy, MA Jobs List ITS63 EHS FY20 Data Warehouse Developer 001-100H-Re-Post -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: As a member of the Executive Office o.... (This job is for - job Jobs in MA Quincy Developer - (in Quincy, MA))         (Developer: ETL Solutions, ETL Scripts, Database Architecture, Sql Skills PLSQL Linux OS Analytical Ski 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)