SUMMARY

• Thirteen years of diversified experience in the field of Information Technology and Data warehousing using Informatica PowerCenter. Developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica.
• Extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Analysis, Design, Development, Testing, Maintenance and Enhancement in variety of technological platforms with special emphasis on Data Warehouse and Business Intelligence applications.
• Complete understanding of Soft Ware Development methodologies like waterfall, Agile etc.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica PowerCenter .
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Good knowledge in OLAP and OLTP process.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies
• Extensively provided end to end 24/7 Production Support by monitoring data into a complex highvolume environment using Quick Base ticket logging system.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multi-dimensional modeling.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
• Experience in Performance tuning of the Informatica and Oracle.
• Expertise in implementing complex Business rules by creating complex mappings / mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• As part of OAT (Operational Acceptance Testing ), moving processing Prod data to different lower level UAT environments (Other Production Like Environments) as requested by the clients.
• Extensively worked on L1 & L2 production support related issues and analyses issue priority and address to L3 team with details and follow up on items.
• Responsible for creating conference calls for groups to discuss incidents that are production related, time or scheduled related incidents.
• Coordinate with DEV teams and work with support teams to move fixes to production.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer
• Experience in working with Informatica Admin team on installing Informatica server, power center client in Development, QA and Prod machines.
• Experienced with working on Onshore Offshore Support Model and shifts.
• Experience in working with production support team and Change management and Incident Management and Deployment Management teams.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Extensively worked on various databases including Oracle 10g, SQL Server, DB2, and Teradata.
• Experience in Integration of various data sources like Oracle, SQL Server, and Flat Files
• Extensively worked with SQL loader for bulk loading into the oracle database.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.
• Willing to relocate: Anywhere
• Authorized to work in the US for any employer

TECHNICAL SKILLS

Data Warehousing: ETL Informatica PowerCenter 9.x/ 8.x/7.x/6.x/5.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Repository, Metadata, Data Mart, OLAP, OLTP..

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flack, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERWIN

Databases: Oracle … Sybase, MS SQL Server … DB2 8.1.

Programming: SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization, Perl

Tools: TOAD,, SQL Developer, Excel, Word, PuTTY, WinSCP, Notepad++

Reporting Tools: Microstrategy, OBIEE, Cognos

Environment: UNIX, Windows XP/Vista

Methodologies: SDLC, Agile

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 9.6.1.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 9.6.1
• Conducted performance tuning to increase performance of the mappings, sessions & workflows.
• Used PL/SQL with Informatica Power Center 9.6.1 for Oracle 11g database.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.
• Worked with complex mappings, mapplets, worklets and transformations Implemented SQL/PLSQL Stored Procedures/Functions.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data using the debugger.
• Developed, implemented and enforced ETL best practices standards.
• Performance tuning and bottleneck resolution.
• Created and Implemented Reusable tasks like E-mail.
• Involved in logical and physical data modeling and analyzed and designed the ETL processes
• Involved in the documentation of the project like TDD( Technical Design Document)
• Prepared the change request Plan and update the status of the change request to the onshore with progress and achievements.
• Worked in different support activities when needed.

Environment: Informatica Power Center 9.6, Oracle 11g, SQL Assistant, MS UNIX, Perl Script, Win CVS, Putty, SQL Developer, MS Xcel, Flat files.

Confidential

Technical Lead

Responsibilities:

• Worked closely with the Business analysts and attended meetings to gather and discuss the requirements for enhancements and defect fixes for various projects
• Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
• Resolved Production issues and helped in promoting the code to different environments for testing needs and participated in the deployment group.
• Participate in project status meetings, peer reviews and other events with developers to get the status of the deliverables.
• Analyzed and Identified the Tables/Views, Procedures and ETL objects that need to be migrated and prepared necessary Documentation.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's.
• Provided support and quality validation through test cases for all stages of Unit and Integration testing.
• Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in migrating objects to different environments using Deployment groups and Labels.
• Prepared various documents like ETL Specification doc, Technical Design doc, Run Book etc.
• Worked with Informatica Partitioning when dealing with huge volumes of data and worked on parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Creating and modifying existing Technical Design Specification document and other client deliverables for different releases.
• Coordinated and interacted with other teams to maintain integrity in performing the tasks and execution of the loads appropriately in a timely manner.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL Developer, UNIX, Notepad+ +, WinCVS, Putty, Flat files.

Confidential

Module Lead

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Participated in reviewing requirements during analyze and ensuring that sufficient details is available going into the design phase.
• Developed ETL Mappings using Informatica PowerCenter 8.1 involving extraction and loading of data from Informix Database to Oracle.
• Worked with Informatica PowerCenter-server, Repository Manager, Designer, server Manager, Informatica Server.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor
• Test the Informatica mapping and workflows against the specifications on the detailed design.
• Participate in project status meetings, peer reviews and other events with developers to get the status of the deliverables.
• Creating and modifying existing Technical Design Specification document and other client deliverables for different releases.
• Extensively worked in the Performance Tuning of the programs, ETL Procedures and processes.
• Developed Pre-Session and Post-Session UNIX scripts to automate the data load processes to target Data warehouse.
• Extensively used parameter files to avoid hard-coding in mappings to facilitate possible future changes thereby saving migration times.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Monitoring the ETL production jobs and resolved the issues/bugs.
• Identified sources, targets, mappings and sessions and tuned them to improve performance.

Environment: Informatica Power Center 8.1, Informx, Oracle 10g, SQL Developer, UNIX, Notepad+ +, WinCVS, Putty, Flat files.

Confidential

Analyst

Responsibilities:

• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's.
• Provided support and quality validation through test cases for all stages of Unit and Integration testing.
• Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in migrating objects to different environments using Deployment groups and Labels.
• Prepared various documents like ETL Specification doc, Technical Design doc, Run Book etc.
• Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
• Resolved Production issues and helped in promoting the code to different environments for testing needs and participated in the deployment group.
• Participate in project status meetings, peer reviews and other events with developers to get the status of the deliverables.
• Creating and modifying existing Technical Design Specification document and other client deliverables for different releases.
• Coordinated and interacted with other teams to maintain integrity in performing the tasks and execution of the loads appropriately in a timely manner.

Environment: Informatica Power Center 6.1, Oracle 10g,Toad,UNIX, Notepad+ +, WinSCP, Putty, Flat files.