We provide IT Staff Augmentation Services!

Informatica Administrator Resume

Westbrook, MainE

SUMMARY:

  • Having 9 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 and Business Intelligence tools like OBIEE 11g and Cognos 10 and Business Objects .
  • Expertise, worked extensively on Informatica Power center 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.
  • 1.5 years of experience as an Informatica MDM Administrator .
  • Experience in 24X7 production support, ETL executions and resolving root causes.
  • Configured and maintained Informatica 9.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.
  • Having good knowledge in Informatica AWS.
  • Strong experience in installation / upgrade of Informatica Power center .
  • Installation and configuration of IDQ and power center 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 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 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, groups and folder groups 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 upgrade s.
  • 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 SERVER 2000/2005/2008

ETL Tools: Informatica 7.x/8.x/9.x,10.x, MDM, B2B DX and IDQ

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, 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 and Remedy

Modelling Tools: ERWIN, ERStudio

PROFESSIONAL EXPERIENCE:

Confidential, Westbrook, Maine

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 upgrade s 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, NJ

Informatica Administrator

Responsibilities:

  • Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
  • Installed Informatica 9.x and configured in GRID.
  • Upgrade d 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.
  • Configured Content Management service for analyst tool.
  • 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 upgrade s 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, MA

Informatica Administrator

Responsibilities:

  • Worked as an Informatica Consultant.
  • Define the Naming Standards and Standard process for Informatica .
  • Installed and upgrade d Informatica 9.x
  • Developed multiple ETL process to synchronize the data between legacy and new system.
  • Configured services like MFT, Activemq, and Dashboards in B2B data Exchange.
  • Manage and backup the B2B Data Exchange repositories in frequent intervals.
  • Configured load balancer in B2B environment.
  • Providing the necessary privileges for team and maintaining the security and permissions to the Active MQ services in B2B DX.
  • Configured the batch workflows to the particular integration service in B2B DX.
  • Installed Data Archive service to archive the events in B2B DX.
  • Installed and configured Informatica MDM.
  • Setup Informatica AD Authentication.
  • Configured Informatica High Availability setup.
  • Performed the Setup of DR Servers.
  • Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing.
  • Applied Informatica Patches to the Informatica servers.
  • Troubleshooting the issues in Informatica .
  • Involved and resolving the issues (Tickets) in Informatica Power center.

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 upgrade s.
  • 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 upgrade s 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 users 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.

Confidential

Informatica Administrator

Responsibilities:

  • 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 upgrade s.
  • 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 upgrade s 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:

  • 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.

Hire Now