Job Title : ON-SITE - ETL Informatica Consultant - HBITS-05-13424
Location : Albany, NY, 12204
Duration : Long-term
Job Description:
- 84 Months Experience using Informatica Powercenter 9.6.x or higher in a data warehouse environment including familiarity with advanced warehousing concepts, and design and development of complex mappings
- 84 Months Experience with Informatica Powercenter Administration including Installation, Patching, Metadata analysis, ETL code migration, and repository optimization.
- 84 Months Experience analyzing and converting, heterogenous Health systems data, including admission, discharge, census, financial, billing, human resource, payroll, Medicaid and Pharmacy data into complex ETL code
- 84 months Experience in relational data management disciplines and design and development experience using Oracle technologies including designing and implementing Oracle Virtual Private Database(VPD) and Oracle Fine grained Auditing in an Enterprise Data Warehouse environment
- 60 Months Experience working with UNIX and or LINUX Operating Systems
- 60 Months Experience collaborating with developers as a team lead in designing Powercenter ETL and database architecture using advanced data warehousing concepts.
- Bachelor s degree in computer science, business intelligence, information science or related field
Agency: Office of Mental Health
Project: Enterprise Data Warehouse and OMH projects as needed
Detailed Job Description: Support the Data warehouse Informatica Powercenter ETL(Extract, Transform, Load) processes, Informatica administration, and redesign and implementation of current and future OMH projects.
Max: SEVEN 32.800.2838
Kevin:- SEVEN 32.800.2373
ON-SITE - ETL Informatica Consultant- HBITS-05-13424