PROFESSIONAL SUMMARY

• 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.
• Experience in Informatica Performance tuning
• Excellent Analytical and problem solving skills, systematic approach to programming tasks and good interpersonal skills.

Skill set:

Professional Experience

Confidential

Informatica ETL Lead

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

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

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.
• Coordinated with offshore and onsite team and worked as a module lead.
• Attended user design sessions, studied user requirements, completed detail design analysis and wrote design specs and regularly reported update to the management.
• Ensuring that the quality of the project is up to the mark.
• 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

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

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