PROFESSIONAL SUMMARY

• Experience in Informatica Performance tuning
• 7 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of OLTP and OLAP systems.
• 7 years of experience in using Informatica PowerCenter 8.1/8.6/9.1 tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Strong PL/SQL programming skills.
• Experience in development of Stored Procedures, Functions, Cursors, Triggers and Packages using PL/SQL.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP applications.
• Expertise in Data Warehouse/Data mart and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Involved in project planning, scheduling, System design, Functional Specification, Design specification, coding and system test plan.
• Have extensive experience in Onsite / Offshore Client Handling.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and PL SQL blocks.
• Proficiency in developing SQL with various relational databases like Oracle, Teradata.
• Experience in development of database objects like tables, indexes, Materialized Views, Procedures and synonyms
• Experience in RDBMS development including coding using SQL Plus, PL/SQL Developer, SQL Loader, TOAD and good understanding of Oracle data dictionary
• Experienced in providing production support and investigating and resolving system defects and fixing bug.
• Excellent Analytical and problem solving skills, systematic approach to programming tasks and good interpersonal skills.

Skill set:

Professional Experience

Confidential

Informatica ETL Lead

Cisco Systems being leader in Networking for the Internet and a major supplier of Internet/Networking equipment solutions sale there Hardware products which do result in returns/failures. Project Quality Management System deals with the Cisco returned products and show case the key failure metrics for each and very Cisco's returned products. The project enables Failure Analysis Operations team Cisco to conducts monthly operations reviews to track performance and identify areas for improvement along with prioritizing high priority issues to have the Product failure fix.

Responsibities:

• Worked with the Application Clients for Gathering Requirements.
• Handling offshore team of size 8. Assigning tasks to the team as per the team's availability.
• Attended story meetings and coordinating with other teams and MassMutual vendors.
• Designed and Developed complex mappings and workflows using Informatica Designer, Workflow manager.
• Worked with transformations like Lookup, Aggregator, Expression, Router, Filter, Update strategy, Stored Procedure etc.
• Used transformations such as source qualifier, aggregator, expression, lookup, router, filter, update strategy, joiner, SQL transformation, Union and stored procedure.
• The tables had to be populated for use in daily load for the initial load 'inserts' and then updated using incremental loads and update strategy transformation.
• Worked Extensively with Slowly Changing Dimensions i.e. Type1, Type2 Type3.
• Created Jobs Job plans for the Workflows, SQL jobs UNIX scripts by Dollar Universe tool.
• All the Job plans are scheduled through Dollar Universe tool.
• Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
• Optimized the mappings by changing the logic and reduced running time and encouraged the usage of reusable objects.
• Exclusively used ETL to load data from flat files to Teradata and Oracle Database
• Involved in Development, Testing and Production support.

Environment

Informatica Power Center 9.1, Oracle 10g, PLSQL, OBIEE, Dollar Universe tool, Kintana, Quality Centre.

Confidential

Software Developer

• This project provides a framework for the clients to view the informatica logs in the shapes of tableau reports. Based on the reports users can analyze the logs data and understand there ETL behavior .The reports build using tableau are on hive table and can be sliced and diced based on time variable to showcased daily, weekly, monthly, quarterly and yearly metrics.
• It provides a decision support system to the user through which they can analyze the ETL behavior/performance trends and can take out decisions to improve their ETL performance. Based on the generated reports they can identify the actual bottleneck for a session and take necessary action. The framework uses Hadoop/big data technologies and tableau for reporting. Perl code is used to parse the informatica logs, which is automated process, to extract the vital information in order to showcase the metrics.

Responsibilities:

• Played key role in analysis, configuring, designing and implementation for the project.
• Analysis and gathering of requirements for the project.
• Preparation of High Level Low Level Design documents wrt to the requirements gathered.
• Reports development using tableau.
• Unit testing and system integration testing of the developed code.
• Providing fixes to the issues identified in testing phase.
• Packaging of the developed component to be deployed in production environment

Environment

Informatica 9.1, Perl, HDFS Hadoop , Hive and Tableau.

Confidential

Informatica ETL Lead:

• The project provides a framework CRA Change request Automation tool that servers the end user with
• automation of change request impact analysis. The tool helps the end user to reduce the manual task
• involved in analyzing the change request wrt to their application. The tool will automatically notify the user
• via email in case of their application is being impacted due to a change request being submitted by the release team.

Responsibilities:

• Involved in Gathering the requirement, analyzing the requirement and finalizing them.
• Involved in meeting with stakeholders on explaining them on the pros and cons of their requirement.
• Preparing of project execution and implementation plan.
• Involved in preparation and review of the project documents
• Drive the project as a lead and took all the responsibility to deliver it without any failure.
• Ensuring that the quality of the project is up to the mark.
• Attended user design sessions, studied user requirements, completed detail design analysis and wrote design specs and regularly reported update to the management.
• Coordinated with offshore and onsite team and worked as a module lead.
• Developed ETL job workflow with error/exception handling and rollback framework.
• Designed mappings that loaded data from flat-files to the staging tables.
• Developed Informatica mappings, sessions and workflows.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Used Informatica variables to implement complex logic for Informatica mappings.
• Worked with flat files, Oracle Sources and Targets.
• Identified tables/Scripts required for full load, daily delta-load and monthly load and documented ETL process for each load.
• Performed root cause analysis and identified and implemented corrective and preventive measures.
• Scheduled the jobs using Dollar Universe.
• Designed the Migration Plan document to migrate the Mappings and work-flows to the Testing and Production environments.
• Conducted peer-to-peer code review meetings.
• Interacted with key users and assisted them with various data issues, understood data needs and assisted them with Data analysis.

Environment:

Informatica Power Center 9.1, Flat Files, Oracle 10g, PLSQL, OBIEE, Dollar Universe tool, Kintana, Quality Centre.

Confidential

Informatica Developer

The project aimed to provide the metrics which globally highlight the quality and performance of the Cisco's Software Products. It tracks the defects raised by QE or end customer for Software products and also showcase the key metrics related to those defects. It basically represents/show case the entire lifecycle of the concerns defects raised for any kind of Software products failure form the time it was created till it gets resolved and the product is again released to the market.

Responsibilities:

• Informatica PowerCenter 8.1.6 was used to extract data from various sources and load into Data Mart.
• Used transformations such as source qualifier, aggregator, expression, lookup, router, filter, update strategy, joiner, transaction control and stored procedure.
• Worked with pre and post sessions and extracted data from defect tracking tool into staging area.
• Identified facts and dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Migrated Informatica mappings, sessions, and workflows to production instances.
• Created ETL jobs via job scheduler tool.
• Developed and tuned Informatica mappings and Mapplets for optimum performance, dependencies and batch design.
• Created several Informatica mappings to populate data into dimensions and fact tables.
• Worked with team members to identify and resolve various Informatica and database related issues.
• Created and modified reports using OBIEE.
• Developed PL/SQL scripts.
• Involved in preparation and review of project and deployment plans.
• Involved in preparation of High Level Low Level Design documents wrt to the requirements gathered.
• Resolving the tickets raised by the users.
• Trouble shooting the mappings and logs and worked on different change requests.
• Preparing test cases for the change requests after completing the development of CR's by oracle team.

Environment

Informatica PowerCenter 9.5/8.6.1, Oracle11g/10g/9i, TOAD, SQL, PLSQL, Windows, Dollar Universe Tool, Kintana, Quality Centre, Toad

Confidential

Informatica Developer

The project serves a decision support system that assists the business to analyze the actual manufacturing trends, collaborative planning and analysis with the end goal to track results. It also helps the Business to bring together metrics that reflect globally coordinated activities of marketing and quality controls of the hardware products in Cisco.

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Developed mappings to extract data from SQL Server, Flat files, RDBMS and load into DataMart using the Power Center.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataMart.
• Developed Slowly Changing Dimension mappings.
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, execute and monitor sessions, Worklets and workflows.
• Involved in writing PL/SQL packages, procedure and Functions.
• Scheduled the ETL/Jobs via job Scheduling tool Dollar Universe.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Created reports using OBIEE for end users.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Integrating and deploying in production.
• Involved in production support and troubleshooting Data Quality and Enhancement Issues.
• Performed unit testing for all the development activities and involved during the design phase of the project for requirement analysis

Environment:

Informatica PowerCenter 9.5/8.6.1,Oracle11g/10g/9i, TOAD, SQL, PLSQL, SQL Plus, UNIX, Dollar Universe Tool, Kintana, Quality Centre, OBIEE, Toad

Confidential

Informatica Developer

• Confidential based Organization which is leader in Networking for the Internet and a major supplier of Internet/Networking equipment solutions. They provide quality services to various customers for its various products. The project presents metrics that measure the customer's overall end-to-end experience, in areas such as customer relationship/ satisfaction, operational performance, and quality.
• It specifically provides
• Consolidated internal snapshots of how Cisco is performing with Service Provider and Enterprise customer
• Trends to identify corrective actions before they become more serious issues, and
• Comparison of metrics across accounts to help drive more consistent and positive behavior

Responsibilities:

• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica.
• Developing Informatica mappings tuning them when necessary.
• Unit and System Testing of developed mapping.
• Documentation to describe program development, logic, coding, testing.
• Involved in production support and maintenance.

Environment:

Informatica PowerCenter 9.5/8.6.1,Oracle11g/10g/9i, TOAD, SQL, PLSQL, SQL Plus, UNIX, Dollar Universe Tool, Kintana, Quality Centre, OBIEE, Toad