We provide IT Staff Augmentation Services!

Informatica Administrator & Architect Resume

SUMMARY

  • Skilled Software Engineer dedicated to constantly improving tools and infrastructure to maximize productivity, minimize system downtime and quickly respond to the changing needs of the business
  • 10 years of experience in Information Technology with a focus on Business Intelligence, Data Warehousing and Data Lake implementation solutions
  • Strong experience as an Informatica & Talend Administrator in Data Integration - Informatica 8.x,9.x & 10.x and Talend 5.x, 6.x &7.x
  • Certified in Informatica Power Center Data Integration 9.x Administrator Specialist & Talend Data Integration 6.x Administrator
  • Good experience as an OBIA (OBIEE+ODI) Administrator in 11.1.1.9.x & Oracle Endeca Administrator in 3.x
  • Having strong hands-on experience in installing, configuring & upgrading ETL tools Informatica 9.x, 10.x/Talend 5.5.x & 6.1.x services and in ERP reporting tools like OBIA services include OBIEE, ODI and Oracle E-Business Suite Information Discovery 12.1.x services
  • Good experience in extracting data using ETL tools from various sources like MySQL, Oracle, Greenplum, PostgreSQL, Teradata, MongoDB, Cassandra DB, SFDC, Hive into Data Warehouses, Data Lake using Informatica Power Center, Power Exchange, Power Connect as ETL tool and to Data Lake using Talend 5.x and 6.x as ELT tool.
  • Expertise in core administration of Informatica Products including applying Hotfixes and Patches on different versions
  • Experience in configuring the Informatica/Talend HA/Grid setup for High Availability and Improving Performance and scalability
  • Experience in technical maintenance and administration of Informatica Power Center performance, security, integrity, and developing and evangelizing the procedures to support enterprise applications and business function
  • Developed server monitoring and service monitoring shell script programs for Automation of day to day project activities and automated few migration steps in OBIA migration
  • Worked as Administrator/Developer/Support in multiple projects
  • Trained in Bigdata technologies and good exposure to AWS & GCP could and NoSQL databases like MongoDB and Cassandra DB

TECHNICAL SKILLS

Operating Systems: Windows, MSDOS, Sun Solaris, Linux and Ubuntu

Languages: SQL, Shell Scripting, C, C++ and Core Java

Databases: Oracle 9g,10g,11g, MySQL, Greenplum, PostgreSQL, Teradata, MongoDB, Cassandra DB, SFDC, Hive

BI Tools & Utilities: Informatica 8x/9x/10x, Talend 5x/6x, OBIA 11x, Endeca (EEE) 12.1x, ODI, Hadoop, HDFS, SQL developer, Toad, Putty, WinSCP, DBeaver, Notepad++

Domain: Supply Chain, Assurance, GE Power, Water, Energy Management & Aviation

PROFESSIONAL EXPERIENCE

Informatica Administrator & Architect

Confidential

Responsibilities:

  • Prepare pre-requisites document for infrastructure team to provision the hardware
  • Prepare Infrastructure and hardware sizing in coordination with Dell & Informatica team
  • Design Architecture diagrams for an MDM solution
  • Installing Informatica Master Data Management, Product 360, Data Quality and Power Center products in four different environments with single node & multi-node along with High Availability
  • Involved in preparation of maintenance releases, project planning, tracking, reviews, status reporting and technical guidance
  • Administration of Informatica services and servers, user administration, creation of projects
  • Maintaining all level of securities & Monitor performance of the overall system
  • Handling all application-related issues which occur and providing the root cause analysis
  • Coordinating with Cloud and Database teams whenever required for troubleshooting the issues
  • Deal with Informatica support to resolve issues
  • Coordinating within the team members on the issues and updating the knowledge
  • Handling Outages and restarting the services in time
  • Review and optimize performance bottlenecks
  • Setting up meetings with respective teams to discuss on the project plans and high-level issues
  • Preparing weekly status update reports and preparing technical and installation documents.

Technical environment/Tools: Informatica Master Data Management 10.3 HF1, Product 360(PIM) 8.1.1 HF2, Power Center & Data Quality 10.2 HF1, Oracle, Linux

Informatica Administrator & Architect

Confidential

Responsibilities:

  • Prepare pre-requisites document for infrastructure team to provision the hardware
  • Prepare Infrastructure and hardware sizing on GCP in coordination with Cloud team
  • Design Architecture diagrams for MDM solution on Google Cloud Platform
  • Installing Informatica Master Data Management and Data Quality products
  • Involved in preparation of maintenance releases, project planning, tracking, reviews, status reporting and technical guidance
  • Administration of Informatica services and servers, user administration, creation of projects
  • Maintaining all level of securities & Monitor performance of the overall system
  • Handling all application-related issues which occur and providing the root cause analysis
  • Coordinating with Cloud and Database teams whenever required for troubleshooting the issues
  • Deal with Informatica support to resolve issues
  • Coordinating within the team members on the issues and updating the knowledge
  • Handling Outages and restarting the services in time
  • Review and optimize performance bottlenecks
  • Setting up meetings with respective teams to discuss on the project plans and high-level issues
  • Preparing weekly status update reports and preparing technical and installation documents.

Technical environment/Tools: Informatica Master Data Management 10.3, Data Quality 10.2 HF1, MSSQL, Google Cloud Platform, Informatica Intelligent Cloud Services

Informatica Administrator

Confidential

Responsibilities:

  • Administering Informatica Power Center 10.x, Metadata Manager 10.x, Data Quality 10.x, Master Data Management 10.x, Big Data Management 10.2.x products
  • Administration of Informatica services and servers, user administration, creation of projects
  • Carry out deployment, migrations environment to environment
  • Installations, upgrades, hotfixes, applying new patches.
  • Maintaining all level of securities for all environment Repositories
  • Monitor performance of the overall system on all environments (prod, stage, dev, test)
  • Handling all application-related issues which occur and providing the root cause analysis to the issues
  • Coordinating with all the UNIX, Network, Database Admin teams whenever required for troubleshooting the issues
  • Deal with Informatica support to resolve issues
  • Coordinating within the team members on the issues and updating the knowledge
  • Performing Capacity & Stability monitoring
  • Handling Outages and restarting the services in time
  • Configuration and tuning of production and lower-level environments
  • Supporting on call on a Rotation basis
  • Review and optimize performance bottlenecks
  • Monitored disk space and load balance & Scheduled jobs and setting alerts
  • Setting up meetings with clients and teams to discuss on the project plans and high-level issues

Technical environment/Tools: Informatica Power Center 10.x, Metadata Manager 10.x, Data Quality 10.x, Master Data Management 10.x, Big Data Management 10.2.x, Cherwell, MSSQL, Teradata

Informatica Administrator

Confidential

Responsibilities:

  • Prepare pre-requisites document for infrastructure team to provision the hardware
  • Installing Informatica Enterprise Data Catalog and Data Lake 10.2.1, Big Data Management 10.2.1, Data Quality 10.2, Secure @ Source 4.3, Axon 5.3 products
  • Administration of Informatica services and servers, user administration, creation of projects
  • Maintaining all level of securities & Monitor performance of the overall system
  • Handling all application-related issues which occur and providing the root cause analysis
  • Deal with Informatica support to resolve issues
  • Coordinating within the team members on the issues and updating the knowledge
  • Handling Outages and restarting the services in time
  • Review and optimize performance bottlenecks
  • Setting up meetings with respective teams to discuss on the project plans and high-level issues

Technical environment/Tools: Informatica Enterprise Data Catalog and Data Lake 10.2.1, Big Data Management 10.2.1, Secure @ Source 4.3, Axon 5.3, Oracle DB

Hire Now