*Hello Business Partners* * GREETINGS FROM VIRGO INC*
* Let me know if you have any opening Positions for my below Available Consultants!!!! * *(Note: Our consultants are authorized to submit only to your direct clients or prime vendors. Third party layers are strictly prohibited)*** loc: VA visa: H1b available Immediately *Professional Summary:* · *Over 7 years *of IT experience in the *Analysis, design, development, testing *and Implementation* *of Business Intelligence solutions using* Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server * applications*.* · Extensive *ETL *experience using* Informatica 8.1/7.1/6.2/5.1* (*Power Center/ Power Mart) *(Designer, Workflow Manager, Workflow Monitor and Server Manager) · Experience in Dimensional Data Modeling using *Star and Snow Flake Schema*. · Designed data models using *Erwin*. · Experience* *in Business Intelligence in generating various reports using business Intellignece tool *Cognos.* · Extensive experience in *Extraction, Transformation and Loading*of data from multiple sources into Data warehouse using Informatica. · Proficient experience in different Databases like* Oracle, SQL Server, DB2 and Teradata* · Expertise in Developing *PL/SQL Packages*,* Stored Procedures/Functions, triggers.* · Expertise in utilizing Oracle utility tool *SQL*Loader *and expertise in *Toad* for developing Oracle applications. · Extensively worked on *Dimensional modeling*, Data cleansing and Data Staging of operational sources using ETL processes. · Extensive* *Working experience in applying* *Relational Database concepts,* *Entity Relation diagrams and Normalization concepts. · Experience in *Performance Tuning* of sources, targets, mappings and sessions. · Automated and scheduled the Informatica jobs using *UNIX Shell Scripting.* · Experience in all phases of Software Development life cycle. · Application Data warehousing experience in *Banking, Pharmaceutical, Insurance* and *Telecommunications.* · Performed Unit, Integration and System Testing. · Good analytical and problem solving skills. · Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time. * * *EXPERIENCE:* *Sr. Informatica Developer:* *Responsibilities:* · Responsible for Business analysis and requirements gathering. · Involved in Designing *Logical and Physical Data model* using Erwin* *Tool. · Involved in creating the *design and technical specifications* for the ETL process of the project. - Worked on *Informatica* *Power Center tool* - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer. - Development of mappings as per the technical specifications approved by the client. - Developed *mappings* using Informatica *Power Center Designer* to transform and load the data from source systems to target database. - Worked on various types of transformations like *Expression, Joiner, Update strategy*, Aggregator, Filter, Lookup - Worked on different sources like Oracle, flat files. - Created* Mapplets *to reduce the development time and complexity of mappings and better maintenance. - Implemented performance tuning logic on *targets, sources, mappings, sessions* to provide maximum efficiency and performance. - Implemented the *Slowly Changing Dimension Type 2* methodology to keep track of historical data. - Created various *stored procedures* for dropping and recreating indexes on target tables. - Involved in *enhancements, * *maintenance* activities of data warehouse including performance tuning - Used *mapping variable *for imparting flexible runs of workflows based on changing values. - Involved in the debugging of the mappings by creating break points to gain trouble shooting information about data and error conditions. - Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards. - Performed *Unit testing* and created Unix Shell Scripts & Cron jobs and provided on call support. - Preparation of *UTP *(*Unit Test Plan)* with all required validations and test cases. *Environment:* Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 10g, SQL Server 2005, Erwin 4.0, UNIX, Windows 2000, TOAD. *Thanks & Best **Regards**,* * **Kumar M.A.* *Virgo, Inc || "Technology Leaders"|| 333 N Oxford Valley Road ||* *Suite 405 Fairless Hills || PA 19030 || Fax: (805) 926 4256 || * *Ph: 215-310-1562 Ext 214||* *Email: [email protected] <[email protected]>**||* *Web: www.virgosystemsinc.com* *Yahoo ID: **kumar.virgo* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "jobinusa" 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/jobinusa?hl=en -~----------~----~----~----~------~----~------~--~---
