Job Description :
Job Title: BI ETL developer (SSIS & Informatica)

Location: Bay Area, CA

Role: Contract (C2C /W2)

Job Description

Experience with Informatica/SSIS to build, design, deploy and troubleshoot ETL’s

Extremely comfortable with SQL/PL/SQL, basic understanding of star schema

Ability to create and troubleshoot DAC/SSIS Scheduler plans to manage ETL tasks

Ability to run SQL queries and troubleshoot data and performance issues

Identify and test for bugs and bottlenecks in the ETL solution

Able to complete unit testing tasks (e.g. compare source and target row counts, data elements, amounts by period and accounts, etc

Communicate issues, risks and concerns proactively to management

Performs other related duties as required

Following experience in at least 3 of the following areas:

OBI Apps experience with Financials, Procurement and Project Accounting (big plus) Analytics

Informatica/ODI/SSIS development experience on top of oracle EBS source (new mappings, troubleshoot mappings, extend mappings)

EBS based reporting experience for AP, AR, GL, PO and PA modules (good understanding of tables, joins, etc

DAC/BIACM experience (new plans, maintain existing load plans, monitor loads, configurations, index changes, etc

RPD development/changes for OBI Apps RPD