Informatica MDM Developer Resume Samples

Description :

1. Designed and implemented a robust partner data model and data hub to streamline data management.
2. Enabled front-end functionalities for partner management, enhancing user experience and efficiency.
3. Validated and accepted cleaned partner data through an intuitive front-end interface.
4. Integrated partner profile data into BI Analytics and DWH layers for improved reporting.
5. Conducted requirement-gathering sessions with business users to align data models with business needs.
6. Played a key role in creating data models tailored to specific business requirements.
7. Developed and maintained documentation for data models and processes to ensure compliance and clarity.

Experience

5-7 Years

Level

Executive

Education

M.S. CS

Description :

1. Collaborated with data architects to define match criteria and data model structures for MDM.
2. Designed and created landing, staging, and reference tables to support data integration.
3. Analyzed batch process failures to identify root causes and implemented corrective actions.
4. Established master and reference data for key business entities using Informatica MDM.
5. Implemented data quality rules to ensure data integrity in data marts and warehouses.
6. Developed and maintained documentation for MDM processes and data governance.
7. Trained business users on MDM functionalities and best practices for data management.

Experience

5-7 Years

Level

Executive

Education

M.S. CS

Description :

1. Optimized Teradata views and SQL queries, enhancing batch processing and response times for users.
2. Implemented slowly changing dimensions and fact tables using Informatica MDM, ensuring data integrity.
3. Conducted data validation pre and post-processing to ensure high data quality and accuracy.
4. Developed shell scripts for automation of data processing tasks, improving efficiency.
5. Collaborated with MDM architects to design and deploy MDM solutions tailored to business requirements.
6. Designed and debugged ETL routines and MDM hub configurations, ensuring seamless data flow.
7. Managed data quality services and workflow solutions to maintain data consistency across systems.

Experience

5-7 Years

Level

Executive

Education

GED

Description :

1. Developed and optimized ETL processes for data integration, ensuring compliance with industry standards and reducing redundancy.
2. Created detailed Source to Target mapping documents to facilitate data migration and transformation.
3. Designed and implemented Informatica mappings to efficiently load data from various source systems into the Data Warehouse.
4. Collaborated in the design of star schema data models, enhancing reporting capabilities and data accessibility.
5. Executed data transformations for extraction, staging, validation, and quality assurance, ensuring high data integrity.
6. Utilized Teradata stored procedures to validate and load data, improving overall data processing efficiency.
7. Conducted performance tuning and optimization of ETL workflows, resulting in significant processing time reductions.

Experience

5-7 Years

Level

Executive

Education

Bachelors Of Technology

Description :

1. Collaborated with PowerCenter team to integrate data from various external sources into the MDM hub.
2. Executed match and merge processes to establish a single golden record for data accuracy.
3. Conducted unit testing to validate match and merge outcomes against business requirements.
4. Customized MDM hub user exits and Java cleanse functions to meet specific business needs.
5. Developed standalone Java applications to enforce business rules effectively.
6. Created database procedures and packages to implement complex business logic.
7. Reviewed offshore development work to ensure adherence to best practices and quality standards.

Experience

2-5 Years

Level

Executive

Education

Bachelors

Description :

1. Designed and implemented scalable application architecture for MDM solutions, enhancing data accessibility.
2. Provided expert guidance on Informatica MDM Hub development, ensuring project success.
3. Configured and optimized the Physical Data Model to meet business requirements.
4. Oversaw the creation of source-to-target design specifications, improving data flow.
5. Developed, tested, and deployed ETL transformations to streamline data processing.
6. Created custom workflow processes to automate data management tasks, increasing efficiency.
7. Led integration development using the Services Integration Framework (SIF) and Business Entity Services.

Experience

2-5 Years

Level

Executive

Education

BSc CS

Description :

1. Designed and implemented a multi-domain MDM solution using Informatica MDM, enhancing data accuracy.
2. Configured and optimized Match and Merge processes, improving data quality and consistency.
3. Collaborated with cross-functional teams to gather requirements and create staging tables and foreign key relationships.
4. Developed mappings to load data into staging tables, ensuring efficient ETL processes.
5. Defined trust and validation rules for base tables, enhancing data governance.
6. Managed production incidents, ensuring timely resolution and minimal downtime.
7. Participated in agile ceremonies, contributing to continuous improvement and delivery of business value.

Experience

5-7 Years

Level

Executive

Education

M.S. CS

Description :

1. Developed and maintained complex hierarchies within the MDM hub to enhance data organization.
2. Collaborated with cross-functional teams to design an MDM platform that aligns with business goals.
3. Provided technical support for MDM tools, ensuring high system availability and performance.
4. Designed architectural solutions for data flows into the MDM platform and downstream applications.
5. Implemented match-merge logic and survivorship rules to ensure data integrity.
6. Conducted performance tuning of fuzzy matching algorithms to enhance processing speed.
7. Established data quality routines to validate and cleanse data entering the MDM system.

Experience

5-7 Years

Level

Executive

Education

M.S. CS

Description :

1. Led the design and implementation of data ingestion and integration jobs for the MDM platform, enhancing data accessibility.
2. Conducted workshops with stakeholders to identify data requirements and resolve business challenges.
3. Managed MDM tools and configurations, ensuring optimal performance and reliability.
4. Developed Informatica Data Quality components, adhering to design and functional specifications within budget and timelines.
5. Facilitated secure data flow between internal systems and third-party applications, including ERP and CRM tools.
6. Performed administrative tasks such as user management, monitoring, and troubleshooting to maintain system integrity.
7. Collaborated with Solution Architects to define and refine MDM architecture and design solutions.

Experience

5-7 Years

Level

Executive

Education

M.S. CS

Description :

1. Configured and deployed Informatica MDM Hub server across multiple environments, ensuring optimal performance.
2. Collaborated with ETL architects to design data flow processes, enhancing data integration efficiency.
3. Developed and executed match rules to improve data quality and accuracy within the MDM framework.
4. Designed base objects and staging tables, establishing robust data relationships and lookups.
5. Utilized hierarchies tool for effective entity configuration, enhancing data visibility and management.
6. Conducted data profiling and analysis to identify and resolve data quality issues proactively.
7. Implemented best practices for MDM processes, resulting in a 20% increase in operational efficiency.

Experience

7-10 Years

Level

Management

Education

MSc CS