Previous Job
Oracle SQL Developer
Ref No.: 18-18300
Location: Quincy, Massachusetts
Job Title: Oracle SQL Developer (ITS63_APPDEV_EHS_FY 19 - 003)
Location: Quincy, MA  02171
Duration: 11+ Months Contract 

Job Description:
·         We are seeking self-starters who are highly motivated, efficient, professional, communicative and able to contribute to the team on day one.
·         Data Warehouse developers perform analysis, design, code and testing of moderate to extremely complex data extraction routines and report development.
·         Supports the Medicaid data warehouse systems, works on multiple assignments concurrently, and completes work in queue by aggressive due dates.
·         Uses a range of expert technical skills based on a keen knowledge of data warehouse and must be highly proficient with Oracle SQL.
·         Helps identify and implement continuous improvement opportunities.
·         Regularly peer reviews the work of frequently mentors others.
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 standards
·         Provide query writing support and testing expertise to analysts and end users
·         Develop shell scripts for production job automation
·         Work in a 24/7 environment which requires on-call rotation
·         3-5years of experience in database development including analyzing, designing, documenting, coding, testing and implementing primarily SQL Code.
·         Thorough knowledge of Data Warehouse Principles and techniques, specifically dimensional data
·         Exceptional Oracle SQL skills and PL/SQL skills
·         Hands-on Experience with set based operations, analytic functions and query-based hints
·         Command of Data Warehouse modelling concepts is required.