SUMMARY:

• 8 years of ETL and Data Integration experience in developing ETL Mappings, Mapplets, Workflows, Worklets using Informatica Power Center 9.6.1/9.5.1/9.1/8. x/7. x.
• Extensive ETL experience using Informatica Power center client tools (Designer, workflow manager, workflow monitor and server manager).
• Experienced in all phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experienced in all phases of SDLC using Waterfall, Agile methodology.
• Experienced in working with business analysts to understand requirements and translating them into ETL code in Requirement Analysis phase.
• Involved in creating High Level Design and Detailed Design documents in the Design phase.
• Good understanding of Confidential (Dimensional) & Bill Inman (Relational) model Methodologies.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, OLTP Data Modeling and Data warehousing concepts (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, DB2, XML, SQL server, MS access and non-relational sources like flat files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Hands on experience on several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type I and Type II).
• Strong experience in performance tuning, debugging and Error handling of mappings, sources and targets for better performance, also identified and fixed the bottlenecks.
• Experience in creating Reusable Mapplets, Worklets used event wait, Event raise, Decision box and Command tasks in Workflows.
• Strong knowledge in writing efficient & complex SQL Queries in Oracle 11g/10g/9i and in PL/SQL for Stored Procedures, triggers, indexes, cursors.
• Worked in writing SQL Queries DDL, DML and DCL Commands.
• Experienced in UNIX work environment, file transfers (FTP, SFTP), job scheduling and error handling.
• Hands on experience on UNIX shell scripts for Informatica pre & post session operations.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Knowledge in Preparing migration document to move the mappings from development to testing and then to production repositories.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Assign work and provide technical oversight to onshore and offshore developers.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/ 8.x/7.x

Data Warehousing: Informatica Power Center 9x/8x/7x/6x, Informatica Power Exchange 9.x/8.x/7.x, Repository Manager, Designer, Workflow Manager, workflow Monitor.

Databases: DB2 5.0, Oracle 11g/10g/9i/8i, SQL Server 2008, MS Access,MS-Excel.

RDBMS Load Tools: Toad, SQL Developer, SQL Loader, SQL plus.

Reporting Tools: Business Objects XI3.1

Programming Skills: SQL, PL/SQL, UNIX shell scripting.

Data Modeling Tools: MS - Visio, Erwin

Operating Systems: UNIX, Windows 98/2000/2007/ XP/NT, UNIX (Solaris, AIX).

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

ETL/Informatica Developer

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designed and built ETL mappings and workflows to load data from different DB2 sources.
• Used Source qualifier, Expression, Joiner, Lookup, Filter, Router, Sorter, Aggregator, Union, Router transformations to do necessary data calculations and manipulations according to the business rules and loaded data into target systems.
• Developed new and maintained existing Informatica mappings and workflows based on specifications.
• Implemented Variables and Parameters in the mappings.
• Worked with Reusable Sessions to drop staging data and to create tables in staging.
• Extensively worked in writing SQL Queries in DB2 for unit testing and involved in documenting the test results.
• Worked with diff UNIX shell scripts to load data to staging for different batches and to move data to CCDB & to drop the staging data.
• Expertise in documenting Mapping documents, Unit test plans, test results and Deployment plans.
• Analyzed change requests and performed impact analysis and estimated level of efforts.
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and worked with them to fix it.
• Worked with Session partitions to improve performance of sessions.
• Worked with Debugger for identifying bottlenecks and to debug the complex mappings and fix them.
• Involved in creating Automation tracks to create jobs using Tivoli scheduler.
• Involved in providing status reports to lead.
• Involved in production deployment activities, creation of the deployment guide for migration of the code to production, also prepared change management forms & created packages using Harvest tool.

Environment: Informatica Power Center 9.5.1, DB2 5.0, Toad, UNIX, Putty, Tivoli, Harvest, Track +.

ETL/Informatica Developer

Responsibilities:

• Integrated data from 32 diff SOR systems and housed it for JPMC Litigation services.
• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designed and built ETL mappings and workflows to load data from different sources Oracle, SQL Server and fixed width as well as Delimited Flat files.
• Created Mapplets, Reusable transformations, Worklets and used them in different mappings and workflows.
• Used Source qualifier, Expression, Joiner, Lookup, Filter, Router, Sequence Generator, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Implemented Variables and Parameters in the mappings.
• Developed PL/SQL scripts, stored procedures, Indexes in Oracle.
• Developed stored procedure to automate the testing process to ease QA efforts and also reduced the test timelines for data comparison on 5000 tables.
• Extensively worked in writing SQL Queries, DML, DCL, TCL Commands.
• Written UNIX shell scripts to automate SFTP files, archive files and pre-validation scripts by exchanging SSH keys between UNIX servers.
• Expertise in documenting Mapping documents, Unit test plans, test results and Deployment plans.
• Worked on advanced concepts like concurrent running of the workflow, session level partitioning techniques and pushdown optimization.
• Scheduled informatica jobs using Control-M as per the business requirements.
• Involved in production deployment activities, creation of the deployment guide for migration of the code to production, also prepared production run books.
• Coordinated offshore and onsite teams for multiple projects.
• Involved in designing and developing the reporting requirements by using Business Object Xi3.1, Business Objects Report Designer.
• Created and maintained several custom reports for the client using Business Objects.
• Created List Reports and Cross Tab Reports and Drill Through reports.

Environment: Informatica Power Center 9.6.1, Oracle 11g, PL/SQL, Toad, SQL plus, UNIX, Putty & Winscp, Control-M, Business Objects XI3.1.

ETL Informatica Developer

Responsibilities:

• Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
• Involved in creating Logical and Physical design of data models using Visio.
• Actively involved in requirements gathering and complete life cycle of the project.
• Extensively worked on Informatica client tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Designer, Worklet Designer and Task Developer.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files...etc. into the Staging table and then to the target database.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Developed new and maintaining existing Informatica mappings and workflows based on specifications.
• Created Mapplets, reusable transformations, Worklets and used them in different mappings, workflows.
• Used Source qualifier, Expression, Aggregator, Lookup, Router, Normalizer, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Performed trunk & Load process by using stored procedure transformation and load control table to stage the data.
• Worked on Slowly Changing Dimensions i.e. Type1 & Type2 and data ware housing Change Data Capture (CDC).
• Developed PL/SQL scripts, stored procedures, Indexes, Constraints and triggers in Oracle.
• Worked on production issues like bug fixing, bottlenecks, data validation and report errors.
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and worked with them to fix it.
• Created pass through session partitions to improve performance of reading source data.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Prepared test Scenarios and Test cases in Confidential Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Involved in production support.
• Scheduled Informatica jobs through Control M as per the business requirement.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them.
• Involved in designing and developing the reporting requirements by using Business Object Xi3.1, Business Objects Report Designer.
• Created and maintained several custom reports for the client using Business Objects.
• Created List Reports and Cross Tab Reports and Drill Through reports.

Environment: Informatica Power Center 9.1, Oracle 10g, PL/SQL, Visio, TOAD, SQL*Plus, UNIX, Putty, Control-M, Business Objects Xi3.1.

Informatica Developer

Responsibilities:

• Involved in Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Developed mappings using XML, Oracle, fixed and delimited Source files and loading into a flat file.
• Extensively used Erwin tool in Forward and Reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier, Update strategy Transformations in Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Extracted Incremental data (CDC) from source systems to load data to targets.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Used bulk load to manage the performance by dropping indexes, truncating stage tables, rebuilding the indexes, and analyzing the tables during the process.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Worked on Autosys to schedule Informatica workflows.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Provided production support for Business Users and documented problems and solutions for running the workflow.

Environment: Informatica 8.6.1, Oracle 10g, SQL Developer, SQL plus, UNIX, Autosys.

Jr. Oracle /ETL Developer

Responsibilities:

• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Involved in Logical and physical database design using Erwin.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Workflow Manager.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored workflows and Sessions using Informatica Power Center Server.
• Tuned the mappings & oracle queries to increase its efficiency and performance.
• Used Informatica Workflow Manager to create workflows.
• Workflow Monitor was used to monitor and run workflows.
• Created UNIX scripts and used in Informatica with command tasks.
• Set up Batches and Sessions to Schedule Loads at regular intervals in Informatica.

Environment: Informatica Power Center7.1, Windows 2000, Oracle 9i, PL/SQL, SQL Developer, UNIX shell scripting, Erwin.

Confidential

Jr. Data warehouse Developer

Responsibilities:

• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loaded the data into targets using Power Center Designer.
• Designed and developed Oracle PL/SQL Procedures.
• Worked on Informatica Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations.
• Involved in creating Shell Scripts to automate Pre-Session and Post-Session Processes.
• Developed Sessions and Batches to schedule the loads at required frequency using Power Center Server Manager 5.1.
• Involved in data quality testing.

Environment: Informatica Power Center 5.1 / Power Mart 5.1, Oracle 8i, SQL, PL/SQL, TOAD and Windows NT.