Informatica ETL Developer III

Title: Informatica ETL developer

Location: Houston TX - 5 Days onsite

Duration: 8 Months + Possible extensions

JOB SUMMARY:

• The Informatica ETL developer will be responsible for the design, development, testing, maintenance, and support of OBIEE solutions for Oracle Financial, Human Resources, Procurement, Projects, and Asset Maintenance Analytics within the data warehouse.


• The candidate will work closely with members of the data warehouse team including business customers to understand broad business information requirements, develop solutions to meet those requirements, and execute the design to meet business needs.

KEY RESPONSIBILITIES:

• Utilize best practices to design, develop, and support the OBIEE/OBIA data warehouse architecture


• Develop and administer Informatica Repository, Mappings, Sessions, and Workflows Monitor nightly loads and troubleshooting issues as they arise in the Database, DAC and Informatica


• Develop and administer DAC tasks, task groups, subject areas, and execution plans for existing and new applications


• Migrate DAC and Informatica development objects to test, production, and disaster recovery


• Maintain Administrator documentation for all customizations and extensions


• Serve as a subject matter expert for OBIEE/OBIA, demonstrating expertise in Oracle BI Server, ETL, DAC, and OBIEE performance tuning of BI Applications


• Troubleshoot production issues on day-to-day bases


• Assist with migration from PowerCenter to IDMC

Technical skills - Must Haves:

• Experience with DAC Administration


• Experience with IDMC - data integration and PowerCenter modernization


• Experience with OBIA - Financials, HR, Supply chain, etc..

Nice To Have

• Experience with CI/CD


• Experience with Snowflake


• Python Scripting


• Working with JSON files

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.