Hi Business Partners, This is Ashok from keeninfotek.
Job title: Sr Informatica Developer Location: Carlsbad, CA Duration: 6 Months *PS: Need local to CA candidates only* *Required Skills* *Experience with Informatica PowerCenter 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 PowerCenter to populate the tables in a data warehouse * Experience with sourcing different databases including Oracle, SQL Server, DB2, and flat files into Oracle * Experience designing and developing in the Informatica IDQ/DQA environment * Proficient in SQL, PL/SQL, Procedures/Functions, Triggers and Packages in Oracle 10g or higher * 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 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 PowerCenter on Client/Server environment * 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: * Informatica 8.1.1 or higher * Databases: 10g or higher * Languages: SQL, PL/SQL, Unix/Linux * Data Modeling: E-R Modeling, Dimensional Modeling, Star Schema, Snow Flake Schema, Fact and dimension tables * Excellent written and verbal communication skills - must be able to organize and lead projects with little direction * Informatica IDQ/DQA is now OPTIONAL Education: B.S. Computer Science or equivalent technical field *Thanks & Regards * *ASHOK* *Keen Info tek, Inc **| Keen Education Services | Keen University*** *710 E || Ogden Ave || Suite #*300* || Naperville || IL 60563 || Ph: **630-364-4263** ||* *|| Fax: (630) 206-0325|| **Email:**[email protected] <[email protected]>** || ** www.keeninfotek.com* <http://www.tekpartner.com/>* * Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with "remove" and include your "original email address / addresses" in the subject heading. Include complete address/addresses and/or domain to be removed. We will immediately update it accordingly. We apologize for the inconvenience if any caused. -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" 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.com/group/open-source-j2ee-frameworks?hl=en.
