Database Architect Expert

DKMRBH Inc

Database Architect Informatica / Oracle

Duration: 30 Months

Employment Type: Contract (C2C) Job Summary

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 Responsibilities

Design, 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.

Required Qualifications

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.

Required Technical Skills

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

Apply

Vacancy posted 1 day ago

Similar jobs that could be interesting for youBased on the Database Architect Expert in Albany, NY vacancy

Bookkeeping Expert (Work from Home)
$24 - $33 per hour
Base pay range $24.00/hr - $33.00/hr Overview At Intuit, our mission is to power prosperity around the world. As a QuickBooks Live Expert you are the center of that mission, providing professional bookkeeping, payroll and tax guidance to our QuickBooks Live small...
Suggested
Part time
Work at office
Work from home
Flexible hours
Intuit
Albany, NY
4 days ago
Cafe Team Expert
...Caf Team Expert A Barnes & Noble bookstore is a gathering place for readers and the community. As Caf Team Expert (CTE), you are an integral leader for the caf team. You work through the team to develop their knowledge to create a welcoming environment for our customers...
Suggested
Flexible hours
Shift work
Afternoon shift
Early shift
Barnes & Noble
Albany, NY
3 days ago
Software Architect Expert
Software Architect ExpertDay to Day Task Include:Provide oversight on the analysis and design for enterprise applications using JAVA/JEE... ..., data structures, data manipulation, preparing logical database models.Prepare, and/or review technical documentation such as...
Suggested
Full time
Work at office
Flexible hours
Spruce Technology
Albany, NY
8 hours ago
NYS ITS Expert Software Architect
...Expert Software Architect Diverse Agile Solutions (DAS) Location: Remote (New York State Preferred) Employment Type: Full-Time / Contract... ..., and data validation. Monitor and optimize Oracle database performance through query tuning, indexing, partitioning,...
Suggested
Full time
Contract work
Remote work
Diverse Agile Solutions
Menands, NY
more than 2 months ago
Expert Project Manager
...Expert Project Manager Diverse Agile Solutions (DAS) Location: Albany, NY (Hybrid/Onsite as required) Employment Type: Full-Time / Contract Experience Level: Expert (7+ Years Required) Clearance: Must be eligible to work on U.S. government projects...
Suggested
Full time
Contract work
Diverse Agile Solutions
Albany, NY
more than 2 months ago
Systems Developer - Expert
...position will work under the direction of a Technical Lead, Project Manager & Software Architect. Perform writing of stored procedures/triggers in an Oracle database utilizing PL/SQL Required Qualifications: ~84 months experience developing N-Tier...
Temporary work
Cays Inc
Albany, NY
1 day ago
Data Architect Sr. Manager
...together our Experienced Innovation, Strategic Investment, Exceptional Talent, and Power Ecosystem. You Are:You are a data/senior data architect who designs enterprise data fabric solutions that provide unified, intelligent, automated access to distributed data across on-...
Full time
Work experience placement
Live in
Work at office
Local area
Accenture
Albany, NY
4 days ago
SAP Data Migration Manager/Architect
...equally comfortable whiteboarding migration architecture and rolling up your sleeves to solve a stubborn data quality issue.The Work:Architect end-to-end SAP data migration strategies for S/4HANA transformation programs, including greenfield, brownfield, and selective data...
Full time
Work experience placement
Live in
Work at office
Local area
Accenture
Albany, NY
1 day ago
Bioequivalence Expert Pharmaceutical Consultant
...Bioequivalence Expert Pharmaceutical Consultant Join to apply for the Bioequivalence Expert Pharmaceutical Consultant role at Pharmavise Corporation Bioequivalence Expert Pharmaceutical Consultant 3 days ago Be among the first 25 applicants Join to apply...
Contract work
Remote work
Pharmavise Corporation
Sand Lake, NY
3 days ago
Senior Machine Learning Engineer, Perception - Autonomous Driving
$184k - $287.5k
Intelligent machines powered by Artificial Intelligence computers that can learn, reason, and interact with people are no longer science fiction. Today, a self-driving vehicle powered by AI can meander through a country road at night and find its way. NVIDIA's GPU runs ...
Full time
Remote work
Worldwide
Night shift
Nvidia
Albany, NY
4 days ago
Information Technology Architect 1 (Lead Data Architect)
$100.67k - $126.88k
...Attorney General, Office of theTitle: Information Technology Architect 1 (Lead Data Architect) Occupational Category: I.T. Engineering... ...comprehensive understanding of software engineering, data engineering, database administration or other data-related specialty and its...
Permanent employment
Full time
Work at office
Remote work
2 days per week
State of New York, USA
Albany, NY
3 days ago
2026 03-04 ETL Developer / Data Architect
...and experienced candidate to serve as an ETL Developer / Data Architect on our Business Intelligence ("BI") team supporting key clients... ...array of varying data sets, including flat files, direct database connection, and XML transactions. ~4+ years of experience with...
Flexible hours
VISTRADA
Albany, NY
2 days ago
PostgreSQL Database Developer
...Job Description Job Description PostgreSQL Database Developer Employment Type: Full Time, Experienced level Department: Information Technology CGS is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and...
Full time
Flexible hours
Contact Government Services, LLC
Albany, NY
22 hours ago
Knowledge Engineer Manager - Back-end Engineer
...services that power our AI-driven knowledge platform. You will work across the full back-end stack — architecting APIs, building data pipelines, managing multi-modal database systems, and owning the reliability and performance of the services that application and product...
Full time
Work experience placement
Live in
Work at office
Local area
Accenture
Albany, NY
3 days ago
Senior Oracle APEX Developer
..., CSS, and HTML. - Create dynamic reports within the Oracle APEX environment. Provide support in the advanced use of Oracle Database products version 11 and above. - Provide support for Oracle database objects – tables, indexes, directories, sequences, triggers...
Full time
Flexible hours
Contact Government Services, LLC
Albany, NY
16 days ago
FinOps AI / ML Engineer Assoc Director
...sustained savings and speed-to-value across AWS, Azure, and Google Cloud. We are a collaborative team of architects, engineers, financial analysts, and delivery experts who partner with world-class clients to transform how they manage, optimize, and govern cloud spend.You...
Full time
Work experience placement
Live in
Work at office
Local area
Accenture
Albany, NY
3 days ago
FinOps AI / ML Engineer Manager
...sustained savings and speed-to-value across AWS, Azure, and Google Cloud. We are a collaborative team of architects, engineers, financial analysts, and delivery experts who partner with world-class clients to transform how they manage, optimize, and govern cloud spend.You...
Full time
Work experience placement
Live in
Work at office
Local area
Accenture
Albany, NY
1 day ago
Machine Learning Engineer II, Logistics AI
We're transforming the grocery industry At Instacart, we invite the world to share love through food because we believe everyone should have access to the food they love and more time to enjoy it together. Where others see a simple need for grocery delivery, we see exciting...
Permanent employment
Full time
Work at office
Remote work
Work from home
Flexible hours
Instacart
Albany, NY
1 day ago
Machine Learning Engineer New Grad 2024-2025 -Remote
$107.66k - $161.7k
About Quora: Quora’s mission is to grow and share the world’s knowledge. To do so, we have two knowledge sharing products: Quora : a global knowledge sharing platform with over 400M monthly unique visitors, bringing people together to share insights on various topics...
Remote job
Full time
Work experience placement
Internship
Quora
Albany, NY
1 day ago
Evaluation and ML Systems Engineer, AI Safety and Security Engineering
$152k - $241.5k
NVIDIA is widely recognized as one of the most sought-after employers, with some of the most dedicated people in the world working for us! We believe open-weight models are foundational to American AI leadership and cybersecurity, and that trust in AI grows through participation...
Full time
Remote work
Nvidia
Albany, NY
3 days ago
AI & Machine Learning Engineering Consultant - Manager - Consulting - Location OPEN
$150.7k - $251.2k
Location: Anywhere in Country At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world. The opportunity...
Full time
Work experience placement
EY
Albany, NY
1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Architect Expert. Be the first to apply!