Informatica Mdm Developer
Resume:
Manohara Teja
*****************@*****.***
SUMMARY
Adaptable Informatica MDM Developer with 4+ years of experience providing first-class results with overall 6 years of experience in the IT field. Meets job demands and deadlines through diligent work ethic and dedication to quality to maintain a long-term customer relationship.
PROFESSIONAL EXPERIENCE:
Informatica Developer
•Development and support experience in Informatica MDM (Siperian) Hub, Hierarchy Manager, Informatica Data Director, designing of Cleanse functions and Match rules, MDM User Exits.
•Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
•Hands-on experience in designing and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries, and packages.
•Mitigating performance issues by identifying the mappings causing issues and tuning them.
•Good knowledge of maintaining data integrity by applying reconciliation activities and testing mappings using test cases.
•Involved in handling admin console activities for repository and data integration services.
•Knowledge of implementing hierarchies, relationship types, packages and profiles for hierarchy management in MDM Hub implementation.
•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 on data.
PROFESSIONAL EXPERIENCE:
•Working for Infosys PVT LTD, In Hyderabad as informatica MDM Consultant from April 2023 to Till date
•Worked for Ina vantage Solutions Pvt Ltd, In Bangalore as Informatica MDM Consultant from Nov 2016 .
PROJECTS:
Project: Entity Master Data Management .
Client: Yes HPE. April 2023 to till date.
Role: Informatica MDM Developer
Yes is a support project that handles Master data of “Party” and “Location” that flows from MDCP system to S4,EAP and other downstream system using informatica Power Center,IDQ,MDM and Snap Logic
Using Informatica MDM suite of tools - design, develop, optimize and support MDM processes, including performance tuning of existing processes
Work is performed in a typical office environment
Manage the partnership with Data Integration Hubs around data modeling, data mappings, data validation, hierarchy management and overall security
Develop, optimize and support Informatica PowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data
Configure and optimize various MDM processes including landing, staging, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Informatica MDM
Configure and optimize various MDM processes and stages including data ingestion/acquisition, standardization/enrichment, harmonization and data provisioning using MDM tools
Responsibilities:
Worked for a support project for HPE client
Maintained models of downstream information in Metadata too for database changes
Load models, database objects, and PowerCenter workflows into metadata tool
MDM Support role for the client based on incidents
Handling the data and sending the master data to down streams
Worked on incidents handled through service now internal tool
Identify and manage data cleanup projects to improve data accuracy
Working on daily and weekly reports
Worked as support and experienced in solving incidents through backtracking
Loading data from Informatica MDM Landing to Stage
Worked on SOAP API where I use to Update data on different API’s as per the client requirement
Executing match and merge process and performing the Xref update, balance Reclass & Wrapper Program
Project: TELECOMMUNICATIONS.
Client: Yes Telecom Netherlands. April 2021 to till date.
Role: Informatica MDM Developer
Yes Telecom Netherlands is a telecommunication service provider and positioned as a mobile virtual network operator (MVNO). The company is engaged in rendering prepaid & amp, post-paid mobile services including SIM contacts, low-cost calls, high quality international mobile services using GSM technology, and standard activation services. Furthermore, the company operates and maintains more than 300 business partners across the country for rendering their full range of services including top-ups, international phone cards, related accessories etc. Apart from this, Yes Telecom is fostering several further steps in the service territory for extending its services and product portfolio, such as catering benefits to loyal customers and offering services and products with considerable added value for the targeted group. The company is headquartered in Leiden, the Netherlands.
Responsibilities:
•Defined the Trust and Validation rules and set 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.
•Create Landing, staging and Base Objects.
•Create Data validation and Trust settings.
•Create Match and Merge rules using Informatica MDM Hub to run Batch jobs
•Loading data from Informatica MDM Landing to Stage
•Define requirements for data matching and merging rules, and data stewardship workflows.
•Designing data hierarchy management for Informatica MDM.
•Executing jobs in Batch Viewer and Batch Group.
•Created Batch Scripts using Informatica, and Oracle APIs.
•Used Hierarchies tool for configuring entity base objects, entity types, and relationship base.
•Involved in Informatica server and Repository Migration from One Machine to another.
•Worked shoulder to shoulder with Informatica Vendor team to resolve Production issues
•Handling Critical Applications in Production Database
•Providing Temporary Solutions to the Failed jobs in Production and raising a Change Request.
•Stabilized the Production Environment
•Improved performance of Informatica Objects and Oracle Objects.
•Identified Major Data Quality issues in MDM Production.
•Expertise in Informatica Matching components.
PROJECT 1:
Project: Horizon BCBS NJ July 2018 – Feb 2021
Client: Wega Services
Role: Informatica MDM Admin
Horizon Blue Cross Blue Shield of New Jersey, headquartered in Newark, New Jersey is the only licensed Blue Cross and Blue Shield Association plan in New Jersey, providing health insurance coverage to over 3.2 million people throughout all of North, Central, and South Jersey. It is best known for its managed care and traditional indemnity plans for individuals and employers. It is a not-for-profit health service corporation.
Responsibilities:
•Design, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
•Worked on designing/defining the cleansing/trust rules, matching, and merging rules/Rulesets.
•Perform operational activities including job monitoring, troubleshooting, and data analysis and make recommendations for system improvements to improve operations.
•Excellent Understanding of MDM approach and methodologies.
•Experience in working with Oracle databases and proficiency with SQL.
•Design, development, testing, and maintenance of data validation rules for standards and compliance enforcement.
•Execute and monitor daily interface activities; investigate and resolve interface issues involving Informatica MDM.
•To report and develop operational or process enhancements.
•Trouble-shooting metadata validation issues.
•Configuring hierarchies, data relationships, packages, and profiles in hierarchy manager.
•Configuring, implementing, and troubleshooting IDD applications.
•Writing user exits for custom operations in the CMXUE package.
Title: HMS - BA Reporting Team
Client: Health Management Systems, Texas (USA) June 2014- May 2018
Role: Report Developer
Health Management Systems is a pioneer in cost containment, coordination of benefits, and program integrity services for government health care programs. Using information technology and data mining techniques, HMS identifies other insurance coverage, coordinates benefits, and recovers overpayments. HMS enables Medicare and Medicaid programs throughout the United States to recover their claims from the carriers and thereby financially help the Government through cost containment services.
Responsibilities:
• Developing the SOP(Standard Operating Procedures) from the KT received from the client.
• Developed reports in MS Excel on daily, weekly, monthly basis
• Modifying the reports by running the queries using tools like DB2, Teradata,
Micro strategy, DC4, Image now
• Modifying the reports based on the requirements
• Running the macros in Excel
• Interacting with clients and gathering the requirements
• Transferred the project KT to new joiners and assisted them
• Developed flow charts using Microsoft Visio tool
EDUCATION:
GITAM University (M Tech) May 2015
Contact this candidate