Technical Developer (Informatica P360)

at  The Home Depot Canada

With a career at The Home Depot, you can be yourself and also be part of something bigger.
Position Summary: We are seeking to hire a MDM-PIM Configurator. Person is responsible for designing & configuring the informatica P360 solution as per the requirements. Person should also be experienced with the data quality and data integration aspects of the Informatica MDM-360 solutions.

TECHNICAL EXPERIENCE:

Detailed understanding of Informatica P360 Components and Informatica Developer Components.
Knowledge of Informatica Data Quality standards, guidelines and best practices
At least 2 years of experience with Java / J2EE technologies or a similar language
At least 2 years of experience with database technologies
3+ years’ experience in defining and deploying data quality programs and tools on enterprise data quality projects
Experience in data profiling & data quality rules development using Informatica Data Quality tools
3+ years of data analyst experience performing data profiling, data mapping, data validation, data manipulation, data analysis, use case, test cases, etc.
3+ years of workflows development experience utilizing Informatica ActiveVOS
Proven experience translating business problems into actionable data quality initiatives
Familiarity with current trends in Data Quality technologies
Good knowledge on Informatica Data Services (IDS) Informatica Analyst and Informatica Developer
Data mapping experience – mapping data sources to and from multiple applications
Production support experience ( troubleshooting

P360 configuration on an AWS/Azure provisioned environment
Create and manage catalogues
Profile source data and determine all source data and metadata characteristics
Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data for the implementation phase
Experienced with IDQ designer to develop mapplet and data quality rules
Uses the Informatica Data Integration platform to extract, transform, and load data from sources to targets
Develops data integration mapping designs
Uses Informatica Data Integration to perform data quality operations
Makes sure that the ingestion and integration processes can be executed on Cloud technologies such as AWS or GCP where suitable and advantageous.
Develops data integration task flows and load processes
Design, development, and unit testing of complex interactive processes
Develop complex data transformation mostly on XML or JSON documents
Develop and maintain workflows designed using ActiveVO designer
Unit test process flows for accuracy and consistency