Sr. Informatica Consultant

About the role

Support the Data Warehouse Informatica PowerCenter ETL (Extract, Transform, Load) processes, Informatica administration, and redesign and implementation of current and future projects.

Responsibilities

• Analyze and translate patient health data business requirements into ETL code, including admission, discharge, day-to-day census records, financial, billing, human resource, payroll, Medicaid, and Pharmacy data.
• Participate in Data Warehouse design and architecture planning using Kimball methodologies of Star schema design and Dimensional Data Modeling techniques.
• Collaborate with developers as a team lead in designing Informatica PowerCenter ETL and database architecture using advanced data warehousing concepts.
• Extract and interpret Informatica Metadata repository data.
• Implement Fine Grain Access Control Audit (FGACA) to protect healthcare data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
• Analyze and code complex UNIX scripts to validate and FTP files and monitor Informatica workflows.
• Perform Informatica Administration including installation, patching, and deployment of Informatica ETL code across all platforms.

Requirements

• 14+ years of experience in Information Technology, supporting development platforms, technical architectures, or business applications.
• 84 months of 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 of experience with Informatica PowerCenter Administration, including installation, patching, metadata analysis, ETL code migration, and repository optimization.
• 84 months of experience analyzing and converting heterogeneous health systems data (admission, discharge, census, financial, billing, human resource, payroll, Medicaid, and Pharmacy data) into complex ETL code.
• 84 months of experience in relational data management disciplines and design 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 healthcare data such as Medicaid, Pharmacy, and HIPAA PHI.
• 60 months of experience working with UNIX and/or Linux operating systems.
• 60 months of 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 a related field.
• Copy of candidate identification (e.g., driver’s license and/or passport and visa if applicable).
• Any documents referenced in the qualifications (e.g., professional certifications, degrees).

Schedule

This is a 100% onsite role.