PLSQL Oracle SQL Plus Linux Environment Shell Scripting AWS Cloud ETL Experience M   Requirement id 90897 Job title Architect Job location in Quincy, MA Skills required ETL Scripts, Database Architecture, SQL Code, PLSQL Oracle SQL Plus Linux Environment Open Date 05-Apr-2019 Close Date Job type Not specified Duration 2 Months Compensation DOE Status requirement --- Job interview type Phone Screen and Face to Face interview    Email Recruiter: coolsoft Job Description Architect: ETL Scripts, Database Architecture, SQL Code, PLSQL Oracle SQL Plus Linux Environment Note: RTR form must be submitted. Note: Maximum number of resumes per ITS63 Vendor: 2 Submission Deadline: 4/12/2019 Start Date: 4/22/2019 End Date: 6/30/2019 Client: EOHHS Description: The Commonwealth of Massachusetts is currently seeking exceptional individuals to join the Data Warehouse team. This is an exciting opportunity to join a highly skilled team and contribute to a critical and highly visible project within the Executive Office of Health and Human Services. We are seeking self-starters who are highly motivated, efficient, professional, communicative and able to contribute to the team on day one. The Data Warehouse Architect is responsible for analysis, design, coding, and testing of moderate to extremely complex data extraction routines and report development. The Architect will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a business analyst. The Architect will also support existing table structures and provide input on best practices and potential efficiencies. The Architect will work on multiple assignments concurrently and be required to complete work by aggressive due dates. The Architect 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. SPECIFIC DUTIES • Creates data models and designs to meet specific business needs • Ability to determine 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 • Is able to 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 Erwin ERD modeling • Proficiency with Linux and shell scripting • Experience working with a large, multi-terabyte data warehouse PREFERRED QUALIFICATIONS • 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: 90897 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 Scripts job openings in Quincy, MA Jobs List ITS63 EHS FY21 Senior Apps Developer 004-OPS-DW-Bfsd -SP Create date: 01-Oct-2020 Note: Email Submission Note: RTR form must be submitted. Submission Deadline: 10/8/2020 Start Date: 10/19/2020 End Date: 6/30/2021 Client: EHS Description: SUMMARY (Job Overview): The Senior Developer will support existing warehouse infrastructure and provide input on best practi.... (This job is for - ERwin Jobs in MA Quincy Developer - (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)) ITS63 EHS FY20 Data Warehouse Developer 001-100H -SP Create date: 15-Nov-2019 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: <.... (This job is for - job Jobs in MA Quincy Developer - (in Quincy, MA)) ITS63 EHS FY20 Senior ETL Developer 002 -SP Create date: 08-Aug-2019 Note: Email Submission Note: RTR form must be submitted. Note: Maximum number of resumes per ITS63 Vendors: 2 Note: person must be local Submission Deadline: 8/16/2019 Start Date: 8/26/2019 End Date: 8/25/2020 Client: EOHHS Description: Duties: · Collaborate with all de.... (This job is for - job Jobs in MA Quincy Developer - (in Quincy, MA))    ETL Scripts job openings in other states Jobs List ETL Developer - 3573 Create date: 27-Mar-2020 Note * Please be advised responses are due no later than 3/28/20. Responsibilities: Are you a tech & IT geek? We have an 18-month project with our client in Albany, NY that requires an ETL Developer, Expert Day-to-Day Tasks include, but not limited to: Develop ETL Scripts using .... (This job is for - Obiee Jobs in NY Albany Developer - (in Albany, NY)) Data Quality Support Analyst (ETL)_61512 Create date: 24-Mar-2020 Note : Need to have a minimum of 8 years of experience Candidate must be our W2 Employee Description: Candidate Responsibilities As a Data Quality Support Analyst, you will contribute to support of current critical data and assist with the validation of data for the digital platform. Maintain existing.... (This job is for - Python Jobs in IL Peoria Analyst - (in Peoria, IL)) ETL Developer - 3573 Create date: 16-Mar-2020 Note: * Please be advised responses are due no later than 3/28/20. Responsibilities Are you a tech & IT geek? We have an 18-month project with our client in Albany, NY that requires an ETL Developer, Expert Day-to-Day Tasks include, but not limited to: Develop ETL Scripts using PL/SQL and O.... (This job is for - job Jobs in NY Albany Developer - (in Albany, NY)) Senior ETL Developer - 3572 Create date: 16-Mar-2020 Note: * Please be advised responses are due no later than 3/25/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have an 18-month project with our client in Albany, NY that requires a Senior ETL Developer Day-to-Day Tasks include, but not limited to: ODI Jobs in NY Albany Developer - (in Albany, NY)) ETL Technical Architect - NTTJP00022839 Create date: 28-Jun-2019 start date:08/15/2019 End date:08/14/2021 submission deadline:8/9/2019 Description: we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our abi.... (This job is for - Obiee Jobs in NY NewyorkCity Architect - (in Newyork City, NY))     (Architect: ETL Scripts, Database Architecture, SQL Code, PLSQL Oracle SQL Plus Linux Environment 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)