SUMMARY

• About 7+ years professional experience in IT industry and wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding, unit testing, SIT and implementation including post production support but not limited to Databases, Reporting, Data Warehouse, ETL Design and BI Applications across wide industry verticals.
• Diversified Domain expertise implementing solutions to Data Warehousing Projects. Work experience in Banking, Insurance and Retail domains.
• Have extensive experience in using Native Database Connection and Power Exchange Database connection.Well versed with Teradata Parallel Transporter (TPT) which combines the functionality ofTeradataFastLoad, MultiLoad, FastExport, and TPump.
• Strong ETL experience using Informatica Power Centre (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations, worklets, Sources: flat file, Mainframe DB2, Oracle, Teradata, Targets: flat file, Mainframe DB2, Oracle, Teradata.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Extensive experience in Extraction, Transformation and Loading (ETL) of data from multiple Data sources into Data Warehouse and Data Mart.
• Designed and developed complex mappings, from various transformations like Unconnected/Connected lookups, Router, Filter, Expression, Sorter, sql, Aggregator, Joiner, Union, Update Strategy and more.
• Well experienced in Performance Tuning of Informatica (sources, mappings, sessions and targets) and Databases.
• Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple data sources into targets
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow Designer&Worklet Designer.
• Experienced in designing and writing on-demand UNIX shell scripts.
• Designed and developed pre and post session UNIX scripts.
• Co-ordinating with users and establishing good relations between users and development team.
• Strong knowledge of complete System Software Development Life Cycle(SDLC) of Data warehousing.
• Extensively involved in migrating the Informatica components from Development environment to QA environment for SIT Testing
• Extensively involved in migrating the Informatica components from QA environment to Prod environment for Production Implementation
• Post Production Support for the implemented INFA components.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS

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

Databases: Oracle 11g/10g/9i/8i, Teradata, Mainframe-DB2& DB2UDB

Languages: SQL, PL/SQL

Scheduling Tools: Informatica Work Flow Scheduler, Autosys, Tidal

Operating Systems: Windows 2003/2000/NT, Windows XP/ 7, Unix and Windows 7, Z/OSOthers TOAD 9.x/10.x, SQL Developer, MS Office Suite, Teradata SQL Assistant, Putty and WinSCP

Mainframe Skills: JCL, ZEKE Scheduler and DB2

Implementation Tools: BMC Remedy

Test Defect Tools: HPQC(HP Quality Center)

Teradata Utilities: BTEQ(Insert/Update/Delete), FLOAD(Fast Load), FXPORT(Fast Export), MLOAD(Multi Load) Insert,MLOAD(Multi Load) Upsert,Native Connections Mainframe DB2, Teradata TPT(Teradata Parallel Transporter), Power Exchange DB2

PROFESSIONAL EXPERIENCE

Confidential, Mooresville, NC

Sr ETL Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and implement the same into a functional Data warehouse design.
• Involved in creating the design and technical specification documents for the ETL process based on Functional specifications.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Extracted data from Oracle and flat files to pull it into the Staging area.
• Worked on various types of transformations like Expression, Joiner, sorter, union, update strategy, Aggregator, Filterand Lookup.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule and monitor Workflows.
• Involved in migrating the components like Source, Target, Transformations, Mapplets, Mappings, Sessions and Workflows from one environment to other environment.
• Involved in migrating the Data mapping documents and workflows from Development environment to QA environment.
• Created Mainframe JCL's to run the Jobs in all environments.
• Involved in Unit Testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from Oracle and flat files according to the user requirements.
• Performance tuned the mappings to ensure data load was completed by the SLA. Worked with the Cognos developers to create customized BI reports to meet the user requirements using Cognos Query Studio.
• Developed List, Cross tab, Drill through, Master-Detail, Chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio.

Environment: Informatica Power Center 9.1.0 (Power Center Designer, workflow manager, workflow monitor), Cognos 10.2.1(Framework Manager, Data Manager, Report Studio, Analysis Studio, Query Studio and Event Studio), Oracle 10g, TOAD, Mainframe JCL.

Confidential, Dallas,TX

ETL Consultant

Responsibilities:

• Participated in gathering, analyzing, and documentingbusiness requirements, functional requirements and data specifications.
• Involved in creating the design and technical specification documents for the ETL process based on Functional specifications.
• Extracted data from various sources like Oracle andflat files.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.
• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Implemented Slowly Changing Dimension Type 1 for applying INSERT elseUPDATE to Target tables.
• Involved in Version Control of Repository Objects using Check-in and Check-out.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule and monitor Workflows.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during that period.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Informatica Scheduler was used to schedule jobs on daily and hourly basis.
• Involved in developing and designing reports throughSSRS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Working on tools for regression testing related to apps

Environment: Informatica Power Center 9.5.1/8.6.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 10g, TOAD,BMC Remedy, Windows XP,Reporting Services (SSRS), MS visual Studio.

Confidential, Miami, FL

Informatica Developer

Responsibilities:

• Collection of requirements from business users and analysis based on the requirements.
• Extensively used flat files and developed complex informatica mappings using expressions, aggregators and filters to ensure movement of the data between various applications.
• Created sessions, configured Workflow to extract data from various sources, transformed data, and loading into ODS.
• Provide support and assist to onshore and offshore Team members.
• Performed data validation on the incoming data to ensure only valid data was loaded into ODS.
• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Involved in migrating the mappings and workflows from Development to Testing.
• Involved in Unit Testing, User Acceptancetesting to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Used Debugger to test the data flow and fix the mappings.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets.
• Used TOADto write queries and view the results.
• Involved in Unit, Integration, system, and performance testing.
• Provided knowledge transfer to the end users and created extensive documentation on the design, development, implementation and process flow of the informatica mappings.
• Involved in Implementation of Informatica Components into production and provided post production support for the implemented components.

Environment: InformaticaPowerCenter 8.1/7.1,Oracle 10g,MS-Office,Windows XP, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Involved in Requirement Gathering, Analysis, Design & Development and Configuration Management for the above project.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Development and scheduling the Workflows.
• Troubleshoot the issues by checking sessions and workflow logs and making necessary code changes to fix the issues.
• Involved in analyzing the bugs, performance of SQL Queries and provided solutions to improve the same.
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows.

Environment: Informatica 8.1.1, Oracle, Crystal Reports.