Previous Job
Previous
Database / Data Warehouse Developer - Quincy, MA
Ref No.: 17-00582
Location: Quincy, Massachusetts
Job Title : Database / Data Warehouse Developer
Location : Quincy, MA
Salary : DOE (W-2)
Position Type :
6+ Month Contract

US Citizen, Green Card and GC EAD preferred.

Job Description

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 standard artifacts for documenting data warehouse designs
  • Provide query writing support and tuning expertise to analysts and end users
  • Develop shell scripts for production job automation
  • Work in a 24x7 environment which requires on-call rotation
QUALIFICATIONS
  • 3-5 years of experience in database development including analyzing, designing, documenting, coding, testing and implementing PL/SQL code
  • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data 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
  • Proficiency with Linux and shell scripting
  • Experience working with a large, multi-terabyte data warehouse
  • Experience with Perl, system administration, database administration, storage architectures, backup & recovery and networking
PREFERRED QUALIFICATIONS
  • BS in Computer Science or related degree, or equivalent experience
  • Medicaid or other healthcare or claims processing experience
  • Informatica ETL experience
  • Cognos 10.3 and/or 11 reporting experience