SUMMARY:

• Over 7+ years of strong experience in Data Warehouse using ETL tools like Informatica Power Center, IDQ,IDE, MDM 9.X, 8.X, SSIS 2012.
• Extensive work experience in the areas of Banking, Finance, Insurance, Manufacturing Industries, Aero Aviation and HealthCare.
• Hands on experience in Defining the development processes, design principals and organizational model for ETL function and Data Quality with IDQ by using Informatica Developer.
• Translated Business processes into Informatica mappings and Quality Improvement, Column Level Profiling and structural issues by using IDE.
• Extensive work experience Design and development of CDC process using time - stamping method and Implemented SCD methodology including Type 2 to keep track of historical data.
• Extensively worked on the ETL mappings Design, Analysis and Documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, with large data sets.
• Strong Hands on Experience in Optimization of performance tuning in the Oracle SQL queries like Indexing techniques.
• Strong Hands on Experience in the Performance tuning of sources, transformations, targets, mappings, work lets, workflows, and sessions.
• Involved in performance improvement for the transaction load process and optimized the existing SQL queries for performance improvement. Apart from that used the analytical functions, collection and other method to enhance the performance.
• Strong Hands on experience in Deployment of Objects from one environment to other environment.
• Preparation of Low level Designs (LLD), UTR, Run Book, Impact Analysis, Project Milestones, and Technical Design Document.
• Strong Hands on experience in the Handling of Offshore and on site teams.
• Proficient in Creating UNIX Shell Scripts.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, IDQ, MDM, SSIS.

Databases: Oracle 11i/10g/9i/8i, SQL Server 2008R2/2012, TeradData.

Database Tools: TOAD, SQL Developer, SQL plus, SQL assistant.

Data Modeling Tools: Erwin 4.0.

MS Products: MS Visio, MS Project, MS office Suite, MS SharePoint.

Programming Languages: PL/T-SQL, UNIX Shell scripting

Operating Systems: Windows 7, Windows NT, Windows 2000/XP, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

• Defined the development processes, design principals and organizational model for Treasury’s ETL function
• Translated Business processes into Informatica mappings.
• Devised and constructed high-performance ETL processes that load a normalized operational data store and dimensional data warehouse.
• Design and development of CDC process using time-stamping method and Implemented SCD methodology including Type 2 to keep track of historical data.
• Development of new workflow to extract the data from EDW and provide the XML, Flat Files, CSV to the end customer through FTP by writing script at session level.
• Deployment of objects.
• Involved in performance improvement for the transaction load process and optimized the existing SQL queries for performance improvement. Apart from that used the analytical functions, collection, BULK Collect /FORALL and other method to enhance the performance.
• Performing code migrations as part of weekly/Monthly Change request releases.
• Troubleshoot, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents.
• Execute the Test cases for the code changes.
• Provided extensive support in UAT (user acceptance testing) and deployment of mappings.

Environment: Informatica Power Center 9.6, Power Exchange, SSIS, Teradata, UNIX, Oracle, Mainframes, Flat Files, XML, VSAM Files, Sequential Files.

Confidential, Newark, NJ

Senior Informatica Consultant

Responsibilities:

• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Designing Informatica mappings to load slowly changing dimensions using Lookup, router & update strategy transformations.
• Creating source to staging and staging to warehouse mappings using Designer Transformations like Expression, Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look up etc.
• Contributed in developing complex ETL mappings, workflows for three types of mappings, source to staging, Dimension and fact loading.
• Involved in performance tuning of the ETL mappings and writing SQL queries for extracting data from source systems.
• Designed unit test cases for each ETL map and Involved in Integration testing and system testing phases of the project.
• Developed shell scripts that are used to populate parameter files automatically before the ETL process starts.
• Worked closely with data population source systems and warehouse components.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: PowerCenter9.1, Oracle, SQL Server 2012, SQL,PL/SQL, Linux, Mainframe DB2, MySQL, SAP EDI, MS Visio, Toad 8.0, Windows 2000,UNIX

Confidential, New York, NY

Senior ETL Developer

Responsibilities:

• Developed high level and detailed level technical documents to define the system components, development environment and implementation planning/strategies.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Gathered business and technical requirements from both formal and informal sessions through NetMeeting, questionnaire, video conferencing and conference calls.
• Creating a SSIS package for front end applications.
• Experience in Creation of ETL mappings using Informatica Power Center to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Created Sessions and Workflows to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations all over the country.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.

Environment: Power Center 8.6, IDQ, Oracle, SQL Server 2012, SQL,PL/SQL, Mainframe MySQL, MS Visio, Toad 8.0, Windows 2000,UNIX

Confidential, MN

Informatica Developer

Responsibilities:

• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Developed custom data transformation (structured/unstructured data) process using Item field content master data transformation tool.
• Worked on InformaticaPowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Developed PL/SQL stored procedures for Informatica mappings.
• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for management reporting.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Providing technical support and troubleshooting issues for business users.
• Actively Participated in problem solving and troubleshooting for the applications implemented with Informatica.
• Used Workflows Manager to create the Sessions to transport the data to target warehouse.

Environment: InformaticaPowerCenter 8.1, Power Exchange 8.1, Erwin 4.1, EDI, Autosys r11.0 oracle 9i, PL/SQL, Teradata 12, SQL,, XML, SQL Server 2005, Windows 2003, Unix.