SUMMARY

• Senior Informatica MDM Developer wif 8+years of IT experience and has portrayed skills in analysis, designing custom solutions, implementationand development of Data warehouses using Informatica and trouble - shooting and testing using ETL testing tools.
• Experience in integrating external application wif Informatica MDM hub using message queries as a significant advantage.
• Experience working on Informatica MDM in design, develop, test and review & optimize Informatica MDM (Siperian) and IDD Applications.
• Strong proficiency in maintaining data warehousing applications using Informatica Power Centre.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Expertise on DataWarehousing Concepts like Dimension Tables, Fact tables, slowly changing dimensions, Datamarts and dimensional modeling schemas.
• Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation etc.
• Extensively worked wif data warehousing, ETL methodologies, technologies, using Informatica Power Center.
• Excellent hands-on Data Exchange, MDM, IDQ, Data Transformation, SQL development.
• Good knowledge in Data warehousing concepts involving dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies.
• Involved in OLAP data modeling for star and snowflake schemas.
• Experience in writing Indexes, PL/SQL procedures, Functions, Packages, Database Triggers.
• Experience in error handling, performance tuning and problem fixing in Informatica MDM.
• Experience on ETL testing tools and worked on QTP and QC.
• Expertise in writing teh data clean up scripts using SQL queries and UNIX scripts.
• Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon's (SCD's), Change Data Capture (CDC), Customer Data Integration (CDI).
• Developed several test plans to find bugs and report errors.
• Experience in teh SIF framework and Application Program Interface (API) development.
• Experience in resolving Defects, resolving requirement and observed design consistencies.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by layering Business Requirements and developing Test Scenarios to support quality deliverables.
• Competent to deliver results on multiple tasks by promptly managing time and priority constraints. Ability to address any ongoing or changing Business needs.
• Strong potential in managing multiple projects wifout effecting quality and delivering on discussed timelines.
• Experience wif On-Site/Off-Shore Model of project delivery.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 8.6, 9.1, 9.5, 9.7, Informatica MDM, IDD, IDQ, SIF

Reporting Tools: Tableau

Scripting Languages: UNIX Shell scripting, VBA Scripting

Databases: Oracle 8i/9i/10g/11g, Teradata, SQL server

Database Tools: TOAD

Loaders: SQL loader, Fastload, TPT, Multiload

Methodologies: Star schema, Snowflake schema

Testing tools: QTP, HP Quality center

Scheduling tools: Autosys, Tidal

Operating systems: UNIX, Windows

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Senior Informatica MDM Developer

Confidential, Atlanta, GA

Responsibilities:

• Interacted in business meetings to analyze teh business requirements and developed a design plan.
• Coordinated wif business analysts to analyze teh business requirements and designed and reviewed teh implementation plan.
• Worked in an Agile Software Development life cycle to successfully accommodate change in requirements.
• Normalized data schema across four different source systems and successfully delivered projects wifin budget.
• Configured source systems collaboratively and performed Batch group wif Stage and Load jobs.
• Implemented Land Process for loading teh customer Data Set into InformaticaMDM from various source systems.
• Design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
• Configured custom landing tables and performed proof of concept integrating hub state indicator as required by teh business requirements.
• Worked in a proactive manner wif testers to identify and close defects before UAT.
• Peformed rule based Profiling on teh client business data in understanding teh depth of accuracy and duplicates which are needed for MDM implementation.
• Created draft technical design documents based on teh functional design documents.
• Resolve functional as well as technical queries by taking help of functional SME or client users.
• Interacted wif business users in configuring Match setup and tool proposition for Data quality Address doctor.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• Reviewed and designed teh MDM/ActiveVOS setup and performed development and Unit testing and deployment.
• Performed and implemented proof ofconcepts when needed to client for solution propositions.
• Worked through all teh phases of SDLC including maintenance.
• Worked on teh CA hub Master Data management to align four different source systems performing fine tuning to teh match/merge rules.
• Initiated API calls using SOAP UI/tools to perform cleansing for Base Objects, HREF, HXREF.
• Integrated wif teh ETL team and developed a new approach for Initial Data loads.
• Implemented Stage Jobs, Load Jobs, Match and Merge Jobs using teh Batch Viewer and Automation Processes.
• Altered Trust scores and set up Validation rules as per teh business requirements.
• Created Batch deployment groupsand ran audit trail for Incremental loads.

Environment: Informatica MDM, IDD, 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.

Senior Informatica MDM Developer

Confidential, Columbus, OH

Responsibilities:

• Teamed wif business analysts to deduce teh business requirements to produce effective 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 InformaticaMDM 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 theentity 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 that reduced teh cost and time of implementation and development.
• Worked on data cleansing using teh cleanse functions in Informatica MDM.
• Used Informatica 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 Autosysscheduling tools depending on client’spreference 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 wifuser-defined functions to use across multiple mappings.
• Executed jobs using ETL frameworkby setting up scripts and configuration files.
• Created deployment groups forproduction migration (mappings, workflows, parameter files and UNIX scripts) and supportedpostproduction 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.
• Responsible for handling Supply Chain Management Data Warehouse and related database and online solutions.
• 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, SIF, Informatica 9.6.0 & 9.5.1, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Erwin, Flat files, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.

Senior Informatica MDM Developer

Confidential, Houston, TX

Responsibilities:

• Gatheird and analyzed business requirements, established functional specifications and converted them to design specifications.
• Collaborated wif Manager, Data Architects and Data Modelers to understand teh business process and functional requirements.
• Closely worked wif Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Collaborated wif teh data modelers using teh Erwin tool for data modeling and performing mappings based on teh models.
• Defined teh Super-Sub entities using teh Erwin tool to organize teh Master detail.
• Converted Data from different legacy systemswif respect to teh organization’s business rules into teh Oracle Application system.
• Associated wif SME’s to convert teh legacy data for assigned modules.
• Worked toconvert Item Costs, Price Lists, Quantity On-Hand and Sourcing rules and Assignment sets from various systems into teh Oracle EBS interface tables.
• Designed and developed validation scripts based on business rules to check teh Quality of data loaded into EBS.
• Worked in implementation of Profiling, Score Card, Classifier models, Probabilistic models, Human task and Exception record management as part of IDQ process.
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• Used Informatica Designer to createand manipulate source and target definitions, mappings, transformations and re-usable transformations.
• Designed and developed scripts to validate and check teh quality of data loaded into EBS.
• Proven experience in improving teh data quality by Match analysis, analysis of teh MDM system performance and tuning teh performance by changing teh existing cleanse function, match rules etc.
• Determined cleansing requirements to improve Data quality analysis and identified data quality issues.
• Worked on data standardization using teh cleanse functions in Informatica MDM.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• Experienced in customizing error messages displayed on teh IDD screen.
• Experienced in creating and implementing enhanced IDD applications.
• Involved in Test Data Management wif teh testing team to build and run teh test plans to improve data efficiency.
• Supported production ETL batch jobs.
• Managed teh Metadata associated wif teh ETL processes used to populate teh data warehouse.
• Tested teh data and data integrity among various sources and targets. Associated wif Production support team in various performances related issues.
• Worked wif business users and gather data cleansing, data reconciliation and data convergence requirements
• Performed Unit testing Cycles and fix defects.
• Implemented cache optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Performed IDDPerformance tuning to ensure optimal session performance.
• Validated mappings using Informatica debugger to gain troubleshooting information about data and error issues.
• Designed, Developed, Reengineered and fine-tuned SQL queries and Oracle Stored Procedures and triggers.
• Designed and developed Informatica mappings for data loads.

Environment: Informatica MDM 9.5.1, SIF, Informatica Power Center 9.0.1 (Repository Manager, Repository Server Administration Console, Power Center Designer, Workflow Manager, Workflow Monitor), Erwin, Power Analyzer 4.1, Oracle 10g, PL/SQL, Autosys, Windows 2000, DB2, Windows NT 4.0.

Informatica Developer

Confidential, West Des Moines, IA

Responsibilities:

• Gathering business and Technical requirements that would best suit teh needs of teh technical architectural development process.
• Worked wifInformaticaData Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities.
• Designed teh Data Acquisition, Transformation, and Data Cleansing approach for teh MDM implementation.
• Handled Production Support by performing normal loads, initial loads, daily loads and monthly loads.
• Worked wif Session logs and Workflow logs for Error handling and troubleshooting during teh job failures.
• Created batch groups for automation.
• Create high and low level ETL design to meet user requirements.
• Create other ETL artifacts such as functional requirement document, data model, source-to-Client mapping, test case matrix, deployment document etc.
• Independently develop efficient Informatica mappings, sessions and workflows as per teh design specifications.
• Design ETL data model and conduct Knowledge Transfer sessions to share knowledge wif teh team.
• Worked on InformaticaData Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
• Involved in implementing change requests and enhancement in performance for teh existing mappings.
• Experienced hands on working knowledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Configured web services sung SIF framework.
• Created High level - low level designdocuments, ETL specification documents, Data modeland test cases documents.
• Worked effectively on handling production defects and change requests.
• Analyzed source data for potential data quality issues and created teh exception mappings/clean up scripts to clean up teh bad data in data warehouse.
• Created Deployment groups for Informatica components for transferring teh code from lower to higher region.
• Involved in maintenance of reporting tools and processes utilizing Data Warehouse data.
• Created Rules on profiled data and used teh same to data quality mappings.
• Implemented Waterfall methodology.
• Created shell scripting for running Informatica workflows and wrote SQL queries to retrieve data depending on requirements.
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval
• Created pre-session and post-session shell scripts and mail-notifications
• Performed error handling for removing database exceptional errors
• Used Debugger utility of teh Designer tool to check teh errors in teh mapping and made appropriate changes in teh mappings to generate teh required results
• Converted reports based on user inputs to perform calculations in Excel macros.
• Held meetings wif business users to confirm business requirem