Technical Developer (Informatica P360)

The Home Depot; Old Toronto; On-site; CAD 100,000 - 125,000; Full time

Job summary

An established industry player is looking for a Technical Developer with expertise in Informatica P360 to join their dynamic team in Toronto. In this pivotal role, you will design and configure MDM-PIM solutions, ensuring high data quality and integration standards are met. Your experience with cloud technologies like AWS and Azure, alongside your skills in data profiling and mapping, will be essential in driving successful data quality initiatives. This is a fantastic opportunity to contribute to innovative projects while advancing your career in a collaborative environment. If you thrive in a fast-paced setting and are passionate about data quality, this position is perfect for you.

Qualifications

• 2+ years of experience with Java or similar languages.
• 3+ years in data quality programs and tools.

Responsibilities

• Configure Informatica P360 solutions based on requirements.
• Develop data integration mapping designs and workflows.

Skills

Data Quality

Data Integration

Informatica P360

Java / J2EE

Data Profiling

Data Mapping

Data Analysis

Education

Bachelor's Degree in Computer Science or related field

Tools

Informatica Data Quality

AWS

Azure

ActiveVOS

Job description

Technical Developer (Informatica P360) chez Home Dépot | Toronto, ON M3C 4H9

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. The person is responsible for designing & configuring the Informatica P360 solution as per the requirements. The candidate should also be experienced with the data quality and data integration aspects of the Informatica MDM-360 solutions.

Roles & Responsibilities:

1. P360 configuration on an AWS/Azure provisioned environment
2. Create and manage catalogues
3. Profile source data and determine all source data and metadata characteristics
4. Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data for the implementation phase
5. Experience with IDQ designer to develop mapplet and data quality rules
6. Use the Informatica Data Integration platform to extract, transform, and load data from sources to targets
7. Develop data integration mapping designs
8. Use Informatica Data Integration to perform data quality operations
9. Ensure that the ingestion and integration processes can be executed on Cloud technologies such as AWS or GCP where suitable and advantageous
10. Develop data integration task flows and load processes
11. Design, develop, and unit test complex interactive processes
12. Develop complex data transformations mostly on XML or JSON documents
13. Develop and maintain workflows designed using ActiveVOS designer
14. Unit test process flows for accuracy and consistency

Technical Experience:

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