Please send resumes only to [EMAIL PROTECTED] Position: ETL Developer
Location: San Marcos, CA Duration: 5 Months PLEASE SUBMIT LOCAL TO CA CANDIDATES ONLY RATE: $50/HR * Experience with Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. * Develop and supported Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate the tables in Data warehouse and Data marts * Extract and transfer source data from different databases including Oracle, SQL SERVER, and flat files into Oracle. * Proficient in SQL, PL/SQL, Procedures/Functions, Triggers and Packages in Oracle 9i * Understand complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc. * Develop reusable transformations and mapplets. * Develop Slowly Changing Dimension Mappings of type I, II and III. * Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions. * Experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets. * Experience in Installation, Configuration, and Administration of Informatica Power Center/Power Mart on Client/Server environment. * Ability to handle large volumes of data warehouse database. Experience in writing UNIX shell scripts (Korn Shell/Bourne Shell), SQL*Loader, Performance & Tuning of Database, Backup and Recovery. * Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star schema and Snowflake schema SKILLS - ETL Tools: Informatica 5.1, 6.2, 7.1 Databases: Oracle 7.x/8i/9i/10g Languages: SQL, PL/SQL Data Modeling: E-R Modeling, Dimensional Modeling, and Star Schema, Snow Flake Schema, Fact and dimension tables Data Modeling Tools: Erwin 3.5.2/4.0/4.1 TOAD EDUCATION - CS or equivalent experience Thanks & Regards, Lisa Valentine Account Manager Data Group Inc 732-734-5335 [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "IT provider" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.co.in/group/IT-provider?hl=en -~----------~----~----~----~------~----~------~--~---
