SUMMARY

• Overall 7+ years of professional IT experience of relevant experience in Analysis, Design, Development, Testing, Administration, and Implementation of various EAI (Enterprise Application Integration), DW (Data Warehouse) and Software Applications.
• Experience in gathering, analyzing, and documenting business requirements, functional requirements, designing and developing the mapping based on the requirements.
• Clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC, Quality analysis, change management, compliance & Disaster recovery.
• Extensive experience on Informatica PowerCenter with strong business understanding and noledge of Extraction, Transformation and Loading of data from/to heterogeneous source systems like Flat files, XML, Oracle, SQL Server.
• Extensively involved in ETL using Informatica PowerCenter 9.x/10.x Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Hands on experience with complex mappings from varied transformation logics like Filter, lookup, Router, Aggregator, Joiner, Update Strategy, and re - usable transformations.
• Extensive experience in Informatica Administration and hands-on experience in installing, configuring, upgrading the Informatica PowerCenter and Data Explorer.
• RDBMS concepts experience in Oracle 19c/12c/11g, SQL*Loader, Netezza, DB2 and Teradata.
• Experience in writing shell scripts.
• Hands-on experience on MRS, DIS and Analyst services configuration.
• Experienced in setting up Disaster Recovery environment and involved in annual DR test exercises.
• Experienced in handling various Informatica PowerCenter code migration methods (XML Export/Import, Deployment Group and Object Copy).
• Experience in handling Informatica repository back-ups, restore and fail-over of services from primary to back-up nodes and vice-versa.
• Experience in installation and upgrade Informatica in UNIX/LINUX and WINDOWS environment.
• Expertise in documenting the ETL process, Source to Target Mapping specifications, status reports and meeting minutes.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x, 9.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Administration Console) Metadata manager, MDM, IDQ (MRS, DIS, AS, CM and SS)

RDBMS: Oracle 19C/12C/11g, SQL Server 2008/2012/2014, Tera Data 14.x/15.x/16. x.

Operating System: RHEL, UNIX, IBM AIX, CentOS, and Windows server 2008/2012/2014 with R2

Job Scheduling Tools: Informatica 10.x, 9x, Control-M 8x and 9x

Languages: SQL, PL/SQL, HTML

Tools: MS Office, MS VISIO, TOAD, SQL-Developer, MS SSMS, WinSCP, Putty, File Zilla

Ticketing Tools: IBM Tivoli, JIRA, Service Now and BMC

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Informatica Administrator

Responsibilities:

• Installed Informatica 9.6.1 HF2, 10.1.1, 10.2 HF2 and 10.4.1 on IBM AIX 7 and RHEL LINUX
• Upgraded Informatica 9.6.1 HF2 to 10.1.1 and 10.2 HF2 to 10.4.1 on IBM AIX 7 and RHEL LINUX.
• Created the Repository, Integration service, web services and enabled the Custom properties in Adminconsole.
• Installed configured and Administering MDM environments.
• Setting up MDM Hub/process Server/Active VOS and IDD on 9.7 and 10.2
• Experienced in creating, configuring, and supporting operational ORS for MDM hub and cleanse servers.
• Installed and configured Address doctor on IPC.
• Supported in creating and configuring IDD and other reference data for MDM cleanse Servers/Process servers.
• Created relations between tables in MDM.
• Created Land, Stage, and Base objects from Hub Console.
• Integrated Informatica Data Quality to MDM Landing tables.
• Converted the Admi console URLs from http to https for different PowerCenter service ID’s.
• Configured LDAP autantication for Infomatica 9.x and 10.x versions.
• Created Relational (Oracle, MS sql server, Netezza, DB2, Teradata and TPT) and Teradata Mload, fast load connections.
• Created Directories and coping the Required files (Source, Target, parameter files) From one env to another env.
• Troubleshooting the issues like workflows, shell scripts fails.
• Creating the Native Groups and assigning LDAP users to dat Native Groups in PowerCenter.
• Created the Repository services without contents and Restored the Backup file for the POC environment.
• Configured Password less autantication between DVO DEV, UAT and PROD for self-service Code Deployment.
• Performing the code migration activity using Export/Import and deployment groups.
• Creating alias/alternate DNS names for FTP and Admin consoles.
• Coordinating with Oracle, MS Sql server, DB2 and Teradata DBA’s for database issues like Space, password, exporting and importing the catalogs.
• Created the ODBC connections, Added the ODBC entries and enabled LDAP autantications.
• Start and stop the Informatica services.
• Adding the Informatica, Oracle, Teradata etc. Environment variables in PowerCenter service Id. profile.
• Support for annual DR testing.
• Provide on call support during weekend and holidays to address production Issues and to monitor the PROD jobs.

Confidential, Texas

Informatica Administrator

Responsibilities:

• Installed Informatica 9.5xon Red Hat Linux platform for new Environment.
• Upgraded Informatica 9.5. xHF3 to 9.6.xon RHEL 6.7.
• Interacting with the clients on a regular basis to discuss day-to-day issues and matters.
• Provide support for 1200 Informatica workflows/mappings (developed using Informatica 9.6.1 and Informatica cloud) which are running into Production environment Confidential client location.
• Installed Informatica cloud Secure Agent on RHEL 6.4 64bit.
• Migration of Informatica Cloud and PowerCenter Objects dev to test, qa and prod.
• Creating users, Relational and Application connections in workflow Manger.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support.
• Handled Critical and non-critical jobs as per client Information.
• Troubleshooting the issue and find out the Root cause when the Informatica domain goes down.
• Supported for Planned and unplanned activities.
• Create salesforce application connections in Informatica cloud.
• Create Amazon web services connection in Informatica cloud.
• Performed disaster recovery tests to ensure system availability and functionality.
• Set up cron jobs, user account maintenance, disk quota controls.
• Maintained and monitored production system alerts and provided triage support.
• Monitoring the Jobs in UC4 tool and sever space availability and CPU Process.
• Code Deployment from dev to test, qa and prod environments.
• Assist with developers to fix and resolve issues related to connectivity to database and Informatica.
• Assist with ORACLE DBA to fix and resolve the oracle account lock and password issues.
• Coordinated with SQL SERVER, ORACLE, Teradata and Linux admin on oracle patches and Increasing CPU and Memory for LINUX boxes.
• Backup and restore the Informatica Repository from PROD to Test.
• Involved in capacity planning for the ETL and worked with Server team to increase the server capacity.

Confidential, Mason, Ohio

Informatica Administrator

Responsibilities:

• Installed Informatica on UNIX/LINUX as part of upgrade from 9.5.1 HF2 to 9.6.1 HF4.
• Configuration of GRID and High Availability architecture in informatica.
• Code deployment using labels one environment to another environment in PowerCenter Repository manger.
• Co-ordinated with offshore team to resolve the issues.
• Installed Informatica cloud secure agent on Windows server 2012.
• Created Oracle, MS SQL Server, and salesforce connection in Informatica Cloud.
• Monitor the day-to-day activity of the data warehouse, Informatica jobs in Control M.
• Assist with the definition of ‘service level’ requirements from all areas of the organization, as they relate to the business Intelligence including application availability, acceptable downtime, data integrity, user support, issue resolution, etc.
• Created Oracle, Teradata loader connections in workflow manager.
• Assigned read, write and Full control permissions for in connections as per env’s.
• Working with other IT teams on application project ETL processes. Ensure standards and procedures for Data Warehouse, ODS, and Data Mart ETL processes are followed.
• Analyze, review and suggestions to increase operating efficiency of ETL servers.
• Experience in scheduling jobs using Control-M.
• Created and maintained specifications and process documentation to produce the required data deliverables.
• Involved in writing shell scripts for regular tasks.
• Administration of BI tools (Informatica Power Center).
• Do POC’s for new functionalities being used for first time.
• Create service requests with vendors for unnon errors, enhancement requests and follow-up.
• Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.
• Code Release Migration from dev to test, QA, and PROD.

Confidential

Informatica Developer

Responsibilities:

• Responsible to monitor and keep the health of Informatica services and Informatica servers.
• Responsible for creating/changing Folders, users, connection objects, deployment groups, promoting/rollback of deployment groups from development to QA and to production environment.
• Support assistance to Informatica developers and advice on their queries.
• Co - ordinate with other support groups in case of planned/un-planned down time.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Involving in extracting the data from Oracle and Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings, and sessions to improve performance Understanding the Functional Requirements.
• Create users, groups and assign permissions in informatica Adminconsole.
• Created connections and folders in Repository manager.
• Deployed Objects from dev to QA and PROD.