Informatica MDM DEVELOPER
Resume:
Kiranmai
MDM DEVELOPER (Informatica)
***********************@*****.***
Professional Summary:
Over 7+ years of experience in Master Data Management (Informatica 10.4,10.3,10.1) Multi Domain Edition in Analysis, Design, Testing, Maintenance and Quality Assurance with implementation of software applications in MDM and Data warehousing.
Involved in every phase of software development life cycle from requirement gathering, design, development, testing, production, and stability support. Worked on tools like Informatica MDM and Informatica Data Director.
Worked on promoting the code changes from lower to higher environments and applying EBF and Hotfixes.
Worked extensively on Match Tuning and resolved bugs related to Match Rules.
Created the Business Entities (BE’s), Business Entity Views (BE View), BE to BE View Transformations, BE View to BE Transformations, and Layouts in Provisioning tool
Worked on SSANAME3 Workbench tool and modified the population file as required for our Business.
Implemented the new Match & Merge architecture and worked with SME’s and Business Analysts.
Worked on creating and enhancing the Word rules for the Name and Address Part1 in population files as per our business needs.
Responsible for proposing high level match tuning with Business and help them decide which customization would be more comfortable for them.
Knowledge on loading the data from IDQ Raw tables to DQ tables and loading the data from DQ tables to Informatica MDM Staging tables.
Explained the IDQ team what the DQ rules are need to be implemented for the quality of the data
Worked with Java Team to develop and come up with new strategies to create records in Database.
Worked on Provisioning Tool, IDD, IDQ, P360.
Expertise in Master Data Management concepts, methodologies, and ability to apply this knowledge in building MDM solutions. Designed and developed landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries, and packages. Created Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group
Highly Skilled in Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager and configuring Informatica MDM solutions.
Worked on Informatica developer to understand the data and its mappings.
Experience in Provisioning Tool 10.3 HF1.
Experience in C360 10.3 HF1.
Experience in creating UI screens and the dashboards
Experience in providing information management consulting services on Master Data Management, Data Integration and Business Intelligence Applications.
Defined the Trust and Validation rules and setting up the auto match/merge rule sets to get the right master records (BVT).
Acknowledge on Oracle 10g, PL/SQL, and SQL Server.
Technical Skills:
Informatica MDM Tools
Informatica MDM 10.1,10.2,10.3,10.4 (MDM Hub, Informatica Data Director, Message Queues). IDQ
Web/App Servers
JBoss EAP 6.4/7.1
Databases
Oracle 11g, Oracle 12C, SQL Server and MSSQL
ETL
Informatica Power Center
IDE
Eclipse, MS Visual Studio
Version Control
SVN, GitHub.
Operating Systems
Windows XP/7/8/10, Linux
Professional Experience:
USAA, Dallas TX Dec 2021 to Present
Senior MDM Developer
Responsibilities:
Integrated Customer data from different sources to create a Master Data to get best version of truth as golden record.
Worked closely with IDQ team for loading the data into MDM staging tables.
Created and configured Base Objects, associated staging tables, lookup tables, mappings and transformations as per business requirements.
Configured foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.
Created the Source to Target Mapping sheet.
Worked on Provisioning Tool, IDD.
Experience in using the SOAP API’s to perform activities like merge, unmerge, ececutebatch delete, recal BO/BVT etc.
Created the Business Entities (BE’s), Business Entity Views (BE View), BE to BE View Transformations, BE View to BE Transformations, and Layouts in Provisioning tool.
Knowledge on Post Load User Exit code and BES code and doing the enhancements for the new requirements.
Deployment of the code from lower environment to higher environment.
Involved in the Production deployment and deployed the code to Production Environment manually.
Environments: Informatica MDM 10.4, Oracle 11g, IDD, Provisioning Tool 10.4, SOAP UI, Windows
Volkswagen, Herndon, Virginia Aug 2020 to Nov 2021
Informatica MDM Developer/Analyst,
Responsibilities:
Worked on IDQ for Data Profiling and standardize the data.
Designed and developed the match rules based on the Data Analysis and post discussions with the Business Analysts.
Enhanced Match rules after consulting with Informatica and Improved the match performance.
Worked on Data Loading via Batch Jobs and fixing data related bugs and reporting the data issue to client.
Helped the team to develop the data model and added new tables to the data model.
Worked on SAM to add/revoke access to the users.
Worked on promoting the code changes to the higher environments.
Worked on developing Hierarchies and creating packages.
Created scripts to automate the match and merge jobs.
Worked on SoapUI to run SIF calls like Cleanse put, put, delete etc.
Worked on validation rules to downgrade the trust on some columns as per the client requirement.
Worked on identifying the bad data in the system with the help of match rules and to clean it.
Interacting with business analysts, clients and customers and resolve the issues as part of production support.
Environment: Informatica Multidomain MDM 10.2 HF1, Oracle 11g, SQL Developer, IDD, SoapUI,
Cigna, Bloomfield, Connecticut Jul 2019 to Jul 2020
MDM Developer,
Responsibilities:
Associated with application teams to understand the design and requirements needed for developing the framework
Developed and tested all the work done in MDM from lower environments to higher environments.
Worked on Data Modeling and as well as Data Mappings and did the testing in all the environments.
Ability to configure match and merge rules in MDM to optimize the performance.
Ability to understand, change and propose solutions to modify.
Ability to analyze the data during all stages of MDM.
Worked with Data Steward In fixing the Match & merge Issues.
Worked with the ETL Team to create batches and schedule jobs.
Developed Hierarchial view of MDM to promote it to the business as per requirements.
Environment: Informatica MDM 10.3, Provisioning Tool, C360, IDQ, IDD, DB Vis, Oracle 11g, JIRA, Pitney Bowes, Informatica PowerCenter, JBoss 6.4.
Blue Cross Blue Shield Richardson, TX Feb 2018 to June 2019
MDM Developer,
Responsibilities:
Worked with ETL Developers in creating External Batches to execute mappings to integrate data from varied sources like Oracle, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
Created and configured Base Objects, associated staging tables, mappings and transformations as per business requirements.
Configured mapping with cleanse functions.
Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
Involved in designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
Configured foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.
Configured hierarchy system tables and user defined tables and configured entity types and relationship types.
Configured match paths, match columns, match rule sets and match rules according to the requirement.
Involved in Data manager and merge manager tools under Data Steward Workbench to manually merge and unmerge records.
Assisted in defining the Trust and Validation rules and setting up the auto match/merge rule sets to get the right master records (BVT). Configured match rule set property by enabling search by rules in MDM according to Business Rules.
Increased performance and improved convenience for business users by configuring IDD.
Involved SIF and configured SoapUI code for API calls to access hub data.
Environment: Informatica Multidomain MDM 10.1, Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, JBoss EAP, Oracle 11g, SQL Developer, Service Now.
Client: I3 Infotech, Hyderabad, India May 2014- Dec 2016
Role: Jr. Informatica Developer
Responsibilities:
Involved in gathering, analyzing, and documenting business requirements, functional requirement for database changes, ETL, Business Reports.
Extracted Data from different source systems like Oracle, and Flat files.
Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO_DATE, Decode, and IIF functions in Expression Transformation.
Worked with PL/SQL to create complex queries, function, store procedures, trigger etc.
Responsible for best practices like naming conventions, and Error Handling
Responsible for Performance Tuning at the Source/Target level, Mapping and Session Level.
Performance tuning of SQL scripts using Oracle Explain Plan.
Responsible for 24/7 Informatica production support.
Involved in various meetings, seminars, presentations and group discussions.
Worked with Informatica Data Quality (IDQ).
Environment: Informatica 8.6.1, Oracle 11g, TOAD, Erwin, SQL SERVER, Shell Scripts, Teradata.
Education:
Masters in Business Analytics from Texas A & M University.
Bachelors in Bio Technology from Vignan University, India
Contact this candidate