PROFESSIONAL SUMMARY:

• 9+ years of IT experience in Analysis, Design, Development, Implementation, Testing, Administrator and Production Support of Data Warehousing and Data Integration Solutions using Informatica Power Center, Data Quality (IDQ), ILM TDM, DVO, Power Exchange (Sales force, Amazon web services S3, Tibco, Hadoop, Sap and Etc ) and Cloud.
• Strong technical experienced in Informatica Repository Manager, Designer, Workflow Manager, Workflow Monitor, Informatica Developer tool.
• Extensively strong work experience on SQL, PL/SQL, Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2 & Teradata.
• Strong Experience on installation & configuration of Informatica PowerCenter, DataQuality (Client/Server), DVO and Power Exchange.
• Experience with product version upgrade from 8x/9x to 10x and applying hotfixes and upgraded to new versions.
• Have good experience as Informatica Administrator in creating Repository, Integration, MRS, DIS, CMS, AS services and folders.
• Experience with Informatica Metadata Manager & Business Glossary tool (MM Services).
• Proficient in using informatica command line utilities like infasetup to define backup and restore domain components, pmcmd to create, schedule and control workflows, tasks and sessions and pmrep to perform repository backups, create folders etc.
• Involved with Pre - session and post session UNIX scripts for automation of ETL jobs using scheduling tools.
• Involved in preparing migration documents to move the mappings from development to production repositories.
• Involved in migration of objects in all phases (DEV, QA and PROD) of project
• Working experience with to maintaining Database relational connections, ODBC connections and installing and maintaining various new database connectivity software and Informatica plugins for respective software.
• Experienced with High Availability, Grid, Real Time and Version control features.
• Created and maintained Users, Groups, Roles and Privileges.
• Prepared a plan for LDAP migration and worked closely with Informatica Administrators and IT Teams to perform the migration from Native security to LDAP.
• Independently perform complex troubleshooting, root-cause analysis (RCA) and solution.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables, actively worked with UNIX teams and Sys admins in rolling out the updates and hotfixes.
• Involved in UNIX shell scripting, FTP and file management in various UNIX environments
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.
• Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse.
• Prepare the run books for installation, services and issues.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.
• Good experience in Mantis, Remedy, HP-ALM 11.0 and Quality Centre (QC) 10.0 modules Requirements Management, Test Plan, Test Lab, and Defects Management.
• 24/7 on -call production support on a rotation basis.
• Extensively worked with Informatica GCS and R&D and Product specialist teams for researching and resolving the issues/bugs found during varies phases of the product life cycle.

TECHNICAL SKILLS:

Operating System: IBM AIX, HP-UX, Windows 2000/2003/2008 , Windows - NT, Redhat Linux and Sun Solaris

Language: SQL, Pl/SQL, Shell Script

ETL Tools: Informatica PowerCenter 10x/9x/8x, IDQ (Model Repository)10x/9x, PowerExchange (sales force, Amazon web services S3, Tibco, Web logic, Cloud and SAP.), ­ Informatica ILM-TDM, Informatica DVO 10x/9x, Metadata Manager (MM)Services, Informatica Cloud.

RDBMS: Oracle 12c/11g/10g, Teradata13/14/15, DB2 QMF, SQL Server and Golden Gate

Test Management Tool: HP Quality Center 10.0, HP ALM and Mantis

BIDM tool: HP SM and Remedy SM

Database Tool: TOAD, SQL Developer, Teradata SQL Assistant Utilities

Domain: Oil and Gas (Utilities), Pharma, Banking, Finance and Insurance.

Deployment Tool: Team Foundation Version control (TFVC), IBM Rational Tam Concert (RTC), GIT and Serena Version Change Manager

Scheduling Tool: Autosys, Zena, IBM Tivoli, CTRL+M and Informatica Scheduler.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Extensively strong work experience on SQL, PL/SQL, Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2 & Teradata.
• Strong Experience on installation & configuration of Informatica PowerCenter, DataQuality (Client/Server), DVO and Power Exchange.
• Experience with product version upgrade from 8x/9x to 10x and applying hotfixes and upgraded to new versions.
• Have good experience as Informatica Administrator in creating Repository, Integration, MRS, DIS, CMS, AS services and folders.
• Experience with Informatica Metadata Manager & Business Glossary tool (MM Services).
• Proficient in using informatica command line utilities like infasetup to define backup and restore domain components, pmcmd to create, schedule and control workflows, tasks and sessions and pmrep to perform repository backups, create folders etc.
• Involved with Pre - session and post session UNIX scripts for automation of ETL jobs using scheduling tools.
• Involved in preparing migration documents to move the mappings from development to production repositories.
• Involved in migration of objects in all phases (DEV, QA and PROD) of project
• Working experience with to maintaining Database relational connections, ODBC connections and installing and maintaining various new database connectivity software and Informatica plugins for respective software.
• Experienced with High Availability, Grid, Real Time and Version control features.
• Created and maintained Users, Groups, Roles and Privileges.
• Prepared a plan for LDAP migration and worked closely with Informatica Administrators and IT Teams to perform the migration from Native security to LDAP.
• Independently perform complex troubleshooting, root-cause analysis (RCA) and solution.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables, actively worked with UNIX teams and Sys admins in rolling out the updates and hotfixes.
• Involved in UNIX shell scripting, FTP and file management in various UNIX environments
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.
• Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse.
• Prepare the run books for installation, services and issues.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.
• Good experience in Mantis, Remedy, HP-ALM 11.0 and Quality Centre (QC) 10.0 modules Requirements Management, Test Plan, Test Lab, and Defects Management.
• 24/7 on -call production support on a rotation basis.