*Please send your requirements to [email protected] <[email protected]>*
Hi, I have an excellent ETL / Informatica consultant available. If you have any positions open with your Vendors / Clients, please send it to us. FYI, below is the summary of my consultant. Highly Motivated IT professional with *7 Years* of experience in IT Industry with *more than 6*years in Business Requirement Analysis, Application Design, Data Modeling, ETL Development, Implementations and Testing of *Data Warehousing* and Database business systems for *Financial, Insurance, Retail* Industries. * Summary:* · Data Warehousing: Over 7+ years of hands on experience in *ETL*and *Data Integration* for developing ETL mappings and scripts using *Informatica Power Center 9.5/9.1/8.6.1/8.6/8.1/7.1* using *Designer, Repository Manager, Workflow Manager & Workflow Monitor*. Exposure on Power Exchange functionality · Involved in understanding client Requirements, Analysis of Functional specification, Technical specification preparation and Review of Technical Specification - Extensive experience in creating Transformations and Mappings using *Informatica Designer* to implement business rules and processing tasks using *Workflow Manager* to move data from Multiple Sources into Targets. - Expertise in working with various transformations using *Aggregator, Data Masking, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, XML, Stored procedure* in InformaticaPowerCenter Designer. - Experience in*Performance Tuning* and *Optimization* of the Sessions and Mappings. · Proficiency in data warehousing techniques for Data Cleansing, *Slowly Changing Dimension* Phenomenon. · Install PowerCenter software, administer repositories and provideapplication support for Institutional Business, Individual Business Broker Dealer and Auto & Home line of business - Experience on Informatica Administration activities. · Strong RDBMS concepts and experience in creating, maintaining and tuning Views, *Stored ProceduresUser Defined Functionsand System Functions using SQL Server, T-SQL*. · Wrote *PL/SQL **procedures*, SQL scripts, and SQL*Loader control files for creating a development database - Expertise in creating *Stored Procedure/Functions, *Triggers and Packages in Oracle 9i/10g. · Databases: Experience in handling various Data sources like *DB2(9.x/8x),Informix,ORACLE (11/10/9g), Teradata,SQL Server 2008/2003/2000, MS Access, Ms Excel*. · Experience in using Erwin to design Logical/Physical Data Models *.* · Data Modeling: Extensive experience in Analyzing the *Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data*. · Reporting: *OBIEE 10g,Business Objects 3.1.* · SDLC: Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support. · Experience working in multiple functional areas including Banking,Sales, Broker dealer ,Marketing and CRM. · Coordinate ETL and database development work with developers and conduct code reviews - Exposure knowledge of *Informatica Migration* and Upgrade. - Experience in Scheduling tools like *AUTOSYS*. · Other: Knowledge of *UNIX shell scripting* job scheduling on multiple platforms. · Excellent individual and team performer maintains high levels of communication with Business Analysts and end users to enable better team performance. -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/groups/opt_out.
