SUMMARY:

• Over 8 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.
• Have 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 Power Center with strong business understanding and knowledge of Extraction, Transformation and Loading of data from/to heterogeneous source systems like Flat files, XML, Oracle, Sybase, SQL Server
• Extensively involved in ETL using Informatica Power Center 7.x/8.x/9.x Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on basic transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Performed the data profiling and analysis making use of and Informatica Data Quality (IDQ).
• 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.
• Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, WinSQL, SQL*Loader, Netezza
• Having Experience in writing shell scripts.
• Hands on Experience on Meta data Manager, Analyst services configuration.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities.
• Hands on Experience on Installation of Proactive monitoring tool.
• Hands on experience in developing SCD type 1/2/3 mappings.
• Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
• Extensive usage of reusable components for sources, targets, user defined functions, transformations, mapplets, worklets and sessions.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications
• Experience in Informatica Administration and hands-on experience in installing, configuring, upgrading the Informatica Power Center and Data Explorer.
• Experienced in setting up Disaster Recovery environment and involved in annual DR test exercises
• Experienced in handling various Informatica Power Center 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 installing Informatica in UNIX environment.
• Expertise in documenting the ETL process, Source to Target Mapping specifications, status reports and meeting minutes.
• Experience in working on onsite and offshore delivery model.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
• Good knowledge on Software Development Life Cycle.
• Experience in project and issue tracking tool like REMEDY.
• Ability to work in teams as well as individually, quick learner and able to meet deadlines.
• Overview of EDI transactions.
• Overview of Data Warehousing concepts.
• Good understanding on file transport protocols like FTP, SFTP
• Good understanding on using PGP encryption.
• Good overview of production support procedures, Release and change management.
• Diverse background with fast Learning and creative Analytical abilities with good Technical, Problem Solving, Communication and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Administration Console) Metadata manager, IDQ (MRS, DIS, AS, CM and SS), Power Exchange CDC with (Oracle, MSSQL server and IBM i5OS), DIH 9.6.X, Proactive monitoring, Informatica Cloud (Secure Agent).

RDBMS: Oracle11g / 10g / 9i, SQL Server 2000/2005/2008, Tera Data 15.x, Cassandra 3. x.

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

Job Scheduling Tools: Informatica 9x and 8x, Control-M 8x and 9x, Cisco TES

Languages: SQL, PL/SQL, HTML.

Tools: MS Office, MS VISIO, TOAD, SQL-Developer, MS SSMS, Winscp, IBM I Access, Putty, File Zilla.

Ticketing Tools: IBM Tivoli, JIRA and Service Now.

PROFESSIONAL EXPERIENCE:

Confidential,SFO,CA

Sr. Informatica/CDC Administrator

• Installing Informatica on Unix as part of upgrade from 9.5.1 HF2 to 9.6.1 HF4.
• Configuration of GRID and High Availability architecture in informatica.
• Installation Informatica Power Exchange CDC 9.6.1 on LINUX and windows.
• Configuration of Power Exchange CDC listener and logger.
• Installation Informatica Power Exchange CDC Navigator 9.6.1 on windows 7/8.
• Configuration of Power Exchange CDC dbmover and pwxccl files.
• Creating Registration groups in Informatica Power Exchange Navigator 9.6.1.
• Registration of CDC tables in Power Exchange Navigator for different source systems like oracle and MS SQL server with the Row test.
• Importing CDC tables in Power Center Designer.
• Create application connections for PowerExchange CDC real time and continues mode.
• Cold start and warm start workflows with token numbers.
• CDC tables migration one environment to another environment using PWX Utilities.
• Code deployment using labels one environment to another environment.
• Supporting Production issues like p1, p2 and p3.

Confidential,Albany, NY

Sr. Informatica Administrator

• Reducing maintenance needs, improving reliability, reducing execution time and performance tuning and monitoring.
• Installing Informatica on Unix as part of upgrade from 9.5.1 to 9.6.1 HF1
• Installing Informatica DIH on Unix as part of upgrade from 9.6.0 to 9.6.2.
• Installation, upgrade and configuration of Meta data manager and IDQ.
• Identify root cause and implement resolution for production processing issues.
• Adding new resource, loading resource, linking resource and scheduling resource in Meta data manger.
• Installation, upgrade and configuration of Power exchange CDC.
• Applying Hot Fix’s to existing Informatica servers.
• Installation and configuration of Control - M with components and FIXPACKS.
• Updating the NEW Address doctor files every month.
• Maintain Centralized Issue Logs and weekly status reports.
• Involved in LDAP configuration.
• Monthly maintenance of 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.
• Responsible to monitor and keep the health of Informatica services, OBIEE services.
• Support assistance to Informatica developers and advice on their queries.
• Co-ordinate with other support groups in case of planned/un-planned down time.
• Involved in setup of DR environments.
• Prepare RCA for service failures and follow-up with relevant stakeholder if required.

Confidential,Lombard,IL

Sr. Informatica Administrator

• Monitor the day-to-day activity of the data warehouse, Informatica jobs, BI Tools and reporting.
• 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.
• 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.
• Design and architect new ETL processes prior to development to ensure the best approach is chosen.
• Analyze, review and suggestions to increase operating efficiency of ETL.
• Used Informatica power center 9.0.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files.
• Experience in scheduling jobs using Control-M.
• Created and maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows).
• Involved in writing shell scripts for regular tasks.
• Have experience in using ‘sed’ and ‘awk’ while writing shell scripts.
• Administration of BI tools (Informatica Power Center).
• Do POC’s for new functionalities being used for first time.
• Create service requests with vendors for unknown errors, enhancement requests and follow-up.
• Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.
• Configuration Management.
• Code Release Migration.
• On call support for BI tool services.

Environment: Informatica Power Center 9.6.1 HF1, Meta data manger, IDQ, DIH, Power exchange, Address Doctor, Control- M, Toad, PL/SQL (Stored Procedures, Triggers, Packages), MS Visio, Windows 7, Winscp, Putty.

Confidential,CA

Sr. Informatica Administrator

• Responsible to monitor and keep the health of Informatica services and Informatica servers.
• On call support for Informatica services.
• 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.
• Support for annual DR testing.
• Do POC s for new functionalities being used for first time.
• Prepare RCA for Informatica service failures and follow-up with relevant stake holder if required.
• Create service requests with Informatica support for unknown errors and follow-up.
• Maintenance of Informatica Repository, purging/archival of logs on Informatica servers.

Environment: Informatica Power Center 9.5.1/8.6, Meta data manager, MS SQL server 2005, Oracle 10g/11g, Toad, PL/SQL (Stored Procedures, Triggers, Packages), MS Visio, Windows 7, Winscp, Putty

Confidential,Mooresville,NC

Informatica Administrator

• Install PowerCenter software, administer repositories and provide application support for Institutional Business, Individual Business,
• Broker Dealer and Auto & Home line of business
• Provide PowerCenter performance tuning and production support
• Implement and support PowerCenter development, test, quality assurance and production environments including object migrations
• Manage PowerCenter security
• Provide standards using Informatica velocity guidelines to application development teams
• Upgrade PowerCenter to version 8.6 from 8.5 and 7.1.5, 7.1.5 from 7.1.3, 7.1.3 from 6.2
• Create/administer Oracle 10.2.0.3 databases for PowerCenter repositories
• Configure and support Oracle10G Data Guard databases.
• Worked with NZLoad to load flat file data intoNetezzatables.
• Good understanding about Netezza architecture.
• Assist DBA and Architect to identify proper distribution keys for Netezza tables.
• Setup and configure PowerCenter domain, grid and services
• Perform object deployments on versioned repositories from QA to Production
• Setup and administer PowerCenter security
• Implement capacity management and performance best practice guidelines and monitoring
• Coordinate PowerCenter technical review/approval before on-boarding new projects to shared platform.

Environment: -Informatica PowerCenter8.1, SQL, MS Visio, UNIX

Confidential

Informatica Developer

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Developed SCD Type 1/2/3 mappings.
• 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.
• Developing, Testing and debugging the mappings in Informatica.
• Preparing the documents for test data loading.

Environment: -Informatica Power Center 8.1, Oracle 10G, UNIX Scripting.

Confidential

Informatica Developer

• Involved with all the phases of the life cycle starting from gathering requirements for designing DS systems, data modeling involving in the design of the logical and physical databases, Data warehouse design with decision support in mind and development.
• Involved in designing the Dimensional Data Model of the Data warehouse by using Erwin 4.1 to identify the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, Workflow Manager and Monitor
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and used mapping designer to map the source to the target.
• Extensively used transformations like Source Qualifier, Lookup, Expression, Aggregator, Joiner, Router, Normalizer, Filter, Sequence generator, Expression, Sorter, and Update Strategy to create Mappings.
• Mapplets and Reusable Transformations have been part of the mappings since different data types conversions have to be dealt multiple times which are similar and also most of the lookups have been similar.
• Wrote Informatica ETL design documents, established ETL coding standards, developed Informatica mappings and perform reviews of the same.
• Created reusable email tasks in workflows to send post session and suspension emails as per user requirements.
• Created and maintained folders in the repository manager to logically organize all the metadata in the repository including mappings, schemas and sessions.

Hardware/Software: Informatica 7, Power center, ORACLE 9i, TOAD, PL/SQL Developer, XML, DB2, Micro strategy, SQL Server 2000, UNIX, Business Objects 5, Windows XP