| Description :
|
- MDM Lead with experience in analyzing, development, maintenance and troubleshooting on Informatica MDM solutions and Informatica IDQ & IDD.
- Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
Strong knowledge in MDM packages and queries. - Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
- Planning and designing of MDM end to end solutions. Data modeling for multiple MDM projects.
- Understanding of Security access Manager SAM configuration
- Strong knowledge in Subject Area Group, Subject Area, Subject Area Child configuration in IDD Base
- Understanding of IDD User Exit implementation
- Experience with MDM admin activities
- Good understanding of Unix commands shell scripts
- Exposure to cleanse function and Java library in MDM
- Experience configuring and deploying complex client server software on Unix and Windows servers Strong RDBMS SQL and troubleshooting skills
- Experience in Informatica MDM Hub administration using Hub Console build the data model and other objects in the Hub Store.
- Experience in Informatica Data Director Configuration.
Extensively used ETL methodology for supporting Data Extraction, Transformations and Loading processes in corporate-wide ETL solutions using Informatica.
Knowledge of Informatica repository tables and queries.
Knowledge in Dimensional/ Data Modeling Technique, schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), and handling SCDs.
Good knowledge in ETL and SQL query performance tuning to improve the session run times.
Have also worked on Onsite Offshore model, carried out the different phases of the projects effectively by excellent co-ordination and communication
|