We provide IT Staff Augmentation Services!

Sr. Informatica/edg Administrator/lead Resume

3.00/5 (Submit Your Rating)

Minneapolis, MN

SUMMARY

  • Overall 9+ years of experience in the field of Information Technology with ETL Informatica administration, design, development and Data Warehouse implementation, 3+ years of Experience in EDC,B2B DT, DX, HIPAA.
  • Expertise as Informatica Administrator to setup new Informatica environments and Upgrade existing Informatica environments to new versions.
  • Expertise in installing, configuring, maintaining and Upgrading Informatica Power Center (9.x, 10.x (10.4.1,10.2HF1,10.2,10.1.0,10.1.1,10.1.1HF1)) versions on Unix, AIX servers.
  • Performed MDM 10.2hf1/10.3 setup on Linux servers.
  • Setup and configured HA/GRID on nodes.
  • Worked on different versions of Address Doctor Engines.
  • Experience in installing and configuring IDQ services.
  • Expertized in installing and configuring B2B DX, DT and HIPAA.
  • Installed/Configured EDC 10x versions and setup different resources i.e SQL/ORACLE/DB2 ZOS/DB2 MAINFRAME/SALESFORCE/SHAREPOINT/CUSTOM MODELS/ Confidential S3.
  • Experienced configuring license, certificates, connections related to Salesforce.
  • Hands on experience with Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
  • Created and configured Power Exchange, HDFS connectivity.
  • Good experience with change management, deploying code from DEV to TEST and PROD - using deployment groups in Informatica Repository manager.
  • Provided guided support for the teams involved in B2B DT for deployment and resolving issues on B2B DX side.
  • Responsible in Installing/administering the ‘Denodo’ and ‘RightData’ Applications.
  • Setup Roles/Users in Denodo application.
  • Configured the AD groups for different roles for different application teams.
  • Configured various database connections in Denodo application.
  • Configured various jobs for different line of business.
  • Performed an Upgrade on Denodo to latest version.
  • Setup Users/Roles/query chains in RightData App.
  • Installed/Configured /Administered “MoveIT-Automation App”.
  • Performed FTP/SMTP and PGP transfers.
  • Maintained DR plan for Informatica Suite servers.
  • Experienced in Setup and Configuration of Metadata Manager and performed lineage.
  • Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP), Change Management (JIRA).
  • Documented informatica related Runbook, Procedures, Best Practices on ‘CONFLUENCE’ .
  • Build automated Scripts to have Informatica server startup/shutdown via ‘JENKINS.’
  • Installed and Configured BIGIP load Balancer for Informatica.
  • Installed and Configured ‘SPLUNK’ on Informatica servers to have logs dumped on Splunk dashboard via Forwarder.
  • Installed and Configured EDC (Enterprise Data Catalog) and it’s dependent governance applications i.e AXON, Axon agent, DQ agent.
  • Configured IICS and setup domain/repository for alerts/monitoring.
  • Axon EDC integration.
  • Map EDC Assets to Axon.
  • Linked Glossary assets from EDC to Axon.
  • Installed and Configured BDM.
  • Installed and Configured ‘APPDYNAMICS’ on informatica Servers to monitor the performance.
  • Maintained and stored informatica metadata backups on ‘BITBUCKET’.
  • Responsible for performing the MDM installation 10.2HF1, registering/configuring ORS.
  • Responsible for managing SAN, NAS mounts storages and interacting with dependent teams.
  • Coordinated with information Security team for new AD user setups and access related concerns.
  • Coordinated with the ‘End-User’ application team for packing the ‘Informatica’ Products to Stakeholders machines.
  • Well-exposed and problem solver for Business Glossary, Analyst service issues.
  • Involved in applying necessary ‘EBF’ for IDQ, PC and B2B DX/DT.
  • Expertise on Informatica client tools Admin Console, Developer tools, Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
  • Installation and configuring Secure @ source Enterprise standards.
  • Pertinent experience using heterogeneous databases such as Oracle 9i/10g/11g, DB2/UDB, MS SQL Server 2012/2008, XML and various Flat File (Structured, Unstructured) systems for integration into Enterprise/Business Analysis DWH.
  • Experience in writing shell scripting for various ETL needs.
  • Well exposed and worked closely with testing teams in performance unit testing, user acceptance testing and system integration testing.
  • Used Auto Sys for automatic job management, event driven scheduling and programmable error recovery.
  • Experience with Metadata Manager and Data Analyst.
  • Support the Testers, Deployers and provided KT sessions to the Teams about the best Practices.
  • Exclusively worked on different flavors of UNIX and Windows operating systems and good Experience in UNIX shell scripting.
  • Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.
  • Coordinated with Release Management Teams for any infrastructure changes.
  • Coordinated with the vendor Informatica GCS for ongoing and escalations issues.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/, SQL Server 2012/2008/2005 , DB2 10.1/9.7 FP1, Sybase 15.x.

ETL Tools: Informatica Power Center 10.2HF 1/10.2.0/10.1.1 HF 1/ 10.1.1/10.1.0/ 9.6.1/9.5.1 , MDM 10.2/10.3,Power Exchange, Data Analyst, Metadata Manager 10.1.1,10.1.0, B2B DX,DT 10.1.1/10.1.0/ 9.6.1/9.5.1 , HIPAA 6.7/8.4,TDM, EDC, Axon.

Operating System: Unix-AIX/Linux/Solaris, Windows NT/2000/XP/Server.

Languages: SQL,PL/SQL, Shell Scripting

Modeling Tools: ER Studio, Erwin 4.1, MS Visio.

Other Tools: SQLPlus, Toad, AutoSys, SQL developer, SQL Management Studio, Microsoft Visio,Jenkins,BIGIP,Splunk,AppDynamics,JIRA,Confluence,Denodo,RightData

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Informatica/EDG Administrator/Lead

Responsibilities:

  • Responsible for maintaining Power Center and Power Exchange installations, configuring Power Center Domain, node and Create Different services in the Domain.
  • Installed and configured ‘Informatica v10.1.1 HF1/10.2HF2/10.4.1 PowerCenter and DQ services‘ on Windows platforms.
  • Coordinated with the web infrastructure, Database, Desktop Support and Security teams while initiating the setup.
  • Responsible for initiating the backups of the repository.
  • Responsible for deploying metadata across different regions (DEV, QA, STG and PROD) of Informatica.
  • Responsible in resolving the bottleneck issues for PowerCenter/DQ jobs.
  • Performed tuning of Informatica Mappings for optimum performance.
  • Responsible for maintaining the Informatica Servers w.r.t Memory/Health Monitor.
  • Configured LDAP security profiles for various regions.
  • Responsible for creating the users/groups.
  • Created Relational Connections for PowerCenter/Data Quality.
  • Responsible for configuring the batch load process.
  • Expertized in B2B Data Exchange, Data Transformation 10.1.1HF1 and HIPAA/NCPDP Validations installation and configurations setup.
  • Helped in deploying the B2B DT files on the server side across various environments through Production Environment.
  • Helped in placing the B2B DT files in the source location and waiting for them to get processed.
  • Helped in running the B2B files using Informatica and tracking down the status both on B2B DX console and Informatica Monitor to observe the Statistics of Applied Rows, Affected Rows and Throughputs.
  • Experience in TDM for Data-Mask and Data Sub-setting.
  • Installed and Configured EDC 10.5x (Enterprise Data Catalog) and it’s dependent governance applications i.e AXON 7x, Axon agent, DQ agent on both AWS cloud and IBM instances.
  • Configured IICS and setup domain/repository for alerts/monitoring.
  • Axon EDC integration.
  • Map EDC Assets to Axon.
  • Linked Glossary assets from EDC to Axon.
  • Utilzied Swagger to sync the data between AXON and EDC.
  • Created various Native and custom resources in EDC.
  • Helped customer/user in building DQ profiles and scorecards.
  • Helped in configuring the resources within EDC with relationships and data lineage.
  • Helped in resolving various Axon/Catalog issues with data assets/relationships/profiles etc.
  • Responsible in configuring the sync between EDC and AXON.
  • Responsible in creating Firewall requests for EDG/IDQ servers and appropriate application end database server for configuring the EDC resources.
  • Responsible in syncing the data for DR instances for EDC/AXON servers.
  • Responsible in upgrading DR servers.
  • Coordinated with new applications teams on providing the introduction on EDG/AXON/IDQ applications to review their metadata.
  • Maintained and Created ‘Service-Now’ for tracking down the ongoing tasks assigned.
  • Expertized in administering the ‘Denodo’ and ‘RightData’ Applications.
  • Setup Roles/Users/Connections/Jobs in Denodo app.
  • Created DEV/STG/PROD instances for Denodo application.
  • Performed an upgrade for Denodo app.
  • Interacted with Denodo support team via support cases for various build/job issues.
  • Setup Users/Roles/querychains in RightData App.
  • Installed/Configured /Administered“ MoveIT-Automation App”.
  • Performed FTP/SMTP and PGP transfers.
  • Documented Informatica best practices and configurations on ‘Sharepoint’.
  • Interacting with the vendor Informatica GCS for ongoing and escalations issues.

Environment: Informatica Power Center 10.1.1HF1/10.2HF2/10.4.1, DataQuality 10.1.1HF1/10.2HF2,Power Exchange, B2B DX/DT (10.1.1HF1/10.2HF2), DVO v 10.1.1/10.2 HF2, TDMv10.1.1HF1/10.2HF2, SQLSERVER 2016, Toad, SQL Management Studio, Windows XP/Server, DB2 10.1, Denodo, RightData., MoveIt-Automation, EDC 104/105x, Axon 7x.

Confidential, Michigan

Sr. Informatica Administrator/Lead-Architect

Responsibilities:

  • Responsible for maintaining Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
  • Installed and configured ‘Informatica v10.2 DQ services‘ on linux platforms.
  • Setup and configured ‘HA’ and ‘GRID’ for informatica DQ services.
  • Coordinated with the web infrastructure, Database, SSA teams while initiating the setup and configuring Informatica 10.2 on Linux platforms.
  • Setup and configured Enterprise Data Catalog on linux environments.
  • Setup and Configured Axon and its related agents on Linux instances.
  • Setup and Configured Axon agent on linux instance.
  • Configured SQL/JDBC/ORACLE resources on EDC LDM.
  • Helped various applications teams on previewing their data on IDQ and catalog UI.
  • Setup and configured Load Balancer ‘BIGIP’ for Informatica.
  • Configured ODBC and Environmental Variables on Informatica Servers.
  • Responsible for initiating the backups of the repository.
  • Responsible for deploying metadata across different regions (DEV, USER, QA and PROD) of Informatica.
  • Responsible in resolving the bottleneck issues for DQ jobs.
  • Performed tuning of Informatica Mappings for optimum performance.
  • Responsible for maintaining the Informatica Servers w.r.t Memory/Health Monitor.
  • Responsible for running additional resource of applications to track the traces of heap dumps for the bottle neck issues.
  • Configured and tuned up Informatica Product which supports DQ Batch Load (30Million) running parallel with Openshift Java Realtime/Webservice calls.
  • Configured LDAP security profiles for various regions.
  • Responsible for creating the users/groups.
  • Created Relational Connections for Data Quality.
  • Responsible for initiating ‘JENKINS’ to have informatica node startup/shutdown.
  • Responsible in building the automated scripts and invoking them into Jenkins to have jobs automated.
  • Setup and configured ‘Splunk’ for informatica to have domain and services logs uploaded to Splunk dashboard via Forwarder.
  • Setup and configured ‘App Dynamics’ for informatica to have it monitored for the performance.
  • Utilized ‘Bitbucket’ to have the backups dumps stored.
  • Installed and configured ‘PowerExchange’ for JDBC DB2 connectivity.
  • Involved and help development team in having all sets of pre-requisites (java,database schemas etc) enabled for the successful data flow of DQ for real time in MDM.
  • Responsible for maintaining a RUN book for MDM 10.2 HF1.
  • Responsible for setting up all pre-requisites ready installed on the linux servers prior MDM install.
  • Responsible for performing the MDM installation, java web start for HUB console, configuring/registering database ORS in HUB console.
  • Responsible for creating Hub master db and vm hosting app server.
  • Responsible for exports/imports of metadata into MDM master database.
  • Responsible for configuring Hub server, cmx server properties and its file.
  • Responsible for Configuring ActiveVOS to point correct hosts, configuring properties file.
  • Responsible on repackaging the EAR files.
  • Responsible on setting/registering ‘Process Server’ and configuring properties with node,server.host information.
  • Registering the LDAP authentications and providing access roles to the users within console and database access.
  • Responsible for configuring IDD on ActiveVOS.
  • Responsible for configuring workflow engine and Resource KIT.
  • Responsible for configuring the batch load process.
  • Maintained and Created ‘JIRA’ for tracking down the ongoing tasks assigned.
  • Documented Informatica best practices and configurations on ‘CONFLUENCE’.
  • Interacting with the vendor Informatica GCS for ongoing and escalations issues.

Environment: Informatica Power Center 10.2HF1, MDM 10.2/10.3,Power Exchange, SQLSERVER, Toad, SQL Management Studio, Windows XP,UNIX/Linux, DB2 10.1.,Jenkins, Bit bucket, BIGIP, Splunk, App Dynamics,JavaSoapUI., EDC, Axon.

Confidential, NJ

Sr.Informatica Administrator/Architect

Responsibilities:

  • Responsible for maintaining Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
  • Installed and configured IDQ services on 10.1.1HF1 informatica.
  • Installed and configured Metadata Manager and loaded resource for PC, BG, OBIEE, Hyperion and generated lineage, Metadata manager linking rules.
  • Worked on Business Glossary setup on 10.1.1HF1 informatica.
  • Worked on migrating the Business Glossary contents from 9.6.1HF4 to 10.1.1HF1 informatica.
  • Created Relational Connections and Security Group Project Folders.
  • Creating on board new users, assigning them to the repository security group, project folder and assigning them the privileges.
  • Responsible for maintaining both hardware and software requirement as part of prerequisite prior installations.
  • Coordinated with the ‘Storage Management’ team to have the enough storage limitations prior the informatica installation/upgrade.
  • Coordinated with the ‘TechCafe’ team to have the security clearance while installing the applications.
  • Coordinated with the database team to have the new schemas created and backed-up.
  • Coordinated with the ‘End-User-Management’ Team for packaging ‘Informatica Suite’ after performing the initial checks.
  • Worked as ‘Business Glossary Administrator’ in solving the product related issues.
  • Worked on ‘Rest API’ issues.
  • Upgraded Informatica Address Doctor Engine v5.8 to 5.9 and 5.11 on 10.1.1HF1 Informatica.
  • Responsible for regular downloads and updating Address Doctor library files.
  • Involved in setting up EIC (Enterprise information Catalog).
  • Worked on the incident Heat production requests.
  • Used Informatica PowerCenter Repository to deploy the Informatica jobs among different environments (DEV, TEST, QA and PROD).
  • Worked with Web-Hub Service team for the keystore setup issue and validated SOAP test.
  • Responsible for maintaining repository backups and their restorations
  • Involved in Prod Support to research and resolve the daily load issues and trouble shoot them.
  • Interacting with the vendor Informatica GCS for ongoing and escalations issues.

Environment: Informatica Power Center 10.1.1HF1, 9.6.1HF4, Power Exchange, Oracle 11g, Toad, SQL Developer, Windows XP,UNIX/Linux, DB 2 10.1/9.7/8.1 , SQL Server 2012

Confidential, Greensboro, NC

Sr Informatica Administrator

Responsibilities:

  • Responsible for Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
  • Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
  • Created and configured HDFS connection so that the application developer can make a use of reading and writing the data to HDFS or to local file system and access data in Hadoop Cluster.
  • Installed and configured IDQ services.
  • Install Metadata Manager and load resource and generate lineage, Metadata manager linking rules.
  • Installed and Configured BDM and its dependent application services.
  • Managed BDM connections privileges.
  • Configured Kerberos authentication on both Active directory BDM.
  • Configured BDM repositories, users, security management.
  • Performed data ingestion to Hadoop cluster.
  • Performed processed data on the cluster and extracted data from the Hadoop cluster.
  • Performed Informatica mappings transfer into Scala code in Spark mode and MapReduce mode in Hive.
  • Used CDC to perform the updates made on the source files.
  • Documented steps for both upgrade and back-out(rollback plan) steps in high level for the implementations.
  • Contacted DBA, Midrange, Storage Teams for the backups prior environment upgrade.
  • Upgraded Informatica PowerCenter, B2B, Metadata Manager from 9.5.1 to version 10.1.0 and 10.1.1 on AIX/Linux servers.
  • Upgraded Informatica Address Doctor Engine v5.8 to 5.9 and 5.11.
  • Expertized in solving issues with Business Glossary /Analyst Services.
  • Worked on ‘Rest API’ issues.
  • Responsible for regular downloads and updating Address Doctor library files.
  • Created JIRA Change Management request for tracking issues on the server sides.
  • Interacted with Information Security team for the new AD account setup and access related issues.
  • Coordinated with dependent teams like Storage team (SAN, NAS mounts), Midrange team (AIX administrators), DBA (oracle, SQL, Shadow-teams) while planning for upgrades.
  • Participated in team meetings and proposed ETL Strategy and provide them best practices.
  • Interacting with the vendor Informatica GCS for ongoing and escalations issues.
  • Coordinated with Release Management Teams for any infrastructure changes.
  • Worked with Web-Hub Service team for the keystore setup issue and validated SOAP test.
  • Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
  • Expertized in B2B Data Exchange, Data Transformation 10.1.0 and HIPAA Validations installation and configurations setup.
  • Validated Emergency Bug Fix for B2B DataExchange v10.1.0 and Installed B2B DX Client plugin.
  • Helped in deploying the B2B DT files on the server side across various environments through Production Environment.
  • Helped in placing the B2B DT files in the source location and waiting for them to get processed.
  • Helped in running the B2B files using Informatica and tracking down the status both on B2B DX console and Informatica Monitor to observe the Statistics of Applied Rows, Affected Rows and Throughputs.
  • Install Metadata Manager and load resource and generate lineage, Metadata manager linking rules
  • Experience in TDM for Data-Mask and Data Sub-setting.
  • Performed tuning of Informatica Mappings for optimum performance.
  • Responsible for maintaining repository backups and their restorations
  • Worked closely with Development managers to evaluate the overall project timeline.
  • Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
  • Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
  • Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
  • Involved in Prod Support to research and resolve the daily load issues and trouble shoot them.
  • Document the Prod job failures and provide the root cause analysis to the management.
  • Used Informatica PowerCenter Repository 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.
  • Scheduled meetings with Senior Data Leads and analyzed the data.
  • Worked closely with Deployment tool ‘ACM’ for performing the code migration between various Environments.

Environment: Informatica Power Center 10.1.1,10.1.0, 9.6.1/9.5.1 , Power Exchange, B2B 10.1.1/10.1/9.6.2/9.5 , EAM 8.4/6.7, Oracle 12c/11g, Toad, SQL Developer, SQL Loader, Windows XP, AIX,UNIX/Linux, DB 2 10.1/9.7/8.1 , SQL Server 2012, Autosys.

Confidential, Mounds View, Minnesota

Informatica Administrator

Responsibilities:

  • 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.
  • Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
  • Participated in team meetings and proposed ETL Strategy and provide them best practices.
  • Upgraded Informatica power center 9.1 to version 9.5.1, 9.6.1 on Linux servers.
  • Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
  • Install Metadata Manager and load resource and generate lineage, Metadata manager linking rules
  • Performed tuning of Informatica Mappings for optimum performance.
  • Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
  • Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
  • Involved in Support on B2B for developer teams for their regular job runs.
  • Involved in deploying the B2B files across various environments
  • Involved in Prod Support to research and resolve the daily load issues and trouble shoot 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

Environment: Informatica Power Center 9.6.1/9.5.1 , Power Exchange, B2B 9.5.1,EAM 6.7,Oracle 11g, Toad, SQL Developer, SQL Loader, Windows XP, UNIX/Linux, DB2 9.7, SQL Server 2012, Autosys.

Confidential

ETL Analyst

Responsibilities:

  • Worked cooperatively with the Team Members to Identify and Resolve various issues relating to Informatica and Databases.
  • Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
  • Involved in Migrating the Code from Development to Testing to UAT and to Production.
  • Worked with DB2 Connections, Shadow Connections, Relational connections creations.
  • Worked with Salesforce Team to resolve issues with the certificate issues.
  • Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
  • Provided On-call support 24x7 for any informatica issues.
  • Used Confidential Trouble-ticket web tool to resolve requests.
  • Worked on emergency code fixes (Incident) to Production.
  • Worked an SME (Subject Matter Expert) and trained All New Hires (Transition) Batches on Process.
  • Was a member of Andon Resolver Group (which is basically working in Trouble Ticketing queries in-order to Fix issues

Environment: Informatica Power Center 8.1/7.x, Oracle/9i, DB2, PL/SQL, TOAD, SQL*Plus, SQL*Loader, Windows, UNIX.

We'd love your feedback!