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 with Sif API to interact with 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 that 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 with the 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 the data into the 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 the ETL.
• Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the 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

Senior Informatica MDM Developer

Confidential, Raleigh, NC

Responsibilities:

• Worked with 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 the tasks such as cleansing the data and populate that into staging tables.
• 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.
• Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Helped the 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 the Trust and Validation rules and setting up the match/merge rule sets to get the 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 the 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 with user interface on IDD application.
• 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.
• 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 with business analysts to deduce the business requirements to produce effective technology solutions.
• Worked with 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 the software requirements in a structured way.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
• Collaborated with the data modelers to perform mappings and organize the data using the Erwin tool for data modeling.
• Worked on data cleansing using the cleanse functions in Informatica MDM.
• Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to the data mart.
• Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server
• Extracted data from Sales department to flat files and load the data to the 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 the data according the 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 the data into the base tables
• Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
• Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them using the 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 the 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 with 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 the parmfiles, sending mails and FTP files.
• Used scheduling tools to create new jobs and job dependencies are setup with different Autosys cycles.
• Experienced in writing SQL queries for retrieving information from the database based on the requirement.
• Experienced in partition creations and dimension additions.
• Involved in the UAT testing of the Items Data Mart price files tool automation project.
• Performed testing on connections, scripts, workflows, mappings and other scheduled activities.
• Worked with the offshore team and supervised on their development activity.
• Reviewed code and confirmed it was compatible to standard programming practice.
• Conducted Knowledge transfer sessions about the project to the team and managed the 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 the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• 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.
• 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.
• Deployed new MDM Hub for portals in conjunction with 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.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
• Developed various Ad-hoc mappings for various business needs.
• Facilitate/lead design reviews of functional design with other members of the 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, TX

Responsibilities:

• Defined the Landing tables, Base objects, staging tables, foreign key relationships, lookup definitions, queries, packages and query groups.
• Developed and managed relationships between data domains for the data models.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Analyzed the business data and defined the Match and Merge rules and Trust Scores for MDM Hub.
• Used Informatica components extensively Repository, Designer, Workflow Manager & Workflow Monitor .
• Created workflows and used various tasks like Email, Event-wait and raise, decision in workflow manager.
• Involved in interaction with DBA team for creation of primary and secondary indexes on data warehouse tables.
• Used debugger to test the 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 the data warehouse.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Worked with Enterprise Architects to do dimensional modeling for the data warehouse.
• Developed Fact and Dimension tables implementing Star Schema in the 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 with Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• 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 the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the 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 with 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 with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with 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.