Senior ETL Consultant

Randstad DigitalON, Canada

2 days ago

Job type

Temporary

Job description

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

Location : North York ON, CA

Must be eligible to work in Canada

Remote position, working EST hours

Position Overview :

Looking to hire an MDM-PIM Configurator. The person is responsible for designing & configuring the Informatica P360 solution as per the requirements. The candidate should also have experience with the data quality and data integration aspects of the Informatica MDM-360 solutions.

Key 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 prepare the project data for the implementation phase.
Utilize IDQ designer to develop mapplet and data quality rules.
Use the Informatica Data Integration platform to extract, transform, and load data from sources to targets.
Perform data quality operations using Informatica Data Integration.
Ensure ingestion and integration processes can be executed on Cloud technologies such as AWS or GCP where suitable.
Develop data integration task flows and load processes.
Design, develop, and unit test complex interactive processes.
Develop complex data transformation primarily on XML or JSON documents.
Maintain workflows designed using ActiveVOS 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+ years.

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, mapping, validation, manipulation, 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 of Informatica Data Services (IDS), Informatica Analyst, and Informatica Developer.

Data mapping experience – mapping data sources to and from multiple applications.

Seniority Level

Mid-Senior level

Employment Type

Contract

Job Function

Information Technology

Industries

IT Services and IT Consulting and Retail

J-18808-Ljbffr