Expert Database Architect - Informatica ETL & Data Warehouse

Location: Albany, NY

Duration: 30 Months

Experience: 10+ Years

Position Type: Contract

Job Overview

We are seeking an experienced Expert Database Architect to support enterprise data warehouse initiatives involving Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC). The ideal candidate will have extensive experience in ETL development, database architecture, Informatica platform administration, and healthcare data integration.

The candidate will be responsible for enhancing existing data integration solutions, designing scalable data warehouse architectures, developing complex ETL workflows, and supporting the modernization of legacy data processing environments. Experience working with sensitive healthcare information and implementing database security controls is essential.

Roles and Responsibilities

• Design, develop, and maintain complex ETL workflows using Informatica PowerCenter 10.5.x or later and Informatica Intelligent Data Management Cloud (IDMC).

• Analyze business and technical requirements and translate healthcare data integration needs into scalable ETL solutions.

• Architect and enhance enterprise data warehouses using dimensional modeling, star schemas, and Kimball data warehousing methodologies.

• Integrate data from multiple healthcare and administrative domains, including patient admissions, discharges, census, billing, financial operations, payroll, human resources, Medicaid, and pharmacy systems.

• Lead database architecture and ETL design activities while collaborating with application developers, business analysts, and technical teams.

• Administer Informatica environments, including installation, configuration, patching, deployment, repository maintenance, metadata analysis, and performance optimization.

• Develop, review, and optimize complex Informatica mappings, transformations, sessions, workflows, and reusable ETL components.

• Analyze Informatica repository metadata to support impact analysis, dependency tracking, data lineage, and migration planning.

• Design and implement Oracle database security mechanisms, including Virtual Private Database (VPD) and Fine-Grained Auditing (FGA), to safeguard sensitive healthcare information.

• Ensure appropriate protection of Medicaid, pharmacy, and HIPAA-regulated Protected Health Information (PHI) through database access controls and auditing practices.

• Develop and maintain UNIX/Linux shell scripts to validate incoming data files, automate file transfers, execute operational checks, and monitor ETL workflow activities.

• Troubleshoot data quality issues, ETL failures, database performance bottlenecks, and production processing incidents.

• Coordinate ETL code migrations and deployments across development, testing, and production environments while maintaining data integrity and operational stability.

• Establish data validation, reconciliation, error-handling, and monitoring procedures to improve the reliability of enterprise data processing.

• Provide technical leadership, code reviews, architectural guidance, and knowledge sharing to support development teams and ensure adherence to data engineering standards.

• Participate in data warehouse modernization, redesign, and implementation initiatives to improve scalability, maintainability, and performance.

Required Qualifications

• Extensive hands-on experience with Informatica PowerCenter 10.5.x or later and Informatica Intelligent Data Management Cloud (IDMC) in enterprise data warehouse environments.

• Strong background in Informatica administration, including installation, patching, metadata management, ETL migration, repository optimization, and deployment.

• Proven expertise in designing and developing complex ETL mappings and workflows for heterogeneous healthcare data sources.

• Strong knowledge of Oracle database architecture, relational data management, database security, Virtual Private Database (VPD), and Fine-Grained Auditing (FGA).

• Experience with healthcare data integration involving admissions, discharges, patient census, billing, financial, payroll, human resources, Medicaid, and pharmacy information.

• Expertise in dimensional data modeling, star schema design, and Kimball data warehouse methodologies.

• Proficiency in UNIX/Linux environments, shell scripting, file validation, FTP/SFTP processes, and workflow monitoring.

• Experience leading technical teams and collaborating with developers on ETL design, database architecture, and enterprise data warehouse solutions.

• Knowledge of HIPAA requirements and security practices for protecting confidential healthcare data.

• Strong analytical, troubleshooting, communication, and technical documentation skills.

Education

Bachelor s degree in Computer Science, Information Science, Business Intelligence, Information Technology, or a related discipline.

Preferred Qualifications

• Experience supporting large-scale healthcare data warehouse platforms.

• Familiarity with data governance, metadata management, data lineage, and data quality frameworks.

• Experience modernizing legacy ETL processes and transitioning data integration workloads to cloud-based data management platforms.

• Ability to work independently, provide technical direction, and mentor other team members.