SUMMARY

• Total 7 years of experience in IT Industry.
• Worked as an Informatica Administration for large data warehouse projects using Informatica versions (Power Centre 8, 9).
• Good in doing UPGradation from lower to high versions(8.x to 9.1 and 9.1 to 9.6).
• Good knowledge on Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Experience in Installing Informatica power center on Linux, including upgrading versions and applying hotfixes/patches.
• Good knowledge on C and C++.
• Extensively worked in Informatica backup and Restore from DEV environment to other environments like QA, UAT, PREP and PROD.
• Good experience in creating multiple Informatica connections like (DB2, Oracle, SQL and Teradata etc.)
• Good At Installing Power Exchange to convert COBOL Files to Informatica Understandable.
• Proficient in importing teh Informatica objects.
• Identify, troubleshoot, and resolve complex production environments (Informatica Application, Databases, etc.) reported through monitoring systems, support teams, and trouble tickets as per established SLAs.
• Installed B2B,MFT and troubleshoot infrastructure related issues.
• Good at Configuration of MRS, DIS, AS and troubleshooting IDQ related issues.
• Good knowledge On Test Data Management Installation and configuration.
• Expertise in tuning teh performance of mappings and sessions in Informatica and determining teh performance bottlenecks.
• Basic knowledge of installing MFT and TIBCO.
• Good experience in Outages Handling and communicating wif different teams at teh outage time.
• Proficient in Infrastructure Support.
• Understanding of various support process like Incident, Problem, Change and Release Management.
• Strong understanding of ETL, data structures, data flow, data patterns, and data governance in depth knowledge of Informatica.
• Proficient experience to work job scheduling tool like Crontab and Know about control-M but never worked. .
• Collaboratively worked wif Offshore & Onshore Teams wif good communication skills.
• Extensive knowledge on Healthcare, Retail & Pharmacy industry.
• Self-motivated team player wif good communication skills, analytical and problem solving skills.
• Follow best practices and quality control wif CMM Level 5 processes.
• Skilled in authoring technical documentation and performing reviews.
• Ability to work independently or collaboratively.

TECHNICAL SKILLS

Industry Skills: Pharmaceutical,Retail,Health care and HVAC

ETL’s & Utilities: Informatica Power Center 8.6/9.1/9.5.1/9.6.0, IDQ and TIBCO

Language: C, CPP,SQL and Shell

Database: Oracle 11g/10g/9i/8i,DB2UDB 9.7, Teradata and SQL Server 2008

Operating Systems: UNIX (Sun Solaris, AIX, HPUX, Linux), Windows NT/2000

Tools: Control-M,crontab,TOAD, Putty, SQL Developer,Power Center Designer,Repository Manager,Workflow Manager,Workflow Monitor,Power Center Visio and Jenkins.

PROFESSIONAL EXPERIENCE

Confidential, El Segundo, CA

Informatica Administrator

Responsibilities:

• Installed and upgraded Informatica Power Center 9.1/9.6/9.6.1 in a good number of servers.
• Installed and Configured Informatica B2B.
• Installation and Configuration Knowledge of IDQ, TDM and troubleshooting teh issues.
• Creation and maintenance of Informatica users and privileges.
• Created Groups, roles, privileges and assigned them to each user group.
• Repository Service Backup, Migration and restore between DEV, QA and PROD environments.
• Coordinated wif UNIX and Database Administrators.
• Identify root cause and implement resolution for production processing issues.
• Collaboratively worked wif Application Support Team, Network, Database Teams, and UNIX teams.
• Worked wif Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.
• Created shell scripts to take backup of teh repositories.
• Good at scheduling repository Backup scripts using Crontab.
• Responsible for Unit testing and Integration testing of mappings and workflows
• Monitoring teh loads (workflows) whether teh loads are running as scheduled.
• Responsible to manage Development, QA and Production environments.
• Working in Agile Environment.

Environment: Informatica powercenter 9.1/9.6/9.6.1/ Oracle11g/Linux/AIX/B2B/IDQ and knowledge on Scripting .

Confidential, Chicago IL

Informatica Administrator

Responsibilities:

• Worked as a Informatica Administrator
• Installing and configuration of Informatica 8.x/9.x on UNIX.
• Optimized Informatica mappings for performance at transformation level, mapping level and session level.
• Wrote Stored Procedures and integrated them through PowerCenter Stored Procedure Transformation.
• Migrated mappings and sessions to production as per instructions specified in teh document
• Monitored teh Informatica loads
• Performed failure analysis for Informatica loads using error logs
• Assigned permissions and privileges to objects
• Written SQL overrides in source Qualifier according to business requirements.
• Experience in writing UNIX scripts.
• Tuned various mappings for optimum performance to reduce teh load time for sessions and workflows.

Environment: Informatica Power Center 8.1/9.1, Flat files, DB2,Erwin, SQL Server 2005,SQL Server 2008, Xml, SAP, SQL,SQL*PLUS,PL/SQL,UNIX.

Confidential - Hoffman Estates, IL

Informatica Administrator

Responsibilities:

• Installed and configured Informatica Power Center 9.1.
• Configured Load balancing and High availability of Informatica.
• Creation and maintenance of Informatica users and privileges.
• Created Native Groups, Native Users, roles, and privileges and assigned them to each user group.
• And if teh user is new user tan it needs to add teh user information to teh safe site which a place to store all teh infrastructure passwords.
• Developed a standard ETL framework to enable teh reusability of similar logic across teh board. Involved in System Documentation of Dataflow and methodology.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using teh PowerCenter.
• Written pre session and post session scripts in mappings.
• Created deployment groups and assigned teh permissions to teh deployment group.
• Created Informatica Folders and assigning teh permissions to teh Folders.
• Created OS profiles for teh user which used to run teh applications.
• Migration of Informatica Mappings/Sessions/Workflows from Dev to Test and Test to Stage and Stage to Prod environments.
• Coordinated wif UNIX and Database Administrators for creating OS profiles and file systems.
• Handled outages when there is any maintenance in UNIX and DATA BASE.
• Collaboratively worked wif Application Support Team, Network, Database Teams, and UNIX teams.
• Bouncing Activities or Restarting teh Service in Network Changes or in any maintenance and Communicating to Business.

Environment: Informatica powercenter 9.1 HF4/Oracle 11.2.0.3.0/ Linux

Confidential -Englewood cliffs, NJ

Informatica Administrator

Responsibilities:

• Handling a huge Production Support Environment and halps in teh smooth working of teh system and make permanent fixes to stable teh system.
• Creation of Informatica users, granting privilege to users, creation of Groups granting privileges to groups
• Creation of Folders and Granting permissions to teh Folder.
• Starting teh Repository servers, Repositories and Informatica servers.
• Informatica backup and Restore from CM to QA and CM to PREP, PROD.
• Hot fixing teh Objects.
• Configuring Connections SAP, Oracle and SQL Server.
• Worked wif saprfc.ini and sideinfo files for SAP connectivity.
• Administration and configuration of Informatica Servers.
• Assigning teh Informatica servers to teh workflows. And scheduling teh workflows.
• Informatica troubleshooting.
• Interacting wif different markets across teh globe for teh Dev, QA and CM, PREP, PROD environment issues related wif Infrastructure.
• Resolving issues related to all teh Markets and halping teh markets to setup teh Infrastructure for their Pre Prod and Prod activities till GO LIVE.

Environment: Informatica powercenter 8.1/8.6, DB2 v7.2, v8.1, Oracle 9i, AIX 5.1

Confidential

Informatica administrator

Responsibilities:

• Worked as a Team Administrator
• We are testing teh informatica code according to teh new releases
• We are handling 3 test environments for testing teh code in parallel.
• Transformed data from source system to target.
• Writing teh queries on metadata level to figure it out teh standards
• Implementing teh standards in teh release basis.
• Migration of objects from Dev-SIT, SIT - PPE and PPE - PROD
• Handling teh issues in teh informatica level
• Creation of folders/user permissions.
• Handling other informatica administration activities
• Upgrading teh Informatica Repositories from 6.x to 7.x.
• Giving L2/L3 Support for all applications.
• Giving 24/7 Production Support for all application.
• Involved and resolving teh issues (Tickets) in Informatica Power center.

Environment: Informatica PowerCenter 8.x, Oracle 10g, Teradata, SQL Server, Flat files, Sql loader, UNIX Shell Scripts.