Location: Albany, NY, 12204

Duration: Long-term

Job Description:

· 7 years’ 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

· 7 years’ Experience with Informatica Powercenter Administration including Installation, Patching, Metadata analysis, ETL code migration, and repository optimization.

· 7 years’ 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

· 7 years’ 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

· 5 years’ Experience working with UNIX and or LINUX Operating Systems

· 5 years’ 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

Job Type: Contract

Pay: $50.00 - $55.00 per hour

Experience level:

• 10 years
• 8 years

Schedule:

• 8 hour shift

Experience:

• Informatica: 1 year (Preferred)
• SQL: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)

Ability to Commute:

• Albany, NY 12204 (Required)

Ability to Relocate:

• Albany, NY 12204: Relocate before starting work (Required)

Work Location: In person