Sql Server Data

VINUTHA KOLLI

Sr. Informatica Developer

Office: 408-***-****

*****@*************.***

SUMMARY

• Over 7+ years of IT experience with a strong background in SDLC, Data Integration tool Informatica PowerCenter, Informatica PowerExchange.

• Expertise in Informatica Power Center 9.x/8.x/7.x/6.x extracting data from Oracle, SQL Server and DB2 databases.

• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.

• Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.

• Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas.

• Very skilled in development of Informatica Mappings and Informatica Workflows.

• Experience with Informatica Advanced Techniques like Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.

• Extensively involved in Optimization and Performance Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and partitioning.

• Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in SQL Server 2000/2005, Oracle 10g/9i/8i and DB2.

• Expertise in Unix Shell Scripting and experience on different UNIX platforms.

• Experience in scheduling of ETL jobs using Crontab, Autosys and Appworx .

• Knowledge in developing reports using Business Intelligence tools like Business Objects and Cognos.

• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.

• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.

• A highly motivated self-starter and a good team-player with excellent verbal and written communication skills.

Contact this candidate