Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
PLSQL ERwin Linux Scripting Shell Script Developer
(Jobs in Quincy, MA)
 
Requirement id 73534
Job title Developer
Job location in Quincy, MA
Skills required Data Warehouse, SQL, Oracle SQL, PLSQL ERwin Linux Scripting Shell Script
Open Date 19-Sep-2018
Close Date
Job type Not specified
Duration 9 Months
Compensation DOE
Status requirement ---
Job interview type Face to Face interview
Apply
   Email Recruiter: coolsoft
Job Description Developer: Data Warehouse, SQL, Oracle SQL, PLSQL ERwin Linux Scripting Shell Script

Bid Number: ITS63_AppArch_FY19_EHS-002- DW

Note: May be filled PRIOR TO CLOSE DATE: _x_Yes
Note: Maximum number of resumes per ITS63 Vendors: 2

Submission Deadline: 9/24/2018
Start Date: 10/4/2018
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/Developer (AD) is responsible for analysis, design, coding, and testing of moderate to extremely complex data extraction routines and report development. The AD will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a business analyst. The AD will also support existing table structures and provide input on best practices and potential efficiencies. The AD will work on multiple assignments concurrently and be required to complete work by aggressive due dates.

The AD 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 AD will help identify and implement continuous improvement opportunities. The AD is responsible for regular peer code reviews and frequently mentors others.

Specific responsibilities include:

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 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: 73534 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 job openings in Quincy, MA
Jobs List

ITS63 EHS FY19 DW DQTL Project Manager 006 Re-Post -SP
Create date: 05-Apr-2019
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: 10/21/2019

Client: EOHHS

Description:

The Executive Office of Health and Human Services MassHealth Data Warehouse (DW) is actively seeking ene.... (This job is for - job Jobs in MA Quincy Manager - (in Quincy, MA))

ITS63 FY19 EHS DW EA Applications Developer 007 -SP
Create date: 22-Feb-2019
Note: RTR form must be signed by candidate.
Maximum number of resumes per ITS63 Vendor: 2

Submission Deadline: 3/1/2019
Start Date: 3/11/2019
End Date: 6/30/2019

Client: EOHHS

Description:

The Commonwealth of Massachusetts is currently seeking exceptional individuals to join the Business In.... (This job is for - Business Intelligence Jobs in MA Quincy Developer - (in Quincy, MA))

ITS63 Oracle SQL Developer - SP
Create date: 25-Jul-2018
Note: Please refer the attachment to get all skills for this position

Note: ITS63_APPDEV_EHS_FY 19 - 003 – DW – bf/dp

Submission Deadline: 7/30/2018
Start Date: 8/10/2018
End Date: 6/30/2019

Client: EOHHS

Description:

General Requirements:

CORI requirements: _x_After can.... (This job is for - job Jobs in MA Quincy Developer - (in Quincy, MA))

ITS63 Data Warehouse Developer (Cognos) -SP
Create date: 25-Jul-2018
Note: Please refer the attachments for all Skills

Bid Number : ITS63_Data Warehouse Developer_FY19-EHS-001- bfsm

Submission Deadline: 7/30/2018
Start Date: 8/10/2018
End Date: 6/30/2019

Client: EOHHS

Description:

The Executive Office of Health and Human Services is seeking a Cognos d.... (This job is for - job Jobs in MA Quincy Developer - (in Quincy, MA))

ITS63 - Data Warehouse Architect
Create date: 18-Aug-2016
Start Date :09/08/2016
End Date :06/30/2016
Submission Deadline :09/02/2016
Description :

SUMMARY:
The Data Warehouse Strategic Scientist (DWSS) will be instrumental in the Commonwealth of Massachusetts rollout of the nationwide initiative of payment reform via Accountable Care Organization.... (This job is for - job Jobs in MA Quincy Architect - (in Quincy, MA))
 
 Data Warehouse job openings in other states
Jobs List

Data Warehouse Developer III - 159207 - Rebid
Create date: 26-May-2026
Start date :7/1/2026
End Date :06/30/2027

Submission deadline :5/28/2026 4:00 PM CST.

Client Info : DOC

Note:

* Interview Process: MS Teams Interviews, with video on.

* WI residency is required.

Description:

This position will perform data analysis, design, deve.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI))

Certified Project Manager IV/Sr. - 158880
Create date: 18-May-2026
Start date :7/13/2026
End Date :06/30/2027

Submission deadline :5/26/2026 at 4:00 PM CST.

Client Info : ETF

Note:

* Interview Process: remote via MS Teams with camera on (may have two rounds of interviews) PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidate.... (This job is for - job Jobs in WI Madison Manager - (in Madison, WI))

Application Data Developer Expert - 65567
Create date: 14-Apr-2026
Start date :5/4/2026
End Date :05/31/2027

Submission deadline :04/20/2026

Client Info : NeDHHS

Note:

* Position Location: Remote

Description:

Senior Cognos Report Developer

Job Summary:

We are seeking a Senior Cognos Report Developer with AWS experience .... (This job is for - AWS Jobs in NE Lincoln Developer - (in Lincoln, NE))

Cloud Data Engineer - 65530
Create date: 30-Mar-2026
Start date : 04/27/2026

End Date : 10/30/2027

Submission deadline : 04/08/2026

Client Info : NeDHHS

Note:

* Position Location : Remote

Description :

The Client is seeking a skilled Cloud Data Engineer to join the Data Office Team in driving the modernization of enterp.... (This job is for - job Jobs in NE Lincoln Engineer - (in Lincoln, NE))

Certified Project Manager III - 155331
Create date: 12-Feb-2026
Start date : 03/23/2026

End Date : 06/30/2026

Submission deadline : 2/19/2026 4:00:00 PM

Client Info : DCF

Note:

* INTERVIEW NOTES:

PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidates bid upon confirming the interview. Please see "Clients .... (This job is for - Jobs in WI Madison Manager - (in Madison, WI))
 
 Data Warehouse job openings in MA
Jobs List

Architect Onsite DGF Sales Force
Create date: 10-Nov-2014
Job Description:

Good understanding of data warehouse concepts and design patterns
Strong experience with Core Java or experience with HDFS, Map-reduce and other tools in Hadoop ecosystem
Strong knowledge and hands-on experience with Map-reduce programming model and high level languages like Pig or Hive
Experience with N.... (This job is for - Core Java Pig Jobs in MA Boston Architect - (in Boston, MA))

Data Warehouse P/ M - ITS43 Data Warehouse Project Manager
Create date: 22-May-2013
Description:

Client is requesting to fill one temporary position (Data Warehouse Project Manager) Please see the below-written job description utilizing the department.

Required Skills:

* Solid knowledge on project management, budgeting, customer management and risk/issue management
* Previous experience in man.... (This job is for - job Jobs in MA Boston Manager - (in Boston, MA))
(Developer: Data Warehouse, SQL, Oracle SQL, PLSQL ERwin Linux Scripting Shell Script in Quincy, MA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us