Job Description :
Role : Application Architect Data warehouse
Location : Quincy, MA

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


Client : State Client

             

Similar Jobs you may be interested in ..