SUMMARY

• Senior Informatica MDM Developer with 8 years of IT experience and has portrayed skills in analysis, designing custom solutions, implementation and development of Data warehouses using Informatica and trouble - shooting and testing using ETL testing tools.
• Experience in integrating external application with 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 Data Warehousing 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 with 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 the 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 the 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 without effecting quality and delivering on discussed timelines.
• Experience with On-Site/Off-Shore Model of project delivery.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 8.6, 9.1, 9.5, 9.7,10.1.0, Informatica MDM 9.7,10, 10.2 IDD, IDQ, 9.7, 10.1.1 SIF, ActiveVos

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 MDM/IDQ Admin/Developer

Confidential, Trenton, NJ

Responsibilities:

• Analyzed the business requirements from the client and propose solutions and best practices related to Informatica based on the organizations RFP.
• Involved in State meetings to report status and deliverables achieved in the Informatica Domain.
• Worked as a Informatica Administrator and Developer.
• Worked on different tools in Informatica (Power Center, Data Quality, Master Data Management and Metadata Management.) obtained by the state to deliver the business requirements.
• Installed and configured Power Center, Data Quality, MDM and Metadata Manager on virtual servers and maintained them.
• Involved in cleansing, standardizing and geocoding the MEDICAID data from the state and publishing it to other downstream systems (MARS, FADS, SUR).
• Worked on creating SCD and CDC concepts to load, record and manipulate data to achieve HPAS History tables.
• Participated in meetings with the network team to discuss about security checks, SSL certificates on the VM servers where Informatica tool(s) were installed.
• Monitor data feeds from the source systems and perform data loads on a weekly/monthly basis.
• Profiled data using the Analyst tool and created Scorecards to provide reports.
• Created mapping documents using mapping specification in Informatica Analyst to avoid standard excel documentation.
• Installed and configured Power Center to create L1, L2 Historical data store (HPAS) mappings to develop a Business Data Warehouse. Worked in data transitions from SDW(Legacy) to BDW.
• Developed ETL to create an Enterprise Data Store as L3. Implemented SCD type 2.
• Installed and configured Informatica Data Quality to standardize, Cleanse and Geocode the address from different source systems and develop profiling reports.
• Installed and configured MDM to create a single repository for all the incoming DFD sources.
• Worked to consolidate data from different source systems and implemented a Third Normalized form to achieve BCI MASTER (Single Repository).
• Helped in viewing records and explained manual merge/unmerge process in IDD to data stewards.
• Installed and configured Metadata Manager to create lineage between Informatica, Cognos, Erwin and Oracle.
• Worked as an Administrator in creating users and setting profiles to users and assigning roles to those profiles.
• Upgraded Power Center and Data Quality from 10 to 10.1.1.
• Participate in daily meetings to discuss about the Data Modelling, ETL loads with respect to Healthcare domain.
• Worked on installing and configuring SVN versioning repositories for IDQ and Cognos.
• Monitor Informatica applications on a daily basis, check the performance of the tool and create profiles to users as an Administrator.

Environment: Informatica MDM 10.2, IDD, Informatica Data Quality 10.1.1, Power Center 10.1.1, Metadata Manager 10.1.1, SQL Developer, Putty, Visio, Windows task scheduler, Cygwin, SVN

Sr. MDM/ActiveVos Developer

Confidential, Houston, TX

Responsibilities:

• Associated with the business team to gain knowledge on the functional aspects.
• Conducted weekly sessions with the functional team to finalize the client requirements and the Datastewards team to understand the roles in their hierarchy.
• Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
• Implemented Land Process for loading the customer Data Set into Informatica MDM from various source systems.
• Designed and developed MDM data model and defining logical relationships between the objects.
• Configure IDD and Hierarchy Manager. Configured Trust scores.
• Reviewed and designed the MDM/ActiveVOS setup and performed development and deployment.
• Configured integration between the Activevos 9.2.4.1 and MDM 10.0.1 for creating the custom workflow process and designing the orchestration project.
• Designed Interfaces in connecting to External systems Salesforce/SAP using JMS messaging
• Performed a proof of concept in customizing the default MDM Task Workflow process.
• Developed BPEL files, deployed the .BPR files onto the ActiveVos server.
• Worked on the Activevos Console to monitor and report the processes, tasks and servers.
• Worked on Xpath, Xquery, and SOAPUi and WSDL files.
• Created workflows using Events, Gateways, Controlflows and generated forms by creating .avcconfig files.
• Generated .PDD files and exported them to the server and deployed the .BPR files into the server.
• Configured Human tasks in the workflow to assign roles to the Datastewards and configured Email/Messaging/Identity services
• Created forms in the Activevos designer and deployed them on the ActiveVos central to trigger workflows through form input.
• Involved in creating IDD tasks and assigning roles to the tasks in ActiveVos to trigger the workflows.
• Configured JMS on Activevos server to publish data to external applications/source systems.
• Installed ActiveVos sever on Windows with JBOSS.
• Configured and setup URN mappings on the Activevos Console.
• Implemented workflows based on Onestep, Twostep Approval processes and customized workflows to suffice business requirements.
• Collaborated with the offshore team and supervised on their build phase activity.

Environment: Informatica MDM 10.0.1, IDD, ActiveVos 9.2.4.1, Flat files, Java, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.

Senior Informatica MDM Developer

Confidential, Atlanta, GA

Responsibilities:

• Interacted in business meetings to analyze the business requirements and developed a design plan.
• Coordinated with business analysts to analyze the business requirements and designed and reviewed the implementation plan.
• Worked in an Agile Software Development life cycle to successfully accommodate change in requirements.
• Worked with ETL tool Informatica Power center for performing custom cleansing when the data is loaded to the landing tables in the MDM.
• Performed a proof of concept in ETL to categorize junk records before data is pushed to landing, mocking the same functionality of post landing user exits.
• Normalized data schema across four different source systems and successfully delivered projects within budget.
• Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
• Implemented Land Process for loading the customer Data Set into Informatica MDM 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 the business requirements.
• Worked in a proactive manner with testers to identify and close defects before UAT.
• Peformed rule based Profiling on the client business data in understanding the depth of accuracy and duplicates which are needed for MDM implementation.
• Created draft technical design documents based on the functional design documents.
• Resolve functional as well as technical queries by taking help of functional SME or client users.
• Interacted with 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 the MDM/ActiveVOS setup and performed development and Unit testing and deployment.
• Performed and implemented proof of concepts when needed to client for solution propositions.
• Worked through all the phases of SDLC including maintenance.
• Worked on the CA hub Master Data management to align four different source systems performing fine tuning to the match/merge rules.
• Initiated API calls using SOAP UI/tools to perform cleansing for Base Objects, HREF, HXREF.
• Integrated with the ETL team and developed a new approach for Initial Data loads.
• Implemented Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
• Altered Trust scores and set up Validation rules as per the business requirements.
• Created Batch deployment groups and ran audit trail for Incremental loads.

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.

Senior Informatica MDM Developer

Confidential, Columbus, OH

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.
• Experienced in creating and maintaining the 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 the development and implementation of the MDM decommissioning project using InformaticaPowerCenter that reduced the cost and time of implementation and development.
• 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.
• 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 the data for crops, materials and breeders in IDD data tab.
• 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.
• Responsible for handling Supply Chain Management Data Warehouse and related database and online solutions.
• 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, SIF, IDQ 9.7, 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:

• Gathered and analyzed business requirements, established functional specifications and converted them to design specifications.
• Collaborated with Manager, Data Architects and Data Modelers to understand the business process and functional requirements.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Collaborated with the data modelers using the Erwin tool for data modeling and performing mappings based on the models.
• Defined the Super-Sub entities using the Erwin tool to organize the Master detail.
• Converted Data from different legacy systemswith respect to the organization’s business rules into the Oracle Application system.
• Associated with SME’s to convert the legacy data for assigned modules.
• Worked toconvert Item Costs, Price Lists, Quantity On-Hand and Sourcing rules and Assignment sets from various systems into the Oracle EBS interface tables.
• Designed and developed validation scripts based on business rules to check the 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 create and manipulate source and target definitions, mappings, transformations and re-usable transformations.
• Designed and developed scripts to validate and check the quality of data loaded into EBS.
• Proven experience in improving the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
• Determined cleansing requirements to improve Data quality analysis and identified data quality issues.
• Worked on data standardization using the 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 the IDD screen.
• Experienced in creating and implementing enhanced IDD applications.
• Involved in Test Data Management with the testing team to build and run the test plans to improve data efficiency.
• Supported production ETL batch jobs.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Worked with 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 IDD Performance 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 the needs of the technical architectural development process.
• Worked withInformaticaData Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities.
• Designed the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
• Handled Production Support by performing normal loads, initial loads, daily loads and monthly loads.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting during the 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 the design specifications.
• Design ETL data model and conduct Knowledge Transfer sessions to share knowledge with the 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 the 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 design documents, ETL specification documents, Data model and test cases documents.
• Worked effectively on handling production defects and change requests.
• Analyzed source data for potential data quality issues and created the exception mappings/clean up scripts to clean up the bad data in data warehouse.
• Created Deployment groups for Informatica components for transferring the 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 the 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 the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Converted reports based on user inputs to perform calculations in Excel macros.
• Held meetings with business users to confirm business requirements.

Environment: Informatica Power Center 8.6 (Repository Manger, MDM, Designer, Workflow Monitor, Workflow Manager), Flat files, Oracle10g

Informatica Developer

Confidential, Providence, RI

Responsibilities:

• Involved in the design, development and implementation of ETL process using Informatica.
• Generated workflows using reusable tasks, worklets and workflows containing sessions, commands, event raise/wait, decision and timers for flow control
• Involved in optimization of ETL programs and SQL queries (overriding SQL query) in order to increase performance
• Worked with relational sources and flat files
• Involved in rigorous testing of ETL mappings
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance
• Provided excellent Informatica production support
• Used Debugger to test the mappings and fix the bugs
• Automated scheduling of sessions at regular intervals using Informatica Scheduler
• Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to Improve performance
• Implemented Informatica Data Quality 8.5 to do data cleansing, data matching, reporting and monitoring the XML files
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results

Environment: Windows XP, Informatica Power Center 8.1.x, DB2 8.1, WinSql 5.5, UNIX.

ETL Developer

Confidential

Responsibilities:

• Implemented various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Created Debugging Mappings to examine any performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Analyzed the requirements and having discussion with onsite and business team to understand the requirements.
• Created the mapping design documents for business requirements.
• Worked with various active transformations in Informatica Power Center like Normalizer Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, Sequence generator Transformation and Update Strategy Transformation.
• Worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, Sorter Transformation, and Lookup Transformation.
• Worked with Slowly Changing Dimensions (SCD) Type1, Type2, and Type3 for Data Loads.
• Created and Documented ETL test plans, test cases, test scripts, expected results, assumptions and validations for unit, integration and system tests for mappings developed.
• Involved in postproduction support and monitoring the activity in various environments.
• Worked on waterfall methodology.

Environment: Informatica Power Center 8.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat Files, Oracle10g, Teradata, UNIX Scripting, Putty, Visio, ESP.