We provide IT Staff Augmentation Services!

Sr. Informatica Mdm Developer Resume

Whippany, NJ

SUMMARY:

  • 13+ year experience in various phases of Data warehouse Lifecycle that includes Requirements Gathering, Design, Development, Implementation and testing for end - to-end IT solution offerings.
  • Strong knowledge and development Experience in Informatica Power Center, Informatica MDM, Oracle, PL/SQL and Data Warehouse concepts.
  • 5+ years of experience with MDM architecture and design in multiple implementation.
  • I was also involved in Project analysis, Design, Development and Maintenance using technologies like Informatica MDM and Java/J2EE.
  • Configuring and maintaining various components of the MDM Hub including the schema, staging and landing tables, configuring base objects, Look ups, Display Package, Put Package and query groups
  • MDM Hub configurations - Creating match paths, match rules, match rule sets, system trust scores and trust score decay with Validation rules.
  • Creating mappings using cleanse functions to standardize data, custom JAVA cleanse functions to validate IDD fields and display custom error message
  • Highly experienced in data mart life cycle development and ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. Extensively worked with Informatica mappings, sessions and workflows.
  • Working experience in Informatica metadata 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.
  • Wrote web services client to implement SIF framework in Informatica MDM.
  • Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring.
  • Creating JAVA User Exits using SIF APIs to customize MDM Hub functionality.
  • Created and Configured Subject Areas and Subject Area Groups, related Base Object relationships with Subject Area relationships in IDD.
  • Experience in all aspects of project development life cycle - Product Road map, Project planning and estimation, Functional/Technical specification document, Design Document, Unit test plan, System test Plan, Implementation plan, Lead role in all phases involved in SDLC.
  • Expertise on Java/J2EE technologies (Core Java, JavaScript, JavaBeans, JDBC, Servlets, HTML, JSP, JSTL, EJB, Struts, AJAX), XML and SQL.

PROFESSIONAL EXPERIENCE:

Confidential, Whippany, NJ

Sr. Informatica MDM Developer

Roles & Responsibities:

  • Building master data management solutions in an enterprise MDM environment using MDM tools such as Informatica Master Data Management.
  • Provide technical support for MDM platform, including inbound/outbound data integration (ETL), Data Quality (DQ) and Informatica data director (IDD) development, and maintenance/tuning of match rules and expectations.
  • Design data models to support MDM solutions.
  • Design, develop and translate business requirements and processes for data matching and merging rules and survivorship criteria using MDM.
  • Created Bulk import for mass load of data, Created format to upload in different subject areas and child areas.
  • Cleanse rules are implemented for data cleansing and data format of incoming data.
  • Demonstrated experience and ability to apply data quality techniques such as match, merges, profiling, score carding, data standardization and parsing using IDQ.
  • Consume Application service (URI) in MDMHUB created in IDQ for data cleansing purpose.
  • Create report in IDQ (Create Mapplet, IDQ rules) using profile. User uses Analyst to see the report.
  • Crete ETL mapping in Informatica PC to run the report. Mapping will consume Mapplet created in IDQ.
  • Collaborate with source systems, data strategists and technical staff for data governance and to resolve any data quality or technical issues.
  • Troubleshooting and resolving MDM related issues, providing solid solutions and aligning with master data strategies and best practices.

Environment: Informatica MDM 10.2, Informatica pc 10, Informatica IDQ 10, Soap UI, Web Services, MDM SIF APIs, JBoss, SQL Oracle 10, VSTS for source code

Confidential, Eagan, MN

Tech Architect(ETL/ MDM)

Role & Responsibilities:

  • Interacting with Business users to gather business/functional requirements.
  • Analyze the functional requirements and discuss tasks/issues with the client team and propose optimal design solutions for the corporate/Interim releases.
  • Architecting the technical solution
  • Preparation of High and Low-level technical design.
  • Manage risks to project activities and come up with mitigation plan to ensure the assigned tasks are under control and should not affect the project delivery timelines.
  • Code review and optimization.

Confidential, OK

Sr. Informatica ETL/MDM Developer

Role & Responsibilities:

  • Build complete ETL Specifications and logic buildings.
  • Interact with system analysts to understand the requirements
  • Data load to landing table is designed to be either full load or CDC. The frequency of data load is set to Real time using Informatica Power Exchange or on a set interval.
  • Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
  • Used address doctor to validate and enrich address related data.
  • Developed various kinds of mappings to load landing, lookup and reference tables.
  • Testing jobs to assure that data is loaded as per ETL specification & testing the ETL jobs in UAT and Test environment.
  • Optimizing the mapping through SQL query override, created complex mappings and tuned for better performance.
  • Extensively used Mapping Variables, Mapping Parameters, and Parameter Files in the mapping
  • Process prime Members centric claims using Master Data Management initiatives using Informatica Master data management and data quality product
  • Created landing tables, base tables, staging tables according to the data model and number of source systems.
  • Concatenated the columns to get unique values loaded into the Pkey source of the staging tables.
  • Fixed the issues while getting the data loaded in stage and base tables and worked with Informatica Support.
  • Defined the Trust scores for the source systems as per understanding the business process.
  • Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
  • Analyzed and profiled the data and came with up the initial match rules and gone through several iterations for tuning matches.
  • Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.
  • Utilized SOAP UI to call SIF API requests for Data Clean up services/ Data Put services/ Data retrieval services / testing the cleanse functions services. Used SOAPUI to test web services deployed on MDM HUB.
  • Utilized Putty to shut down and restart the Admin Server / Hub server to speed up the MDM process.
  • Utilized Repository manager for Validating, promoting, importing and exporting the ORS repositories to different environments.
  • Wrote web services client to invoke web services using SIF framework.
  • Create low level design and ETL technical design doc according to requirement.
  • Created customize SQL code to enhance the process, SQL scripts to remove redundant data from base tables.
  • Created Unix script to execute SQL script.

Environment: Informatica power center 9.5/MDM 9.7, Informatica IDQ 9.5, Informatica power exchange, ActiveVOS, Soap UI, Java (Core), JBoss, Oracle 11g, E/R Studio 8.0, Putty, Linux, Subversion, Shell Scripts, Quest Toad, PL/SQL.

Confidential, Beaverton, OR

IDD Consultant

Role and Responsibilities:

  • Created and configured Informatica Master Data Management (MDM) and Informatica Data Director (IDD) components i.e. Base objects, Staging tables, Landing tables, Mappings, Packages and Queries, Trust and Source System, Validation Rules, Match and Merge rule sets, Cleanse list, Cleanse functions, Hub user exits, IDD Subject Area group, Subject Area, Subject Area Child and Grandchild layout.
  • Performed Code Migration in Hub and also in IDD (by importing BDD Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications) to promote changes between all environments from development to production.
  • Implemented the RESTful webservice for the real time interaction with the downstream system Using SIF API.
  • Writing User Exits in MDM as well as IDD to support customized requirement, this is beyond the capability of the tool.
  • Design and develop the IDD application as per the Business requirement.
  • Provided Solutions for the Bulk Upload for Vendor and Item as per the Business requirement.
  • Participate in code reviews, preparation of test packages, release documentation, deployment Support representing development team.
  • Helped Java team in creating the Service Integration framework (SIF) for integrating into User interface application to provide Insert, Delete and real time matching and merging functionality.
  • Set Trust values for different sources for each table as per business requirement.

Confidential, Richmond, VA

Informatica ETL/MDM lead

Roles and Responsibilities:

  • Interacting with Business Analysts to understand the requirements
  • Analyze the functional requirements and discuss tasks/issues with the client team and propose optimal design solutions for the corporate/Interim releases.
  • Work with client leads and business analysts closely in prioritizing the tasks and determining the implementation of fast track code fixes.
  • Manage risks to project activities and come up with mitigation plan to ensure the assigned tasks are under control and should not affect the project delivery timelines.
  • Involved in the designing of Landing, Staging and Base tables in Informatica MDM.
  • Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
  • Applied trust and validation rules in the MDM load process.
  • Plan and estimate the ETL effort and scripting involved.
  • Analyzing the sources and targets, transforming the data, mapping the data and populating the data into targets by using Informatica Designer, Workflow Manager and Workflow Monitor.
  • Code review and optimization.

Technologies: Informatica Power Center 10.6, Informatica MDM 10.6, IDQ, SQL-Server, Oracle, Teradata.

Confidential, Indianapolis, IN

Informatica ETL/MDM Lead

Roles and Responsibilities:

  • Interacting with Business Analysts to understand the requirements
  • Analyzing the requirements and preparing design.
  • Involved in the designing of Landing, Staging and Base tables in Informatica MDM.
  • Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
  • Applied trust and validation rules in the MDM load process.
  • Creating and optimizing the Mappings, Sessions, and Workflows to improve the load performance.
  • Used pushdown optimization on certain sessions to push the transformation logic to target table and improve the session run time
  • Mainly involved in performance tuning in Informatica Load.

Hire Now