*Professional Summary:* · Over 8 years of IT experience with a strong background in SDLC, Data Integration tools including Informatica PowerCenter, Informatica PowerExchange.
§ Experience in developing and maintaining Data Warehouse applications using INFORMATICA Powercenter. § Developed complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extract data from various sources and load into target tables. § Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development. § Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica – Power Center Client tools - Designer, Repository manager, workflow manager/monitor and Server tools – Informatica Server, Repository Server manager. § Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation etc. § Excellent hands-on ETL Informatica Power Center (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer) and Repository Manager, Workflow Monitor. § Strong knowledge in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies. § Strong Knowledge in Data Exchange, MDM, IDQ, Data Transformation, SQL development, Data marts. § Hands on Knowledge on designing Informatica MDM Maps for current Vs future use. § Excellent understanding of Software Development Life Cycle (SDLC). § Strong Oracle database experience using Indexes, Triggers and Views. Highly proficient in large volume data migration to Enterprise Data. § Implemented various Performance Tuning techniques on Sources, Targets, Mappings and sessions. § Hands on experience in tuning mappings, identifying and resolving performance in various levels like sources, targets, mappings, and sessions. § Extensively worked on data warehousing and decision support systems with relational databases such as Oracle design and database development using SQL, PL/SQL, SQL PLUS, TOAD, and SQL-LOADER. Highly proficient in the integration of various data sources involving multiple relational databases like Oracle 11g/10g/9i,MS SQL Server,DB2,COBOL Files and Flat Files. § Experienced in supporting end-user reporting needs using Informatica. Efficiently involved in interacting with Business Analysts, Department Managers and Business Users. Competence to Manage and deliver results on multiple tasks by effectively managing time and priority constraints. Ability to address any ongoing or changing Business needs. § Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel. *Technical Skills**:* *ETL Tools*: Informatica 9.x/8.x/7.x/6.x Informatica Power Exchange *Databases*: Oracle 11g/10g/9i/8i, DB28.x, SQL Server 2006/2007 *Languages*: SQL, PL/SQL, SQL-PL, XML *Operating Systems*: UNIX (SOLARIS, AIX), Linux, Windows 95/98/NT/2000/XP and DOS *DB Tools*: SQL Plus, SQL Loader, Toad, I-SQL, DB Visualiser, Power Designer *Others*: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word) *Desktop Tools* *Kindly send the job description to kva...@vigiboss.com <kva...@vigiboss.com>* *I extend the best of my wishes to you……… * *Lal K Vamsi* *Manager* *Vigi**boss* *Inc.* *Email ** : **kva...@vigiboss.com* <kva...@vigiboss.com> *Phone ** : (1) 774-277-3305* *http://www.vigiboss.com/* <http://www.vigiboss.com/> *http://www.linkedin.com/in/jlkvamsi <http://www.linkedin.com/in/jlkvamsi>* -- You received this message because you are subscribed to the Google Groups "Powerbuilder Assignments" group. To unsubscribe from this group and stop receiving emails from it, send an email to powerbuilder-assignments+unsubscr...@googlegroups.com. To post to this group, send email to powerbuilder-assignments@googlegroups.com. Visit this group at http://groups.google.com/group/powerbuilder-assignments. For more options, visit https://groups.google.com/d/optout.
