Job Description :
We have an excellent opportunity for BI ETL developer (SSIS & InformaticaThe manager would like to interview ASAP. Below is the JD and please send candidates ASAP.
Please do not share profiles who feel uncomfortable sharing legal name, DOB, Copies of ID proof, Work authorization and Passport details (Must for H1B, EAD etc*
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