SUMMARY

• Over 6+ years of extensive experience in Data Warehousing and Business Intelligence with emphasis on requirement analysis, design, development, testing, deployment and release management.
• Strong experience in Data movement solutions, worked extensively in development and migration projects using various versions of Informatica.
• Experience in Extraction, Transformation and Loading (ETL) processes for data Integration, data mapping and data conversion from various sources like Oracle, Teradata, SQL Server and Flat files using Informatica Power Center.
• Responsible for the development, implementation and support of ETL processes for large scale data warehouses.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 5.x/6.x/7.x/8.x/9.x.
• Experience in testing the Business Intelligence applications developed in Qlikview.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Experience in database programming inPL/SQL(Stored Procedures, Triggers and Packages).
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, implementation of STAR, Snowflake schemas and slowly changing dimensions.
• Worked with SCD (Slowly Changing Dimensions) Type 1, 2 and 3.
• Experience in implementing business rules by creating optimized and efficient mappings.
• Experience in identifying and eliminating bottlenecks to increase performance of mappings and sessions.
• Hands on experience with SQL / PL SQL and UNIX shell scripting.
• Providing 24/7 data warehouse production support in time pressured business environments.
• Enormous experience in Onsite - Offshore Model.
• Worked with Waterfall & Agile SDLC methodologies.
• Excellent communication, documentation and presentation skills using Microsoft Word, Excel, PowerPoint and Visio.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center (PWC) 9.5.1/8.x/7.xInformatica Multidomain MDM 9.5.0 Power Exchange (PWX), Data Explorer (IDE), Data Quality (IDQ), SSIS, DataStage, Pentaho, Talend, BigData, Apache Hadoop, HDFS, MapReduce.

Databases: Oracle 11g/10g/9i/8i, Teradata, SQL Server, DB2, MS Access.

Schedulers: Tivoli Work Scheduler (TWS), AutoSys, Crontab.

Tools: MS Office (Word, Excel, Access, Visio, PowerPoint), ERWin, PVCS, SCM.

Languages: SQL, PL/SQL, C, C++, Java, XML, UNIX Shell Scripting

Platforms: Windows, UNIX, Mainframes.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. ETL Consultant

Responsibilities:

• Analyzed and thoroughly studied various data sources and different development environments within the organization.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, PreProd and Prod Environments.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the Oracle databases.
• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Used various Informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the target systems using Informatica power center.
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between Client and different vendors.
• Developed UNIX shell scripting, created command task, and email task for providing the pre-session post-session requirements for various informatica jobs.
• Provide database coding to support business applications using T-SQL
• Worked on automation of informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Worked with different teams as Release Management, DBA, and UNIX team for smooth code promotions.

Environment: Informatica Power Center 9.5.1./ 8.x,Informatica Multidomain MDM 9.5.0, Informatica Power Exchange, SQL, Shell Scripting, Tivoli Work Scheduler (TWS).

Confidential, Detroit, MI

Senior ETL Consultant

Responsibilities:

• Responsible for gathering business requirements and analyzing & developing detailed technical specifications for EDW (Enterprise Data Warehouse).
• ETL Design/Development through Informatica Power Center 9.5.1 version.
• Loaded data into ODS (SCD Type1) and EDW (SCD Type2) making use of various transformation objects in Informatica.
• Involved in creation of Informatica mappings, sessions and workflows using mapping documents.
• Created Mappings / Sessions / Workflows in Informatica Power Center Designer, as per the BRD and STM specifications.
• Imported Mainframe COBOL copybooks as Sources using Informatica Power Exchange.
• Prepared test plans, test scripts, carrying out unit testing, integration testing and system testing without any issues.
• Coordinated and communicated for all approvals with business for smoother PRD implementation.
• Scheduled jobs making use of Tivoli Work Scheduler (TWS).
• Taken care of all EDW component deployments till Production, implemented successfully with in a prior time frame.
• Involved proactively in E2E testing with customer completely from onsite counterpart.
• Monitoring and resolved the bottlenecks in EDW for smoother process.
• Provide 24/7 on-call support whenever necessary.

Environment: Informatica Power Center 9.5.1./ 8.x, Informatica Power Exchange, Sun Solaris, Oracle 11g, Shell Scripting, Tivoli Work Scheduler (TWS), Talend, BigData, Hadoop, HDFS, MapReduce.

Confidential, Indianapolis, IN

Informatica MDM

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from Oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central Oracle database.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
• Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Created Unit Test Case document.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 8.6.1/8.x, Sun Solaris, Oracle 10g, Scripting (Shell), Remedy.

Confidential, Indianapolis, IN

Informatica MDM

Responsibilities:

• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Analyzed the key functionalities of the institute and performed Data Analysis and abstracted the transactional nature of data.
• Profiled the data using Informatica Analyst tool to analyze source data (Departments, party and address) coming from Legacy systems and performed Data Quality Audit.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data.
• Planned, created and executed SSIS packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Successfully managed in setting up the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included in implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Interaction with the Onsite team on a daily basis on the development activities

Environment: Informatica Power Center 8.x, Sun Solaris, Oracle 10g, Scripting (Shell), Remedy.

Confidential, Omaha, NE

Informatica Developer

Responsibilities:

• Understanding the requirement and in-depth analysis of specifications required by ERASE.
• Requirement gathering from Source and developing of Business and Conversion Logics for the data.
• Creation of Mappings using Transformations like Expression, Filter, Look-Up, Joiner, sequence generator, Router and Update Strategy and sessions & workflows.
• Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.
• Stored reformatted data from relational to flat file using Informatica (ETL).
• Monitoring of the Workflows and resolving the bottlenecks in the process.
• Created post-session and pre-session shell scripts and mail-notifications
• Performance tuning by optimizing the sources targets mappings and sessions.
• Tested mappings and sessions using various test cases in the test plans

Environment: Informatica Power Center 8.x, Sun Solaris, Oracle9i, Control-M, Windows 2003 Server.