Description

-
Candidate should have experience in at least 2 of the below tool sets.

ETL - Informatica

===================================

5+ years of experience working with Informatica PowerCenter (especially with OBIA implementation or migration experience (for example, 7.9.x to 11g/12c).).

Hands-on experience with OBIA (Oracle Business Intelligence Applications), including prebuilt and custom ETL scenarios.

Proficient with DAC (Data Warehouse Administration Console): configuring, managing, scheduling, and monitoring ETL execution plans.

Expertise in data warehouse architecture, star/snowflake schema, slowly changing dimensions, and ETL best practices.

Strong SQL skills; experience with Oracle databases (writing, debugging, optimizing SQL and PL/SQL).

Understanding of performance tuning and troubleshooting in Informatica and DAC.

Familiarity with source control, release migration, and OBIA upgrade prac...