Why This Role Stands Out
This hybrid role offers a fantastic opportunity to lead critical ETL processes and contribute to significant data warehousing projects, fostering valuable skills development in Informatica PowerCenter. You'll thrive here if you're an experienced ETL Lead passionate about data solutions and eager to make an impact within a reputable organization. Apply now to explore this exciting career advancement!
Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Menands, NY, United States
Posted
17 hours ago
OracleETLAuditingHIPAAMental HealthPayrollPharmacy
Job Description
Job Description: IT Specialist – Expert (Informatica PowerCenter / ETL Lead)
Role Overview
- Job Title: IT Specialist (Expert Level)
- Request ID: HBITS-08-14991
- Agency: Office of Mental Health (OMH)
- Project: Enterprise Data Warehouse and OMH projects
- Location: Menands, NY (Hybrid – 50% Telecommuting allowed)
- Engagement Duration: 30 Months
- Work Hours: Full-Time (40 hrs/week)
- Interview Format: Webcasting (Camera Required)
Day-to-Day Responsibilities
- Support Data Warehouse Informatica PowerCenter ETL processes, Informatica administration, and the redesign/implementation of OMH projects.
- Analyze and translate complex patient health data business requirements (admission, discharge, census, financial, billing, HR, payroll, Medicaid, and Pharmacy) into ETL code.
- Lead development efforts in designing Informatica PowerCenter ETL and database architecture using Kimball Star Schema and Dimensional Data Modeling techniques.
- Extract and interpret Informatica Metadata repository data and implement Fine Grain Access Control Audit (FGACA) to safeguard Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
- Analyze and write complex UNIX scripts to validate/FTP files and monitor Informatica workflows.
- Perform Informatica administration tasks including installation, patching, deployment, and repository optimization across platforms.
Mandatory Qualifications
- Skill Level: Expert (84+ months of IT experience providing guidance to large teams, demonstrating top-tier industry domain knowledge).
Requested Qualifications & Experience
- Informatica ETL: 84+ months using Informatica PowerCenter 10.5.x (or higher) and Informatica Intelligent Data Management Cloud (IDMC) in a data warehouse environment, including complex mapping development.
- Informatica Administration: 84+ months performing installation, patching, metadata analysis, code migration, and repository optimization.
- Healthcare Data Systems: 84+ months analyzing and converting heterogeneous health system data (admission, discharge, census, billing, Medicaid, Pharmacy) into ETL code.
- Data Security & Oracle: 84+ months with Oracle technologies, specifically implementing Virtual Private Database (VPD) and Fine-Grained Auditing (FGACA) to protect HIPAA/PHI data.
- OS / Scripting: 60+ months of experience with UNIX and/or LINUX operating systems.
- Team Leadership: 60+ months collaborating as a technical team lead in PowerCenter ETL and data warehouse architecture design.
- Education: Bachelor's degree in Computer Science, Business Intelligence, Information Science, or a related field.
Similar jobs
- NG
Sr Principal Software Engineer - Java
NewNorthrop Grumman
Imperial Beach, California🇺🇸$142.2k - $213.4k/yrOn-siteJust nowDockerMicroservicesAgile+4Technology - NG
Sr Principal Software Engineer - Java
NewNorthrop Grumman
Coronado, California🇺🇸$142.2k - $213.4k/yrOn-siteJust nowDockerMicroservicesAgile+4Technology - NG
Staff CORE Systems Engineer
NewNorthrop Grumman
Glen Burnie, Maryland🇺🇸$169k - $253.6k/yrOn-siteJust nowMATLABAgileTechnology - NG
Staff CORE Systems Engineer
NewNorthrop Grumman
Catonsville, Maryland🇺🇸$169k - $253.6k/yrOn-siteJust nowMATLABAgileTechnology - YU
Software Development Career Training Opportunity
NewYear Up United
Torrance, California🇺🇸Hybrid1 minute agoLESSTechnology - US
Director, Data Scientist
NewUSAA
Tampa, Florida🇺🇸On-site3 minutes agoSQLLinearMachine Learning+4Technology