Informatica Developer

Trinity Technology Solutions LLC; Village of Menands (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Trinity Technology Solutions LLC is actively seeking an Informatica Admin/Developer for a contract in Menands, NY. You will handle comprehensive Informatica PowerCenter 10.5+ and IDM Cloud work within a data warehouse environment.

Responsibilities include installation, patching, metadata analysis, ETL code migration, and repository optimization. You will work with health-care data, implement Oracle VPD/FGACA, and support UNIX/Linux systems while collaborating with a developer team.

Qualifications

• 84 months experience with Informatica PowerCenter and IDM Cloud in a data warehouse environment.
• 84 months PowerCenter Administration including installation, patching, metadata analysis, migration, and repository optimization.
• 84 months experience analyzing and transforming health system data into complex ETL processes.
• 84 months Oracle technologies including VPD and FGACA in an Enterprise Data Warehouse for HIPAA PHI.
• 60 months UNIX/Linux operating systems experience.
• 60 months collaborating with developers as a team lead in PowerCenter ETL and DB architecture.

Skills

ETL design

Data warehousing

Team lead

Health data analysis

Informatica collaboration

Education

Bachelors degree in computer science or related field

Tools

Informatica PowerCenter

Informatica Intelligent Data Management Cloud

Oracle VPD

Oracle FGACA

Job description

Please take a look at this job opportunity for Informatica Admin / Developer.

Location: Menands, NY

Duration: Contract

JD:

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 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 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).

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.