Informatica Developer – Menands, NY

Job ID: HBITS-08-14991
Department: New York State Office of Mental Health
Location: Menands, NY
Duration: 30 months
Pay Rate: $60.48/hour on 1099 or $50.48/hour on W-2
Sponsorship: Not available

Position Overview

The New York State Office of Mental Health is seeking an experienced Informatica Developer with strong expertise in Informatica PowerCenter, Informatica Intelligent Data Management Cloud, Oracle, healthcare data, ETL architecture, data warehousing, and UNIX/Linux environments.

Required Qualifications

• 84 months of experience using Informatica PowerCenter 10.5.x or higher and Informatica Intelligent Data Management Cloud in a data-warehouse environment. Experience must include advanced data-warehousing concepts and the design and development of complex mappings.

• 84 months of Informatica PowerCenter administration experience, including installation, patching, metadata analysis, ETL code migration, and repository optimization.

• 84 months of experience analyzing and converting heterogeneous healthcare-system data into complex ETL code. Data must include admission, discharge, census, financial, billing, human resources, payroll, Medicaid, and pharmacy information.

• 84 months of experience with relational data-management disciplines and the design and development of Oracle solutions in an enterprise data-warehouse environment. Experience must include implementing Oracle Virtual Private Database (VPD) and Oracle Fine-Grained Auditing to protect healthcare data, including Medicaid, pharmacy, and HIPAA-protected health information.

• 60 months of experience working with UNIX and/or Linux operating systems.

• 60 months of experience collaborating with developers as a team lead while designing PowerCenter ETL and database architecture using advanced data-warehousing concepts.

• Bachelor’s degree in Computer Science, Business Intelligence, Information Science, or a related field.

Mandatory Submission Documents

Candidates selected for submission must complete a Right to Represent and provide all applicable documents at the submission stage:

• Current resume

• Proof of work authorization

• Driver’s license or other government-issued identification

• and passport copies, if applicable

• Degree certificate and diploma copies

• Three professional references

These documents are mandatory and must be provided before the client will consider the candidate for an interview. Candidates who cannot provide the required documents at the submission stage cannot be submitted.

Candidate Instructions

Please provide an updated résumé clearly showing the applicable clients, projects, exact dates, responsibilities, and total months of experience for every qualification.

Include only experience you personally performed and can verify. Candidates must be willing to work in Menands, NY. Relocation, travel, lodging, and commuting expenses are not provided.