SUMMARY

• Proficient in Data Extraction, Data Transformation and Data Loading withInformaticaPower Center.
• Strong Experience in all the phases of the Data Warehouse project life cycle including Requirement Gathering, Design, Development, Testing, UAT, and Implementation of Data warehouses using ETL, Online Analytical Processing & reporting tools.
• 8+years experience Enterprise Data Warehouse (EDW) /Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Proficient in Analyzing the Business Processes requirements and translating them into technical requirements, design data architecture for data Integration/Migration, dimensions data model.
• Strong knowledge in working withInformaticaPower Exchange for Change Data Capture (CDC) from SQL and Oracle.
• Strong knowledge in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling.
• Experience in integration of various data sources including Oracle, SQL server, DB2, Sybase, and MS access, SAP and non-relational sources like flat files into staging area.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, and Multi Load to export and load datato and from different source systems including flat files.
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Strong knowledge of Hadoop and Hive and Hive’s analytical functions.
• Proficient in writing, testing and implementation of PL/SQL stored procedures, triggers, functions, packages using Oracle and stored procedures and triggers using SQL Server and T-SQL.
• Extensive knowledge of various kinds ofInformaticaTransformations such as Source Qualifier, Aggregate, Lookup, Rank, Joiner, Filter, Router, Sorter, Sequence, Union, Update Strategy, Stored Procedure, Normalizer, xml Transformation.
• Excellent experience withInformaticaconcepts like Labeling of objects, Versioning, Push Down Optimization (PDO).
• 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).
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Created UNIX shell scripts to automate and implement workflows, sessions and dynamic source/target databases.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various aspects of the data warehouse infrastructure.
• Excellent analytical/communication skills and good team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.X/8.X/7.X/6.X, Power Exchange 9.X/8.X, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE).

Data Modeling Tools: Data Mart, Dimensional, Snow Flake, Star Schema, CA Erwin, Microsoft Visio.

RDBMS: Oracle 119/10g, Teradata, SQL Server 2012/2008, DB2, Hadoop.

O/S: Microsoft Windows 98/NT/2000/XP, Sun Solaris, UNIX, Linux Red Hat.

Scheduling Tools: Control - M, AutoSys, Tivoli and Active Batch.

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

ETL Informatica Developer

Responsibilities:

• Developed Data Mappings between source systems and warehouse components using mapping designer.
• Implemented Type II slowly changing Dimension to maintain all historical information in Dimension Tables.
• Performance Tuning of SQL Queries and ETL Mappings. Extensively used PDO for optimizing the loads.
• Converted procedures into mappings using various transformations like Source Qualifier, Expression, sorter, Update Strategy, Filter, Lookup and Aggregator.
• Validation ofInformaticamappings for source compatibility due to version changes at the source.
• Created workflows using Session, Command, and Email tasks.
• Fine-tuned PL/SQL Procedures for better performance.
• Fine-tuned the stored procedures, queries by changing the join orders and giving all combinations of joins and fixed them with the help of explain facility tools.
• Designed and developed database objects such as Packages, procedures, functions and cursors.
• Written Shell Scripts for validating FTP Flat files. Developed Unix Shell scripts to automate the data load processes to target data warehouse.
• Worked with Big Data and Hadoop File System (HDFS).
• Created E-mail notification tasks using post-session scripts.
• Migrated mappings to various environments like development, testing and production.
• Designed and developed several on-demands and scheduled reports using Business Objects.
• Business Objects development included both new reports and customization of existing reports and also Ad hoc reports.

Environment: Informatica PowerCenter 9.5/9.6, Informatica Power exchange, Hadoop, SQL Server, Oracle, Control M, Putty, UNIX, Toad, Business Objects.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Involved in Extraction, Transformation and Loading of the data usingPowerCenter 9.5.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using InformaticaPower center.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
• Developed Mappings and Workflows to load the data into Teradata target tables.
• UsedTeradata utilities Fast load, Multiload, Tpumpto load data.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions for loading the data into target table.
• Developed complexInformaticamappings and tuned them for better performance.
• Designed and developing complexInformaticamappings including Type-I, Type-II slowly changing dimensions.
• CreatedBTEQ (Basic Teradata Query) scripts in Teradata to generate Keys.
• Developed Teradata Utility scripts like FastLoad, MultiLoad to load data from various source systems to Teradata.
• Involved in migration of objects across various environments.
• Informatica Data quality is used for data quality measurement.
• Worked withInformaticaData Quality 9.5 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.5.

Environment: Informatica PowerCenter 9.5, Informatica Data Quality, Teradata, SQL Server, Oracle, Control M, UNIX, Winscp, Putty, SQL Assistant.

Informatica Developer

Responsibilities:

• Worked onInformatica9.1 Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Point of contact for multiple high visible projects with high complex business functionality.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed advanced reusable UNIX shell scripts for ETL auditing, error handling and automation.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Created mapplets& reusable transformations to use them in different mappings.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in theInformaticaDesigner.
• Developed advanced reusable mapplets for SCD and fact loading.
• Used Power Exchange to source copybook definition and then to row test the data from data files.
• Developed mapping parameters and variables to support SQL override.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.

Environment: Informatica PowerCenter 9.1, Power Exchange, DB2, SQL Server, Oracle, Control M, Toad, UNIX, Putty.

Confidential, Wausau, WI

Informatica Developer

Responsibilities:

• Gathered all business requirements by frequently arranging meetings with BA, Source System team and Data Analyst.
• Used Aggregators, sorter, router, connected lookups to createInformaticalogic.
• Parameterized allInformaticacodes using generic UNIX script and make jobs to run by the script.
• Implemented various loads like Daily Loads and Monthly Loads using Incremental Loading Strategy.
• Perform testing of all createdInformaticacodes and document all results in spreadsheet.
• Provided full offline support during any job failures.
• Used update strategy to effectively migrate data from source to target.
• Moved mappings from development environment to test environment.
• Imported and created source definitions from Oracle and flat files.
• CreatedInformaticamappings using various transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Involved in designing of testing plan (Unit testing and System testing).
• Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.

Environment: Informaticapower center 8.6, Oracle, WinSCP, Toad, SQL, PL/SQL and UNIX.

Confidential, Mounds View, MN

ETL Developer

Responsibilities:

• Performed Extraction, Transformation and loading of data usingInformaticaPower Center and TransformationDeveloper.
• Worked onInformaticatools Source Analyzer, Warehouse designer, Mapping Designer and Workflow Manager and workflow monitor.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings Monitored the sessions using Workflow Monitor Implementation and performance tuning of the mappings.
• Wrote PL/SQL functions, cursors, triggers and embedded them in PL/SQL packages.
• Prepared the unit test case and designed SQL according to test result.
• Created parameter files with workflows and sessions.
• Tuned mappings to perform better using different logics to provide maximum efficiency and performance.
• Identified bottlenecks and executed performance tuning.

Environment: Informaticapower center 8.6, Oracle, Toad, SQL, PL/SQL and UNIX.