Hi,

Let me know if you have any one for this

Role: ETL Developer (2 Positions)
Location: Foster City, CA
Duration: 3 months
Start Date: ASAP

Please respond to *[email protected]* with rates

Basic experience
1. Hands on Informatica ETL experience including customizing OOTB ETL
mappings, workflows and DAC updates.
2. Has good SQL experience to create performance intensive SQL queries and
procedures
3. Has prior experience working with Oracle EBS as source system. This is
required.
4. Has prior experience working with at least one OBIA module

Other Informatica skill sets
· Extensively worked on the ETL mappings, analysis and documentation of OLAP
reports requirements. Solid understanding of OLAP concepts and challenges,
especially with large data sets.
· Well versed in OLTP Data Modeling using EBS, Data warehousing concepts
including Star schema modeling.
· Strong knowledge of Entity-Relationship concept, Facts and dimensions
tables, slowly changing dimensions and Dimensional Modeling (Star Schema and
Snow Flake Schema).
· Experience in integration of data sources like Oracle and non-relational
sources like flat files into staging area.
· Experience in creating Reusable Transformations (Joiner, Sorter,
Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence
Generator, Normalize and Rank) and Mappings using Informatica Designer and
processing tasks using Workflow Manager to move data from multiple sources
into targets.
· Experience in creating Reusable Tasks (Sessions, Command, Email) and
Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment,
Worklet, Control).
· Experienced in UNIX work environment, file transfers, job scheduling and
error handling.
· Extensively worked on developing and debugging Informatica mappings,
mapplets, sessions and workflows.
· Worked on Performance Tuning, identifying and resolving performance
bottlenecks in various levels like sources, targets, mappings and sessions.
· Experience in writing, testing and implementation of the PL/SQL triggers,
stored procedures, functions, packages.
· Involved in Unit testing, System testing to check whether the data loads
into target are accurate.

-- 
Regards,

Shiv Kumar
Resource Manager,
Marlborough MA
C#: 781-544-4799 Ext: 110
Fax. 508.519.9180
[email protected]
www.Boston-technology.com
http://www.linkedin.com/in/rajaskumar
http://groups.google.co.in/group/bostontech


-- 
Subscription settings: 
http://groups.google.com/group/tek-professionals/subscribe?hl=en

Reply via email to