Informatica ETL Developer - Contract - 100% Onsite in Downtown Houston

  • Houston, TX
  • Posted 23 days ago | Updated 23 days ago

Overview

On Site
Depends on Experience
Contract - W2

Skills

Extract
Transform
Load
Data Warehouse
Informatica
JSON
OBIA
OBIEE
Oracle Financials
python
snowflake
Continuous Delivery
Continuous Integration

Job Details

Job Title: Informatica ETL Developer (Contract)
Location: 100% Onsite Downtown Houston

Job Summary:
We are seeking a skilled Informatica ETL Developer for a position supporting our data warehouse initiatives. The successful candidate will be responsible for the design, development, testing, and support of OBIEE/OBIA solutions across Oracle Financials, Human Resources, Procurement, Projects, and Asset Maintenance Analytics. This role involves close collaboration with data warehouse team members and business stakeholders to translate information requirements into scalable solutions.

Key Responsibilities:

  • Design, develop, and support OBIEE/OBIA data warehouse architecture using best practices

  • Develop and manage Informatica Repositories, Mappings, Sessions, and Workflows

  • Monitor nightly ETL processes and troubleshoot issues across the database, DAC, and Informatica platforms

  • Create and maintain DAC tasks, task groups, subject areas, and execution plans for both existing and new applications

  • Manage the migration of DAC and Informatica objects across development, test, production, and DR environments

  • Maintain comprehensive documentation for customizations and extensions

  • Act as a subject matter expert in OBIEE/OBIA, with deep understanding of Oracle BI Server, ETL processes, DAC, and performance tuning

  • Support production systems and resolve issues on a day-to-day basis

  • Assist in the migration from PowerCenter to IDMC

Requirements:

  • Minimum 5 years of relevant experience

  • Strong experience with OBIA modules (Financials, HR, Supply Chain, etc.)

  • Proficiency in DAC Administration

  • Hands-on experience with IDMC Data Integration and PowerCenter modernization

Nice to Haves:

  • Experience with Snowflake

  • Familiarity with JSON file processing

  • Experience with CI/CD pipelines

  • Python scripting skills

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.