PROFESSIONAL SUMMARY:

• Having 10 years of IT experience in Data Warehousing Development and migration projects in which, 6+yrs of experience in ETL (Informatica - power Center, Abinitio) development, 2yrs of experience in Informatica Data Quality 9.5.1 and 2yrs exp in Informatica Administration.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse. Extensively used Abinitio and Informatica client tools - Source Analyzer, Warehouse designer, mapping designer,
• Having experience on Data quality & Data profiling by using Informatica Developer suite.
• Strong knowledge of Dimensional Data Modeling concepts, Star/Snowflake Schema Modeling, Entity-Relationship Modeling, FACT & Dimension table’s Physical & logical designs, etc. Proficient in Data Extraction, Transformation, Data Cleansing, Data Profiling, Data Quality and Loading techniques to build scalable, end-to-end Data Warehouse and Data Marts
• Having production support experience on TWS/UNIX/TERADATA environment
• Hands-on experience in Informatica Power Center 9.5.1 Administration
• Strong experience on Deployment of Informatica objects from one environment to another.
• Regularly Coordinating with the onsite, offshore team and the client to understand requirements, analyze scripts provided by them and develop specifications.
• Having good knowledge in MasterDataManagement Siperian tool.
• Ensuring project completion within specified time and in compliance with quality norms and delivering it to the Onsite team.
• Prepared the Database change requests document.
• Prepared the work estimates, and managing the resources
• Prepared Business required documents, LLD for offshore team
• Prepared test plan documents, test cases, Test scripts for Development & Migration project and tested accordingly
• Experience in design and development of various frameworks and conducting POCs.
• Having the hands-on experience on CLOUD (sales force) Computing.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Informatica 9.5.1, Oracle, Teradata, TWS

Lead/Infrastructure Administrator

Responsibilities:

• Coordinating with clients, interfacing teams, database Administrators to get a detailed understanding of existing functionality and system requirements
• Working as Onshore Lead and managing offshore team for coordinating issues and helping resolves issues to the client
• Prepared the work estimates, and managing the resources Confidential onshore
• Prepared Business required documents, Prepared test plan documents, test cases, Test scripts for Development & Migration project and tested accordingly
• Ensure that all the environments are in sync.
• Script review and porting to target environment.
• Support Data Migration activities, Provide post production support and consultancy.
• Worked as Infrastructure Administrator and managed 45 application from Infrastructure team, Worked along with Tier 1/Tier2 support teams and managed multiple application infrastructure of about 45-50 servers(Unix/Linux).
• Responsible for Informatica services installation and testing in multiple environments
• Installed Power Centre Informatica v9.5.1 on LINUX
• Upgraded Informatica environment from 9.1.0 Hotfix 1 to 9.5.1 Hotfix 5
• Used Informatica as an ETL tool and Migrated code from Dev to QA, QA to Prod

Confidential, Irwing, TX

Environment: Informatica 9.5.1 & Teradata

Module Lead

Responsibilities:

• Analyzing the requirement given by client and Responsible for design and development of Data Warehouse project leveraging Informatica Power Center ETL tool
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Sequence generator, Joiner transformations Created Test plan documents and test scripts and tested SIT/UAT Environment.
• Carrying out User Acceptance Testing of the codes.
• Played key role in Development environment
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Providing daily status updates to the Onsite coordinator.

Confidential

Environment: Sql Server 2008, Informatica 8.5

Data Analyst

Responsibilities:

• Designed and developed Process Code update mapping by using Informatica
• Designed and developed Domain Check mappings
• Created One shot file documents as per the new feed
• Created test plan documents and test scripts for one shot files and tested accordingly
• Regularly coordinating with Onsite and Offshore team

Confidential

Environment: Informatica 9.5.1 & TeraData, TWS

Responsibilities:

• Analysis of Functional Specification
• Designed and development of ETL mappings using Informatica.
• Testing and Test plan preparation
• Implement Indexing Technique on the Framework
• Deployment of informatica objects from one environment to Another Best Practices Documentation
• Managing the Serena to follow up the issues, and promoting the new code from

Confidential

Environment: Ab intio2.14,co ops1.14,Unix

Data Analyst

Responsibilities:

• Designed Data Element Mapping Document for Collections Phase-I.
• Prepared Data Validation Test Case Documents for Phase-I and Phase-II.
• Created Data Validation Test Scripts for Phase-I and Phase-II Validated files.
• As per business rule written many complex sql scripts for all Phases (DEV, SIT And UAT).
• Coordinated with Onsite and Offshore ETL Team Confidential the time of SIT and UAT.
• Validated the Data and generated the reports for user

Confidential

Environment: DataStage7.5, DTS on SQL Server 2000

Sr Developer

Responsibilities:

• Designed and developed Simple, Medium DTS Packages, and Complex Data Stage Jobs based on user requirements to lead data from subscribeV4 Data to SubscribeV6 structure.
• Prepared Test Plans for Unit Testing and tested packages with Unit test plan
• Strategies and prepared test result documents.
• Created Sql Scripts for Drop and Creating Indexes Dynamically.
• Created Sql Scripts for Disable and Enable Triggers Dynamically.
• Prepared Test Plans for Unit Testing for Pre and Post Validation Stream and tested Validation Scripts with Unit test plan.
• Prepared the Database change request document
• Strategies and prepared test result documents.
• Direct interaction with clients for change requests and modifications.
• Given knowledge Transfer on Data Stage for new team members.
• Written BCP commands for V4 to V6 Package.

Confidential

Environment: Informatica 9.5.1 & Teradata, TWS

Sr Developer

Responsibilities:

• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to lead data from source and RDBMS tables to target tables.
• Ensuring project completion within specified time and in compliance with quality norms and delivering it to the Onsite team.
• Involved in detail design and development of mappings using Informatica.
• Extensively involved in Data Extraction, Transformation and Loading (ETL Process) from source to target systems using Informatica.
• Worked on connected as well as unconnected Lookup transformation to look up values in a table
• Used most of the Transformations such as Source Qualifier, Expression, Joiner, Router, Update Strategy, Filter, and Unconnected Lookups.