Senior ETL Consultant

MDM-PIM Configurator - Informatica P360, contract positionNumber of openings - 1, 3months contract to start, then FT perm conversationLocation : North York ON, CAMust be eligible to work in CanadaRemote position, working EST hoursLooking 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 environmentCreate 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 rulesUses 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 documentsDevelop and maintain workflows designed using ActiveVO designerUnit test process flows for accuracy and consistencyTechnical Experience : Detailed understanding of Informatica P360 Components and Informatica Developer Components.Knowledge of Informatica Data Quality standards, guidelines and best practices.Must have qualificationsData : Informatica 5-8 yearsSAP MDM 5+yrsInformatica P360 expert 5+yrsJava 5+yrsAt least 2 years of experience with Java / J2EE technologies or a similar languageAt least 2 years of experience with database technologies3+ 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 ActiveVOSProven 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