Role: Informatica & OBIEE Consultant

Location: Houston

Arrangement: On-Site

Employment Type: Contract

About the Role:

We are seeking an experienced Informatica Consultant with deep expertise in OBIEE/OBIA

solutions, DAC, and PowerCenter to IDMC migrations. The ideal candidate will possess a

strong background in data integration, ETL design, and enterprise analytics systems. This is a

strategic role that involves working closely with business and technical stakeholders to ensure

seamless data flow, reporting, and analytics capabilities.

Key Responsibilities:

• Design, develop, and implement Informatica-based ETL solutions using

PowerCenter, Informatica Intelligent Data Management Cloud (IDMC), and Data

Integration Services.

• Migrate legacy ETL processes from PowerCenter to IDMC while ensuring

performance and data integrity.

• Support and maintain existing OBIEE/OBIA (Oracle Business Intelligence

Applications) environments, including DAC (Data Warehouse Administration

Console) configurations.

• Troubleshoot and resolve data integration issues across multiple platforms.

• Optimize and tune ETL workflows for performance and scalability.

• Collaborate with cross-functional teams to gather requirements and deliver solutions

that align with business goals.

• Provide technical documentation and knowledge transfer to internal teams.

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or related field.

• 5+ years of experience with Informatica PowerCenter, and at least 1–2 years with

Informatica IDMC.

• Hands-on experience with OBIEE/OBIA solutions and DAC.

• Proven experience with data warehousing concepts, dimensional modeling, and ETL

best practices.

• Experience in performance tuning of Informatica mappings and sessions.

• Strong analytical and problem-solving skills.

• Excellent verbal and written communication skills.