SUMMARY

• Over all 7+ years of Data Warehousing experience using Informatica Power Center 7.1.3/8.6.1/8.1.1/9.1.0, Oracle 10g/11g, SQL, PL/SQL, UNIX and DB2.
• Have good understanding on Latest Informatica Power Center 9.5 and its added features.
• Experience in Information Technology with strong business understanding into different domains like Banking, Insurance, Finance, Pharmaceuticals - Healthcare and Telecom Sectors.
• Familiarity with Master Data Management (MDM) concepts and Informatica MDM tool -Informatica MDM Hub Console, Hierarchy Manager (HM) and Informatica Data Director (IDD).
• Experience in interacting with Informatica Data Quality(IDQ), Built IDQ mapplets for address cleansing, telephone cleansing and SSN cleansing.
• Extensive Used Standardizer, Parser transformations effectively in mapplets.
• Experience in exporting the mapplets from IDQ to Powercenter and use them in Powercenter
• Experience in Master Data Management (MDM) architectures and business processes.
• Experience in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation.
• Proficient in Performance Tuning of Informatica Mappings, Transformations, Sessions and experienced optimizing query performance.
• Used complex Informatica transformation like Normalizer, Transaction control, UDF’s and SCD’s (Type 1, Type 2 and Type 3).
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML, and Mainframe into Warehouse.
• Have a good understanding on Data Warehouse concepts, MDM, B2B and Teradata.
• Teradata experience using Teradata SQL Assistant and data load/unload utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Tpump.
• Implementation and Support of various OLTP, Data Warehousing, and OLAP applications
• Experience working in Oracle8i/9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes.
• Experience in building a very large data warehouse with many complex transformations, with many sources and targets.
• Able to work in multi-functional projects with strong logical and reasoning skills and innovative problem-solving skills, proven ability to adapt new tools, languages and operating tools.
• Highly motivated team player with the ability to work independently and adapt quickly to new and emerging technologies.

TECHNICAL SKILLS

ETL Tools: Informatica, Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1.1 /7.1.3, MDM, IDE - Informatica Data Explorer, IDQ - Informatica Data Quality

Databases and related tools: Oracle 11g/10g/9i/8i/8.x/7.x,MS SQL Server 2000/2005/2008 R2, TOAD 8/7.5/6.2, PL/SQL Developer 6.0, SQL Loader, SQL Server Management Studio, IBM DB2 and Teradata.

Packages: MS Office (MS Access, MS Excel, MS Outlook, MS Power point, MS Work), MS Project Plan.

Programming: SQL, PL/SQL, Confidential SQL Plus, Working knowledge of Unix Shell Scripting, C, C++, HTML, Java Programming.

Operating System: Microsoft XP/NT/2000/98/95, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior Informatica Developer

Responsibilities:

• Integrated MWV’s legacy source systems to Enterprise Data Warehouse.
• Source system landscape was integrated using Informatica Power Center.
• Involved in all SDLC phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.
• Participated in gathering business requirements for the Data Warehouse Source Systems.
• Analyzed ETL processes, prepared level of estimates, assigned tasks, provided system test support and involved in code migration activities.
• Supported global data convergence strategy through ETL (Using Informatica Power Center releases 8.6.1/9.1.0 ) process development and minimized failure points within current processes.
• Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching of MDM data.
• Efficiently worked on MDM data modelling, data mappings and data integration.
• Maintained & managed multiple Production, Development and Quality database instances of the Data Warehouse.
• Upgrade ETL database instances, which contain more than 2.25 Terabytes volume of data.
• Used IDQ Rules in the mappings and mapplets wherever necessary.
• Extensively interacting in IDQ to match supplier records and their address validations.
• Worked on Informatica Data quality (IDQ) in matching customer records.
• Involved in the development of Informatica mappings and used Informatica partitioning parallel processing capabilities
• Session-Partitioning and Target Table partitioning utilities for performance tuning thereby reducing the load time.
• Involved in on call support to resolve production issues during implementations and attended various team review meetings.

Environment: Informatica Power Center 8.6.1/9.1.0, MDM, IDQ, Linux, Oracle 11g, Windows XP, SQL Server, MS Project and MS Visio

Confidential, Manhattan, NY

Senior Informatica Developer

Responsibilities:

• Used Informatica 9.1/8.6 to extract, transform and load data from multiple input sources like Oracle/ SQL Server, Flat files into Oracle 11g/10g database.
• Worked on Source Analyzer, Warehouse Designer, Mapping, Mapplet Designer and Transformations, Repository Manager, Workflow Manager and Workflow Monitor.
• Used most of the transformations such as the Source Qualifiers, aggregator, Lookup, Routers, Union, Sequence, Generators, Expression, etc. as per the business requirements.
• Used Workflow Manager for creating and maintaining the Sessions. Also used
• Workflow Monitor to Monitor Edit, Schedule, Copy, Aborts and Delete sessions.
• Peer-reviews for the code changes and highly involved in regression testing the changes fixes implemented.
• Worked extensively in implementing SCD’s (Type 1 and Type 2).
• Worked extensively in Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Improved the data quality by eliminating the redundant data by using Informatica data quality (IDQ).
• Performed data profiling of the source data to define the data cleansing rules to be applied using IDQ and IDA profiling options
• Used MDM to integrate with modern service oriented architecture in order to manage master data across many systems which are responsible for data entry.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director, IDD
• Involved in creating /testing stored procedures and also fixing and debugging invalid mappings.
• Involved in integration of various data sources with Multiple Relational Databases like Oracle, Teradata
• SQL Server, MS Access, DB2, and XML System. Used Teradata Utilities like Fast Load, Multi Load, And Fast Export.
• Involved in the development of Informatica mappings and used Informatica partitioning (parallel processing capabilities
• Session-Partitioning and Target Table partitioning utilities) for performance tuning thereby reducing the load time.

Environment: Informatica Power Center 9.1/8.6,MDM,IDQ 9.X, Oracle 11g/10g, TOAD

Confidential, Monterey Park, CA

Informatica ETL Developer

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process
• Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved problems.
• Identified Data Elements & Attributes both from the system requirements and reporting stand point along with the Hierarchy, Relationship between the different Dimensions & Facts.
• Analyzed the different source system interfaces data from flat files & Relational DB in scope for the project based on which wrote the Integration & technical Source-Target Data Mapping rules to be loaded to the Data Warehouse.
• Designed the process dependencies between all the processes and Implemented functionalities like SCD’s, Incremental Aggregations.
• Involved in Production support of the whole application & created Deployment guide, Run book, Production guide.
• Worked with different source systems- Oracle, XML files, flat files.
• As a part of the Production support team, worked on fixing the issues and the failure of the ETL processes considering the minimal time constarint for quick approach of rectification.
• Attended production implementation calls and co-ordinated with the build engineers during migration of the code and was highly acknowledged.
• Communication with the client for weekly status report.

Environment: Informatica Power Center 8.6, SQL Server, Oracle10g, Toad, UNIX Shell Scripting, Mercury Quality Center and Flat Files

Confidential, Birmingham, AL

Informatica ETL Developer

Responsibilities:

• Translated Bank ware Functional Specification logic into Informatica mappings
• Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Created User Defined Functions in Informatica 8.x to reduce code redundancy.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• Worked on developing mappings and mapplets to extract and load the data from Oracle, Flat files, XML files and COBOL files.
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Assisted the other ETL Developers in resolving complex scenarios.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Involved in promoting the folders from Development to Test and Test to Production Environment.
• Involved in different Team review meetings.

Environment: Informatica Power Center 8.6, Oracle l0g, Toad, PL/SQL, SQL*Plus, SQL*Loader, XML, COBOL, DB2, Sun Solaris Unix, Unix Shell Scripting

Confidential, Plano, TX

ETL Developer

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Effectively applied all the business requirements and transforming the business rules into ETL mappings.
• Translated the requirements into technical specifications and prepared ETL design documents.
• Used Informatica Power Center and Power Exchange to extract, transform and load data from various source systems Mainframe systems to staging and target Data warehouse.
• Involved in the Updating of database objects in the data model.
• Used Informatica designer to create complex mappings using different transformations to move source data to a Data Warehouse.
• Used aggregator, router, joiner, stored procedures, look up, filter, source qualifier and update strategy transformations extensively.
• Developed Mappings and Workflows for ETL Jobs, developed reusable scripts, transformations and Mapplets to use in multiple mappings.
• Created mapping parameters, variables in Informatica to handle the loading date’s logic to capture changed data from the source and modified the DAC execution plan
• Development of an automated process for loading the data into the base tables in EDW (for ETL) using TPump, Teradata Parallel Transporter (TPT), Fast load, Multiload, Fast Export, BTEQ utilities of Teradata.
• Developed mappings to load data to partitioned tables and tuned for performance.
• Used the Normalizer transformation to extract source data from COBOL Source files.
• Written scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
• Handled CR’s (Change Requests) and enhancements for existing application.
• Developed UNIX shell scripts to run batch jobs in production.
• Extensively involved in Database testing by writing SQL queries and executing test cases to check the accuracy & integrity of database field values as part of Testing.
• Performed production deployment support and validated post-production environment.
• Involved in code reviews of peers as and when required.

Environment: Informatica Power Center 8.1, Oracle 10g, PL/SQL, UNIX shell scripts, SQL server, TOAD, windows XP, Linux and Teradata

Confidential

Oracle Developer

Responsibilities:

• The software developed for this is based on Client/Server Architecture.
• Analyzing system specification and business requirements.
• Designing and developing the detailed test plan.
• Developed forms to automate the business and generated reports to analyze the business and take intelligent decisions.
• Inserted Buttons, text boxes, combo boxes and various Visual Basic objects to have user-friendly interfaces.
• Developed oracle PL/SQL stored procedures for calculations.
• Involved in connecting the user interfaces to the database to store and retrieve the data.

Environment: Oracle 9i, SQL, PL/SQL, Visual Basic, ODBC, Adobe Photoshop and Microsoft Excel