Professional Summary

• Overall 8 years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 9.X/8.X, SQL, PL/SQL, Oracle, DB2, Unix and Mainframes/SAS environments.
• Experience in Informatica Power Center 9.x/8.x with strong business understanding and knowledge of ETL of data from heterogeneous source systems like Flat files, Excel, XML and Oracle.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, ETL design and implementation, and support for new and existing applications.
• Highly Proficient in Informatica Designer Components like Source Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Expertise in using Oracle 10g/11g and had hands on experience in building advanced relational database objects which uses Oracle 10g/11g database.
• Strong knowledge in Data Modeling Relational, dimensional, Star and Snowflake Schema , identifying FACT and Dimensions Tables, Physical and Logical Database design using ERWIN .
• Troubleshooting and problem solving applications with Informatica Debugger and performing code migration from Dev to Test.
• Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3 , OLAP, Data Reports and Surrogate keys, Normalization/De normalization.
• Designed complex mappings using Source Qualifier, Filter, Normalizer, Aggregator, Router, Update Strategy, Union, Unconnected and Connected Lookups, Joiner, Sorter and Stored Procedure Transformations.
• Developed various Data Documentation Standards and ETL Mapping Documentations.
• Designed Reusable Transformations and Mapplets for better usability and performance.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Knowledge of working with tools like Toad and utilities like SQL PLUS, SQL Developer.
• Good understanding of IT Mainframe Applications written in JCL, COBOL/SAS and DB2 database tool SPUFI .
• Hands-on experience in IBM tools like File-Aid, Changeman, Infoman, Endevor, Xpediter.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Excellent team member with problem solving, troubleshooting skills and interpersonal skills.
• Worked closely with the business analyst team in order to solve the Problem Tickets, Service Requests.

Technical Summary

Project Experience

Confidential

Environment: Informatica Power Center 9.1.0, Oracle 11g, Oracle SQL Developer, PL/SQL, Flat Files,

UNIX Shell Scripting, Erwin

Role: Sr. Informatica Developer

Responsibilities

• Worked with business analysts for requirement gathering BRD , business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Designed and created logical Data warehouse models to support strategic decisions using Erwin.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Extensively used PL/SQL programming by using oracle11g in backend and front end Functions and Procedures, to implement business logics / rules.
• Prepared the Standard Operating Procedure Knowledge Transfer document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Confidential

Environment: Informatica Power Center 8.1/8.6, Oracle 11g, Oracle SQL Plus, Flat Files,

UNIX Shell Scripting, TOAD

Role: Informatica Developer/Tech Lead

Responsibilities

• Involved in gathering the business requirements and molding them in to the technical specifications required for the conversions team.
• Designed the target Data Warehouse using Star Schema, Involved in Extraction, Transformation and Loading ETL Process.
• Extensively worked over the online tracking system for work-requests, database change request issues, automated UNIX scripts modification issues and various scheduler jobs issues.
• Collection of requirements from business users and analyzed based on the requirements.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Mappings involved transformations like Expression, Sequence Generator, Joiner, and Update Strategy.
• Created sessions by extensively using ETL methodology for complete processing of data extraction, transformations and loading using Informatica.
• Managed multi source data extraction using Informatica.
• Involved in necessary training and knowledge transfer to assigned project members.
• Implemented mapping for slowly changing dimensions SCD to maintain current data as well as historical data.
• Created sessions and batches for data movement using Workflow Manager.
• Created reusable Transformations and Mapplets and used them in mappings in case of reuse of the transformations in different mappings.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log.
• Provided end user training and production system support, also worked with architecture team to review the Informatica standard documents.
• Worked extensively on Oracle database 10g and flat files as data sources.

Confidential

Environment: Informatica Power Center 8.1/8.6, Oracle 10g, Flat Files, UNIX Shell Scripting

Role: Informatica Developer

Responsibilities

• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files to Oracle.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Worked extensively on SQL, PL/SQL and UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Designed and developed the fact/dimension entities.
• Co-ordination with Client Business Systems team for QA.
• Performed the tuning of ETL SQLs.
• Compared actual results to expected results and suggested changes to mappings owned by others
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production

Confidential

Environment: Mainframe, JCL, COBOL, SAS/BASE and DB2

Role: Mainframe Developer

Responsibilities

• Involved in developing Specification Document for Component and Application Services.
• Involved in development of Pistols, Application and Component Services.
• Involved in Coding Testing SOA programs.
• Delivering Code meeting all Standards of TIG.
• Have a good knowledge on the architecture of HUON.
• Involved in Unit Testing and Review.
• Implemented best practices and improved the quality.
• Have successfully delivered project with zero defects in system testing.