Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Oracle Data Architecture Sql Skills PLSQL Linux Scripting Shell Script Amazon Web S
 
Requirement id 89024
Job title Architect
Job location in Quincy, MA
Skills required Data Warehouse Schemas, Oracle, SQL Code, Data Architecture Sql Skills PLSQL Linux
Open Date 22-Feb-2019
Close Date
Job type Not specified
Duration 4 Months
Compensation DOE
Status requirement ---
Job interview type Phone Screen and Face to Face interview
   Email Recruiter: coolsoft
Job Description Architect: Data Warehouse Schemas, Oracle, SQL Code, Data Architecture Sql Skills PLSQL Linux

Note: RTR form must be signed by candidate.
Maximum number of resumes per ITS63 Vendor: 3

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 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: 89024 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),
 
 
 
 
(Architect: Data Warehouse Schemas, Oracle, SQL Code, Data Architecture Sql Skills PLSQL Linux in Quincy, MA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us