Database / Data Warehouse Developer - Quincy, MA - Georgia IT Inc.
Quincy, MA
About the Job
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
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
- 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
- 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
Source : Georgia IT Inc.
