SUMMARY

• 9+ Years of professional experience with expertise in Support, Design, Development, Maintenance, Data Conversion and Implementation of Data warehouse applications and Database business systems.
• 9+ Years of experience in Informatica Administrator/Developer.
• 9+ years of ETL experience using Informatica Power Center 9.x/8.x. Expert level skills in developing strategies for extraction, transformation and loading mechanism architect.
• Experience in 24X7 production support, ETL executions and resolving root causes.
• Strong experience in installation/up - gradation of Informatica(Power center,IDQ,TDM).
• Strong experience in entire life cycle of Data warehouse/Data mart using Informatica Power Centre (Designer, Workflow manager and Workflow monitor, Repository manager).
• Experience in architecture, Design, and Implementation of leading metadata vendor solutions implementing adaptive metadata manager.
• Expertise in Asset Management, Maintains records and databases containing information regarding licenses, warranties, and service agreements for the organization's hardware and software. Minimizes organizational cost through product standardization and tracking. Tracks quality throughout the product lifetime.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in working with execution of the scheduled jobs by using Tivoli and Redwood Scheduling tools.
• Experience with relational and dimensional models using Fact and Dimension tables.
• Efficiently used IBM Change Data Capture (CDC) for daily sync of the data from source tables to Stage tables.
• Hands on experience with Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
• Expertise in team collaboration and documentation.
• Having strong Experience in Onsite offshore Model.
• Strong experience in Business Intelligence tools.
• Versatile team player with excellent analytical, communication and presentation skills.

TECHNICAL SKILLS

ETL tools: Informatica Power Center 9.x/8.x/7.x and Change Data Capture (CDC), IDQ, TDM.

Database and related tools: Oracle 12.x/11g/10g/9i, MS SQL Server. 2016/2014/2012/2003/2000 , MS Access 2000, SQL Assistant

BI and Scheduler tools: Cognos 10.x/8.x,Tivoli, Redwood and Control-M, SSRS.

Programming: SQL, SQL*Plus, Python, UNIX shell scripting, C, C++ .

Operating Systems: UNIX (Sun Solaris 5), Red Hat LINUX, AIX (5.X)/AIX 6.1.

Web Development: XML, HTML5

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

Informatica Administrator/Developer

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Designed various mappings using Informatica Designer to load Dimensions and Facts.
• Installed Informatica 9.x .
• Upgraded Informatica 9.0.1 to 9.1.0, 9.1.0 to 9.5 and 9.5 to 9.5.1 and 9.5.1 to 10.1.
• Involved in creation of folders/user permissions.
• Handled other Informatica administration activities.
• Created mapplets to use them in different mappings.
• Used existing ETL standards to develop these mappings.
• Created various Workflows, worklets and Sessions for the mappings to run.
• Used various transformations like Aggregator, Joiner, Expression, Filter and Router, Lookup, Update Statergy, Sequence Generator to transform the data.
• Modified existing mappings for enhancements of new business requirements.
• Used the ETL standards to load the Dimension and Fact tables daily by scheduling the workflow using informatica scheduler.
• Implemented adaptive metadata manager for information management.
• Extensively worked as production support developer to identify and fix data problems.
• Created technical support documentation for the team for production support.
• Worked on the three tier model (DEV, TEST, and PRODUCTION).
• Followed standard procedures to migrate the mappings from Development to Test and Production environments.
• Involved in problem solving skills pertaining to maintenance on existing mappings
• Used the email task in the Production to keep the team posted when session’s fail.
• Created stored procedures to implement the logics and using them in Informatica.
• Extensively used environments to create shell script and maintaining the logs of Informatica admin console.
• Maintains records and databases containing information regarding licenses, warranties, and service agreements for the organization's hardware and software. Minimizes organizational cost through product standardization and tracking. Tracks quality throughout the product lifetime.

Environment: Erwin, Informatica Power Center 9.x, Control-m, DB2, Flat files, TOAD, Oracle 11g/10g, UNIX and Windows 2010.

Confidential, Atlanta, GA

Informatica Consultant

Responsibilities:

• Working as a Informatica Consultant.
• Working with Informatica Power Exchange (CDC and Mainframe Cobol Files).
• Define the Naming Standards and Standard process for Informatica.
• Installed and upgraded Informatica 9.6.1 and 10.1.
• Installed and configured Informatica IDQ,MM and MDM.
• Setup Informatica AD Authentication.
• Configured Informatica HA Setup.
• Performed the Setup of DR Servers.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Applied Informatica Patches to the Informatica servers.
• Troubleshooting the issues in Informatics.
• Involved and resolving the issues (Tickets) in Informatica Power center.

Environment: Informatica Power Center 10.x/9.x, MM,MDM,IDQ and Power Exchange, Control-M, Oracle 10g, SQL*Plus, TOAD 8.5, Windows XP, Linux.

Confidential, Orange County, CA

Informatica Administrator/Test Lead/On-site Coordinator

Responsibilities:

• Worked as Informatica Administrator/Developer.
• Define the Naming Standards and Standard process for Informatica.
• Provided Best recommended solutions/change the process to minimal the Cost for the projects.
• Installed Informatica 8.5.1, 9.0.1 and 9.6 .
• Installed control-M servers and agents.
• Upgraded Informatica 8.1.1 to Informatica 8.5.1 and 9.0.1, 9.6 .
• Applied Informatica Patches to the Informatica serversDeveloped complex mappings in Informatica to support for Health Care Enterprise application.
• Developed complex scripts for the follow the Business requirements.
• Troubleshooting the issues in Informatica.
• Migrating the Cognos reports from one environment to another environment.
• Troubleshooting the issues in Cognos reports.
• Involved and resolving the issues (Tickets) in Informatica Power center.

Environment: Informatica Power Center 8.x/9.x, Tivoli, SQL Server 2003, XML, PL/SQL, SQL*Plus, TOAD 8.5, Windows XP, AIX.

Confidential, Houston, Texas

Informatica Administrator/Developer

Responsibilities:

• Working as Informatica Administrator/Developer.
• Playing a role as Technical lead.
• Installing and configuration of Informatica 9.x on UNIX.
• Having Experience in Allocation of space on Sun Solaris server for various operations to the ETL
• Migration of Informatica Repositories (DEV-UAT, UAT-Prod).
• Upgrading the Informatica Repositories from 8.x to 9.x.
• Given the Informatica supporting for all the applications in Credit-Suisse.
• Involved and resolving the issues (Tickets) in Informatica Power center.
• Giving L2/L3 Support for all applications in Credit-Suisse.
• Giving 24/7 Production Support for all application.
• Mapping the source and target databases by studying the specifications and analyzing the required transforms.
• Involved in Performance Testing of Jobs.
• Troubleshooting day to day database issues.

Environment: Informatica 9.x, UNIX (Sun Solaris), Oracle 10g,PL/SQL,TOAD 8.x,Window XP

Confidential

ETL/Data warehouse Developer

Responsibilities:

• Worked as a Team member/Informatica Administrator.
• We are testing the Informatica code according to the new releases.
• We are handling 3 test environments for testing the code in parallel.
• Transformed data from source system to target.
• Writing the queries on metadata level to figure it out the standards.
• Implementing the standards in the release basis.
• Migration of objects from DEV-ST, and ST - PROD.
• Handling the issues in the Informatica level.
• Creation of folders/user permissions.
• Handling other Informatics administration activities.
• Developed shell scripts to automate the update process.
• Executed Workflows and Sessions using Workflow Monitor.
• Involved and resolving the issues (Tickets) in Informatica Power center.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency

Environment: Informatica Power Center 8.5, Tivoli, SQL Server 2008, XML, PL/SQL, SQL*Plus, TOAD, Windows XP, AIX.