SUMMARY:

• Having 11+ years of total IT experience in System Analysis, design and production support and Enhancement implementation of Relational Database and BI applications, Data Warehousing Systems using Informatica 7.x/8.x/9.x/10.x and Business Intelligence tools like OBIEE 11g and Cognos 10 and Business Objects.
• Expertise worked extensively on Informatica PowerCenter 8.x; 9.x; 10.x and possesses good skills in Administration.
• Coordinated in analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.
• Experience in 24X7 production support, ETL executions and resolving root causes.
• Configured and maintained Informatica 9.x/10.x High Availability and GRID environments.
• Installed and configured Informatica Cloud.
• Installed and configured Informatica 10.1 and upgraded to 10.2 Environment in Linux and to 10.4.1 version.
• 1 year of experience in administering IICS.
• Strong experience in installation/upgrade of Informatica PowerCenter/IDQ/EDC/AXON/BDM.
• Installation and configuration of IDQ and PowerCenter integration.
• Installation and configuration of EDC and Axon integration.
• Worked extensively with versioning repositories.
• Setup and maintain Power center ETL Administration best practices and procedures.
• Participate in key/critical design elements and interfaces, provide ETL approach.
• Worked with Service Now, BMC Remedy, JIRA ticketing tool to address the issues within the SLA.
• Worked on Control - M scheduling tool to schedule the PROD loads.
• Involved in code migration for all the DEV, QA, PREPROD and PROD Environments.
• Documenting all the ETL activities and validating all the ETL process as per the company norms.
• Coordinating with the development teams and ensures of Informatica ETL design standards.
• Monitor the log files of Domain, Application services in frequent intervals and backup them accordingly.
• Installed and configured Native drivers, ODBC, JDBC, SFDC drivers to communicate with Databases.
• Maintain/Update Code pages for the Informatica repository service and integration service and administrator console.
• Creation/Deletion of users, roles, groups and folder groups as per the project requirement.
• Configured and synced LDAP user and groups of Active directory in power center.
• Participated in Planned and unplanned outages for all the three environments.
• Configured/Maintained Disaster Recovery, Scheduled backups for the PROD environments.
• Coordinate with the Developers, DBA’s and Sys Admins for the software upgrades.
• Supported Informatica, SnapLogic AWS cloud implementation.
• Good understanding and Responsible for investigation, characterization, and communication of build and release problems; implementing corrective and preventive actions.
• Have good problem solving and analytical skills. Highly motivated professional,Team Player and the ability to effectively Work with, communicate and mentor people.
• Excellent communication skills: Able to interact with users and business owners and translate high-level business requirements into logical business model.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/ NT, Linux, UNIX, AS400 and MS SQL SERVER2000/2005/2008

ETL Tools: Informatica PC 7.x/8.x/9.x,10.x, IDQ, EDC, AXON, BDM MDM, B2B DX and IICS.

Business Intelligence tools: OBIEE 11g, Tableau, Cognos.

Database: Teradata, Oracle, DB2, SQL Server 2005, TOAD for Oracle 8.6, IIS 7.0. Oracle 9i, 10g, 11g,12c, SQL, PL/SQL 11.1

Version Control: Star Team, HPQC, Service Now, Rational Clear case/Clear quest

Scheduling Tools: Autosys 11, Control - M.

Ticketing Tools: HP Service Manager, Service Now, JIRA and Remedy

Modelling Tools: ERWIN, ERStudio

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Administrator

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Upgraded Informatica from 9.6.1 to 10.1.1 and to 10.2 HF1
• Installed and configured Informatica 10.1 in Windows environment.
• Installed and configured Informatica IDQ 10.1.1 and upgraded to 10.2 HF1 on Windows environment.
• Installation and configuration of PowerCenter Repository service, Integration service.
• Installing and configuring various services like Model Repository Service, Data Integration Service, Analyst Service, and Content Manager Service and Business Glossary in IDQ.
• Establishing connectivity with various data sources like Oracle, Greenplum, sqlservers, Sybase, Saleforce and PowerExchange for Mainframes.
• Upgrading the IDQ versions and EBF's.
• Updating the address doctor versions as per the business need.
• Automated Address doctor files download using ADM Client.
• Having experience in architecting and DR process.
• Responsible for maintaining IICS environments with more than 8 sub-orgs in each environment along with a pre-release environment.
• Responsible for maintaining 10.4 MDM environments.
• Installed and configured AXON 7.1
• Installed and configured EDC 10.4.1.
• Configured Cluster and catalog services of EDC to use HDP cluster with high load.
• Installed and configured MetaQuery tool to analyze more on the embedded queries.
• Monitoring the server for metrics like CPU memory IO swap etc.
• Configured Users/Groups from Informatica domain configuration.
• Configured LDAP Authentication to all the Domains.
• Involved in creation of folders/user permissions and folder groups for PowerCenter and IDQ.
• Created technical support documentation for the team for production support.
• Worked on the three-tier model (DEV, TEST, and PRODUCTION).
• Scheduling the workflows using Informatica command-line utilities.
• Followed standard procedures to migrate the mappings from Development to Test and Production environments by creating deployment groups.
• Preparing weekly and monthly progress report including audits, creating reports for process followed in the project, thus helping the team in decision making and hence increasing productivity.
• Execution of patches and upgrades to supported software.
• Attend planned Outages/Go-Lives and Unplanned Outages and coordinate with DBA’s.
• Procedures and scripts to tune and support environment and execute as required.
• Respond to Informatica Infrastructure monitoring (server/performance alerts).
• Perform repository backup and Domain backup in frequent intervals.
• Conducting route cause analysis for the jobs failed.
• Worked on performance tuning with the development teams.

Confidential

Informatica Administrator

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Upgraded Informatica from 9.6.1 to 10.1.1 & 10.2.
• Installed Informatica on Cloud.
• Installed and configured Informatica 10.2 in Linux environment.
• Installation and configuration of Power Center Repository service, Integration service.
• Installed and configured IDQ and power center integration.
• Installing and configuring various services like Model Repository Service, Data Integration Service, Analyst Service, and Content Manager Service and Business Glossary in IDQ.
• Configured Content Management service for analyst tool.
• Establishing connectivity with various data sources like Oracle, Green plum, sqlservers, Sybase and SAP.
• Upgrading the IDQ versions and EBF's.
• Updating the address doctor versions as per the business need.
• Having experience in architecting and DR process.
• Created projects in the IDQ developer tool.
• Monitoring the server for metrics like CPU memory IO swap etc.
• Configured Users/Groups from Informatica domain configuration.
• Involved in creation of folders/user permissions and folder groups for power center.
• Done LDAP configuration and synced users from the external active directory.
• Created technical support documentation for the team for production support.
• Worked on the three-tier model (DEV, TEST, and PRODUCTION).
• Scheduling the workflows using Informatica command-line utilities.
• Followed standard procedures to migrate the mappings from Development to Test and Production environments by creating deployment groups.
• Preparing weekly and monthly progress report including audits, creating reports for process followed in the project, thus helping the team in decision making and hence increasing productivity.
• Execution of patches and upgrades to supported software.
• Attend planned Outages/Go-Lives and Unplanned Outages and coordinated with DBA’s.
• Procedures and scripts to tune and support environment and execute as required.
• Respond to Informatica Infrastructure monitoring (server/performance alerts).
• Perform repository backup and Domain backup in frequent intervals.
• Conducting route cause analysis for the jobs failed.
• Worked on performance tuning with the development teams.

Confidential

Informatica Administrator

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Installed Informatica 9.x and configured in GRID.
• Upgraded Informatica from 9.5 to 9.5.1, from 9.5.1 to 9.6.1, from 9.6.1 to 10.1.1 & 10.2.
• Installed Informatica on Cloud.
• Configured Secure Agent for Cloud on on-premise Unix servers.
• Installed and configured Informatica 10.1 in Linux environment.
• Installation and configuration of Power Center Repository service, Integration service.
• Installed and configured IDQ and power center integration.
• Installation and configuration of Informatica MDM.
• Configure HubStore, HubServer and HubConsole for Informatica MDM.
• Installed Cleanse match server and resource kit.
• Installing and configuring various services like Model Repository Service, Data Integration Service, Analyst Service, and Content Manager Service and Business Glossary in IDQ.
• Installed and configured Power Exchange CDC for the project 9.6.1 HF2
• Configured the Logger for PWX CDC to capture and store the change data in log data sets
• Configured Content Management service for analyst tool.
• Configured the Metadata Manager Service for the project.
• Establishing connectivity with various data sources like Oracle, Green plum, sqlservers, Sybase.
• Upgrading the IDQ versions and EBF's.
• Updating the address doctor versions as per the business need.
• Enabling Ge-Coding as per the project need.
• Having experience in architecting and DR process.
• Created projects in the IDQ developer tool.
• Monitoring the server for metrics like CPU memory IO swap etc.
• Configured services like MFT, Activemq, and Dashboards in B2B data Exchange.
• Manage and backup the B2B Data Exchange repositories in frequent intervals.
• Configured Users/Groups from Informatica domain configuration.
• Involved in creation of folders/user permissions and folder groups for power center.
• Done LDAP configuration and synced users from the external active directory.
• Created technical support documentation for the team for production support.
• Worked on the three-tier model (DEV, TEST, and PRODUCTION).
• Worked on offshore/onshore model and coordinate with the team on regular calls.
• Scheduling the workflows using Informatica command-line utilities.
• Followed standard procedures to migrate the mappings from Development to Test and Production environments by creating deployment groups.
• Used the email task in the Production to keep the team posted on process status.
• Created stored procedures to implement the logics and using them in Informatica.
• Extensively used environments to create shell script and maintaining the logs of Informatica admin console.
• Schedule a call to the relevant teams if any abnormal job timing or any unexpected data arrived to understand the current scenario.
• Preparing weekly and monthly progress report including audits, creating reports for process followed in the project, thus helping the team in decision making and hence increasing productivity.
• Execution of patches and upgrades to supported software.
• Attend planned Outages/Go-Lives and Unplanned Outages and coordinated with DBA’s.
• Procedures and scripts to tune and support environment and execute as required.
• Respond to Informatica Infrastructure monitoring (server/performance alerts).
• Perform repository backup and Domain backup in frequent intervals.
• Conducting route cause analysis for the jobs failed.
• Worked on performance tuning with the development teams.
• Involved in day to day Business Objects Server maintenance.
• Implemented best practices for using Business Objects Suite.
• Provided support to resolve client technical issues.
• Expertise in BO XI R2 CMS and complete security model at BO enterprise level.
• Well versed in BOE architecture, Services process flows, content, security, scheduling and publishing.
• Conducted end user training sessions and prepared training material.

Confidential

Informatica Administrator

Responsibilities:

• Participation and consultation with GE in the design, validation and implementation of Infrastructure changes, new product and versions
• Support Design in additional education for user community with regard to tool’s capabilities.
• Support Design and Architecture teams
• Participated in build Informatica infrastructure as needed from approved reference architecture.
• Part of outages for application maintenances
• Assist with patch and break-fix module Installation, configuration, and application upgrades.
• Documenting installations steps, guidelines, best practices, standards and ensuring the standards and best practices.
• Review capacity criteria data and ensure the design can accommodate the expected volumes and throughput rate.
• Query Optimization techniques.
• Execution of patches and upgrades to supported software
• Attend planned Outages/Go-Lives and Unplanned Outages
• Procedures and scripts to tune and support environment and execute as required
• Respond to Informatica Infrastructure Monitoring (server/performance alerts)
• Oversee & assist the various development teams with the testing & verification of successful migration of all objects to the new environment.

Confidential

Informatica Administrator

Responsibilities:

• Setup and maintain ETL Administration best practices and procedures.
• Responsible to manage Development, QA and Production environments.
• Making sure that code is sync in all the three environments.
• Responsible for investigation, characterization and communication of build and release problems, implementing corrective and preventive actions.
• Involved in upgrade activities of Informatica 8.x.
• Involved in production support working with various migration tickets.
• Adding users and user groups, modifying the users/user groups.
• Install quick fixes and patches and update users accordingly.
• Set up user level security for the users of Informatica.
• Set up user level, data level security for the Informatica folders
• Worked on performance tuning of various Informatica objects to handle requests better and optimize the performance of the application
• Worked with DBA’s in solving the production issues.
• Troubleshooting the environment in case the BI server goes down or contacts the DBA in case of the down time of the content store database.
• Coordinate with the IT computer and network support team to ensure continued hardware and networking availability of the Informatica services to users and programming staff.
• Session Migrations from Dev to QA, QA to PROD.
• Monitoring the scheduled workloads and coordinating with development teams for performance issues.
• Manually executing the loads as per the development team’s requirements.
• Respond to Informatica Infrastructure monitoring (server/performance alerts).
• Taking part in DB outages support and Password change management.