EXPERIENCE SUMMARY:

• Nearly 9 years of experience as an Informatica Administrator with US leading banks Confidential and Confidential .
• Completed setting up all the Informatica products on new Informatica Power Centre 10.1.1 compatible versions and taking them further till production.
• Metadata Manager (MM)
• Test Data Management (TDM)
• Address Doctor
• Data Validation Option (DVO)
• Reference Table Manager (RTM)
• Proactive Monitoring for Power Centre (PMPC)
• Reporting and Dashboard Services (RDS)
• Worked on building both Informatica Power Center 10.1 Advanced edition and Power Center 10.1.1 Big Data edition.
• Working with Hadoop DBAs for setting Informatica installation required at their end.
• Worked on setting Kerberos authentication to allow Informatica - Hadoop connectivity as Cloudera needs to be accessed via Kerberos as per BOA standards.
• Worked on setting PowerExchange server components for Sales Force and LDAP and registering their plug-ins in Admin consoles.
• Worked for migration of BIDW application source and target databases from DB2 9.7 to Netezza 7.0.4.
• Infrastructure upgraded to HA setup with setting SRDF with IBM and EMC.
• Worked on setting up SVN (Sub versioning) tool for version maintenance for Unix objects.
• Trained new members joining the newly formed SDM team as part of transition.
• Extensive expertise in Infrastructure environment management.
• Deploying and setting up Informatica infrastructure on application servers from scratch.
• Coordinating with DBA and Unix-AIX and Linux SMEs for upgrade activities.
• Worked on Address Doctor subscriptions for various markets for address validation requirements.
• Worked on setting up Netezza - ODBC connectivity for applications utilizing Netezza as source and target database.
• Worked with Informatica in configuring Web Services using SOAP based transport protocol.
• Regularly work in monitoring and rectifying time-critical report generation faults and deploying new releases.
• Understanding in Unix Shell (Korn Shell, Bash Shell) scripting.
• Developing shell scripts for automating various alerts for proactive monitoring of the system. Scheduling jobs using control-M and Crontab schedulers.
• Daily monitoring of the Informatica application servers using Informatica Admin Console.
• User Administration, Coordinating with IBM for server patching and for power cycling the servers, restarting of servers, nodes and integration services.
• Experience in Share point for document versioning and maintenance.
• Code migration from development to testing to production servers using ETL Process.
• Diagnosing and resolving unexpected outages with production servers.
• Log analysis and co-ordination with Informatica vendor in case of issues affecting the business productivity.
• Good Communication, management and Interpersonal Skills.

TECHNICAL SKILLS:

Procuring AIX servers from IBM for application and metadata setup: 8205-E6B AIX 6.1 SP8, AIX 7,1 Linux 5.11, Linux 6

Coordinating with DBA team for creating database instance and schemas: DB2 9.7, DB2 10.1, Oracle 11g, Oracle 12c

Coordinating with Hadoop Admins and DBAs: Cloudera CDH 5.9

Coordinating with Unix SA for setting Java: Java 1.7.0 SR6

Coordinating with Tivoli and MQ teams for setting alerts: Tivoli TSM Client 6.2.5.0 MQ client 7.0.1.6, 7.5.1

Informatica Administration Skills and Tools: Power Centre 8.6 Power Centre 9.1 HF6 Power Centre 9.6.1 HF3

Migration activities: Power Centre 8.6 Power Centre 9.1 HF6 Power Centre 9.6.1 HF3

Metadata upgrade and maintenance: Power Centre 8.6 Power Centre 9.1 HF6 Power Centre 9.6.1 HF3 Power Centre 10.1

Security roles / LDAP: Power Centre 8.6 Power Centre 9.1 HF6 Power Centre 9.6.1 HF3 Power Centre 10.1

Load balancing on servers: Power Centre 9.1 HF6 Power Centre 9.6.1 HF3

Informatica Administration Skills: Power Centre 9.1 HF6 Power Centre 9.6.1 HF3

PWX configuration: Power Centre 9.1 HF6 Power Centre 9.6.1 HF3

Model Repository Service: Power Centre 9.1 HF6 Power Centre 9.6.1 HF3 Power Centre 10.1.1

Analyst RTM: Power Centre 9.1 HF6 Power Centre 9.6.1 HF3 Power Centre 10.1.1

CDC (Change Data Capture): Power Centre and PWX 9.1 HF6 Power Centre and PWX 9.6.1 HF3

Metadata Manager: Power Centre 9.6.1 HF3 Power Centre 10.1.1 B2B Power Centre 9.1 HF6 Power Centre 9.6.1 HF3

Dynamic Data Masking: TDM 9.7.0

TDM Subsets: TDM 9.7.0

ILM Data Archive: 6.2 HF1

DVO: Power Centre 9.6.0

IDQ: Power Centre 9.1 HF6 Power Centre 9.6.0 Power Centre 9.6.1 HF3

Proactive Monitoring for Power Centre Operations: PMPC 3.0 RulePoint 6.1

Confidential, Charlotte, NC

Informatica Administrator

Responsibilities:

• Interacting with server teams, UNIX SA’s, DBAs, Autosys teams, EMC vendor and various others that are involved in building of a new infrastructure.
• Understand infrastructure requirements and provide solutions and resources and availabilities accordingly.
• Interacting with the new team onboarding the infrastructure and getting them ready and setup as per ETLCoE standards.
• Conducting POCs from Informatica infrastructure front for the new tools and database requirements such as Hadoop and Teradata connectivity.
• Interact with development, SIT and production support groups.
• Make sure that all the environments are up and running fine.
• Coordinating with various teams including DBAs, EMC and UNIX SA for various maintenance activities.
• Groom the new joiners in functional, technical and infrastructure prospects.
• Provide necessary accesses and privileges to Informatica users based on Nexus requests raised by users.
• Work on various Nexus requests for various types such as migration activities, creating and modifying connection strings, developer and analyst accesses.
• Coordinating with patching teams for server patching and for power cycling the servers, restarting of servers, nodes and integration services.
• Create automated scripts for migrations and clean up metadata components needed as part of maintenance.
• Preparation of the utilization reports on weekly and monthly basis for capturing the usage of various projects utilizing shared environments.
• Informing respective application teams and their leads regarding the outages and maintenances on various environments in global communication format prescribed by the bank.

Confidential, Phoenix, AZ

Informatica Administrator

Responsibilities:

• Interact with development, QA and production support groups.
• Make sure that all the environments are up and running fine.
• Interaction with Offshore team for handover of day to day issues and upgrades.
• Manage and coordinate with DBA, Unix SAs, EMC, and IBM teams for supports needed by them in respective fields.
• Understand infrastructure requirements and provide solutions and resources and availabilities accordingly.
• Involve with application database teams for establishing connectivity to Informatica infrastructure.
• Interact with business users in case of RTM analyst tool faces any sort of issues.
• Groom the new joiners in functional, technical and infrastructure prospects.
• Provide necessary accesses and privileges to Informatica users based on sharepoint requests raised by them.
• Work on share point requests for various types such as reserving slot for migration activities, creating and modifying connection strings, developer and business accesses.
• Coordinating with IBM for server patching and for power cycling the servers, restarting of servers, nodes and integration services.
• Create automated scripts for migration of Informatica objects using deployment group from lower to higher environment.
• Worked on setting up sub versioning tool for maintaining versions on UNIX environments for all unix objects.
• Proactive automation of the Informatica repository backup process to be executed on daily basis as a part of special projects delivered to the client.
• Automation of the server mount point status and alerts as a part of special deliverables to the client.
• Preparation of the metric reports on weekly and monthly basis to be presented to the client.
• Forecasting of the quarterly resource utilization metrics.

Confidential, Dayton, OH

System Engineer

Responsibilities:

• Automating the collection and conversion process for the same in Java.
• Processing XML raw data into various formats so as for further processes. It mostly uses java programming.
• Running manual conversion for some states that includes various macros and further running scripts for online transmitting.
• Understanding correctness of dataflow from UNIX to mainframe side.
• Verifying the datasets submitted on mainframe for their completeness and correctness.