SUMMARY:

• I have 20 years of experience in Information Technology, of which over 8 years’ relevant experience as Informatica Lead & Administrator for Infrastructure and Maintenance.
• Experience in Informatica Administration, Installation, upgrade, Migrate, Applying Hot Fixes, Configuration, maintenance, migrating objects to DEV, QA and PROD environments.
• Working for Informatica Infrastructure & Application support project, supporting all the Informatica applications EDC,EDP,LDMadmin&LDMCatalogue, EDC Advance Scanners,Axon, IICS, Big Data Management, MDM, IDQ,DPM & Power Center.
• Administration of UNIX, Linux /Windows environment, running automated scripts, rotational on call support and health checks for all environments.
• Installed Informatica 10.5/10.4/10.2.2/10.1.1/9.6/9.1 on Informatica Linux Servers on DEV, QA & Prod Environment for PowerCenter Client, Big Data Management (BDM), EDC, EDP, CDC and Data Quality environments.
• Experience with setting up access roles and privileges and Perform System Administration and Power Exchange System Administration. infrastructure Monitoring for the readiness in the environment, System level parameter checks CPU spike, Memory utilization, Number of parallel loads (sessions) running.
• Experience in creating and managing users, groups, folders and ensure appropriate privileges assigned to the different users and create, update and troubleshoot connections.
• Development experience in creating Profile jobs, Scanners, Resource, Assets, Transformations, creating Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using PowerCenter Designer / Workflow Manager to move data from multiple source systems into a target.
• Team lead Experience, leading a team of 8 people onshore & offshore. Vendor meetings, Coaching sessions, Stand - up meetings, SLA Reports, Budget Planning Resource Hiring .

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Platform Upgrade Consultant

Responsibilities:

• Acted as Team lead for Informatica Platform team group of 7 Informatica’s Admins 2 Hadoop Admins.
• Meetings with Developers and Testers and Admin team.
• Team Meetings and Vendor Meetings, SLAs.
• Administer Informatica applications to include PowerCenter, DataQuality, Data Engineering Integration (BDM), DEQ, and Enterprise Data Catalog.
• Supported Development teams in resolution of issues that they need to solve
• Supported Development teams in setting up Projects, Connections to other sources/destinations, folder creation for scripts, and for source/target files
• Supported Development teams in migrations of developed code from test environment through to production environment
• Monitoring application to keep it healthy
• Perform periodic upgrades of the applications. minor upgrades such as Emergency Bug Fixes up to major version upgrades
• Work with other teams in support of their projects and will also be tasked to construct documentation on various administrative processes.
• Worked Upgrade Project 10.4 to 10.5 .
• Production Support
• EDC Advance scanners support
• Axon Admin support.

Environment: BDM/DEQ IDQ, IPC & EDC 10.5.1.1& 10.4.1.3,Cloudera 6.3.3 & 7.1.7. Kanban and Jira Ticketing.

Confidential

Offshore Operations Lead

Responsibilities:

• Worked on Informatica Infrastructure & Application support, supporting all the Informatica applications lEDC, EDP, Secure@Source, BDM, IDQ and Power Center.
• Maintaining Servers, Nodes & Services for Informatica tools.
• Worked on Informatica 10.4.1.3, 10.2.2 &10.1 EDC, EDP, Secure@Source, BDM, DQ and Power Center Installations, Applied Hotfixes and EBF Patches.
• Created hive, Hadoop, odbc, Teradata & JDBC connections,
• Worked on outage activities like password changes, patch installation, restarting services, license updates & network changes.
• Currently leading a team of eight Admins, on call support for Infrastructure & Application support on all Informatica Servers,
• Working with Developers and Hadoop Admins for Hadoop related issues.
• Worked on Logs, Blazelogs, DISLogs, Profiling logs, Error code analysis, issues, server issues, and data issues.
• Informatica experience to install, configure, upgrade, EBF Install, HF Install, rollback EBF and HF, code migration, folder creation, creating connections.
• Worked Admin tasks like rebooting application server, migrations adding users, roles.
• Automated Jobs for Restarting servers and checking Informatica services (Crontab & infachecker.sh),
• Match rules creations, batch groups, hierarchies, setting up access.
• Installed EDC /EDL on Linux servers and configured services.
• EDC/EDP - Scanners, EDP uploads, Data Profiling. Data Catalogue, Configure EDC services (CAT, EDP, and Data Prep), and GRID services.
• Hadoop 103 TB cluster, Dedicated Node Labels.
• Worked on BDM development like Blaze, Hive, Spark engines.
• Created mappings, Profiles jobs, Scanners, scorecards and Tested with different Loads.
• Worked on BDM (BigDataManagement) setup, created new connections, new mappings and tested jobs.
• Migrations from different environments from Developer client and from Server.
• Worked with Linux Admins, Informatica Developers, and Architects & Informatica Support for Informatica Related incidents & Escalations.
• Created Data Integration Service, Metadata Manager Service, Model Repository Service, PowerCenter Integration Service, PowerCenter Repository Service, Search Service, Content Management Service, Catalog Service on Admin Console.
• Monitoring Jobs on Resource Grid Manager, Blaze Monitor, Admin Console job monitors.
• Secure @ Source 5.1
• Installed Python Binaries 2.7.6 on Linux servers. tested python transformation on Developer client.
• Connect to Domain and Connect to Repository test, Created projects and give Permissions, Import HDFS flat file data object from local machine, Import relational data object from HIVE, ORACLE, SQL SERVER, TERADATA, Created relational table/data objects manually, Created Hive, Oracle or Teradata connection and validate, run Data viewer - unlimited number of records Spark execution, Created mapping and ran from source/target Hive to HDFS, HDFS to HIVE, Hive to Oracle and Vice versa on Native, Blaze and Spark Engine Mode, Created Mapping with RDBMS (SQL SERVER, ORACLE, Teradata) source/target connection, Created and ran Profile and Enterprise Data Profiles on Blaze and Spark Mode. Map Reduce, HDFS, Tez, Hive and Spark. Python transformation Testing.
• Installing Binaries/Informatica Software, set Bashrc variables, Storage & Memory, File system and permissions, Keytabs & Kerberos(krb5), Logs & Locations, OS Profile setup.
• Create, Configure and Check all EDC services (MRS, DIS, AUX, Catalogue Service, Enterprise Data Preparation, Analyst, Secure@Source, Internal Cluster, CMS, MAS, SRCH, Email, RM, ROH, Scheduler & GRID) services are up and running, privileges and permissions are properly set. checked Hadoop, Hive, HDFS, Oracle and JDBC connections working fine or not with proper Hadoop and spark properties added. Monitoring Jobs.
• Create, configure, run and Monitor and Manage Scanners/Resources of Hive, SQL Server, Axon, Custom Lineage, Change Notification Resource, Business glossary, Similarity Discovery, Teradata, System Locations, SAP Power Designer, Informatica Platform, Informatica Domain user, QlikView, PowerCenter, Oracle, Data Domains and DD groups. Jobs Monitoring (Metadata Load, Profile run, Profile fetch, Similarity Profile and value).
• Search, Analyze, Manage and Edit etc. of Resources, Databases, Schemas, tables and data objects. Business titles. about resource Overview, Lineage and Impact, Relationships and Change Summary.
• Uploading files RAW files (CSV, Text, Excel etc) to Desired Databases. Project sharing and Open and prepare the data from the worksheets added in the project.
• Jobs monitoring, node labels, queues, logs and memory.

Environment: Informatica 10.1,10.2 &10.4 EDC/EDP LDMCatalogue, LDMadmin, Informatica Developer, Data Quality (Developer & Analyst), MDM 10.1, BDM, Oracle 12, Hadoop 2.5, 2.6 & 3.1.5, SUSE Linux Enterprise Server 12 (x86 64), Yarn, Blaze & Spark, Yarn Resource Manager, Blaze GRID Manager, Hadoop Ambari, Secure @ Source 5.1, SQL Developer Version 17.2.0.188 and WinSCP. Map Reduce, HDFS, Tez, Hive, Python2.7.6 & Spark.

Confidential

Informatica Developer and Administrator

Responsibilities:

• Oversee project status and update management.
• Assist resolve project issues and been an escalation point for team members and clients.
• Meeting with vendors,Developers, testers,Admins and other teams in th project .
• Migration from 9.1 and to 9.6.
• Making sure all the, ksh, ini and, sh scripts are working fine.
• All workflows are working fine when launching on UNIX and Informatica as well.
• Moving/ migrating files from one server to another on UNIX
• Worked with product managers, technology leaders and key partners in developing a strategy and road map to provide compelling capabilities for our partners across operations that helps them achieve their business goals
• Lead and mentor a small but growing team of manufacturing and operations focused analysts and engineers
• Project management - prioritization, planning of projects and features, Partner management and tracking of external commitments
• Helped define and refine our analytics technology roadmap and technical capabilities
• Managed a team that designs, develops, and maintains business intelligence (BI) applications and tools.
• Identified, research, and resolve technical problems, including developing requirements for new features and enhancements.

Confidential | Milwaukee, WI

BI Tools Support & Informatica CDC Power Center Administrator.

Responsibilities:

• Installing Informatica on UNIX as part of upgrade from 9.1 HF5 to 9.6.1 HF4.
• Creating Infrastructure for new Applications that use CDC (Change Data Capture).
• Installation Informatica Power Exchange CDC 9.6.1 on LINUX and windows.
• Configuration of Power Exchange CDC listener and logger.
• Checking Detail.log for information related loggers.
• Managing Informatica repository backup, domain backup and restore, services monitoring& supporting and maintenance.
• Installation Informatica Power Exchange CDC Navigator 9.6.1 on windows 7/8.
• Configuration of Power Exchange CDC dbmover and pwxccl files.
• Creating Registration groups in Informatica Power Exchange Navigator 9.6.1.
• Registration of CDC tables in Power Exchange Navigator for different source systems like oracle and MS SQL server with the Database Row test.
• Importing CDC tables in PowerCenter Designer.
• Create application connections for Power Exchange CDC real time and continues mode.
• Cold start and warm start workflows with token numbers.
• Creating Registration Groups & Maps and Importing to Informatica 9.6 CDC Repositories.
• CDC tables migration one environment to another environment using PWX Utilities.
• Supporting Production issues like p1, p2 and p3.
• Installing Informatica on Unix Servers as part of upgrade from 9.1.HF5 to 9.6.1 HF4.
• Upgraded 9.6 to 10.1, installing Informatica 10.1/9.6/9.1 on Windows and Installation, upgrade and configuration.
• Maintenance of Informatica servers, Capacity planning, Space cleaning on UNIX/Linux.
• Create Folders and shared folders create, edit, modify and Delete.
• Outages Handling Password Changes, Patch installation (Hot Fixes /Software’s), Bouncing Activities or Restarting the Services and Network Changes.
• Repository Access issues, Domain Configuration, Connections Related issues.
• Kill Sessions on UNIX/Linux Boxes/Servers and Crypto password issues.
• Front end Informatica Installation failed problems, IBM Big Fix issues.
• Creating Relational Connections on DB2, Sybase, PWXDB2ZOS/DB2LUX, ODBC & Netezza and updating ODBC & Netezza entries on Unix Servers, Application Connection on PWXDB2ZOS CDC Real time.
• Installation and configuration of Informatica PowerCenter and other related products.
• Managing the DEV/TEST/PROD environments for uptime according to SLA’s.
• Build Informatica PowerCenter 9.6 batch, CDC and Data Exchange/Data Transformation (DX/DT) and Data Quality environments.
• Install additional Informatica components for various POCs or setting up the environments.
• Perform System Administration and Power Exchange System Administration.
• Experience in Repository creation, integration services and setting up access roles and privileges.
• Liaise with Systems Administrators, Linux/UNIX, Network and DBAs, scheduling and implementing software patches and upgrades.
• Experience in automation of monitoring Informatica environments using Linux/UNIX, pmrep, pmcmd and other Informatica command line language.
• Support development teams with performance tuning and troubleshooting issues.
• Scheduling and Monitoring Informatica repository backup.
• Retail Industry, cash registry Data Collection.
• Worked on Installation, configuration, patching and upgrading of Tableau tool across the environments (Tableau 10)
• Manage the application’s users, groups, and integration with Active Directory.
• Automate monitoring & server job processes.
• Tableau Server Management (Clustering, Load Balancing, User Management etc.)
• Knowledge of Tableau Licensing.
• Tableau migration and scheduling and backups and restoration of Tableau repository
• Knowledge of Tableau Metadata tables and Postgre SQL.
• Supporting Production issues like p1, p2 and p3.

Environment: Informatica 9.1 HF5 /9.6 HF4: Dev/Test Stage/Integration, Prod & 9.6 CDC Dev, Test, Stage/Int, &Prod, DB2, Sybase, ODBC, Shell Scripting & Autosys.

Confidential

Informatica Administration Lead

Responsibilities:

• Installed Informatica ETL systems that are operationally stable, efficient and automated.
• Day to day administration activities user creation, folder creation, configuring DB connections.
• Constantly looking whether the infrastructure is readily available for developers and support team members to perform their tasks. Capacity planning and ongoing monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed.
• Exporting and importing Informatica objects like Mapplets, Mappings, Sessions, and Worklets & Workflows.
• Administration of Repository services and Integration services on Nodes.
• Migration of changes, enhancements etc. through the various environments.
• Carried out root-cause analysis and solution development.
• Configuring Connections FTP, Oracle and SQL Server.
• Planned and assisted on ETL implementations for team utilizing Informatica tools.
• Produced written deliverables for technical design, system testing and implementation activities.
• Installed, configured and maintained the Informatica PowerCenter tool.
• Handled user provisioning and security on the ETL platform.
• Assisted with the integration of ETL toolsets to data sources.
• Monitored and improved the performance of ETL applications.
• Worked with data centers to determine data storage and archiving needs.
• Configure and manage metadata management components of the ETL tool.
• Work with DBAs, application specialists and technical services to tune performance of the system to meet performance standards and SLAs.
• Assisted in the development, documentation and application of best practices and procedures that govern DW implementations and operations.
• Collaborates with Users, Clients and Project teams.
• Install and configure Informatica PowerCenter application software, Create and manage Informatica services Backup/recovery of Informatica software, repository and configurations. Troubleshoot and resolves system issues.
• Ensures proper backup of application data in compliance with regulations.
• Assisted through (Help Desk tickets; phone, email).

Environment: Informatica PowerCenter 9.1/9.6, Oracle 11g, MS SQL Server 2008, flat files, DB2, SQL, PL/SQL, Shell Scripting & Autosys.

Confidential

Technical Team Lead / IT Admin

Responsibilities:

• Pulling day today Reports and Submitting to Manager. Daily Huddles, Monthly Coaching sessions, Weekly and monthly team Meetings. Assigning Tickets, Monitoring Incidents and Requests, Monitoring SLA's and Queue management. Checking Time reports and DSC Reporting. New Employees joining the Team.
• Worked on Various Projects Internal and External as well at Client Sites, Hardware and Software Support for all Internal Confidential Employees, Asset Management and Administration Work, Server Support and Maintenance.
• Managed users, groups, network printers and computers in Active Directory. Installed, Configured & troubleshot Windows Server 2003 & 2008 Active Directory Services.