SUMMARY

• 7+ Years of experience in System Analysis, Design, Development Implementation, Maintenance, and Testing of Data Warehouse and Data Integration Applications using ETL tools like Informatica Power center 9.5/9.1/8.x/7.x
• Experience on Business Requirements Analysis, Application Design, Development, Testing, Implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Healthcare, Finance and Pharmaceutical industries.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Main Frame systems, Oracle(10g - 11g), Flat Files ( fixed width, delimited ), DB2, SQL server, XML and Target databases.
• Dimensional Data modeling experience using Data modeling tool Sybase Power designer.
• Worked closely with the Business Objects reporting team to design the data mart tables for Business Objects reports.
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Expertise in Data Flow Diagrams, Process Models, and ER diagrams with modeling tools like ERWIN & VISIO.
• Extensive Experience in designing and developing complex mappings applying various transformations such as Lookup, Source Qualifier, Update Strategy, Router, Sequence generator, Aggregator, Rank, Stored Procedure, Filter, Normalizer, Joinerand Sorter transformations, Mapplets.
• Experience in using various Informatica Powercenter Client components Designer/ Workflow manager /Workflow Monitor/Repository Manager.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementing the reconcile process accordingly.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Experience in implementing the best practice standards throughout the development cycle following the Informatica Velocity methodology.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Hands on experience in maintaining the code versions using Visual Source Safe / Informatica Versioning.
• Strong written and oral communication skills.
• Good knowledge in writing Unix Shell &Autosys JIL scripts and PERL Scripts.
• Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS

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

OS: Unix, MS-DOS, Windows ME/2000/2003/NT/XP

Databases: Oracle (10g-11g), DB2, SQL Server 2012/2008/2005 , Teradata

Programming Skills: PL/SQL

DB: TOAD, SQL* Plus, Erwin

Data Modeling: Sybase Power Designer 15.2

Scripts: UNIX Shell, PERL, Autosys JIL, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

Sr. ETL Informatica Developer

Responsibilities:

• Major involvement in creating and tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in Work flow monitor
• Created update strategy and stored procedure transformations to populate targets based on business requirements.
• Designing and developing based on the methodologies like Inmon and Kimball
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator and Router Transformations.
• Working with DT studio for transformations
• Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Working with XML and XML Schema Definitions (XSD)
• Design and developing data warehouse and data marts.
• Designed the ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
• Designed and developed Mappings with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator.
• Used Change Data Capture (CDC) to implement Incremental Data Extraction so that only the modified and new records will be extracted to the destination rather than full extraction
• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Loaded operational data from Oracle, Sql server, flat files, Excel Worksheets into various data marts.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
• Created Tasks and Workflows using Task Manager and Workflow Designer also developed numerous Stored Procedures, Triggers and common functions using PL/SQL

Environment: InformaticaPower Center 9.6.1,Unix AIX, Putty,Crontab, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Profiling and Data Quality.

Confidential, Murray Hill, NJ

Sr Informatica Developer/Administrator

Responsibilities:

• Worked on Informatica installation on AIX and configuration.
• Business requirements gathering and preparing technical specifications documents.
• Extensively worked on Process Design, Development and Testing
• Trained DWH team on informatica 9.1
• Effectively interacted with Business Users in analyzing the data quality issues reported.
• Extensively worked on debugging the programs for data quality issues and job failures
• Worked on creating shell script for enhancement in the current application.
• Completed the performance tuning in the current process and finally reduced the job run time considerably.
• Developed Stored Procedures, Packages and Functions.
• Assisted in all aspects of the project to meet the scheduled delivery time.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation and process flow of the application
• Conducted unit testing of the enhancements done.
• Worked as a part of a team and provided 7 x 24 Support when required.
• Involved in enhancements and Production Support.

Environment: Informatica,Oracle 10g, PL/SQL,Cognos and UNIX Shell scripting.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Involved in translating business requirements to Technical specifications.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ application for matching and merging process.
• Work with source system SMEs to identify the source data to be brought down to the Data mart.
• Involved in full project life cycle - from analysis to production implementation and support.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Utilized ofInformatica IDQ to complete initial dataprofiling and matching/removing duplicate data.
• Developed the source to target mapping document for ETL development in Informatica.
• Worked Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Perform system testing and enter test cases in Quality Center to ensure data is loaded and mapped correctly to Data mart tables according to the source to target mapping document.
• Designed, developed Informatica mappings using Informatica 9.1, enabling the extract, transport and loading of the data into target tables and loading into the Teradata.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Assist business analysts/users in identifying data gap and data variances.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Create and execute unit test plans based on system and validation requirements, Troubleshoot, optimize, and tune ETL processes.
• Update the data dictionary on system data and mapping information.
• Responsible to create interactive Dash board reports as per the Business requirements.
• Documented and maintained and ensured the process and quality of the system.

Environment: Informatica Power center 9.1, IDQ, Oracle, Teradata, Sybase Power Designer 15.2, XML, SQL Server, Toad for DB2 4.5, Flat Files, Quality Center, UNIX and ESP, Business Objects.

Confidential

ETL Developer

Responsibilities:

• Worked in the staging area so as to remove the inconsistencies in the data coming from the Mainframe Source systems
• Created mappings using Informatica PowerCenter that extracted the data from sources and loaded the data into Targets using various transformations like Normalizer(for Cobol sources)Update Strategy, Lookup, Filter,Router, Union, Aggregator
• Implemented stored procedures and functions, as per requirements in PL/SQL.
• Involved in unit and integration testing of mappings in ETL Test environments.
• Used Informatica debugger for bug fixes.
• Performed Debugging procedures and Performance Tuning on bottlenecks encountered.

Environment: Informatica Power center 8.1.1, Informatica Power Exchange 8.1.1, Oracle 10g, AIX Version 5, Windows XP, and Toad.