SUMMARY

• Over 7 years of IT experience and gained good experience by working on various projects through all phases of Data Warehouse Development Life Cycle, including, requirement gathering and analysis, design, development, testing, performance tuning, and production support.
• Worked with finance, healthcare and insurance domains.
• Profound experience in gathering functional requirements from business leads/users and has ability to translate them into ETL technical requirements which includes design, data flows, transformations and databases.
• Experience in Dimension Data Modeling, Erwin Modeling (Erwin), Microsoft Visio, Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snowflake Schema, Data Warehouse, Data Mart, FACT tables, and Dimension tables.
• Experience in mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Experience in creating complex Informatica Mappings using Source Qualifier, Expression, Router, Aggregator, Lookup, Normalize, and other transformations in Informatica.
• Extensively worked on flat files that are delimited and fixed length.
• Implemented Slowly changing dimensions and change data capture using Informatica.
• Experience with all components of mapping designer such as Source Analyzer, Target Designer, Transformation Developer, Mapplet designer.
• Experience in designing and developing complex mappings applying various transformations such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected Lookups, Sequence Generator, Rank, Update Strategy and Stored Procedure.
• Implemented Slowly changing dimensions and change data capture using Informatica.
• Extensive experience on working with scheduling tools like SAS Management console, Crontab and lsfadmin tools.
• Programming skills using PL/SQL and Shell Scripts. Creation of scripts for moving the files. PL/SQL procedures for reorganization of tables and indexes and creation of indexes for enhancing performance for data access.
• Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
• Experienced with conducting Requirement Gathering and Analysis, High - level Design, coordinating Development, creating unit Test Cases and supporting UAT.
• Expert in debugging, troubleshooting, monitoring, and performance tuning of Sources, Mappings, targets and sessions.
• Experience in designing exception handling procedures to identify, record and report errors.
• Solid in understanding and implementing best practices and coding standards.
• Motivated self-starter with exceptional team building, leadership, and interpersonal skills.
• Good team player with the ability to work in time sensitive environments.
• Excellent analytical and problem solving skills with the ability to handle multiple tasks effectively and quickly master new concepts and subjects.
• Demonstrated ability to work in a team with talent of quick learning by applying new methods and also imparting knowledge to team members.

TECHNICAL SKILLS

ETL Tools: SAS DI Studio 4.2.1, SAS Flow Manager, Informatica 9.0

Data warehousing: Dimension an fact tables, Data marts, Star and Snowflake schema

Scheduling Tools: lsfadmin, Crontab, Control-M

Database: Oracle, MySQL, SQL Server, Netezza, Green Plum, HBase

Query languages: PL/SQL, SPARQL, XPath, XQuery

Programming languages: C, C++ with Data Structures, Java, Shell scripting

Operating systems: Windows 9X/2000/XP, Solaris, Linux, Unix, DOS

Other skills: Software Engineering, Business Intelligence, HTML/CSSXML, PHP, VB, .NET, Apache Hadoop, JenaIBM BigInsights Mapreduce, Subversion, GitHub, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, Springfield, MA

System Support/ETL Developer

Responsibilities:

• Involved in Production Support, analyzing issues and resolving them.
• Involved in Derivatives Accounting Industry and exposed to various financial instruments.
• Used informatica for various purposes for data import from accounting systems to ODS, and ODS out to other processes and feed. For price import and exports to collateral management, pricing, treasury control, SAP GL feed etc.
• Developing, editing and migrating DOS batch files for automation of various processes in the system.
• Developing, testing and migrating code to the production environment of the ETL Designs through Informatica power center.
• Created stored procedure in Oracle to process accounting and used MS SQL for various lookup tables and stored procedures to process the lookup information like issuer info, pricing used in informatica.
• Well versed in Database Models and various Schema Designs.
• Used Unix shell as per the ad-hoc requirements.
• Involved in Knowledge Transfer to new team members, as well as reverse Knowledge Transfer to clients.
• Update documentation regarding Prod Support cases and resolutions.
• Co-ordinate with off-shore team for Prod Support along with any Informatica enhancements.

Environment: Informatica Power Center 9.1, Unix scripting, MS SQL server 2005, Oracle 11g, PL/SQL (Stored Procedures), Microsoft Tivoli Workload Scheduler, Webfocus.

Confidential - Bridgewater, New Jersey

Sr. Informatica Production Support

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files, Xml Files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Data Modellers for project coordination.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Implemented slowly changing dimension Type 1 and Type 2 forChange data capture.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily.
• Doing Change Requirement for complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1/8.6, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Toad, PL/SQL (Stored Procedures, Triggers, Packages).

Confidential, Dubuque, IA

Informatica Developer

Responsibilities:

• Involved in business requirement gathering, which includes translating the business inputs into ETL design/technical documents.
• Involved in End to End Data flow design in ETLInformaticamappings.
• Extensively worked onInformaticaDesigner, Work Flow Manager, Work Flow Monitor and Repository Manager..
• Created several complexInformaticamappings, Mapplets depending on client requirements. Extensively worked on Connected & Unconnected Lookups, Router, Expression, Source Qualifier, Aggregator, Filter, and Sequence Generator.
• Developed SQL Scripts and PL/SQL Scripts to extract data from different sources.
• Performed Data cleansing, standardizing incorrect data formats, misspellings, redundant, missing data values and performed de-duplication of customer data.
• Extensively worked with Lookup caches like Static cache, Dynamic cache & Persistent cache.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Responsible for performance tuning which includes Tuned sources, targets, mappings, and sessions to improve the performance. To get optimal performance, used parameter files and mapping parameter, Variables in mappings and session variables in workflows.
• Used Workflow Manager to schedule and run batches, sessions, as well as to check session logs and other session related activities.
• Developed UNIX Shell Scripts for automating Batches and Sessions.
• Responsible for Error handling, bug fixing, Session monitoring and log analysis.
• Involved in unit testing, UAT testing and integrated testing of entire process flow.
• DeployedInformaticajobs from Development environment to Test environment and Test to Production Environment usingInformaticaexport/import methodology.
• Developed Business Process diagrams to understand the business and process and developed data flow diagrams using Visio.

Environment: Informatica-Power Center 9.5.1, (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Oracle 11g, Toad, Java, Netbeans, View Point Erwin 7, MS Visio, Windows, Autosys.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Involved in analyzing the source data coming from different Data sources such as XML flat files etc.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Normalizer, Union, Stored procedure, and XML transformations.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.

Environment: Informatica Power Center 8.1, Oracle, Flat files, Shell, UNIX- AIX.

Confidential, North Brook, IL

ETL Informatica Developer

Responsibilities:

• Involved in creating new mappings and changing in existing mappings as per the new business rules.
• Coordinated the offshore team for sharing work and knowledge transfer.
• Attended business meetings and involved in requirement gathering.
• Analyzed business information requirements.
• Used Source Qualifier, Expression, Filter, Lookup, aggregate, Update Strategy, Router, Sequence generator and Joiner Transformations for creation of mappings.
• Created unit test cased and did unit testing for the mappings.
• Created sessions and workflows for the mappings.
• Worked for ETL QA testing.
• Documented the mapping process and methodology used to facilitate future development.
• Extensively interacted with user and involved in various documents preparation like Integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans, and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Tuning mappings for performance improvement in informatica.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica Power Center 9, Oracle 11g, TIVOLI

Confidential

Informatica ETL Developer

Responsibilities:

• Goal of project is to enhance existing warehouse on stock brokers, investors and the market intermediaries and significantly and to enhance NSE’s decisions on trading system.
• Implemented enterprise data warehouse for the Indian National Stock Exchange (NSE)
• Extracted, transformed, and loaded data from source to target files.
• Created source, targeted files, designed the mappings, deployed and scheduled them.
• Created the mappings and scheduled them with file events.
• Created stored procedures and shell scripts to automate the ETL process.

Environment: Informatica Power Center Designer, UNIX, Database: Greenplum.

Confidential

SAS ETL Developer

Responsibilities:

• Goal of project is to create warehouse and perform surveillance on stock brokers, investors and the market intermediaries and significantly enhance SEBI’s investigation and surveillance functions.
• Implemented data warehousing business intelligence system for the Securities and Exchange Board of India (SEBI).
• Extracted, transformed, and loaded data from source to target files.
• Created source, targeted files, designed the jobs, deployed and scheduled them.
• Executed and rectified the errors in the process flow.
• Created the flows and scheduled them with file events.
• Worked on performance improvement techniques in the workflows and mappings.
• Create procedures and shell scripts for the process.
• Debugging the errors and resolving issues in the development and production environments.

Environment: SAS DI Studio, Management console, Process Manager, UNIX, Database: Netezza.