Design secure, robust, fault-tolerant and highly scalable Master Data Management solution
Provide technical leadership for all phases in the solution lifecycle, including architecture, design, code development, testing and deployment
Develop and unit test data solutions, data integrations, data services
Use agile engineering practices and various data development technologies to rapidly develop creative and efficient data products
Mentor and provide direction to data engineers and quality engineers, both on-site and offshore Core Technical Requirements of the role:
Minimum 12 years’ of data engineering experience, with hands-on experience implementing Informatica MDM, Informatica PowerCenter, SQL and IDQ.
Excellent analytical, problem-solving, organizational, communication and interpersonal skills.
Understands all core MDM functionalities
Minimum 2 years hands-on experience on AWS services (S3, Redshift, Glue, Athena)
Minimum 2 years hands-on experience developing APIs and services
Experience leading large-scale data warehousing, data lake and data integration projects
Experience managing offshore development teams
Experience in performance monitoring and performance tuning
Experience in financial domain is a plus
Must have development experience of at least 2 projects with around 4-5 years of relevant experience in Informatica MDM
Good to have skillset of Data Quality and external Data enrichment services.
Should have knowledge around Batch Load and Real Time APIs to/from MDM
Ability to carry out Match Tuning/Match Performance etc.
Customization and Configurations on Data Model/Hub Console/IDD
Ability to convert business requirements and provide estimates
Integration across enterprise systems in terms of sourcing data and publishing MDM Views
Experience in creating source systems and configuring the trust settings in MDM.
Experience in creating base objects and setting their properties, also created staging and landing tables and defining relationships between different core entities.
Experience in creating various cleanse functions by using regular expressions.
Experience in creating the mapping and used various cleanse function
Experience in configuring Match/Merge settings.
Experience in writing the SQL to load data into the landing table and defining the process to load staging tables and then corresponding base Objects.
Experience in creating Queries and packages.
Experience in modifying the repository according to business needs.
Creating import and export templates.
Creating custom views for Web Portal.
Creating Web UI Dashboards for various end users Define Hierarchy for different entities like customer, supplier and product Configuring Informatica PIM repository as per business requirements.
Creating import and export templates for loading and exporting data.