Senior ETL Consultant

MDM-PIM Configurator - Informatica P360, contract position

Number of openings - 1, 3months contract to start, then FT perm conversation

Location : North York ON, CA

Must be eligible to work in Canada

Remote position, working EST hours

Looking to hire an 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.

Roles & Responsibilities :

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

Technical Experience :

Detailed understanding of Informatica P360 Components and Informatica Developer Components.

Knowledge of Informatica Data Quality standards, guidelines and best practices.

Must have qualifications

Data : Informatica 5-8 years

SAP MDM 5+yrs

Informatica P360 expert 5+yrs

Java 5+yrs

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