Job Title: ETL Developer
Duration: 30 Months
Location: Menands, NY 12204 (Hybrid)
Position Type: Contract
Hours Per Week: 40 Hours
Department: Office of Mental Health (OMH)
Need Prior State Client Experience
Required Skills:
- 84 Months Experience using Informatica PowerCenter 10.5.x or higher and Informatica Intelligent Data Management Cloud 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 in relational data management disciplines and design and development using Oracle technologies including designing and implementing Oracle Virtual Private Database(VPD) and Oracle Fine grained Auditing (FGACA) in an Enterprise Data Warehouse environment to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
