SUMMARY

• 10+ years in the IT industry with substantial experience in providing information management consulting services on Informatica Power Center, Informatica Master Data Management, Data Integration and Business Intelligence Applications with Banking and Insurance & finance domain.
• Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Designing, Installing & Configuring core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling
• Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Business Data Director, Hierarchy Manager - Entity types, Relationship objects, Packages, customizing/configuring Informatica
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
• Designing & developing multiple cleansing and standardization scenarios using Address Doctor
• Implementing Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies
• With the software lifecycle phases including design, development and implementation.
• Informatica MDM processes including batch based and real-time processing.
• Performing Data standardization of addresses using Address Doctor, Trillium and Informatica Data Quality and Data integration in real-time using SIF API’s.
• Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectives in many project life cycles.
• Strong data analysis skills.
• Experience of working on Data Warehousing applications focusing on data warehouse analysis and design, data sourcing, mapping, conversion and loading, metadata queries for prod support.
• Experience in converting business requirements into technical specifications.
• Worked with facts and dimensions and designed dimensional model utilizing star/snow flaked schemas for use in BI reporting.
• Experience creating reusable transformations, complex mappings, partitioning and implementing CDC Logic.
• Worked with system owners to resolve source data issues and refine transformation rules.
• Write and maintains unit tests and support system/user acceptance tests.
• Experience in file validation, error handing, incremental load and dynamic parameter file.
• Proficient in applying business logic using PL/SQL packages, stored procedures, functions.
• Experience in writing UNIX shell scripts and automating Informatica Jobs/procedure via control-M.
• ETL, Data Warehouse, Talend, Informatica BI, Business Objects, SQL, and HTML
• Experience in SQL query performance optimization and troubleshooting.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Powercenter 9.x/8.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica Data Quality (IDQ), Talend RTX 4.1, Power Exchange 8.0, Repository.

Data Modeling: Physical Modeling, Logical Modeling, Dimensional Modeling (Star Schema, Snow-Flack, Fact, Dimensions), Relational Modeling, Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2000/2005/2008, DB2, OLTP

Programming: SQL, T-SQL, PL/SQL, SQL*Loader, UNIX, Shell Scripting, SQL Tuning/Optimization, C, Java, HTML, Perl.

Tools: TOAD, SQL*Plus, Excel, Word, Harvest, Autosys, SVN, Tivoli.

Reporting Tools: Crystal Reports

Environment: Windows XP/Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OHIO

ETL/ Informatica Developer

Responsibilities:

• Interact with data analysts to understand the requirements, identify gaps and to turn them into technical documents and mapping specifications.
• Create MDM base objects, Landing and Staging tables to follow the comprehensive data model in MDM.
• Developed Hierarchies using Hierarchy Manager in the Hub, like Patient to Provider, how patient related to Provider. Created Entity objects and types, Relationship objects and types, packages. Configured the profiles according to the requirements. Created different entity objects like employee, member, patient and provider. The result of these hierarchies can be viewed in IDD.
• Create MDM mappings using IHA best practices to capture the errors and have a clean load using Informatica.
• Performed data analysis and validation of the data received from upstream systems.
• Played a major role in Dev., Test and Prod deployment of Provider data in MDM Phase 1.
• Performed unit testing in all stages of MDM and ETL from where data releases.
• Defined Trust and validation rules before loading the data into the base tables
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
• Involved with ETL team in getting the data loaded into the landing tables.

Environment: Informatica MDM 9.5.1, Hierarchy Manager, Informatica Data Director, Informatica Power Center 9.1, Tidal, JBOSS, Oracle 11g, PL/SQL, TOAD, Address Doctor5, SQL Developer.

Confidential, Pittsburg, PA

ETL/ Informatica Developer

Responsibilities:

• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner and Stored procedure transformations.
• Create MDM base objects, Landing and Staging tables to follow the comprehensive data model in MDM.
• Developed Hierarchies using Hierarchy Manager in the Hub, like Patient to Provider, how patient related to Provider.
• Created Entity objects and types, Relationship objects and types, packages.
• Configured the profiles according to the requirements.
• Created different entity objects like employee, member, patient and provider.
• The result of these hierarchies can be viewed in IDD.
• Create MDM mappings using IHA best practices to capture the errors and have a clean load using Informatica.
• Performed data analysis and validation of the data received from upstream systems.
• Played a major role in Dev., Test and Prod deployment of Provider data in MDM Phase 1.
• Performed unit testing in all stages of MDM and ETL from where data releases.
• Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.
• Implemented SCD1, SCD2 type maps to capture new changes and to maintain the historic data.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
• Worked on extract and load type of mappings.
• Developed UNIX shell scripts to schedule Informatica sessions.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created documents that have the detail explanation of the mappings, test cases and the expected results and the actual results.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Used Debugger to troubleshoot the mappings.
• Performed unit testing, knowledge transfer and mentored other team members.
• Responsible for migration of the work from Dev environment to testing environment.
• Have Knowledge on Informatica MDM concepts and implementation of De-duplication process

Environment: Informatica Powercenter 9.5.1, Oracle, Windows 7, IDQ, SQL Developer 2005, UNIX, PL/SQL, Autosys, Business Objects, AIX, SVN.

Confidential, Mayfield, Ohio

ETL/ Informatica Developer

Responsibilities:

• Used ETL tools Informatica 9.1 to extract data from source systems, cleanse Transform, and Load data into XML and Flat files.
• Developed mappings using Power Center -Designer for data transformation as per the technical requirements.
• Designed mappings for different subject areas Patient demographics and order history.
• Extensively used Transformations like Router, Aggregator, Normalizer, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Used Update Strategy to insert and update for inserting and updating the audit tables.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Extensively worked on Informatica IDE/IDQ.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Created mapping using Oracle sources.
• Used Reusable Transformations for different validations.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Experience in setting up Active batches for running the workflows in batch processing
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• Designed workflows that are used to run a set of maps together one after the other, the results such as the execution time, start time; end time and status are stored in a run time repository, which can be accessed by other users.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used debugger to test the mapping and fixed the bugs.
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Generated the Profiles for analyzing the source data and discussed with the business for populating the target columns.
• Co-ordinate with Business teams for any data related issues and updated the QA team with the mapping document.

Environment: Informatica Powercenter 9.1, IDQ, Oracle 10g, PL/SQL, UNIX, Windows 7, Sql server, Active Batch.

Confidential, PA

ETL Informatica Developer

Responsibilities:

• Responsible for logical dimensional data model and use ETL skills to load the dimensional physical layer from various sources including DB2, SQL Server, Oracle, and Flat file etc.
• Successfully collaborated with business users to capture & define business requirements and contribute to defining the data warehouse architecture (data models, data analysis, data sourcing and data integrity)
• Analyzed source data for potential data quality issues and addressing these issues in ETL procedures.
• Developed technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Design, develop, test, maintain and organize complex Informatica mappings, sessions and workflows.
• Complete technical documentation to ensure system is fully documented.
• Design and develop ETL using CDC using Power Exchange 9.1 in Mainframe DB2 environment.
• Created registration and data map for mainframe source.
• Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy.
• Worked with SAP data Services for Data Quality and Data Integration.
• Created UNIX script for identifying CDC hanging workflows.
• Participate in Developing PL/SQL procedures, Korn Scripts to automate the process for daily and nightly Loads.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre-& Post Session SQL Script to meet business logic.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc…
• Worked with Mapping/Session/Worklet/Workflow variables and parameters, running Workflows in RHEL Unix shell script.
• Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc…
• Created Informatica Power Exchange Restart token and enables recovery for all real-time sessions.
• Worked on data warehouses with sizes from 2-3 Terabytes.
• Worked on Teradata utilities like FLOAD, MLOAD and TPUMP to load data to stage and DWH.
• Worked on Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.

Environment: Informatica Powercenter 9.1, Power Exchange 9.1, SQL Server 2008, Teradata 12 UNIX, Toad, Erwin 7, Linux, Harvest, Putty, DB2 Mainframe, FLOAD, MLOAD and TPUMP.

Confidential, Louisville, KY

ETL/Informatica developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed Type1 and Type2 mappings
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java, XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Converted MS SQL Server DTS Packages logic into Informatica mappings.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/Mapplet Parameters/Variables.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Scheduled Informatica workflows using Appworx to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Worked extensively with the Teradata SQL Assistant to interface with the Teradata.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica Powercenter 8.6, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, SQL, PL/SQL, T-SQL, SQL*Plus, TOAD, Appworx, Erwin, Windows XP, Unix, Teradata v2r5, Oracle Applications 11i, Sun Solaris

Confidential

ETL Developer

Responsibilities:

• Understand and Analyze of the Technical requirements
• Involved in implementation of Mapping using Informatica Designer.
• Extensively Used Source Qualifier, Update Strategy, Aggregator, Joiner, Expression, Normalizer, Lookup (connected & unconnected), Stored Procedure (connected & unconnected) Sequences are mostly used.
• Development of workflows and Session Tasks.
• Writing PL/SQL procedures for processing business logic in the data base, tuning sql queries for better performance.
• Generated reusable transformations, Mapplet and using them extensively in many mappings.
• Using type 2 slowly changing dimension tables to keep track of historical data.
• Maintain different versions of mapping through version controlling and apply labels to correct version and add them deployment group.
• Involved in Performance Tuning.
• Involved to prepare UTR and UTP of each mapping.
• Involved in code review and unit testing.
• Helping new team members in solving the issues

Environment: Informatica Power Center 9, PLSQL, TOAD