*No H1B *
*Location:*:: *MA-Massachusetts/Commonwealth Of Ma Duration::: 6+ months * *Job Description::* -Candidate Must have Healthcare Claims or Medicaid exp. -Must have Informatica, and Must have Cognos. *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 • The Client 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. • The Data Warehouse Developer will be working primarily on the MassHealth data warehouse Accountable Care Organization data mart and reporting team. • The MassHealth data warehouse stores claims, provider, member, eligibility, enrollment and other data from various sources. • The developer must possess extensive knowledge of Oracle SQL, PL/SQL, data warehouse architecture and methodologies, business intelligence (BI) tools, and health care and government data and processes. • The developer will be responsible for implementing code based solutions as determined by the team’s project manager and business analysts. • The developer is responsible for unit testing their code, checking in code on a daily basis and maintaining their code as needed. • The developer will work with a team of programmers who share key concepts and knowledge in order to create a unique and exciting work environment. • The developer will work closely with the project team and business in order to determine best practices and solutions for current data quality issues and to plan for future strategic goals implementation. • The developer will be responsible for providing documentation as needed, based on EOHHS standards. • The developer will be required to work with standard tools including JIRA. *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 sql/pl 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 *Regards, Rashmi Singh(Technical Resource Specialist)Ramy Infotech IncPhone: 408-317-9256 Ext-334 Fax : 408-273-6834Email: rashmi.si...@ramyinfotech.com <rashmi.si...@ramyinfotech.com>Note: We are working with prime vendor (One Layer between) for this position. * -- You received this message because you are subscribed to the Google Groups "Oracle Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to oradev+unsubscr...@googlegroups.com. To post to this group, send email to oradev@googlegroups.com. Visit this group at https://groups.google.com/group/oradev. For more options, visit https://groups.google.com/d/optout.
