SUMMARY:

• Having 11+ years of IT experience in Administrative, Development and Support of D Confidential Warehousing and D Confidential Integration Solutions using Informatica Tool.
• Hands on knowledge and experience with Informatica Power Center, Informatica D Confidential Quality, Informatica Meta D Confidential Management, Business Glossary, Test D Confidential Management, Master D Confidential Management, Proactive Monitoring and Enterprise D Confidential C Confidential log etc.
• Hands on experience with installation, configuration, Upgradation, apply HF and EBF in different Informatica products as well as provide the day by day basic production support activities.
• Performed to install the Informatica client, server and created the different type of application services like (RS, IS, DIS, MRS, TMS, MM, ANS, CMS etc.) in both window and Linux environment.
• Performed different Informatica administration tasks such as create folders, users, groups, roles and provide the privilege & permissions in both Informatica and in Linux end.
• Performed the different type of ETL activities as an Informatica Administrator and developer in different environment with different domain knowledge like Banking, Health Care, Finance and Media Entertainment.
• Worked in different type of connections such as Oracle, SQL server, Netezza, Terad Confidential, SAP and ODBC etc. in different environment.
• Performing the different type of code migrations technique such as folder migration, DG migration and export/Import method and Script migration from dev to stage to prod environment of Informatica objects.
• Provided different types of PC, DQ, ANS, MM.MDM, TDM, EDC related issue such as analyzed the long running workflows generation/execution, project set up, access related, performance and connections etc.
• Installation, configuration of PMPC3.0, set up the Confidential account for rule point, PMPC and RTAM in different environments.
• Handling the production issues within SLA period and providing support to client on 24*7 bases, on call etc.
• Involved in creating different type of scripts (Domain/Repository Back up, Clean up, Project set up, Monitoring) which decreases the manual effort and save the time of our resources.
• Interacts with the vendors in rated technology stacks, ensure all products are used in accordance with our Informatica licensing agreements.
• Involved in technical discussions, documentation, peer reviews and providing guidance to team members as well as attending different meetings in such as maintenance window or any issue related to product with different teams such as D Confidential base, Network, Linux, Storage and application team in regular basic.
• Ability to work individually as well as in a team environment with problem solving and trouble - shooting capabilities.
• Good interpersonal skills, commitment, result oriented, hard working with a zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX.

Programming / Scripting: SQL, Knowledge in window and Unix script

D Confidential base: Oracle 11i/10g,12c, Tera D Confidential, SQL Server 2012

Packages: MS-Office 2007/2010/2016

D Confidential Warehousing Tools: Informatica 10/9.6/9.5

Tools: SQL Developer, Toad, Tidal, Win Scp

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Admin

Team Size: 5

Environment: Informatica 10.x, Oracle 12c, Linux Rhel 7.x, Tera d Confidential

Responsibilities:

• Providing different types of L1/L2/L3 support activities as per the SLA.
• Installed and configured the power center 10.1hf1 in UNIX Rhel 7.x platform.
• Performed Informatica upgrade from 961hf4 to 10.1hf1 in all environments as per the client requirement.
• Upgraded the hot fix and applied the EBF in IDQ 961 hf4 in all environments.
• 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 d Confidential base patch, OS upgradation and hot-fix applied as per the maintenance window
• Involving in IDQ & MDM day by day production supports request by the customer.

Confidential

Informatica Admin

Team Size: 8

Environment: Informatica 9.6/9.5, Oracle 11i, SQL Server 2005, Service Now

Responsibilities:

• Providing different types of L1/L2/L3 support activities as per the SLA.
• Installed and configured Power Center 9.6.1 HF2 in UNIX platform for new DC.
• Performed Informatica upgrade from V9.5.1 HF3 to V9.6.1 HF1 for TDM environment.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, 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.
• Interact with customers, responding to technical inquiries, and requirement gathering, and documentation, communication on scheduled and unscheduled system events.
• Work with Informatica Vendor to understand new features, functionalities and capabilities required for project.
• Always fixes the issues within SLA’s period and providing support to client on 24*7 bases, on call etc.
• Performed different Informatica administration tasks such as created users, groups, privileges, roles, permissions and connection etc.
• Involved in DR activity and all other maintenance activity such as Involved in d Confidential base patch, OS up gradation and hot-fix applied as per the maintenance window
• Involved in Test d Confidential management installation, up gradation and provide day by day production support as requested by the customer.
• Involved in PMPC 3.0 installation and configuration and verify the alert mechanism.

Confidential

Informatica Admin.

Team Size: 12

Environment: Informatica 9.6/9.1, Oracle 11g, Terad Confidential, Service now

Responsibilities:

• Installed and configured Power Center 9.1.0 and 9.6.1 on UNIX platform.
• Performed Informatica upgrade from V 9.1.0 to V9.6.1 in Window platform.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.
• Migrated of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments using various technique such as Export/Import method, DG/Folder migration.
• Worked on EBF and hot-fix upgrades and also involved with different team during the maintenance window.
• Ensured that all support requests are properly approved, documenting common issues and resolution procedures and maintain ticket status, change Request based on ITIL-based ticketing.
• Interact with customers, responding to technical inquiries, and requirement gathering, and documentation, communication on scheduled and unscheduled system events.
• Follow all J&J processes including IQ/OQ (Installation Qualification/Operational Qualification) documenting that all installation steps have been adhered and completed.
• Work with informatica Vendor to understand new features, functionalities and capabilities required for project.
• Always fixes the issues within SLA’s period and provided support to client on 24*7 bases, on call etc.
• Created Groups, roles, privileges and assigned them to each user group and restrict the privilege depend on each environment both from application and server level.

Confidential

ETL Specialist

Team Size: 10

Environment: Informatica 9.1, SQL Developer, UNIX, Win Scp, Oracle 11i.

Responsibilities:

• Performed Installations/Upgradation, Setup, Maintenance & Troubleshooting of Informatica Software on Linux and Oracle platform.
• Created Groups, roles, privileges and assigned them to each user group both for Native and Confidential account.
• Setup and configured power center domain, grid, repository services and Integration service in oracle and Linux platform.
• Involved in creating different type of scripts (Back up, Clean up, Project set up, Monitoring) which decreases the manual effort and save the time of our resources.
• Identifies performance bottlenecks and availability risks, manage action items to address and prevent issues, and influence peer organizations to implement improvements.
• Proactively monitor and apply required bug fixes, Hot Fix releases etc. on the existing Informatica environments
• Accepted and resolved, within defined SLA metrics, operations application and d Confidential related help desk requests to meet or exceed IT support expectations.
• Monitor the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Prepared the month load closing status and Send the daily load status as per the client requirement.
• Gathering the month load preparation and Maintain a log files, screenshot, run statistics.
• Communicate with the clients and customers and attend the calls and provide the solution on time.
• Always fixes the issues within SLA’s period and provided support to client on 24*7 bases, on call etc.

Confidential

ETL Specialist

Team Size: 10

Environment: Informatica 9.1.0, Oracle 10g, Tera D Confidential, Autosys

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 like (RS,IS,DIS,MRS,TMS.etc) 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, Terad Confidential 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.
• Work with application developers and other technologists to troubleshoot issues with pre-production and production systems.
• Experienced in Informatica developer and analysist to perform the project set up and access provided to the user/groups in project folder level
• Prepared ETL specification after getting a hold on business needs
• Interacted with client to understand mapping for implementation of CR
• Developed mapping for extraction, transformation and loading of d Confidential from OLTP to staging using various Transformations.
• Developed mapping to load to d Confidential from Staging area to D Confidential warehouse, using SCD techniques.
• Prepared unit test cases and executed the System integration test cases.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Attended daily call with team members and on-site coordinator to discuss about the future requirement.
• Worked on Autosys tool for running jobs, scheduling jobs and monitoring output.
• All the errors encountered while testing was reported to the concerned point of contacts.
• Ensured proper business logic has been taken care during the development.