SUMMARY

• 7+ years of experience in Informatica MDM, Informatica Powercenter, IDQ, Oracle as an Informatica, Informatica MDM and Etl Developer.
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules,
• Merge properties and Batch Group creation.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
• Worked wif Sif API to interact wif real time applications.
• Solid expertise in Data Extraction, Data Migration, Data Transformation and Data Loading using ETL process in Informatica Power Center 9.x/8.x/7.x.
• Experience in designing Reusable Transformations in Informatica such as Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Worked on Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Experience in designing and developing Informatica mappings for data loads dat include Source Qualifier, Aggregator, Unconnected Lookup, Connected Lookup, Filter, Router, Update Strategy etc.
• Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g, SQL Server 2012/2008/2000, Teradata 14/13/12 and DB2 databases. Proficient in writing Packages, Stored Procedures, Triggers, Views, Indexes and query optimization.
• Experience in integration of various data sources like Oracle, SQL server and MS access, flat files, and XML files.
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions wif teh help of error logs generated by Informatica server.
• Experience in Agile, Waterfall and UML Methodologies.
• Good Exposure to development, testing, debugging, implementation, documentation and production support.
• Extensive experience in implementation of Data Cleanup procedures, Transformations, Scripts and Execution of Test Plans for loading teh data into teh targets.
• Experience in UNIX shell and batch scripting, Perl, FTP, SFTP and file management in various UNIX/Windows environments.
• Performed unit testing at various levels of teh ETL.
• Experience in production support to resolve critical issues and mingle wif teams to ensure successful resolution of teh reported incident.

TECHNICAL SKILLS

Databases: Oracle 9i/10g, 11g/12c SQL Server 2014, 2012, 2008, 2005

Languages: SQL, PL/SQL, Java, UML 2.0, Unix

ETL Tool: Informatica Power Center 10.x/9.x/8.x (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

MDM Packages: Informatica MDM Multi Domain Edition 10.0, 9.7.1, 9.5, 9.1. Informatica Data Director (IDD) 10.0, 9.7, 9.5. Informatica Data Quality(IDQ) 10.0, 9.6, DDM 9.6

RDBMS: Oracle 12c/11g/10g/ 9i (SQL/PLSQL)

Tools and Utilities: TOAD 10.1, Text pad, Word Pad, SQL Developer 4.0.3

Modeling Tools: Erwin 4.0 data modeler, ER studio 7.5, MS Visio 2007

Environment: Windows 7/XP/2000, Unix, Windows Server 2003, 2008/Linux

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio, Java Eclipse

PROFESSIONAL EXPERIENCE:

Sr. Informatica MDM Developer

Confidential, Raleigh, NC

Responsibilities:

• Worked wif ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform teh tasks such as cleansing teh data and populate dat into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved wif Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Identified Golden Record (BVT) for Customer Data by analyzing teh data and duplicate records coming from different source systems.
• Helped teh testing team for data integrity and consistency.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined teh Trust and Validation rules and setting up teh match/merge rule sets to get teh right master records
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used teh entity types as subject areas in IDD.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.
• Deployed new MDM Hub for portals in conjunction wif user interface on IDD application.
• Defined teh Trust and Validation rules and setting up teh match/merge rule sets to get teh right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Created mappings using Informatica Power center and loading data into pre-landing tables.
• Created Unit Test Case Document, Detailed Design Document, Supplementary Document and Knowledge Transfer Document.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Finally, Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica MDM, Informatica Power Center 9.6, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor 5, IDD, Informatica Data Quality IDQ 9.5.1, Windows server, Unix.

Sr. Informatica MDM Developer

Confidential, Morrisville, NC

Responsibilities:

• Teamed wif business analysts to deduce teh business requirements to produce TEMPeffective technology solutions.
• Worked wif Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Conducting requirement gathering sessions, feasibility studies and organizing teh software requirements in a structured way.
• Involved in implementing teh Land Process of loading teh customer Data Set into Informatica MDM from various source systems.
• Collaborated wif teh data modelers to perform mappings and organize teh data using teh Erwin tool for data modeling.
• Experienced in creating and maintaining teh entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).
• Participated in teh development and implementation of teh MDM decommissioning project using InformaticaPowerCenter dat reduced teh cost and time of implementation and development.
• Worked on data cleansing using teh cleanse functions in Informatica MDM.
• Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to teh data mart.
• Worked wif different sources like Oracle, flat files, XML files, DB2, MS SQL Server
• Extracted data from Sales department to flat files and load teh data to teh target database
• Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.
• Extracted data from sources like fixed width and Delimited Flat files transformed teh data according teh business requirement and then loaded into Target Data mart.
• Data Quality and Data integration in real-time using SIF API's.
• Defined Trust and validation rules before loading teh data into teh base tables
• Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
• Running teh Stage Jobs, Load Jobs, Match and Merge Jobs using teh Batch Viewer and Automation Processes.
• Performed in creating tasks in teh workflow manager and exported IDQ mappings and executed them using teh scheduling tools.
• 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.
• Worked on Tidal and Autosys scheduling tools depending on client’s preference to schedule tasks
• Involved in preparing required Tech Specification Documents from teh Business requirements following Organization standard.
• Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects.
• Constructed reusable objects like Mapplets and worklet transformations combined wif user-defined functions to use across multiple mappings.
• Executed jobs using ETL framework by setting up scripts and configuration files.
• Created deployment groups for production migration (mappings, workflows, parameter files and UNIX scripts) and supported post production support during warranty.
• Practiced soft proofing on JDF enabled products to communicate between each other by exchanging JDF files through hot folders.
• Worked on UNIX platform in creating a shell script to perform functions for updating teh parmfiles, sending mails and FTP files.
• Used scheduling tools to create new jobs and job dependencies are setup wif different Autosys cycles.
• Experienced in writing SQL queries for retrieving information from teh database based on teh requirement.
• Experienced in partition creations and dimension additions.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching teh data for crops, materials and breeders in IDD data tab.
• Involved in teh UAT testing of teh Items Data Mart price files tool automation project.
• Performed testing on connections, scripts, workflows, mappings and other scheduled activities.
• Worked wif teh offshore team and supervised on their development activity.
• Reviewed code and confirmed it was compatible to standard programming practice.
• Conducted Knowledge transfer sessions about teh project to teh team and managed teh project by providing reviews on it.

Environment: Informatica MDM, IDD, IDQ 9.7, Informatica 9.7, 9.6.0 & 9.5.1, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.

Informatica MDM Developer

Confidential, Richardson, TX

Responsibilities:

• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
• Good exposure in Informatica MDM where data Cleansing, De-duping and Address correction were performed.
• Involved in Informatica MDM hub configuration, IDQ cleanse function implementation, Hierarchy Configuration in MDM hub.
• Defined teh Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Defined teh Trust and Validation rules and setting up teh match/merge rule sets to get teh 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 teh project plan wif other team members.
• Performed match/merge and ran match rules to check teh TEMPeffectiveness of MDM process on data.
• Configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Created Sessions/Batches in Informatica server manager to execute mappings.
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used teh entity types as subject areas in IDD.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching teh data.
• Deployed new MDM Hub for portals in conjunction wif user interface on IDD application
• Deliver new systems functionality supporting corporate business objectives.
• Translate requirements and high-level design into detailed functional design specifications.
• Wrote stored procedures, functions, and database triggers in SQL Server 2008.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Supported teh BI team by extracting operational data from multiple sources, merging and transforming teh data to facilitate enterprise-wide reporting and analysis and delivering teh transformed data to coordinated data marts.
• Coordinated wif Business Users to understand business needs and implement teh same into a functional Data warehouse design.
• Implemented teh concept of slowly changing dimensions to maintain current and historical data in teh dimension. Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Facilitate/lead design reviews of functional design wif other members of teh technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications.

Environment: Informatica Power center 9.0/8.6, Informatica MDM, oracle 11g/10g, Unix, Unix Shell Script, Dollar Universe, OBIEE 10.1, TOAD, Teradata, SQL Assistant.

Informatica/MDM Developer

Confidential Planning, TX

Responsibilities:

• Involved in landing teh data from Seven Different source systems by running external batch process to load business data for creating customer master data. External batch process used was ETL process.
• Defined teh Landing tables, Base objects, staging tables, foreign key relationships, lookup definitions, queries, packages and query groups.
• Analyzed teh source systems for erroneous, duplicative, and integrity issues related to teh data which is resided in various source systems such as ERP, LEGACY, CRM, DNB, SALES system, and defined those all source systems in systems and trust model workbench.
• Developed and managed relationships between data domains for teh data models.
• Created mappings to perform teh tasks such as cleansing teh data and populate dat into staging tables.
• Analyzed teh business data and defined teh Match and Merge rules and Trust Scores for MDM Hub.
• Involved in loading data from different sources to staging area by cleansing data to do dis we are using Trillium services and Duns Numbers from Duns and Bradstreet (DNB). After getting data as per business requirement from DNB and Trillium we are loading data to teh ware house
• Involved wif ETL developers, for developing complex mappings, mapplets, reusable transformations using Informatica 8.6 designer to integrate data from different sources like Oracle, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
• Used Informatica components extensively Repository, Designer, Workflow Manager & Workflow Monitor .
• For loading business logic successfully to database used different transformations like Router, Expression, Source Qualifier, Aggregator, Filter and Sequence Generator transformations extensively.
• Created workflows and used various tasks like Email, Event-wait and raise, decision in workflow manager.
• Involved in interaction wif DBA team for creation of primary and secondary indexes on data warehouse tables.
• Used debugger to test teh mappings and fixed bugs accordingly.
• Created Session and Batches using server manager to execute mappings.

Environment: Informatica Multi Domain MDM 9.5, Informatica Data Director 9.5, Informatica Power Center 9.5, Oracle 11gR2, IBM DB2, Windows Server 2008, Teradata, Toad 10.1, SQL*Loader, Erwin.

Informatica Developer

Confidential

Responsibilities:

• Translated business requirements into functional specifications. Designed and developed process flows for ETL to load data to teh data warehouse.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Worked wif Enterprise Architects to do dimensional modeling for teh data warehouse. Developed Fact and Dimension tables implementing Star Schema in teh data warehouse
• Extracted Erwin physical models into repository manager using Informatica Power Plug.
• Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracle 10g, SQL Server 2005, MS-Access and loaded data into Oracle using Informatica PowerCenter.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool.
• Worked wif Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup, Stored procedure, Sequence generator and Joiner transformations.
• Created sessions, database connections and batches. Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica Repository Manager to backup and migrate metadata in development, test and production systems.
• Developed custom business intelligence reports in Cognos Impromptu.

Environment: Informatica Power Center 8.6, Cognos Impromptu 6.0, Impromptu web reports (IWR 6.0), UNIX, IIS 4.0, PL/SQL, Oracle 10g, SQL Server 2005, T-SQL and Win NT.

ETL Developer

Confidential

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracted data from Oracle, Flat file, Excel files and performed complex joiner, Expression, Aggregate, and Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into teh target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Developed teh transformation logic, identifying and tracking teh slowly changing dimensions, heterogeneous sources and determining teh hierarchies in dimensions.
• Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in teh batch process.
• Developed complex Informatica Mappings, Mapplets and reusable Transformations for different types of tests in pharmaceutical research studies on daily and monthly basis.
• Worked wif Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Created pre-and post SQL scripts which need to be run at Informatica level.
• Worked extensively wif session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix teh defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked wif various Lookup caches like Static, Dynamic and Persistent.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Experience in Performance tuning using Push Down Optimization, Partitioning etc.

Environment: Informatica Power Center8.1.0, Oracle, SQL Server, Win XP, UNIX, UNIX Shell Script, TOAD.