SUMMARY:

• Around 9 years of IT experience in Data warehousing projects, primarily as specialist in performing Analysis, Design, Development, Testing, Implementation, Migration, Deployment, Enhancement and Maintenance ofInformatica, Oracle, Teradata, DB2/UDB,Sybase and SQL Server environments.
• Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments and warranty Support.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Good Understanding of Ralph Kimball and Bill Inman methodologies/approach
• Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse on Windows and Unix Platforms for Financial, and Health Insurance Industries.
• Extensive experience with Informatica Power Center 9.x, 8.x and 7.x hosted on UNIX, Linux and Windows platforms.
• Installing Informatica on windows as part of upgrade from 8.6 to 9.1.
• Extensively worked on creating XML Mappings.
• Create and manage users, groups and folders. Ensure appropriate privileges are assigned to the different users.
• Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Extensive experience in utilizing ETL Process for designing and building very large - scale data OLAP using Teradata and ETL tools Informatica.
• Expertise in SQL and Performance tuning on large scale Oracle, Teradata
• Expertise in creating databases, users, tables, triggers, macros, views, functions, Packages, joins and hash indexes in oracle and Teradata database.
• Hands on experience using query tools like TOAD, PLSQL developer, Teradata SQL Assistant and Query man.
• Hands on experience in defining Technical Requirements for ETL processes and developing Complex Mappings to load data into enterprise data warehouse and data marts.
• Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica.
• Good understanding of relational database management systems like Oracle, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Expertise in trouble-shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
• Extensive knowledge of various Performance Tuning Techniques on Sources, Targets, Mappings and Workflows using Partitions/Parallelization and eliminating Cache Intensive Transformations.
• Very strong understanding in data warehousing concepts star and snow flake methodologies, slowly changing dimensions.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Committed individual with excellent interpersonal, analytical and communication skills
• Ability to work simultaneously on multiple projects, work independently as well as a team member.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.x/7.x/6.x, Power Exchange 9.1/8.x/7.x, Informatica Data Quality, Power Mart 5.x(Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformation Developer, Repository Manager, Workflow monitor)

Data Modeling: MS Visio, ER Diagrams.

Databases: Oracle 11g/10g/9i/8i, Sybase, DB2, MS SQL Server 2000/2005,Teradata, Veeva CRM, Axis.

DB Tools: Oracle SQL Developer, SQL*Loader, Toad, Saleforce Console

Operating Systems: Windows 98/2003/2000/ XP/7/NT, UNIX, MS-DOS, Linux AIX.

Scheduling Tools: Skybot, Autosys, Control M

Languages: SQL, PL/SQL, UNIX, HTML, XML

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

PROFESSIONAL EXPERINCE:

Confidential, Weston, MA

Sr. ETL/Informatica Consultant

Responsibilities:

• Involved in designing Technical and functional specs based on requirements provided by business.
• Involved in writing mapping specification document (STTM).
• Developed Informatica mappings, sessions & workflows, using active and passive transformations, Mapping parameters, session parameters, reusable and non-reusable objects.
• Involved myself in identifying the bottlenecks of the Informatica mappings and tuned the Mappings and increased the performance of the mappings.
• Involved in Performance Tuning both in informatica and database level.
• Validated the data and ensures that data is being populated as expected.
• Worked on enhancements of existing mapping for handling Type-I &Type-II.
• Used debugger to identify the issues and to fix the bugs.
• Preparing Unit Test Case document and performing Unit testing.
• Worked in the Informatica Cloud in order to replicate the data from the Salesforce.
• Worked in the ABC which is more like an internal Tool for the CDC and Error capture.
• Involved in generating deployment packages across various environments.

Environment: Informatica Powercenter9.6.0, Windows XP, UNIX, TOAD, OracleSQL, PL/SQL, Oracle11g/9i Salesforce Veeva CRM, AXIS.

Confidential, Mansifiled, MA

Sr.ETL/Informatica Developer

Responsibilities:

• Designing Functional and technical specs based on requirements provided by business.
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusingInformatica power center.
• Created Mappings using Mapping Designer to load data from various sources like Oracle, Flat Files, MS SQL Server and XML.
• Unique Device Identification (UDI) Program for Medical Devices in Global instance that meet regulatory.
• Created a view to handle multiple packages in the XML.
• Generated Xmls usingInformatica power center to send FDASIA Skus to FDA through GHX using PTC Windchill Tool.
• Maintained day to day report on the errors and successful ACK3 from FDA and prepared Excel charts.
• Involved in writing batch scripts to pull the required information from Ack3 xml files.
• Ack3 are loaded into database Tables usingInformatica power center.
• Created new mappings and updating old mappings according to changes in Business logic
• Actively Involved into Informatica code migrations and monitoring according to our client's standards.
• Involved in the documentation of the ETL process with information about the various mappings, the order of execution for them and the dependencies.
• Used Parameter files to specify DB Connection parameters for sources.
• Used debugger to test the mapping and fixed the bugs.
• Involved inPerformance Tuningat various levels including Target, Source, and Mapping.
• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.
• Involved in integration testing at various levels including Target, Source, and Mapping.
• Perform ETL Informatica Administration functions such as user access accounts, roles, and setting standards.
• Create and manage users, groups and folders. Ensure appropriate privileges are assigned to the different users.

Environment: Informatica Powercenter9.1.0, Windows XP, TOAD, OracleSQL, PL/SQL, Oracle11g/9i and SQL Server, Skybot.

Confidential, Bridgeport, CT

Sr. ETL/Informatica Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Responsibilities included designing and developing complex Informatica mappings including Type-I, Type-II slowly changing dimensions.
• Migration of objects across various environments
• Had developed and tested the warehouse application according to functional specifications using Teradata utilities, UNIX.
• Creation of Unit Test Cases.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue. Preparing the documents for test data loading.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor

Environment: Informatica Powercenter9.1.0TOAD,OracleSQL,PL/SQL and Oracle11g/9i, Sybase and Control - M.

Confidential, Brea, CA

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusingInformatica power center.
• Extensively used all the features of Informatica Version 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Good understanding of relational database management systems like Oracle, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction, transformation and loading of data from various database source systems
• Created Complex mappings using transformation like Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Created stored procedures, views, triggers, functions inPL/SQLand TSQL.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Worked with Data Stage Director for testing and monitoring the executable jobs.
• Worked with Data Stage Manager to import and export job and job executables for back up and also move jobs from one environment to other.
• Involved in Performance tuning and scheduled workflows using Autosys job plan.
• Designed and developed UNIX shell scripts as part of the pre-session and post-session command to automate the process of loading, pulling, renaming and pushing data from and to different servers.

Environment: Informatica Power Center 8.6/9.0.1,Oracle 10g/11g, TSQL, PLSQL, DB2 SQL server, Toad, UNIX, Windows XP

Confidential, Schenectady, NY

ETL/Informatica Developer

Responsibilities:

• Understanding the Business Design Documents and creating an overall design based on requirements and Business reviews.
• Designed and reviewed the ETL solutions inInformatica Power Center 7.1.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging area.
• Developed Informatica mappings to load data into various fact tables and dimension tables.
• Created Mappings using Mapping Designer to load data from various sources like Oracle, Flat Files, MS SQL Server and XML.
• Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation etc for developing Informatica mappings.
• Prepared ETL standards, naming conventions and wrote ETL flow documentation.
• Importing source and target tables from their respective databases.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Performed Repository Administration tasks (Creating Repositories, Users, Assigning privileges, creating backups and recovery).
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Implemented versioning of folders in the Informatica Designer tool.
• Used Parameter files to specify DB Connection parameters for sources.
• Used debugger to test the mapping and fixed the bugs.
• Involved inPerformance Tuningat various levels including Target, Source, and Mapping.
• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.

Environment: Oracle 9i, Informatica 8, SQL*Plus, SQL Developer 1.2, Windows XP, UNIX.

Confidential

ETL Developer

Responsibilities:

• Analyze project plan to gather the business requirement.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Extract data from flat files, Oracle, SQL Plus,MS SQL Server 2008 and to load the data into the target database.
• Extensively used Informatica Power Center 7.1 an ETL tool to extract, transform and load data from remote sources to DW.
• Created Complex mappings using transformation like Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Developed complex joins in the mappings to process data from different sources.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors of target data load.
• Developed workflowtasks like reusable Email, Event wait, Timer, Command, Decision.
• Performed unit testing of Informatica sessions, batches and the target Data.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Effectively utilized shared/ persistent caching techniques and incremental aggregation strategies to improve performance.
• Designed and developed UNIX shell scripts as part of the pre-session and post-session command to automate the process of loading, pulling, renaming and pushing data from and to different servers.
• Designed and developed SQL, PL/SQL and UNIX shell scripts.

Environment: Informatica Power center Designer 7, Oracle 9.x/10g, TOAD, Flat Files, UNIX, MS SQL Server 2008, SQL, PL/SQL, and SQL PLUS