SUMMARY:

• Informatica Admin with more than 10 years of IT experience in Data warehousing, Business Intelligence
• 7 years of experience in Informatica Administration, Informatica Power Center, Data Quality (IDQ), Data Exchange (B2B DX), Power Exchange’s.
• Hands on Informatica 7.x/8.x/9.x installation, configuration, debugging, tuning and administration.
• Experienced in Maintaining High Availability of Informatica services on a multi - node environment (Currently 32 servers)
• Systems implementation, operations and its optimization as Informatica admin
• Proven experience as an Informatica Admin on monitoring resource utilization and proactively identifying Informatica job performance and resource issues (network, disk usage, memory usage, server side limitation)
• Experience on multi-Node, Grid and High availability configurations
• Strong experience in Informatica DR activities
• Expertise in setup LDAP authentication security in Informatica.
• Strong experience in analyze in performance related issues Confidential server/job level.
• Experienced in installing/configuring PowerExchange Components
• Installed/ Configured Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), Informatica Metadata Manager (MM)
• On call support taking the ownership & interacting with DBA, Informatica Global Support and work on problems and drive them to resolutions.
• Day to day administration activities: Manage users, groups, privileges, roles and permissions, folder creation and management, configuring DB connections etc
• Configured Informatica MM to extract metadata from SAP BO for establishing data lineage between Erwin, Informatica, Oracle and SAP BO
• Highly experienced in working and managing projects in Onsite-Offshore models.
• Proficient in handling and meeting client expectations.
• Proven ability to manage multiple project modules simultaneously.
• Expertise in Informatica power center setup, configuration, user security and administration
• Expertise on Service Now incidents, IMR (Incident Management Record), CMR (Change Management Records) process and management.
• Expertise in fine-tuning Informatica jobs by identifying the bottlenecks to improve the performance.
• Expert in typical Admin jobs like Migrations, FTP requests, Performance tuning, Installation of patches, hotfixes and upgrading the tool.
• Followed and Implemented Best Practice methodologies,
• Experience in Scheduling jobs using TIDAL, AUTOSYS and using UNIX Shell Scripts and Unix Crontab
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals Confidential all levels

TECHNICAL SKILLS:

ETLTools: Informatica (Power Center 6.x, 7.x, 8.x,9.x), Business Objects Designer 4.1/5.1.1, 5.5.

Databases: Oracle 12C, 11g, 10g, 9i/8i/7.x,IBM DB2, MS SQL Server, MS Access, Teradata

Web Technologies: ASP 3.0/2.0, COM/DCOM, MTS 2.0, HTML 4.0, DHTML XML2.0, XSL, XSLT, CSS, VBScript, JavaScript, ODBC, ActiveX, ADO2.5, RDO

Operating Systems: UNIX, Linux and Windows

WORK EXPERIENCE:

Informatica Administrator

Confidential, Phoenix, AZ

Environment: Informatica Power Center 9.5.1 HF3/HF4

Responsibilities:

• Installed Informatica PowerCenter/IDQ/B2B DX 9.5.1 and applied latest patches
• Maintaining High Availability of all 32 Informatica servers in a multi-node environment
• Automate different administration tasks via UNIX Shell scripts, command-line utilities.
• Experience in domain management tasks including the backup and restore
• Detailed knowledge in Oracle databases, schemas, table structures, data models-
• Provide detailed documentation and maintain a knowledge base repository
• Day to day administration activities: Manage users, groups, privileges, roles and permissions, folder creation and management, configuring DB connections etc.
• Code promotion - Migration of ETL objects from lower environment to production.
• Supporting the development teams as needed
• Troubleshoot issues related to databases, job failures, software bugs and performance bottlenecks.
• On call support taking the ownership & interacting with DBA, Informatica Global Support and work on problems and drive them to resolutions.
• Created and configured IDQ Analyst, Data Director, Model Repository, Data Integration, Reporting and Dashboard Services
• Created/Configured Content Management Service including configuring out-of-the-box and address validation files for IDQ Address Validation Tool.
• Configured Tidal for Informatica, BO, SAP Data Services, SAP BW, SAP ECC Connectors
• Installed drivers and Configured ODBC connecters that are needed for SAP HANA connectivity.
• Have done Code reviews before moving code to Production
• Experience in Deploying Objects from one environment to other
• Designed semi-auto deploy jobs to deploy Informatica as well as other code into different environments
• Experience in writing Unix scripts to automate various processes
• Configured and used Informatica BCI integration to extract data from SAP IDOCS near real time.
• Extensively involved in migration of database objects
• Tuned the workflows and mappings
• Extensively worked with Business Analysts in fixing the problems faced in the daily load process
• Maintained User Access provisioning process with LDAP and non-LDAP (Native)

Informatica Administrator

Confidential

Responsibilities:

• Installed Informatica PowerCenter 9.6 and applied latest patches
• Upgraded Informatica v8..1 to versions 9.1 and 9.6
• Designed base line architecture for HA and Grid Architecture
• Configured SAP and SFDC Power Exchange’s to source SAP and SFDC data
• Created and configured IDQ Analyst, Data Director, Model Repository, Data Integration, Reporting and Dashboard Services
• Created/Configured Content Management Service including configuring out-of-the-box and address validation files for IDQ Address Validation Tool.
• Installed Tidal 6.0.3.140 scheduling Tool on Linux platform
• Configured Tidal for Informatica, BO, SAP Data Services, SAP BW, SAP ECC Connectors
• Installed drivers and Configured ODBC connecters that are needed for SAP HANA connectivity.
• Have done Code reviews before moving code to Production
• Experience in Deploying Objects from one environment to other
• Designed semi-auto deploy jobs to deploy Informatica as well as other code into different environments
• Experience in writing Unix scripts to automate various processes
• Involved in design and development of normalizing the existing database to globalize
• Designed, developed Informatica mappings enabling to extract, transport and loading of data into different target tables.
• Configured and used Informatica’s BCI integration to extract data from SAP IDOCS near real time.
• Extensively involved in migration of database objects
• Tuned the workflows and mappings
• Extensively worked with Business Analysts in fixing the problems faced in the daily load process
• Maintained User Access provisioning process with LDAP and nonLDAP (Native)
• Created various connection objects, and maintained odbc.ini, saprfc.ini and side info files

Informatica Administrator

Confidential

Environment: Informatica Power Center 8.6.1/9.1

Data Base: Oracle 11g/10g/9i and SQL Server 2005

Responsibilities:

• Administrating Informatica, by creating user logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.
• Daily migrations through various environments (EDW, Transformation, Legacy & OBIEE) with export/import Technique based on requests raised by users.
• File transfers through FTP using various tools.
• Install of patches, hotfixes and upgrading the tool up to date in regular basis.
• Performing regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.
• Worked on Informatica Maintenance, Backups and Recovery Plans.
• Expertise in configuration, performance tuning, installation of Informatica, & integration of various data sources like Oracle, MS SQL Server, and XML, Flat files into the staging area and Design ETL processes that span multiple projects.
• And also implementing performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Installed / Configured Informatica IDQ Services
• Schedule and maintain routine Jobs, Tasks, and Alerts using Ctrl M.
• Assisted with scripting and monitoring interfaces between UNIX scripts and Oracle.
• Monitor Informatica session Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/Intent locks.
• Troubleshooting and Performance Tuning for database systems.
• On Call Production Support for after-hour requests like daily migrations and other Misc. Requests in shifts.

Informatica Administrator

Confidential

Environment: Informatica Power Center 8.6.1/9.1

Data Base: Oracle 11g/10g/9i and SQL Server 2005

Responsibilities:

• Implemented Procedures to maintain, monitor, backup and recover operations for ETL Environment.
• Performed Code Deployments of ETL Jobs across various environments.
• Maintained Ownership of Release activities interacting with ETL projects.
• Setup and configured Informatica domains, services (repository, integration, Metadata manger, data analyzer, data integration, Model repository etc.).
• Designed HA/Grid Informatica ETL Environment for data warehouse/integration.
• Installed and configured Informatica server software in HA/Grid Environment.
• Conducted ETL optimization, troubleshooting and debugging.
• Provided Application support to ETL application development teams,
• Established projects, roles, users, privileges in different ETL Environments (DEV, QA, UAT and PROD).
• Provided 24/7 Support related to Administration tasks (Emergency Deployments, FATAL ERRORS on the Informatica server, unexpected Informatica services failures, Repository issues etc).
• Experience installing and configuring Informatica 9.5 as well as migration from Informatica 8.6 to 9.5.
• Developed UNIX scripts
• DB2 and Oracle PL/SQL, SQL queries, stored procedures and client configuration
• Proactively monitored batches/interfaces and provided statistics to management
• Troubleshoot performance of workflows/sessions and UNIX processes
• Troubleshoot technical issues with Informatica admin and/or Informatica tech support
• Hands-on experience with Domain Admin Console, user management, start/stop PowerCenter and PowerExchange services
• Worked on Unix scripts to create FTP jobs

BW/Informatica Consultant

Confidential

Responsibilities:

• Involved in Datacenter migration including new installation
• Understand business needs and implement the same into a functional database design.
• Monitor daily, weekly, monthly Data Warehouse load processes and other DW related processes
• Removing unwanted files with frequent file system cleanup.
• Hands on Service Now incidents, IMR'S (Incident Management Record), CMR (Change Management Record) process and procedure.
• Involved in Informatica servers migrations, repositories setup in new environment
• Configure different data source system Confidential server level as well as in Informatica power center
• Admin accounts change on regular basis and user audit report generation
• Coordinating with all different groups (UNIX SA, DBA etc.) in case of any issue with respect to Domain/Server and repository database
• Guide/support application team in terms of implementation of Informatica best practices while code development process by being proactive.
• Assist the application team, while performance tuning of existing code.
• Coordinate Informatica Product support through SR process.
• Expertise in Disaster Recovery (DR) of Informatica components
• Involved in the monitoring of process chains and also to automate the process of loading data into data targets

BW Consultant

Confidential

Responsibilities:

• Used ODS to stage the data before transferring the ODS contents to the infocube
• Info Package Management for data loads via Idoc or PSA, Flat file creation/load PSA
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads
• Created custom and modified standard Info Objects based on Master and Transactional data from SAP and flat files into BW
• Involved in Performance improving related issues by creating Aggregates, compressing infocubes & rolling the data to BIA
• Performed Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the structures to support the business needs
• Worked on Bex Analyzer (RRMX) and created queries using BW Reporting Variables, Navigational Attributes and Filters
• Lookup of Master Data Attributes in Update Rules, lookup for ODS key fields, lookup for ODS data fields. Multiple Data Sources per File-Source System. Start Routine in BW Transfer Rules
• Involved in creating Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx

BW Consultant

Confidential

Responsibilities:

• Experienced in analyzing the business Scenario and mapping them to SAP processes.
• Interacted with Power users for report generation
• Extracted data using R/3 and flat files as data sources
• SAP BW Maintenance by monitoring daily and weekly data loads
• Handled trouble shooting scenarios during the data loading
• Created User roles and authorizations in BW for restricting a particular user to specific activities and screens