Duration: 30 Months
Employment Type: Contract (C2C)
We are seeking an experienced Database Architect with extensive expertise in Informatica PowerCenter, Informatica Intelligent Data Management Cloud (IDMC), Oracle database technologies, and enterprise data warehousing. The ideal candidate will have strong hands-on experience designing complex ETL solutions, administering Informatica environments, integrating healthcare data from heterogeneous systems, and implementing advanced Oracle database security controls.
Key ResponsibilitiesDesign, develop, and maintain complex ETL mappings and enterprise data warehouse solutions using Informatica PowerCenter 10.5.x or higher and IDMC.
Administer Informatica PowerCenter and IDMC environments, including installation, patching, metadata analysis, ETL code migration, and repository optimization.
Analyze, transform, and integrate heterogeneous healthcare data, including hospital admissions, discharges, census, financial, billing, human resources, payroll, Medicaid, and pharmacy data.
Design and implement Oracle database security solutions using Virtual Private Database (VPD) and Fine-Grained Auditing (FGA).
Apply advanced data warehousing concepts, relational data management principles, and database architecture best practices.
Develop and optimize complex ETL workflows to support enterprise reporting, data integration, and healthcare data management.
Protect sensitive healthcare information, including Medicaid data and HIPAA-regulated Protected Health Information (PHI).
Collaborate with developers and technical teams to establish ETL design standards, database architecture, and data integration strategies.
Troubleshoot performance issues and optimize ETL processes, database operations, and Informatica repository performance.
10+ years of experience with Informatica PowerCenter 10.5.x or higher and IDMC in enterprise data warehousing, including complex mapping design and development.
10+ years of experience administering Informatica PowerCenter and IDMC, including installation, patching, metadata analysis, ETL code migration, and repository optimization.
10+ years of experience analyzing and transforming data from heterogeneous healthcare systems into complex ETL solutions.
10+ years of experience in relational data management and Oracle technologies, including designing and implementing VPD and FGA in enterprise data warehouses.
10+ years of experience working with UNIX and/or Linux operating systems.
10+ years of experience leading and collaborating with development teams on PowerCenter ETL solutions and database architecture.
Strong understanding of healthcare data security, Medicaid data, and HIPAA-protected PHI.
Demonstrated expertise in enterprise data warehouse architecture, complex data integration, and relational database design.
Informatica PowerCenter 10.5.x or higher
Informatica Intelligent Data Management Cloud (IDMC)
ETL development, complex mappings, and data migration
Enterprise data warehousing and relational data management
Oracle database architecture, VPD, and FGA
Healthcare data integration and transformation
UNIX/Linux operating systems
HIPAA, PHI, and Medicaid data security
...: Employment Type: Full time Shift: Evening Shift Description: Job Title: Protection Officer Employment Type: Full Time Shift: Evening (SUMMARY) Position Highlights: Competitive salary Benefits - Medical, Dental & Vision, PTO, Free Parking...
Job Summary: We are seeking an experienced Line Test Technician to guide line operators on proper SOP execution, perform basic maintenance on test fixtures, and create daily test reports using Microsoft Excel. Key Responsibilities SOP Guidance: Assist and ...
...Responsible for greeting guests and creating an exceptional guest experience in Lounge areas. Perform various drink making techniques which... ...Knowledge of basic cocktail and mixology recipesPrevious bartending experience in a fast paced high volume environmentAbility to...
...you are the right match for the following opportunity, apply after reading the complete description.Epic & Encoder Pro experience is preferred.Valid AAPC or AHIMA credential. xhyhwjd Must reside in the U.S.Remote working/work at home options are available for this role.
...and improve patient outcomes. Qualifications: Current Massachusetts license as registered nurse. Experience in sexual and reproductivehealth and/or ambulatory surgical setting preferred but not required (new grads are welcome). Current CPR certification....