Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
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
   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)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us