SUMMARY

• Senior Informatica/Initiate Admin with 10+ years of IT experience in Data Warehousing, Business Intelligence.
• 7+ years of experience in Informatica Administration.
• Experience in data modeling, data warehouse, Ralph Kimball and Bill Inman models with Star/Snowflake Schema Designs with analysis - definition.
• Strong experience in Installing and Managing Informatica PowerCenter, Data Quality and Metadata Manager.
• Involved in the agile development lifecycle from requirements gathering through development and support using Informatica PowerCenter Repository Manager, Workflow Manager and Workflow Monitor.
• Expertise in Informatica and Initiate Administration including Installation, upgrade, Applying Hot Fixes, Configuration, maintenance and troubleshooting.
• Strong working experience in installation of Informatica on LINUX, Migration of repositories and repository upgrades.
• Professional Experience in ETL Architecture using Informatica PowerCenter 9.6.1 HF3, HF2, 9.5.1/9.1.0/9.0.1/8.6.1/8.5 …etc.,
• Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and pmcmd commands.
• Involved in a role as an Informatica Administrator in upgrading the repository database and giving permission to various groups of users and testers.
• Installation and configuration of Informatica servers and client environments.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Create and manage users, groups, folders and ensure appropriate privileges are assigned to the different users.
• Hands on experience using query tools like TOAD, PLSQL developer, Teradata SQL Assistant and Query man.
• Extensive experience in Banking, Telecom, eCommerce & Healthcare applications.
• Experience in 24X7 on call Production support and preparing procedures / documentation whenever necessary.
• Experience in handling multiple tasks and work independently as well as in Team.

TECHNICAL SKILLS

Tools: Informatica PowerCenter, IDQ, PowerExchange for Hadoop, Teradata, TOAD, SVN, PuTTY, SharePoint, Tidal, CyberArk, Cherwell, IRS, IBM Data Studio, SQL Developer, Control-M, Confluence, Jira, FileZilla, WinSCP, GIT

Databases: Oracle 11g/12c, Teradata, DB2, SQL Server, MySQL

App/Web Servers: JBoss, WebLogic, WebSphere, WAS7, Apache Tomcat

Operating Systems: Linux/UNIX, Windows 8/7/XP/2000/9x

PROFESSIONAL EXPERIENCE

Confidential, San Roman, CA

Sr Informatica Admin

Responsibilities:

• System migration of Development, Test and Production in the primary data center from virtual machines to physical nodes.
• Designed and Implemented Disaster Recovery (DR) in Backup data center.
• Upgraded Informatica from 9.5.1 HF4 to 9.6.1 HF3 and configured services in both PowerCenter and Data Quality.
• Setup and validated batch framework.
• Handled day to day administration activities like create users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository Manager, configuring DB connections, monitoring nodes, Repository and Integration services.
• Scheduled backup scripts for domain and repositories.
• Migration of ETL objects on versioned repositories from DEV to TEST and TEST to Production.
• Automated different administration tasks via Shell scripts, command-line utilities in pmrep commands.
• Managed day-to-day Informatica administration support like domain, nodes Repository services, Integration services, domain security and privileges.
• Configured relational connections and managed security and privileges.
• Managed backup and recovery of the domain metadata and appropriate shared file directories.
• Granting privileges to various groups of users and maintain security on Linux OS level.
• Coordinating with different teams like DBA, Network and Linux admin team to troubleshoot the various issues.
• Participated in daily stand-up meetings, reviews, retrospectives, release planning and other Scrum related meetings.

Environment: s: Informatica PowerCenter 9.6.1 HF3, Data Quality, RHEL 6.7, Oracle 11g, CFT, Tumbleweed, Data Guard, PuTTY, FileZilla, Windows7, Shell scripts, SVN, CyberArk, Cherwell, IRS

Confidential, Bellevue, WA

Sr. Informatica Admin

Responsibilities:

• Installed Informatica PowerCenter version 9.6.1 HF2 on Development POC environment.
• Installed Informatica PowerCenter Evaluation/Trial version 9.6.1 HF3 on Development Integration (DIT) environment.
• Upgraded Informatica from 9.6.1 HF2 to 9.6.1 HF3 on Development POC (DevPOC) environment.
• Applied new License key to the environments when necessary.
• Scheduled backup scripts for domain and repositories.
• Migration of ETL objects on versioned repositories from DEV to DIT.
• Created scripts for starting the Informatica services when services were down.
• Managed day-to-day Informatica administration support like domain, nodes Repository services, Integration services, domain security and privileges.
• Configured relational connections and managed security and privileges.
• Managed backup and recovery of the domain metadata and appropriate shared file directories.
• Granting privileges to various groups of users and maintain security on Linux OS level.
• Prepared and maintained of technical documentation, deployment check lists etc.,

Environment: s: Informatica PowerCenter 9.6.1 HF3, RHEL 6.5, Oracle 12c, Golden Gate, BSCS, OM/EPC, Samson, Rebellion, Data Guard, PuTTY, FileZilla, Windows7, Shell scripts, EriDoc.

Confidential, San Francisco, CA

Sr. Informatica Admin

Responsibilities:

• Acted as a Subject Matter Expert for Informatica Application
• Installed Informatica version 9.1 & Upgraded Informatica from 9.1 to 9.5 and from 9.5 to 9.6.1
• Perform ETL Informatica Administration functions such as user access accounts, roles, and setting standards.
• Create and manage users, groups and folders. Ensure appropriate privileges are assigned to the different users.
• Deploying the codes from DEV, TST and PRD regions.
• Creating new users and groups with required privileges at the repository level.
• Managing the various alerts due to disk space and High volume alerts.
• Perform Start and stop of services when major maintenance work is required on the servers.

Environment: s: Informatica PowerCenter 9.6.1/9.5/9.1 , Informatica Power Exchange for SAP, Web service, SFDC, Informatica Data Quality (IDQ), SunOS, IBM-AIX, Windows7, Oracle 12c/11i/10xe OEM, PuTTY, and WinSCP.

Confidential, San Francisco, CA

Informatica Admin

Responsibilities:

• Analyzed the user requirements by participated in the Review meetings of functional requirements specifications and design specifications.
• Responsible for building dev and test repositories to ensure strong testing environment and smooth transition to production
• Creating users accounts, roles and privileges for development operations and security maintenance
• Responsible Configuring Informatica repository for database connectivity.
• Configured Informatica test repository for the integration test and given admin support though out
• Created user accounts controlling the accessibility, deployed and validated the mappings and workflows in the test environment
• Migrated development mappings to production environment
• Automated Informatica repository backup using shell and cron job Scheduling

Environment: s: Informatica PowerCenter 9.1.0, Windows XP, TOAD, Oracle SQL, PL/SQL, Oracle11g/9i and Skybot.

Confidential, San Francisco, CA

Informatica Admin

Responsibilities:

• Analyzed the user requirements by participated in all phases like Inception, Quick Start, Design Storming and Review meetings of functional requirements
• Upgraded Informatica PowerCenter 8.1 to Informatica 8.6 HF9
• Deployed code across environments related toInformaticaData Quality (IDQ).
• Helped in installation of PowerCenter clients on developer's machine and establish connectivity to Informaticarepository services
• Applying Hotfix & EBF provided by vendor.
• Planning and maintaining sufficient memory on application servers across the grid for better ETL Load performance
• Created UNIX shell scripts for backing up the domain and repository services.
• Handle new user access requests on a regular basis
• Code migration across DEV, UAT & Production Repositories.

Environment: Informatica Data Quality, PowerCenter, DEV, SIT, UAT, UNIX Shell Scripts

Confidential, San Francisco, CA

Informatica Admin

Responsibilities:

• Interacted with the Client for getting the user requirements by participated in the Review meetings of functional requirements and design specifications.
• Installed and configured Informatica 7.x on UNIX
• Involved in migration of Informatica Repositories (DEV-UAT, UAT-Prod)
• 24X7 On-call production support on a rotation basis.
• Supported all the application of Informatica.
• Analyzed the user requirements by participating in the Review meetings of functional requirements specifications and design specifications.
• Tested the enterprise version of the mBill™iLoader generated XML outputs prescribed by the FCC of US.
• Performed Validation Testing with the STIGMA Tool.
• Root Cause Analysis (RCA) on the major incidents.
• Direct interaction with the Business Analyst and Development team while requirements review tracking and reporting the bugs for the quality output.

Environment: Eclipse 3.0, Windows 2000 pro, Oracle 9i, XML, SQL, TOAD, and Test Director.