*Hi All,* *Hope you are doing great !!!*
*Please send the resume to : bob.sm...@panzersolutions.com* * * *Job Title: ETL (Informatica) Developer* *Location: 100 Hancock Street, Quincy MA **(No H1b “**CANDIDATES MUST BE ABLE TO DO AN ONSITE INTERVIEW AFTER A PHONE” !!)*** *Duration: Through 6/30/14 plus extensions* *Position Summary:* The Commonwealth of Massachusetts 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. 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 performs 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 including SQL, data warehouse concepts, ETL, and OLAP reporting. Helps identify and implement continuous improvement opportunities. Regularly peer reviews the work of others and frequently mentors others. Specific responsibilities include: *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 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. Previous experience with ETL tools, preferable Informatica Develop shell scripts for production job automation. Work in a 24x7 environment which requires on-call rotation. *QUALIFICATIONS* 7-8 years of experience in database development Thorough knowledge of data warehouse principles and techniques specifically dimensional data modeling. Exceptional Oracle 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. Technophile with command of the command line. *PREFERRED QUALIFICATIONS* Medicaid or other healthcare or claims processing experience Informatica ETL experience Thanks Bob Smith 203-652-1444 Ext 118 -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/groups/opt_out.
