Aravind A

Informatica MDM Developer and Application Support Analyst experienced in developing and implementing master data management solutions using Informatica MDM Hub and Informatica Intelligent Data Management Cloud. Delivered efficient data integration and troubleshooting through expertise in MDM Hub architecture, data cleansing, and repository management. Focused on optimizing processes and collaborating with cross-functional teams to align solutions with business needs.

• Customer insight master data, Medtronic, Developer, 10/01/22, Present, Customer insight master data is mastering of the batch data coming from multiple source systems through MDM functionalities and publishing the mastered golden data to downstream consuming systems like Vendavo, GSR., Created multiple landings and configured Base Objects for these according to client requirement., Created source systems to create staging tables and relationship defined between the Base Object’s., Created mappings by using cleanse functions and configured stage process., Defined trust on columns according to client requirement and tested the reliability of column data from various source systems., Created match rules like fuzzy match for finding the probabilistic match of the records and exact match for finding the exact match of the records in Base Objects., Configured merge process by setting rules to consolidate data from matched records., Configured queries and packages to view data in Base Object’s., Configured Cleanse functionality., Run the tokenization process, Match process and used various tables like XREF, MTCH, STRP, RAW, REJ and etc., Configured Batch Jobs to execute Stage, load, Match and Merge processes and analyzed Load Jobs in Batch Viewer for resolving Bugs/errors., Configured various roles in SAM to achieve secure access to Data Stewarts, Business End Users who have access to MDM hub console., Worked on Provisioning tool/IDD and Business Entity creation and customization queries, Packages and relationships etc.
• Project#1, Valley National Bank, NJ, ORACLE PL/SQL DEVELOPER, Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data., Worked on SQL
• Loader to load data from flat files obtained from various facilities every day., Involved in the continuous enhancements and fixing of production problems., Developed PL/SQL triggers and master tables for automatic creation of primary keys., Created scripts to create new tables, views, queries for new enhancement in the application using SQL Developer., Created indexes on the tables for faster retrieval of the data to enhance database performance., Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer., Extensively used bulk collection in PL/SQL objects for improving the performance., Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching., Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application., Oracle 11g, SQL
• Plus, SQL
• Loader, SQL Developer, Windows XP
• Project#2, SANOFI, PL/SQL DEVELOPER, Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers., Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data., Loading data from flat files into database tables using SQL
• Loader., Created Materialized Views and partitioning tables for performance reasons., Monitoring day-to-day Process for different Data Loads and resolving Issues., Involved in peer design and code reviews and extensive documentation of standards, best practices., Preparing documentation for requirements, design, installation and Unit testing and System Integration., Worked in Performance Tuning, Perform root cause analysis on failures. Resolve performance tuning related issues and queries.

• 5 years of professional experience in ORACLE PL/SQL Development.
• 4+ years of experience in MDM HUB environment, development and Implementation of Business applications using Informatica MDM 10.4.
• 1.5 years of hands-on experience in Informatica Intelligent Data Management Cloud (IDMC) – Master Data Management (MDM SaaS).
• Skilled in monitoring and troubleshooting data jobs, managing application-level incidents, and ensuring seamless data integration across enterprise systems.
• Good understanding of MDM HUB Process flow and Architecture.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Match and Merge properties and Batch Group creation.
• Experience in creation and maintenance of entity objects, hierarchies, entity types and relationship objects.
• Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, look ups, query groups, queries/custom queries and packages.
• Knowledge on implementing hierarchies, relationship types, packages and profiles for hierarchy management in MDM Hub implementation.
• Worked on Data cleansing, Standardization using cleanse functions in MDM Hub.
• Used Repository manager for validation, promotion, importing, exporting the ORS repositories to Development.
• Hands on Experience on IDD Application creation by creating Subject Areas and Subject area Group.
• Ensuring solutions meet business needs and requirements.
• Prioritizing initiatives based on business needs and requirements.
• Locating and defining new process improvement opportunities.
• Worked alongside teams within the business or the management team to establish business needs.
• Good Experience in IT industry in Broad range of function & involved in development, Support of various projects.
• Experience in writing complex SQL queries.

• Father's Name: G. Arul selvan
• Date of Birth: 04/04/93

• MDM Implementation: Methodology Beginner Course
• Cloud Data Integration Concepts and Architecture
• CDI Implementation Practitioner Certification
• Cloud Data Integration Mapping Design and Development
• Informatica Master Data Management Concepts (MDM)
• Cloud Data Integration Runtime Environments