Jobs → Data & Analytics → Database Architect

About the Role We are looking for an Expert Database Architect with strong expertise in Informatica PowerCenter, IDMC, ETL development, database architecture, and enterprise healthcare data warehousing. Key Responsibilities • Design and implement database architectures for healthcare data warehousing • Develop and maintain ETL processes using Informatica PowerCenter and IDMC • Perform Informatica administration tasks including installation, configuration, and performance optimization • Manage Oracle Database Architecture, including VPD and FGA implementations • Apply dimensional modeling, Star Schema, and Kimball methodology for data warehousing • Integrate healthcare data including patient admissions, discharges, billing, and pharmacy • Utilize UNIX/Linux shell scripting for automation and ETL workflow monitoring • Conduct data lineage, metadata analysis, and dependency tracking • Ensure HIPAA compliance and PHI protection • Provide production support, troubleshoot issues, and perform ETL performance tuning • Lead technical reviews, documentation, and team mentoring Requirements • 12+ years of experience in database architecture and ETL development • Expertise in Informatica PowerCenter 10.5.x+, IDMC, and ETL development • Strong knowledge of Oracle Database Architecture and relational database management • Experience with healthcare data integration and enterprise data warehousing • Proficiency in UNIX/Linux shell scripting and automation • Understanding of data governance, data quality, and data security principles • HIPAA compliance knowledge and experience with PHI protection • Bachelor’s degree in Computer Science, IT, Information Science, Business Intelligence, or a related field