Informatica Admin/Developer

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

Job summary

Trinity Technology Solutions LLC seeks an ETL specialist with Informatica PowerCenter 10.5+ expertise to design complex mappings and support warehouse administration. You will optimize ETL processes within a data warehouse environment and collaborate with developers on architecture.

Focus areas include health systems data (admission, discharge, census, billing, Medicaid, Pharmacy) transformed into scalable ETL code, secure data handling with Oracle technologies, and leading a collaborative

Qualifications

• PowerCenter ETL development and design experience.
• Experience with Informatica PowerCenter Administration.
• Strong data warehousing concepts and design skills.
• Experience with health data (PHI) and HIPAA considerations.
• Bachelor’s degree in CS, BI, or related field.

Skills

ETL design PowerCenter

Team leadership

Data warehousing concepts

Metadata analysis

PHI/HIPAA data handling

Education

Bachelor’s degree in computer science / BI / information science

Tools

Informatica PowerCenter

Informatica Intelligent Data Management Cloud

Oracle

UNIX/Linux

Job description

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.

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

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.

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

Experience working with UNIX and or LINUX Operating Systems.

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.