SUMMARY

• Having 7+ years of IT experience in Administrative, Implementation and Support of Data Warehousing and Data Integration Solutions using Informatica Tool.
• Hands on knowledge and experience with Informatica Power Center, Informatica Data Quality, Analyst, Business Glossary, Metadata Manager and IICS etc.
• Hands on experience with installation, configuration, Upgradation, apply HF and EBF in different Informatica products such as PC, DQ as well as provide the day to day basis production support activities.
• Set up the Informatica domain, node configuration, HA, Grid and also created the Repository service, Integration service, model repository, Data integration service, Content management service, Analyst service.
• Migrated the Informatica codes from DEV/QA/UAT/PROD environments using DG migration and export/Import migration method.
• Worked in different type of connections such as Oracle, SQL server, Netezza, Teradata in different environments.
• Work with Informatica technical support to get the root cause/ fix ongoing issues which cause ETL job failures.
• Performed different Informatica administration tasks such as create folders, users, groups, roles and provide the privilege & permissions in application level.
• Extensively worked on UNIX shell scripts on automation (Backup, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.
• Handling the production issues within SLA period and conduct reviews, identify gaps, and recommend and implement change to release and change management policies.
• Involved in technical discussions, documentation as well as attending different meetings such as maintenance window, DR Exercise or any issue related to the product with different teams.
• Proven experience as an Informatica Admin on monitoring resource utilization and proactively identifying Informatica job performance and resource issues network, disk usage, memory usage, server side limitation.
• Designed and Prepared Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Understanding the requirement gathering, design the code and prepare the Unit test case and System Integration test case base on the requirement and delivery the code on time followed by the project life cycle.
• Creation of folders, OS profiles, assign the privilege and role to the Informatica objects and Monitor the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Create the lineage for different resource load and configure the secure agent based on the requirement.
• Continually worked towards improving and stabilizing production environment through shell scripts using Informatica command line utility and deploying them as part of release management.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.
• Good interpersonal skills, commitment, result oriented, hard working with a zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS

Operating Systems: Windows, Linux

Programming / Scripting: SQL, HTML, Linux Script

Database: Oracle 11g/12c, Sql Server 2012, Netezza

Packages: MS - Office 2003/2007/2010

Data Warehousing Tools: Informatica 10.x/9. x.

Other Tools: Putty, Wisp, Toad, SQL Developer, Service now

PROFESSIONAL EXPERIENCE

Confidential

Informatica Administrator

Responsibilities:

• Providing different types of L1/L2/L3 support activities as per the SLA and client requirement.
• Installed and configured the Informatica power center 10.X in UNIX Rhel 7.x platform using Oracle 12c database.
• Performed Informatica upgrade from 961hf1 to 961hf4 in all environments as per the client requirement.
• Performed the Informatica Data Quality Installed and configured and then up gradation for 961 hf4 to 10.1hf1 in UNIX Rhel 7.x platform.
• Set up the domain configuration and different types of services such as Model Repository Services, Data integration Services, Integration services and so on.
• Extensively worked on UNIX shell scripts on automation (Backup, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.
• Performing different types of code migrations technique such as folder migration, DG migration and export/Import method from dev to stage to prod environment of Informatica objects.
• Interacting with customers, responding to technical inquiries, and requirement gathering, and documentation, communication on scheduled and unscheduled system events.
• Working with Informatica Vendor to understand new features, functionalities and capabilities required for project.
• Performing different Informatica administration tasks such as created users, groups, privileges, roles, permissions and connection etc.
• Involving in DR activity and all other maintenance activity such as Involved in database patch, OS upgradation and hot-fix applied as per the maintenance window.
• Extensively Worked on Informatica Server and Client components such as Informatica Admin Console, Repository Manager, Power Exchange Navigator, Designer, Workflow Manager, and Workflow Monitor for ETL Development and Administration activities.
• Guide/support application team in terms of implementation of Informatica best practices while code development process by being proactive.

Environment: Informatica 10.x, Oracle 12c, Linux Rhel 7.x, Tera data 15.X, Service Now

Confidential

Informatica Administrator

Responsibilities:

• Providing different types of L1/L2/L3 support activities as per the SLA.
• Installed and Configured Informatica Power Center and Data Quality 9.x.
• Applied the hotfix and EBF in all environments base on the requirement.
• Create User, Groups and Roles in Admin Console and assign the privileges to the same.
• Create the folders and assign permissions to developers for folders depending up on the environments.
• Performing different types of code migrations technique such as folder migration, DG migration and export/Import method from dev to stage to prod environment of Informatica objects.
• Interact with customers, responding to technical inquiries, and requirement gathering, and documentation, communication on scheduled and unscheduled system events.
• Creating case to Informatica Incase-related to any production usability and install issues.
• Create and maintain technical documentation including operations run books, user guides, and standard operating procedures
• Perform administration of the Informatica Platform, including incident management and resolution and 24x7 on-call rotation
• Support development teams with performance tuning and troubleshooting issues.
• Involved in DR activity and all other maintenance activity such as Involved in database patch, OS up gradation and hot-fix applied as per the maintenance window
• Frequent Informatica/Linux health checkups across all Environments Monitoring Informatica server for I/O Usage, Memory usage, CPU usage, storage usage.
• Configure security for the Users and User groups and implemented LDAP for Informatica and User access management.

Environment: Informatica 10.x/9.x, Oracle 11g, Toad, Netezza, WinScp, Service Now

Confidential

Informatica Administrator

Responsibilities:

• Provided the L1/L2 support activity as per the SLA request.
• Create users, groups and roles and assign the privilege base on requirement.
• Create folders and give permission for the folder in a Repository.
• Migrate the informatics and Linux codes from one environment to other base on the CR.
• Automated the script which are taking the informatica domain, repository backup in daily basis and also monitor the services and taking care of server space utilization alerts.
• Worked in different type of connections such as Oracle, SQL server, Teradata and ODBC etc. in different environment.
• Working with Informatica Vendor to understand new features, functionalities and capabilities required for project.
• Handling outage and restarting the service in time.
• Handballing all application related issue which occur and providing the root cause analysis to the issue.
• Coordinating with all the UNIX, Network, Database Admin and other teams whenever require for troubleshooting the issue.
• Review of informatica ETL design documents and working closely with development to ensure correct standards are followed
• Scheduling jobs through autosys for monthly and daily job cycles and Support production jobs with performance tuning and troubleshooting issues
• Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language.

Environment: Informatica 9.x, Oracle 10g, Toad, Autosys, WinScp, Service Now

Confidential

Informatica Administrator

Responsibilities:

• Provided the L1/L2 support activity as per the SLA request and also involved in L3.
• Performed to install the Informatica client, server and created the different type of application services in Linux environment.
• Performed the different type of code migrations technique such as folder migration, DG migration and export/Import method from dev to stage to prod environment of Informatica objects.
• Worked in different type of connections such as Oracle, SQL server, Teradata and ODBC etc. in different environment.
• Experienced in Implementing Proactive Informatica Environment Health Checks and Performance Threshold Alerting such as CPU, Memory and disk utilization.
• Preparation of ETL specification.
• Followed technical documents to understand the client requirements
• Developed mapping for extraction, transformation and loading of data from OLTP to Staging area.
• Performed Unit Test Cases (UTC) for mapping according to unit test Plan.
• Optimizing the mapping to load the data and reduce run time.
• Develop the mappings, sessions, workflows as per the design document’s
• Tuned the mapping for better performance on request.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Environment: Informatica 9.x, Oracle 10g, Toad, Autosys, WinScp, Service Now