SUMMARY

• 6 years of IT experience with Data Warehouse, System analysis, design, development, Database design, SQL, PL/SQL programming.
• Extensive experience on Informatica PowerCenter 9.x/8.x, SSIS.
• Development experience across business areas such as healthcare, Insurance, Pharmaceutical domain.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Experience in using the Informatica command line utility to schedule and control sessions and batches.
• Expert in Database procedures, functions.
• Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica PowerCenter.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Worked on integrating data from heterogeneous sources like Oracle, flat files, DB2, MSSQL Server and XML files.
• Extensive knowledge of SSIS transformations such as lookup, derived column, data conversion, aggregate and conditional split.
• Experience with pre - session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Skilled in full life cycle development for building a Data Warehouse.
• Skilled in Reporting tools like IBM Cognos, SAP Business Objects and SSRS.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

ETL Tools: Informatica (Power Center 9.X, 8.X), SSIS (Microsoft Visual Studio 2010).

Operating Systems: Windows 2010/2008/2007/ XP, Sun Solaris 11.

RDBMS: Oracle11g/10g(SQL, PL/SQL)MSSQL Server 2008/2012(SQL, T-SQL).

Data Base Tools: Toad, SQL Server Management Studio, SQL Navigator 4.0SQL Loader, DTM Data Generator, DB GhostRed Gate SQL Data Compare, Red Gate SQL Compare.

Data Modeling: CA ERwin Data Modeler 8.

Reporting Tool: IBM Cognos10 (Transformer, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), SAP Business Objects 4, SSRS (Microsoft Visual Studio 2010).

Scripting: Shell Scripting.

Other: HTML, XML.

Languages: C, SQL, PL/SQL, T-SQL, Basic Java.

PROFESSIONAL EXPERIENCE

Confidential, Windsor Mills, MD

ETL Developer

Responsibilities:

• Analyzed stored procedures and functions in PL/SQL.
• Prepared Low Level Design document.
• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a corporate-wide-ETL Solution using Informatica.
• Used several transformations like source qualifier, expression, lookup, aggregator, Joiner, sequence generator, router and update strategy transformations for complex mappings.
• Used pre-defined parameters and user-defined variables at mapping and session level.
• Created objects like Mapplets, reusable transformations, shortcuts for ease of enhancement by facilitating reusability.
• Used Debugger wizard to analyze the flow of data on row by row basis from transformation to transformation.
• Monitored Workflows and Sessions using Workflow Monitor.
• Involving in trouble shooting of long running sessions and fixing bugs.
• Precise Documentation was done for all mappings, workflows (Interface Design Document).
• Prepared unit test cases and performed unit testing.
• Tuned Informatica mappings for better performance using different techniques to provide maximum efficiency and complete performance.
• Developed UNIX shells scripts and automate the sessions running processes using pmcmd commands in UNIX shell scripts.
• Coordinated with source system owners, day-to-day ETL progress monitoring, and maintenance.
• Implemented SCD type 1, Type2 and Type3 as per the business need.
• Excellent in creating the map, assigning workflow, testing the flow and monitoring the job.
• Extensively used ETL to load data from wide range of sources such as flat files, excel files, XML to Oracle.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.

Environment: Solaris 11, Oracle 12C, PL/SQL, Informatica Power Center 9X, Business Objects, Tableau, UNIX.

Confidential, Los Angeles, CA.

ETL Developer

Responsibilities:

• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
• Analyzed Source System data. Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformation designer.
• Responsible for developing Source to Target Mappings.
• Used most of the Transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Expressions, Update Strategy, and Router etc.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used pre-defined workflow variables and created persistent workflow variables to reference values and record information in a workflow.
• Used ETL to load data from Oracle, sql server, flat files, and xml to the Data Warehouse.
• Worked with Operational data sources (ODS), Staging data, Data Marts and Data Warehouse.
• Created reusable Mapplets /transformations embedding business logic.
• Created Stored Procedures to transform the Data and worked on T-SQL for various needs of the transformations while loading the data.
• Configured sessions and batches using Informatica Power Center Work Flow Manager and monitored them in the Work Flow Monitor.
• DesignedSSISPackages to transfer data between files and database servers. Used different SSIS task and transformations to implement the business logic. Used SQL Server Agent for scheduling jobs and alerts.
• Developed UNIX scripts for modifying, parsing and validating data.
• Developed shells scripts to automate the sessions running processes using pmcmd commands.
• Tuned mappings, transformations and recommended tuning options of source/target database to DBA team for obtaining optimum performance.
• Implemented Informatica Pipeline Partitions for improving session performance.
• Performed Unit testing for mappings, workflows and prepared source to mapping (STM) document, Unit testing document.
• Developed several reports featuring multiple prompt selections, drill through reports, List Report, Crosstab Report and Chart Report using Cognos10.
• Performed Unit testing for reports and prepared Unit testing document.

Environment: Solaris, Windows 2007, Oracle 10g, Informatica Power Center 9X, Cognos10, SQL Server 2008, SSIS, SSMS, UNIX, Espresso job scheduler.

Confidential, Charlottesville, VA

ETL Developer

Responsibilities:

• Analyzed the data from heterogeneous sources to maintain consistency and performed validation.
• Identified the facts and dimensions and designed the relevant dimension and fact tables.
• Used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created Complex Mappings which involved Slowly Changing Dimensions to implement Business Logic and capturing the deleted records in the source systems.
• Used Parameterization Technique to increasing flexibility, reusability and readability.
• Created dynamic PL/SQL procedures and mappings to load data from staging area to the data marts.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing for Informatica mappings and workflows.
• Prepared UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Prepared Documentation like source to mapping (STM) document, Unit testing document for all mappings and workflows.
• Used Debugger in troubleshooting the existing mappings.

Environment: Windows 2007, Oracle 11g, Informatica Power Center 8.X, UNIX.