Position : ETL Developer Location : CA
Duration : Foster City, CA Rate : Open Basic experience Hands on Informatica ETL experience including customizing OOTB ETL mappings, workflows and DAC updates. Has good SQL experience to create performance intensive SQL queries and procedures Has prior experience working with Oracle EBS as source system this is required. Has prior experience working with at least one OBIA module 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 Thanks & Regards Naga Raj Business Development Manager Aim Computer Consulting Phone : 734-591-3562 EXT 1+214 | Fax: 734-418-2603 www.aim-cc.com <http://www.aim-cc.com/> | <mailto:[email protected]> [email protected] | <mailto:[email protected]> [email protected] | <mailto:[email protected]> [email protected] P Please do not print this email unless it is absolutely necessary. Spread environmental awareness. -- You received this message because you are subscribed to the Google Groups "java-core" group. To post to this group, send an email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/java-core?hl=en-GB.
