SUMMARY:

• Around 7years of IT experience as ETLDeveloper (Informatica PowerCenter 9.5/9.1/8.6/7.1.2 ), ETL, SQL, PL/SQL programming and extensive experience in Data Quality, Data integration, ETL Informatica, Unix Scripting, Data analysis, Data profiling, developing and implementing decision support, Operational Data Store, Data Warehousing and other information management solutions and strategies on various Database platform. 
• Thorough knowledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Working Knowledge on different data sources as Flat Files, Oracle, Excel.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations.
• Used B2B DT extracted data from all files, Document and message - based data, including Microsoft Word and Excel Document. 
• Experience in Informatica B2B Data Exchange using Unstructured, Structured Data sets. 
• Excellent in creating the map, assigning workflow, testing the flow and monitoring the job.
• Worked on integrating data from heterogeneous sources like Oracle, flat files XML files.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Hands on experience in Informatica in the Data Quality (IDQ) process.
• Error review, log and restudy/recode of the system.
• Experience with complex mappings using Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator.
• Experience in creating Sessions, Workflows, and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Designing process flows, deploying and populating staging area objects defining and populating the Enterprise Data Warehouse.  
• Worked on resolving data quality issues by standardizing the data arriving from several sources to match the DW format. 
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Knowledge of full life cycle development for building a Data Warehouse.
• Extensively interacted with the Business Analysts to create reports according to their requirements and specifications.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 7.1, 8.6, 9.1,9.5, Data ware housing Concepts,B2B, Data Exchange

Other Tools: Toad, Oracle SQL Developer,Tableau, ERWin, Quality Center

Databases: Oracle 9i, Oracle 10g, Oracle 11g

Languages: SQL, PL/SQL

Web Technologies: HTML, DHTML, XML

Operating Systems: Windows and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL Informatica Developer

Responsibilities:

• Designed and Developed mappings using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Extensively used PL/SQL programming procedures, packages to implement business rules.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Workflow Manager.
• Used Structured and Unstructured Data like PDF files, spreadsheets, Word documents, legacy formats, and print streams option to get normalized data using B2B DataExchange of Informatica.
• Created real time mapping, workflows, restart token and recovery process using Informatica Power Exchange.
• Used Informatica B2B Data Exchange to Structured data like XML. 
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Maintain production EnterpriseDataWarehouse environment,  
• Developed Procedures and Functions in PL/SQL for ETL.
• Loaded the target data and provided the logical objects for the analysts and users to preview the data for data quality purpose inInformatica Analyst (IA) 
• Performing standard IDQ functions including data profiling, data cleansing and address standardization, validation and cleansing using Informatica Data Quality (IDQ). 
• Coded BTEQ scripts to load data from Teradata staging to Enterprise Data warehouse.  
• Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Developed pre-session, post-session routines and batch execution routines.
• Debugging and Trouble Shooting Of Mappings.

Environment: Informatica PowerCenter 9.5, Toad, SQL, PL/SQL, Oracle 11g, Flat files, Informatica B2B Data Exchange,UNIX,Autosys, Jira(Ticketing Tool).

Confidential, Washington, DC

ETL Informatica Developer

Responsibilities:

• Created Mappings with different transformations including Source Qualifier, Lookup, Filter, Expression, Aggregator, Look up Transformations.
• Used Designer to create mappings using different transformations to move data from source to target Data Warehouse.
• Designed and Developed mappings using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• B2B Data transformation supports transformation and mapping.
• Error review, log and restudy/recode of the system.
• Involved in using Informatica DataExplorer (IDE) for data profiling over metadata and Informatica Data Quality (IDQ) for data quality measurement
• Debugging and Trouble Shooting Of Informatica Mappings.
• Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows. 
• Used Autosys for scheduling jobs. 
• Used Parameter files to manage the relational connection in different environments.
• Tuned SQL Queries in Source qualifier Transformation for better performance.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Developed Task/Sessions and Workflowsas required with session variables.
• Developed various packages, stored procedures, functions for business needs.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created reusable transformations and Mapplets and used them in various mappings.
• Responsible to move mapping elements to UAT,QA&PROD by Import/export as XML files subsequently create the migration documents for UAT QA &PROD.

Environment: InformaticaPowerCenter 9.5, TOAD, Informatica B2B Data Exchange,Oracle 11g, Unix, Quality Center.

Confidential, Dallas, TX

ETL Developer/ Analyst

Responsibilities:

• Designed and developed complex Informatica mappings to extract data from the staging area and build the EDW using Source Qualifier, Expression, Filter, Sequence Generator, Router, Joiner and Lookup transformations.
• Performed Unit testing and documented the results in the testing documents both in development and Integration environments.
• Troubleshooting issues in the production environment and help in resolving issues in the same. Used debugging tools to debug the flow of data and found the exact issues where expected data was not populated correctly.
• Performed impact analysis for various enhancement requests to find out the systems/programs that could be potentially affected by proposed change(s).
• Involved in analysis to ensure data is correct, identify the correct source of data.
• Created Sessions, Workflows, Post Session email task and also performed various workflow monitoring and scheduling tasks.
• Wrote complex SQL, stored procedures in Oracle .
• Data analysis to ensure data quality in DW.
• Involved in analysis to make sure source and target data are in sync and no failures during data migration.
• Performed testing for various sample data.
• Involved in offshore coordination.

Environment: Informatica 8.6, Oracle, Teradata, Teradata SQL Assistant 12.0, Toad, SharePoint, SQL, UNIX

Confidential, Fort Worth, TX

Informatica developer

Responsibilities:

• Analysis and integration of legacy asset data to Asset Hub for business reporting.
• Involved in analysis of legacy data from different databases.
• Requirement gathering from users.
• Involved in design and ETL development.
• Involved in creating mapping, session, workflows.
• Create XML file using informatica ETL.
• Peer design review and documentation of the ETL process.
• MQ Series analysis to setup MQ between Informatica and asset hub.

Environment: Informatica 8.5.1/8.6, SQL, XML, MQ Series, SharePoint, UNIX.

Confidential

Informatica developer

Responsibilities:

• Designed and Developed mappings using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Extensively used PL/SQLprogramming procedures, packages to implement business rules.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Workflow Manager.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.
• Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Developed pre-session, post-session routines and batch execution routines.
• Debugging and Trouble Shooting Of Mappings.

Environment: TOAD, Informatica PowerCenter 7.1, Oracle 9.1 .