Avinash Achanta
Sr Informatica Platform Administrator/Engineer
Summary
An Informatica Administrator with over 12 years of experience, installing and configuring various Informatica tools (9. X, 10. X) within Unix environments. My expertise extends to upgrading these systems to newer versions and efficiently migrating them to cloud environments. I am adept at supporting these systems through their development cycles, managing day-to-day tasks, and ensuring smooth daily production activities. My experience also involves in providing 24/7 production support. I have a strong background in managing different types of Informatica migrations, including version upgrades and cloud migrations.
In the realm of IICS/Informatica Data Management Cloud (IDMC), my skills include working with different microservices, involving in Designing architecture, various Administrator tasks, day to day activities. Providing end-to-end support for IDMC Platform related issues.
Overview
15
15
years of professional experience
Work History
IDMC Administrator Lead/Engineer
USAA
04.2025 - Current
- Designing Document for IDMC configuration.
- Working on Repository Assessment for IPU’s Estimation on IDMC for CDI-PC modernization.
- Designing Security Architecture on IDMC internal to Organization.
- Designing Architecture of IDMC on AWS EC2 Instance and on Data Centers.
- Designing IDMC requires AD Groups that need to be configured.
- Working on Implementing IDMC and Fivetran Across the Organization.
- Designing Fivetran HVR and Fivetran SAAS Architecture.
- Implementing various database integration in fivetran HVR and Fivetran SAAS.
IDMC Administrator Lead
Johnson & Johnson
11.2024 - 04.2025
- Creating, Installing, and configuring secure agents and run time environments to use IDMC services.
- Created Sub-Organizations within an Org in IICS/IDMC as per specific business requirements.
- Deploying Projects in to different IDMC services such as CDI, CAI, CDQ, MDM, CDGC, Mass Ingestion, MCC.
- Creating and configuring CICD pipelines for IDMC CDI services for automation of deployments and also working migration yaml script for automation deployments.
- Working with Developers in troubleshooting IDMC issues related to different services CDI, CDQ, CAI.
- Working with Informatica GCS in case of IDMC related issues in different services.
- Integration IDMC with various cloud platforms such as AWS, Azure, GCP, SharePoint etc.
- Configuring SAML and AD Groups for the users in IDMC.
- Created required custom roles and groups based on the requirements from CDGC, MCC, CDI, CAI and CDQ teams.
- Creating and Configuring Connections for various sources and Targets in IDMC.
- Enabling GIT HUB Repository and creating various branches for the IDMC projects.
- Enabling and configuring IDMC Platform Alerts in cases of services interruption.
IDMC Administrator Lead
One America
04.2024 - 11.2024
- Worked on creating and configuring runtime environments in IICS, ensuring optimized performance for data management tasks.
- Worked on deploying the code from PowerCenter to IDMC CDI services successfully.
- Managed the Informatica Cloud Secure Agent, handled downloading, installation, status monitoring, restarts, and re-registration to different organizations in the cloud and working with GCS in process.
- Created Sub-Organizations within an Org in IICS/IDMC as per specific business requirements, enhancing organizational data management structure.
- Worked on CDI, CAI, CDQ, CDGC, MCC Services creating connections.
- Worked on creating connections such as ADLS, SharePoint Cloud, DB2 connections, SQL Connections and Snowflake connections.
- Worked closely with the network to enable the firewall rule and whitelist informatica IDMC IP Address.
- Worked with Azure team to create the required OS file system and disk shared file system for the application teams.
- In Process of integrating IDMC with control M to schedule the integration jobs.
- Worked with the Azure team to enable the file system backups.
- Worked on Creating Automation of deployment through CICD Pipelines in Azure.
- Created required custom roles and groups based on the requirements from CDGC, MCC, CDI, CAI and CDQ teams.
- Worked with the Azure team to enable the required alerts for the server.
- Used Ansible for automation of deleting old files in the server.
- Worked with Informatica vendors on various issues related to IDMC on different services CDI, CAI, CDQ, CDGC.
- Helping the developers in troubleshooting any IDMC related issues related to the IDMC platform.
- Worked on updating the logs, cache, and parameter path files in IDMC Console.
- Enabled Git Hub Repository for different orgs in IDMC.
- Setting up SAML security for users to login to the IDMC environment.
- Planning and deploying IDMC assets from one Org to another Org.
- Planning, testing, and executing DR activity in IDMC in Production environment involving various infrastructure teams.
SR Informatica Cloud Administrator/Production Support
JCI
03.2023 - 03.2024
- Worked on creating and configuring runtime environments in IICS, ensuring optimized performance for data management tasks.
- Managed the Informatica Cloud Secure Agent, handled downloading, installation, status monitoring, restarts, and re-registration to different organizations in the cloud and working with GCS in process.
- Created Sub-Organizations within an Org in IICS/IDMC as per specific business requirements, enhancing organizational data management structure.
- Enabled source control through GITHUB Repository IDMC Assets.
- Worked on setting up Single Sign-On (SSO) method for Informatica Cloud and configuring Security Assertion Markup Language (SAML) in IICS/IDMC.
- Demonstrated familiarity with various Informatica cloud interfaces, including CDI, CAI, CDQ, Product 360, Business 360, Customer 360, and MDM Multidomain.
- Configured and created user roles, privileges, and access control policies, ensuring secure data access and compliance with organizational policies in snowflake.
- Providing the required access for the users and adding the appropriate groups for snowflake databases.
- Performing DDL Operations for the developers in Snowflake database.
- Worked with Network team on creating the required network policies across the organization for the snowflake required databases.
- Conducted POC for various modules including MDM Business 360, Product 360, CDI, CAI and CDQ, showcasing system capabilities in different scenarios.
- Defined and managed business and technical groups in IICS/IDMC, assigning appropriate roles to streamline operations and enhance collaboration.
- Developed custom roles according to business needs, ensuring precise user access control and system security.
- Task and Event setup in IICS Business 360 Console.
- Setup of Publish mechanism in Business 360 Console.
- Working on profiling the required data in CDQ.
- Worked on code migration across folders and organizations in IICS, ensuring smooth transitions and consistent data management practice.
- Worked on CDI/CAI/CDQ/Product 360/Business 360/customer 360/MDM Multidomain in Informatica cloud interface.
- Worked with Informatica GCS on various IICS/IDMC platform issues to resolve the issue.
Sr. Informatica Administrator/Production Support
FANNIE MAE
08.2020 - 02.2023
- Installing and upgrading Informatica Power Center and Data Quality to 10.5 from 10.4 over 80+ applications.
- Installing, upgrade and configure Informatica EDC 10.4, Axon and Integrating with IDQ.
- Installing, configuration, and upgrade of Informatica Data Integration Hub (DIH) across different environments.
- Configured security settings including user access control, role-based permissions, and authentication for secure data integration processes.
- Scanning Required metadata resources from Informatica EDC.
- Working with UNIX, DB and Network teams to make the environment ready for the installation and upgrade Informatica on Linux and Solaris servers.
- Providing Informatica platform support for upgrade related issues to the application teams.
- Working with application teams to On-Board from On-Prem Power Center/ data quality and Abinitio to the AWS cloud environments.
- Providing support to the application teams in performing day to day activities and issues.
- Creating the folders, groups and adding the groups in LDAP security for AWS cloud application.
- Providing support day to day activities for the Informatica and Ab Initio applications based on the JIRA story boards and service now requests.
- Experience with deploying and managing Informatica environments in a cloud environment.
- Create and manage EC2, EFS and other AWS services.
- On-boarding the applications of Informatica, Abinitio from On-Prem to AWS cloud environment.
- Automated the deployment of Informatica objects by integrating with CICD, GitHub and Jenkins to streamline version control and continuous delivery.
- Installing, Configuring, and upgrading Informatica MDM 10.5 and MDM Hub Server, App Server (JBoss), Active OS.
- Creating the ORS and working on incremental deployments in MDM and validating ORS.
- Configuring LDAP services for MDM Hub.
- Adding and managing the users in the MDM Hub console.
- Performing MDM refresh, and code deployment activities across all the environments.
- Providing production support 24/7 for all the Informatica Power Center, IDQ, MDM, EDC, Axon and Managing IICS, and Ab Initio applications.
- Creating Different connections from informatica to Oracle, DB2, PWX, ODBC, Teradata, Snowflake etc.
- Configuring Informatica components and working with the infrastructure teams on installation, upgrades, Performance, and monitoring stability in the newer versions of the Informatica.
- Working with the UNIX, DB, Network team, and various infrastructure teams on troubleshooting the various Informatica issues regarding performance.
- Installing the GDE CO-OS keys in the Abinitio different versions used by the application team.
- Working with application teams to On-Board from On-Prem Power Center/ data quality and Abinitio to the AWS cloud environments.
- Installing the GDE CO-OS keys in the Abinitio different versions used by the application team.
- Installing and managing PWX CDC and performing DR activity with the application team.
- Troubleshooting the AWS cloud environmental issues and performance issues for the Informatica and Ab Initio applications.
- Installing HP Voltage, Control M agent, UCD agent and redshift ODBC drivers' installation on the required AWS EC2 hosts for Informatica and Ab Initio applications.
- Installing the updated patches across all the environments in EC2 instances.
- Build the CICD pipelines for the application teams across lifecycles in AWS.
- Configuring SMTP and mail x in EC2 instances.
Informatica Administrator/Production Support
TOYOTA FINANCIAL SERVICES
08.2019 - 07.2020
- Install and Configure Informatica Enterprise data Catalog (10.2 HF2/10.4) in EC2 instance Linux servers. Responsible for creating catalog services and installation of internal Hadoop services in Informatica EDC.
- Installing Axon Agent in Informatica Data Quality servers and Integrating with Informatica Data Quality.
- Install and Configure Informatica Axon services and Integrate with Informatica Enterprise Data Catalog servers.
- Responsible for installing AS400 services in the Informatica servers. Configure LDAP Security Informatica user security across all the Informatica Products which includes Informatica Data Quality, Informatica EDC, and Informatica Axon.
- Created custom scanners in Informatica EDC such as Snowflake etc.
- Gathering the requirements for the installation of Informatica Enterprise Data Catalog, Informatica Axon, Informatica Data Quality, Informatica ILM, and Informatica TDM on Linux Servers.
- Configuring required Security of the Users in EDC and Axon.
- Integrating Axon with Informatica Data Quality.
- Integrated With Git hub repository in Informatica data Quality.
- Set up Informatica EDC Services, Informatica Data Quality (IDQ), Informatica TDM, and Informatica ILM using SQL RDS instance database as metadata.
- Creating and Integration informatica to Oracle, DB2, PWX, ODBC, Netezza, AS400, Teradata, Sharepoint.
- Upgrading Informatica EDC from 10.2 HF1 to 10.4, Informatica Data Quality 10.1 to 10.2 HF2 to 10.4, Informatica ILM, Informatica TDM 10.1 to 10.4.
- Install, configure, and upgrade Informatica Data Quality 10.2 HF2 and 10.4 and create required services which include. MRS, Search Service, DIS, Monitoring services.
- Creating the various required resources such as Mainframe, Oracle, and AS400 in Informatica EDC to Scan the required Meta Data and show the Lineage.
- Configure and create required user roles and groups and add the LDAP users to the required groups.
- Responsible for installing and updating Informatica data quality Address doctor reference files incrementally every 3 months.
- Configured Master Node and Backup nodes under a High Availability environment. Working with the Network team to set up the Load Balancer across the Informatica servers.
- License compliance maintenance and update as necessary.
- Documentation of ETL server installations and migration including client components.
- Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA, and PROD).
- Working on INCIDENT Tickets and Providing L3 support for the Informatica Applications (IDQ, EDC, TDM.ILM).
- Installing and setting up Compact BI for scanning the PWX resources to generate the Lineage and integrate with Axon.
- Responsible for migrations from the Development repository to the QA and Prod repositories.
- Responsible for enabling the SSL for Informatica domain and enabling secure protocol for the Console URLs and secured domain, creating keystore, trust store files and exporting CA signed certificates.
- Installed Informatica Power Center 10.2 in AWS EC2 instance Leveraged EFS on Informatica servers as NAS shared Files system and EBS Configure RDS for Informatica Power Center version 10.2.
- Used SQL Database as Informatica Power Center metadata database in AWS servers.
- Provide L2 and L3 support for Informatica applications.
Informatica Administrator/Production Support
Toyota Financial Services
12.2017 - 07.2019
- Installed and Configured Informatica Power Center 10.1 on Linux Servers Upgrade Informatica Power Center from 9.5.1 to 10.1.
- Adding and managing users, Creating connections and startup and shutdown IICS secure agent.
- Working with an Informatica vendor regarding any updates to the IICS.
- Installing the IICS secure agent on UNIX servers.
- Worked with the vendor in upgrading ICS to IICS and co-ordination with the application teams.
- Responsible for Power Center, PMPC, and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
- Installing, configuration, and upgrade of Informatica Data Integration Hub (DIH) across different environments.
- Implementation of Informatica Power Center DR.
- Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
- Migration of Informatica objects across the environments using the deployment groups.
- Configured OS Profiles, LDAP Authentication and applying the Patches Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
- Configured Master Node and Backup nodes under High Availability environment License compliance maintenance and update as necessary.
- Documentation of ETL server installations and migration including client components.
- Responsible for maintaining repository backups and their restorations.
- Responsible for migrations from Development repository to the QA and Prod repositories.
- Configuring HPOV alerts for Informatica repository services.
- Upgraded Informatica Power Center from 9.5 to 10.1, 10.1 to 10.2 HF1, 10.1 to 10.2.
- Troubleshoot the Productions failure and provide root cause analysis.
- Worked on emergency code fixes to Production.
- Worked with IBM vendor and Application team to move the Informatica workflows from Netezza to Sailfish database on Informatica 10.1 Worked with the DBA to improve Informatica session performance.
- Query performance by collecting statistics and defining relevant indexes on target tables.
INFORMATICA ADMINISTRATOR/Production Support
T Rowe Price
05.2016 - 11.2017
- Gathering the requirements for the Informatica Power Center Install on Servers.
- Responsible for Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
- Responsible for upgrading Informatica PowerCenter and data quality to 9.6 versions and troubleshooting issues related to the upgrade.
- Configure the Security (LDAP), enabling the OS profiles and Applying Patches on the base install. Creating Users, Groups, Roles, and granting privileges to the users.
- Create folders, Relational and Application connections and configure the ODBC connectivity.
- Installing secure agent IICS (Informatica Cloud) across different environments and managing users for Informatica cloud.
- Working on the deployments for IICS from one environment to the other environment.
- Participated in team meetings and proposed ETL Strategy and provided them best practices.
- Configuring Repository backup jobs across all the different applications of Informatica.
- Upgraded Informatica power center 9.1 to version 9.6.1 on Linux servers.
- Install and configure DVO tool for validating the data.
- Install and Configure Informatica DR environment platform.
- Created Shell scripts to automate the Backups, ETL Execution.
- Worked on Managing the Alerts for the server failures using SMTP Configuration.
- Experience in writing, testing, and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL.
- Provided ongoing support and maintenance of the migrated MDM system, resulting in improved system performance and increased end-user satisfaction.
- Monitor and communicate the availability of UNIX and Informatica Environment.
- Follow-up on problem tickets.
- Install Metadata Manager and load resource and generate lineage.
- Reviewing the code for different Projects before Promoting their code to different Environment Implemented Informatica Power Center, IDQ, MDM DR.
- Worked on installing and updating Informatica address doctor incrementally for every 3 months on IDQ servers.
- Worked closely with Development managers to evaluate the overall project timeline.
- Experience in Installing and configuring MDM HUB software and setting up databases for the Hub store.
- Experience with configuring security access manager, resource loading and monitoring operations of MDM HUB.
- Migrating the code to different environments in MDM.
- Working with the application team and database to perform MDM refresh activities.
- Enabling SSO for the Informatica MDM.
- Involved in Prod Support on Informatica Power center, MDM, IDQ, ILM, TDM and Informatica Cloud to research and resolve the daily load issues and troubleshoot them.
- Document the Prod job failures and provide the root cause analysis to the management.
- Used Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA and PROD).
- Developed UNIX scripts for scheduling the delta loads and master loads using Auto sys Scheduler.
- Configured and implemented the IBM mainframe large environments with the source and target.
- Worked on the JAWS analytic tool.
- Creating Job streams and generating reports for the Project teams.
Informatica ADMINISTRATOR
Apps Services
08.2010 - 07.2014
- Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
- Responsible for maintaining repository backups and their restorations.
- Responsible for migrations from Development repository to the QA and Prod repositories.
- Populated data into staging tables from flat files, XML sources and Relational Sources.
- Installed and Configured Informatica Power Center on Client and Server Machines and Configure Informatica Server and Register Servers.
- Worked on Informatica Power Center 8.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
- Managed one-time migration of data with planned outages in the weekend.
- Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
- Used Workflow Manager, Repository Manager for Creating, Validating, Testing, and running the Batches and Sessions and scheduling them to run at specified time.
- Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
Education
MASTER’S - COMPUTER SCIENCE
Texas A&M University-Kingsville
12.2015
BACHELOR’S - Information Technology
JNTU University
Hyderabad, India01.2010
Skills
- Informatica Power Center
- IICS/IDMC
- Informatica Power Exchange
- Informatica Data Quality
- Informatica MDM
- MDM SaaS
- Business 360 Console
- Informatica EDC
- Axon
- Cloud Platform
- Oracle
- Snowflake
- Shell Scripting
- Linux
- Python
Timeline
IDMC Administrator Lead/Engineer
USAA
04.2025 - Current
IDMC Administrator Lead
Johnson & Johnson
11.2024 - 04.2025
IDMC Administrator Lead
One America
04.2024 - 11.2024
SR Informatica Cloud Administrator/Production Support
JCI
03.2023 - 03.2024
Sr. Informatica Administrator/Production Support
FANNIE MAE
08.2020 - 02.2023
Informatica Administrator/Production Support
TOYOTA FINANCIAL SERVICES
08.2019 - 07.2020
Informatica Administrator/Production Support
Toyota Financial Services
12.2017 - 07.2019
INFORMATICA ADMINISTRATOR/Production Support
T Rowe Price
05.2016 - 11.2017
Informatica ADMINISTRATOR
Apps Services
08.2010 - 07.2014
BACHELOR’S - Information Technology
JNTU University
MASTER’S - COMPUTER SCIENCE
Texas A&M University-Kingsville