Data Engineer - Informatica & API/Kafka

Technical/Functional Skills

Produces and develops detailed MDM design specifications, develops custom mapping functions and customization to the data tier of MDM Hub. • Experience on Informatica MDM hub components: Landing tables, base objects, staging tables, lookup tables, relationships, mappings, cleanse function, trust and matching rules, hierarchy management, E360 (provisioning) etc. • Review MDM environment for efficacy, performance improvement (including APIs), and support overall MDM data governance model. • Build customized APIs for data ingestion into MDM. • Troubleshoots issues related to MDM and identifies opportunities for improving data management processes. • Provides strategic guidance on MDM best practices. • Experience in working with IICS/IDQ ETL Cloud technologies. • Unix and shell scripting hands-on experience • Strong SQL and DB knowledge (MySQL, Oracle and SQL Server ) • Good understanding of AWS services