Database Development Testing Skills SQL Code Sql Skills PLSQL Medicaid AWS Cloud E   Requirement id 88655 Job title Developer Job location in Quincy, MA Skills required Data Warehouse Solutions, Operational Data Stores, Shell Script, Database Development Testing Skills SQL Open Date 14-Feb-2019 Close Date Job type Not specified Duration 4 Months Compensation DOE Status requirement --- Job interview type Face to Face interview Apply    Email Recruiter: coolsoft Job Description Developer: Data Warehouse Solutions, Operational Data Stores, Shell Script, Database Development Testing Skills SQL Note: Maximum number of resumes per ITS63 Vendors: 3 Note: RTR Form must be signed from candidate. Submission Deadline: 2/21/2019 Start Date: 3/4/2019 End Date: 6/30/2019 Client: EOHHS Description: The Executive Office of Health and Human Services MassHealth Data Warehouse (DW) is actively seeking energetic, creative, data interested, team member to join a new Data Quality team. The team will be responsible for over all data quality as well as quality control of reports and extracts produced by the data warehouse. The Data Quality Developer (DQD) will perform analysis, design, coding and testing of moderate to extremely complex data extraction routines and report development. The DQD will support the Medicaid data warehouse, work on multiple assignments concurrently and complete work by aggressive due dates. The DQD will use a range of expert technical skills based on a keen knowledge of data warehouse principles and must be highly proficient with Oracle SQL. The DQD will help identify and implement continuous data improvements. The DQD will regularly contribute to peer reviews and will mentor others as needed. SPECIFIC DUTIES: • Understand and translate business requirements into Data Warehouse solutions, • Create data models and designs to meet specific business needs that require sourcing data from multiple source systems,. • Code Oracle ETL scripts that will extract data from an operational database and populate the staging and target data warehouse schemas, • Document code and processes for distribution to all interested parties • Document design using industry standards, • Provide query writing support and tuning expertise to analyst and end users, • Develop shell scripts for production job automation • Work in 24x7 environment which requires on-call rotation QUALIFICATIONS: • 3-5 years experience in database development, including analyzing, designing, documenting, coding, testing and implementing primarily SQL code • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data • 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 PREFERRED QUALIFICATIONS • BS in Computer science • Medicaid or other health or claims processing experience • AWS (Cloud) Experience • Exadata Expertise • Informatica ETL: experience • Cognos 10.3/Analystics reporting experience   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 88655 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 Solutions job openings in other states Jobs List RFO0191 SWIFT 9.2 Upgrade PeopleSoft DOT Lead-SP Create date: 06-Mar-2017 Submission Deadline : 3/23/2017, 1:00 PM CDT Client : Departments of Administration and Management & Budget(DOAMB) Description : The Office of Minnesota IT Services (MN.IT) @ the Departments of Administration and Management & Budget are planning to upgrade the current PeopleSoft Enterprise Financial Management Solu.... (This job is for - job Jobs in MN StPaul Architect - (in St Paul, MN))     (Developer: Data Warehouse Solutions, Operational Data Stores, Shell Script, Database Development Testing Skills SQL in Quincy, MA)

Featured Jobs ASP.Net Government Developer (Jobs in Madison, Wisconsin) Manual Consultant (Jobs in Columbus, Ohio) IT Specialist (Jobs in Columbus, Ohio) Batch CMDB Management System Administrator (Jobs in Glen Allen, Virginia) - Architect (Jobs in Richmond, Virginia) - Analyst (Jobs in Denver, Colorado) PMP Manager (Jobs in Atlanta, Georgia) Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Javascript Developer (Jobs in Tucker, Georgia)