SUMMARY:

• 7 years of IT experience providing solutions and services in Banking and Financial Services domain which includes complete SDLC such as Architecting, Analysis, Design, Development, Implementation, Modeling, Testing and Production support for Data warehousing applications.
• Extensive knowledge of ITIL processes used in change, problem and incident management.
• Expertise in Informatica Administration tasks including Configuration of domains, Code Promotions/ Migrations, Deployment groups, managing users, groups, associated privileges, performing backups and system administration tasks.
• As an ETL Release manager, responsible for all Informatica, Unix and PWX Datamap codes migration in production environment using Harvest, Artifactory, uDeploy, PowerCenter and PowerExchange tools.

TECHNICAL SKILLS:

Languages: C, SQL, PL/SQL, Unix Shell Scripting

Programing Skills: ETL, UNIX

Databases: Exadata Oracle 11g/10g, Teradata 14, DB2, Microsoft SQL server

Operating System: LINUX, UNIX and Windows

Data Integration Tools: PowerCenter (v10.2, 9.6.1, 9.5.1, 8.6.1), IDQ, IDE PowerExchange, Metadata manager

Scheduling tool: CA7, Autosys

Other Tools & Utilities: uDeploy, Toad, Putty, Mainframes, OBIEE, Web Methods, Service Now, NDM

Version Control Tool: Harvest, Artifactory, GIT, Serena

Domain Experience: Banking and Financial Services

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, Ohio

Informatica ETL Administrator

Environment: Informatica PowerCenter v10.2, 9.6.1 and 9.5.1, Power Exchange v10.2, 9.6.1 and 9.5.1, Metadata Manager, Data Quality, OBIEE 11g

Responsibilities:

• Design, implement, support and operating Data Integration Infrastructure.
• Worked on planning, design and implementing the standards, guidelines and best practices for upgrade of Power center v9.6.1 to v10.2.
• Troubleshooting issues related to databases, job failures, software bugs and performance bottlenecks to all incidents working with multiple cross functional teams like DBA, Unix Server Administrator, Informatica Global Support and work on problems and drive them to resolutions.
• Worked on automation of ETL code migration tool to deploy XMLs from lower to upper environment in v10.2.
• Working with Big data team to configure Informatica component to work with Hadoop environment.
• Worked with various teams including DBAs, Production Office, Security Administration, Architects, and Middleware Teams to setup and design the data integration environments.
• Extensively worked in design, configure and upgrade Informatica PowerCenter services - Repository Service, Integration Service and Web Service Hub, Data Quality services - Model Repository Service, Data Integration Service, Analyst Service, Content Management Service and Search Service along with Metadata Manager and act as a SME.
• Provided day to day on call support for ETL services.
• Responsible for day-to-day admin activities including creating/changing/managing folders, users, roles, groups, privileges, connection objects, promoting/rollback of deployment groups from development to QA and to production environment, code reviews, domain management tasks (including backup and restore), configuring DB connections, managing downtimes etc.
• Responsible to monitor and keep the health of Informatica services and Informatica servers.
• Extensively worked on OS migration during the AIX to Linux migration of Data integration services.
• Doing POC’s for new functionalities being used for first time (IDQ, PMPC).
• Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.
• Worked with Informatica for software licenses, hotfixes, EBFs, patches, Informatica bugs, issues etc.
• Provided technical documentation as a part of support/upgrade/maintenance.

Confidential, Cleveland, Ohio

ETL Release Manager

Environment: Informatica PowerCenter v10.2, 9.6.1,9.5.1 and 8.6.1, Power Exchange v10.2, 9.6.1,9.5.1 and 8.6.1

Responsibilities:

• Facilitates varying client units to promote smooth and timely delivery of applications, change to production with normal, emergency and exception CR.
• Co-ordination and work in conjunction with Configuration Management & Change Management to complete production implementation.
• To create, promote and approve the Harvest/Artifactory packages in different environment.
• Managing the deployments (Labels, folder, deployment groups) and conflict resolutions.
• Requirement gathering and analysis, Code reviews, Development, automated unit and integration testing.

Confidential

ETL Developer

Environment: Informatica Power center 8.6, Harvest, Toad, CA-7, Putty

Responsibilities:

• Understanding business, functional, ETL requirements.
• Involved in Data Extraction from various branch data sources like Oracle, flat files to load the extracts into the target warehouse.
• Involved in creating mappings and mapplets using Transformations such as Source Qualifier, Expression, Filter, Joiner, Router, Sequence Generator, Look up and Update strategy Transformation.
• Involved in creating Jobs for SCD Type 1 dimensions.
• Created workflows to support daily, nightly, weekly loading.
• Developed and modified UNIX shell scripts to reset and run workflows.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Developed Procedures and Functions in PL/SQL for Data ETL.
• Responsible for Query Optimization, Performance Tuning and SQL tuning.