SUMMARY

• Ambitious and self - motivated with strong technical background around 8 years of work experience.
• Primary strengths include Data Warehousing and Decision Support Systems in a Unix/Windows environment using Informatica.
• Team player with good analytical, communication and interpersonal skills.
• Maintain positive communications and working relationships at all business levels.

TECHNICAL SKILLS

Platforms: UNIX (Solaris), Microsoft Windows® operating systems, Linux (Red Hat), OEL Linux Version,AIX

Languages: Shell Scripting, PL/SQL, HTML, Perl.

ETL: Informatica PowerCenter 9.x to 10.1.1HF2, PowerExchange 9.1.2 to 951 EBF04, PowerExchange, DVO, IDQ Version 9.6.1 to 10.4.1, Proactive Monitoring, Informatica Intelligent cloud services, Axon Data Governance 5.2 to 7.1, Test Data Management 10.2.0 to 10.4.1, Enterprise Data Catalog 10.2.0 HF1 to 10.4.1.1 .

RDBMS: Oracle versions 7.x to 11g, DB2 UDB 7.x to 10, MS SQL 200x, SQL Server, Teradata and Snowflake.

Tools: Developer 2000, Toad, SSMS, Autosys, Microsoft Office System, Microsoft Project, and Microsoft FrontPage, Microsoft Visio, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Sr. Informatica Administrator

Confidential, CA

Responsibilities:

• Expertise in Installation of Various Informatica products such as Power Center, Informatica Data Quality, Axon Data Governance, Enterprise Data Catalog, IICS and Test Data Management applications.
• Responsible for managing multiple Informatica environments including Dev, QA, Production and Disaster Recovery.
• Install Informatica client tools, data validation options client, Python, Anaconda etc..
• Setup new QA environment for IDQ & DR environment for Axon Data Governance.
• Configured LDAP security & created respective roles for the Axon Data Governance, EDC, IDQ & TDM applications.
• Standardized the environments by increasing the RAM, CPU cores and Data storage as per the usage.
• Configured SSL certificates, Data Market Place, email notifications on Axon Data Governance.
• Integrated Axon-IDQ & Axon-EDC applications.
• Performed DB restore activity by replacing the Axon Dev DB with Axon PROD DB.
• Work Closely with Application Architect, downstream application teams Performed Code Deployments from lower to Higher environments.
• Implemented CI/CD with Azure DevOps on Informatica Data Quality as part to automate the Code Deployments.
• Azure platform Agent installation (as service) for pipeline communication & GitHub Versioning for MRS REPO.
• Worked with Informatica professional Services(IPS) and solution Architect .
• Informatica Enterprise Data Catalog (EDC) Installation / configuration on RHEL platform. Version installation 10.2.2, lead the upgrade efforts to 10.4.1 along with Disaster Recovery setup.
• Informatica EDC LDAP, importing required .cer and pkc12 certs into EDC domain for resource compatibility
• Configured resources on Enterprise Data Catalog(EDC) & scheduled as per the user request
• Testing EDC Advance scanner for resource which do not provide out of the box support, ex. SQL store procedures on SQL and ORACLE DB
• Use Shell script in EDC to perform LDM auto backup scripts.
• Debugging scanner logs for failed EDC resource metadata load (resource manager external Ambari logs)
• Engage meetings with end Business User to understand the requisite of AXON - EDC integration and provide custom solution based on the use case.
• Configured automated monitoring environments for monitoring disk space utilization and cleanup old files.
• Install Informatica cloud secure agents and integrate SAML.
• Informatica Intelligent Cloud Services (IICS) Agent installation on Windows / Linux.
• Decoupling current setup to new setup along with Business continuity (Disaster Recovery - setup)
• Created Users & User Role Standards on IICS.
• Performed Grid setup (Cluster Agent grouping / Token Registration) on IICS.
• Implemented SSO on the IICS as part of the Organizational standard.
• Implemented IICS-Snowflake connection by Add-on connectivity.
• Configured IICS-Snowflake connectivity.
• Performed Code Deployments on IICS.
• Performed performance tuning on the IICS mappings to increase the run-time.
• As part of the IICS Maintenance activity by using the Blackout Period option paused the jobs.
• Performed backup of the IICS Assets by using the REST API calls.
• Performed Erwin DIS & BUP suite Installation on windows Machine(10.1 Version).
• Performed upgrade on Erwin DIS & BUP suite from 10.1 to 10.2V.
• Install ESP/CAWA application on Informatica application to monitor the PROD jobs.
• Apply Hotfixes/EBF to fix the bugs related to the environments. Coordinate maintenance effort with different teams with minimal impact to the end users/business.
• Troubleshoot issue regarding the Informatica. Work closely with vendor where necessary.
• Provide on Call Support during weekend and holidays to address Production Issues and to monitor the PROD JOBS.
• Coordinate with DBA team to address day to day operations and to fix the dB issues related to IDQ PROB jobs.
• Involved in capacity planning for the ETL and work with application and UNIX teams to achieve optimal configurations for the servers’ configurations.
• Coordinate with different teams like System Admins, Database and Storage Admins during maintenance activities and make sure the ETL and Composite environments are back online without any issues.

Environment: Informatica Power Center Versions 10.2.0, Informatica Data Quality 10.2.0/10.4.1 , Axon Data Governance 5.x/6.x/7.x, Test Data Management 10.2.0/10.4.1 , enterprise Data Catalog 10.2.0/10.4.1 , DVO, Informatica Cloud Services, Erwin Data Modeler 10.1/10.2,Oracle 11g/12g, SQL Server and Proactive monitoring.

Sr. Informatica Administrator

Confidential, TX

Responsibilities:

• Expertise in Upgrade process for PC from 9.1 to 10.1.1 and performed DQ Services upgrade from 9.6.1 to 10.1.1HF1.
• Automated user creations, connection Creations and Folder creation tasks using shell scripts.
• Flexibility using different command line utilities like pmcmd, infacmd, pmrep and infasetup commands.
• Install Informatica Data validation option client and configured properties.
• Install Data quality components (Model repository Service, Data Integration service, Search service, content Management service and Analyst Tool).
• Tune performance of Model repository Service and Analyst Service.
• Install Informatica cloud secure agents and integrate SAML.
• Setup Proactive monitoring for powercenter operations and Governance.
• Configured automated monitoring environments for monitoring disk space utilization and cleanup old files.
• Provide on Call Support during weekend and holidays to address Production Issues
• Work closely with Application Architect and provide workable solutions from the Informatica end to fulfill end user needs.
• Setup ETL environments starting from the Scratch as requested by the Architect.
• Maintain User Security using LDAP security and create new Groups for the new projects.
• Troubleshoot issue regarding the Informatica. Work closely with vendor where necessary.
• Apply hotfixes to fix the bugs related to the enviornments. Coordinate maintenance effort with different teams with minimal impact to the end users/business
• Maintain different Informatica cloud enviornments and resolve issues when necessary.
• Automated the disk monitoring, configured email alerts and take proactive steps to avoid such known issues occurring in future.
• Involved in capacity planning for the ETL and work with application and UNIX teams to achieve optimal configurations for the servers’ configurations.
• Coordinate with different teams like System Admins, Database and Storage Admins during maintenance activities and make sure the ETL and Composite environments are back online without any issues.

Environment: Informatica Power Center Versions 9.6,10.1.1HF1 FOR IDQ, Power Exchange for SQL Server, DVO, Informatica Cloud Services, Oracle 10g/11g/12g, SQL Server and Proactive monitoring.

Informatica Administrator (ETL Admin)

Confidential, CA

Responsibilities:

• Responsible for managing multiple Informatica environments including Dev, QA, UAT and Production.
• Manage Power Exchange Services for SQL server CDC captures and resolve production issues on daily basis.
• Upgraded Informatica environments from 9.6.1 HF3 to 10.1.1 on Sun Solaris and AIX servers respectively.
• Identify potential bottlenecks with existing Informatica versions and worked with Global support to provide RCA and make sure CR is created to resolve the same in future releases.
• Monitor Informatica services proactively with help of Shell scripting on Sun and AIX servers.
• Maintain PowerExchange Environments for SQL Server and resolve the issues with the same
• Attend weekly meetings with Stakeholders and Application teams to discuss current issues and update the progress on different activities.
• Developed and deployed scripts to monitor Integration Service Hung status to alert teams in timely manner.
• Developed and deployed scripts for automate repository backup, Informatica work directories cleanup and weekly recycle of Informatica Services.
• Implemented and carried out disaster recovery strategy for critical Informatica environments on Sun Solaris servers.
• Involved in Repository sizing and performance tuning of Informatica Environments.

Environment: Informatica Power Center and Power Exchange applications 9.x and 10.x, PowerExchange, Oracle 10g/11g,SQLServer,Sun Solaris and AIX.

Informatica Administrator (ETL Admin)

Confidential, MI

Responsibilities:

• Responsible for Monitoring, troubleshooting issues of the Informatica Power Center Applications and IDQ applications for Production, Stage and Development environments.
• Did RCA for the various Outages and failed loads on Informatica Production Environment.
• Handled maintenance activities during the Oracle Repository upgrades and server migrations. Resolved issues w.r.t failover in highavailabitly environment.
• Accommodate the Time slots for the new applications’ code on production without affecting existing loads.
• Involved in Newly developed code reviews meeting and suggested significant changes for the same.
• Worked on setting up SFTP, PGP to enable file transfer done in a secure manner between Informatica and other third party servers.
• Analysis of Session, Workflow and Integrations logs to identify the performance bottlenecks for the loads on production.
• Worked with Informatica Global support for RCA and fix for the various issues of Informatica Products.
• Actively assisting with the Informatica enterprise design for SuperValu, consolidating 3 versions of the software operating on 3 different operating systems and incorporate these into a single version that operates on one UNIX OS.
• Preparing standard operating Procedures for related Informatica issues. Preparing weekly and monthly progress report.
• Engage in all aspects of the engineering and complete design of the enterprise Infrastructure
• Responsible for investigation, characterization, and communication of build and release problems; implementing corrective and preventive actions

Environment: Informatica Power Center and IDQ applications 9.1 HF1 and 9.6.1HF2, Oracle Enterprise Linux, Oracle 10g/11g.SQLServer.

Informatica Administrator(ETL-Admin)

Confidential

Responsibilities:

• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Experience in Oracle 10g/9i/8.x, UDB DB2 9.x, SQL Server 2000
• Expected to take control and responsibility for Dev, QA, and production environments while guiding the Users in the best practices of the software.
• Assist with architecting the systems to meet company standards while exploiting the full capabilities of the software and the hardware resources.
• Being proactive in identifying and preventing resource bottlenecks, and to position ourselves early to prepare for resource upgrades to meet the growing needs of our business.
• Creating SR to Informatica Inc- related to any Power center product issues.
• Build a strong alliance with our various network, UNIX, Storage, and IT architecture teams, involving these teams early to build sound, stable, and supportable Informatica environments across the enterprise
• Readily identify potential processing conflicts and to offer alternative solutions to the project teams both on and off shore and help them to expedite those solutions
• Involved with the responsibility of Informatica upgrade procedures for Informatica Power center to the latest version of Informatica Power Center.
• Involved with the design and implementation of many of the data transfer process through the use of NAS and SAN mount points, as well as well as interactive Windows shares to afford enterprise business applications to easily communicate with Informatica workflows
• Ensures proper configuration of the Power Center Domain components. Experience in nodes, Repository services, Integration services, Reporting Services

Environment: Informatica Power Center 8.6.0/8.6.1/9.1.0 , SUN SOLARIS and Linux, Windows -2000 and DB2 9.5/9.1,Teradata,SQL Server, Oracle V 10.2.0.4