SUMMARY

• 7 years of experience with Informatica Powercenter 8.6.0/9.5.1 product suites which includes Designer, Workflow Manager and WorkFlow Monitor.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Good Exposure to Oracle 10g Database.
• Participated in Requirement Analysis to gather and understand Client requirements.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Responsible for all activities related to the development, implementation, support of ETL processes for large scale data warehouses using Informatica Power Center.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Documented Functional and Technical Specifications using requirements and delivered them to the Business stakeholders & Technology Team.
• Extensive experience in ETL design, development and maintenance using Oracle SQL.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Conducted Design Workshops based on requirements to conduct FIT/GAP Analysis.
• Designed Requirement Specification Document (RSD) for many projects by summarizing key business and presenting them in visually intuitive, easy - to-read, interactive documents.
• Created knowledge sharing documents from Business perspective and to Technology Team.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Extensively worked on Powercenter to create mappings.
• Good Experience working with offshore teams.
• Extensive work experience with Ad-hoc Projects and Proactive at defining Strategies. Good Experience working with SQL.
• Comprehensive operational knowledge & understanding the problems very quickly and finding solution to the team. Proactive at defining strategies, gaps, and dependencies to support and enhance department goals and initiatives across multiple Projects.
• Was an Active Team member in analysing the MDM metadata and developing data design, Successfully implemented many projects and maintenance activities
• Good experience in the usage of Transformations like Source Qualifier, Expression, Filters, Router, Update Strategy, LookUp, Transaction Control etc.
• Good in Datawarehouse concepts Fact and Dimensional Tables.
• Experience in SLA and leading all phases of the software life cycle (feasibility studies, estimating, system analysis, design, development, quality assurance and implementation). Ex: Waterfall Model.
• Good experience in Informatica Schema and Star Schema configuration.
• Sound Knowledge on SCD 1,2,3 tables.
• Exposure in dealing with variety of Relational Databases like Oracle, SQL Server, Db2.
• Experienced in working with UNIX and Windows operating systems.
• Excellentproblem solving, interpersonal and communication skillswith experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning.
• As a Informatica Developer/Lead, gathered business requirements, Analyzed & did feasibility study of the client’s requirements, Estimated the project, prepared functional and technical specifications, provided technical guidance/support to the team, reviewed deliverables from the offshore team, prepared test scripts, resolved support issues at Onsite.

TECHNICAL SKILLS

Operating Systems: Windows XP/2000, 7 ultimate, Unix

Databases: Oracle 10g/9i, DB2 V8.01, SQL Server

Database Tools: DB Visualizer, TOAD, SQL Navigator

ETL Tool: Informatica PowerCenter 8.6.1

BI Reporting Tools: Business Objects

Programming Languages: cobol,XML

Scripting Languages: Unix Shell Scripting

Scheduling Tools: Control-M,UC4

Test management Tools: Quality Center, Mantis

PROFESSIONAL EXPERIENCE

Confidential, Portsmouth, NH

Informatica Lead/Developer

Environment: s: Informatica 8.6.0/9.5.1 , Windows 7 Ultimate, Oracle 10gDb2,DB Visualizer

Responsibilities:

• Responsible for gathering business requirements, Analysis & feasibility study of the client’s requirements, Estimating the project and executing the tasks.
• Discussed with Business Teams and Analyzed the Business Requirements.
• Designed and Converted the Technical Design work streams into mappings, sessions, workflows.
• Understood the Insurance Business Terminology in Short span of time and Implemented very big project which became very successful so that Customers are really happy and so the Clients are.
• Effectively coordinated and communicated IT Framework with different departments.
• Responsible for fixing all the production issues from Real Time Premium Posting Team.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Used Informatica Power Center 8.6.0 for extraction, transformation and load (ETL) of data in the data warehouse.
• Developed complex mappings in Informatica to load the data from various sources.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.

Confidential, Richmond, VA

Informatica Developer/ETL Designer

Environment: s: Informatica 8.6.0/9.5.1 , Windows 7, Oracle 10g, Db2DB Visualizer, Cobol DB2 Stored Procedures.

Responsibilities:

• Responsible for meeting with business users to discuss and finalize the requirements and design the approach.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the Loads.
• Prepared various mappings to load the data into different stages
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on Oracle 10g and SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on SQL programs and Db2 stored Procedures as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs for File validation with Signal and Data files.
• Worked on OLAP Services.
• Closely worked with the reporting team to ensure that correct data is presented in the reports and make sure the correct data is on Targets.
• Interaction with the offshore team on a daily basis on the development activities.
• Generating the DDLscripts for the physical data model.

Confidential, Houston, TX

Informatica Developer

Environment: Informatica 8.6.0, Windows 7, Oracle 10g, Toad

Responsibilities:

• Member of warehouse design team assisted in creating fact and dimension tables based on specifications provided by managers.
• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts like PMS and DEA.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• PerformedUnit Testingand Involved in tuning the Session and Workflows for betterPerformance.
• Debugged and sorted out the errors and problems encountered in the production environment.
• Created set ofReusable TransformationsandMapplets.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extensively used SQL for creating Stored Procedures in DB2 and used Cursors, Views and Indexes.
• Very strong in the Database and understood the complex table relationships.
• Worked on Fact and Dimensional Tables and Fine tuned the Table data and helped in establishing the relationship between Fact and Dimensional tables to maintain Data integrity.
• Experience in preparing documentation such as High-level Design and System Requirement document, Technical Specification Document, etc.

Confidential

Informatica Developer

Environment: Informatica 8.6.0, Windows 7, Oracle 10g

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Understanding the requirements specification and use case documents.
• Creation of test plan, test strategy and test approach.
• Created Test scripts, Traceability Matrix and mapped the requirements to the test cases.
• Done Peer review of test scripts and prepare the QA measurement forms.
• Attended the QA Audit meetings and test artifacts review.
• Participated in the Integration testing and Unit Testing along with the Development team.
• Conducted System, GUI, Smoke and Regression testing identified application errors and interacted with developers to resolve technical issues.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Analyzed, designed, constructed and implemented the ETL jobs using Informatica.
• Extensively used SQL scripts/queries for data verification at the backend.
• Executed SQL queries, stored procedures and performed data validation as a part of backend testing.
• Used SQL to test various reports and ETL Jobs load in development, testing and production
• Performed negative testing to test the application for invalid data, verified and validated for the error messages generated.
• Responsible for Generating Progress Reports and Updates to Project Lead Weekly including with test Scenarios Status, Concerns and Functionality outstanding.
• Involved in Daily and Weekly Status meetings.
• Creation of Test Summary report, traceability Matrix, Test Script Index.
• Monitor the testing project in Quality Center and ensuring defects are being entered, tested, and closed.
• Analyzed, documented and maintained Test Results and Test Logs.