Informatica MDM Consultant with IICS

Job Title

Informatica MDM Consultant with IICS

Job Duration

12 Months

Location

Brooklyn NY(Onsite)

Description:

Senior Data Solution and Delivery Engineer role to ensure the efficient and successful implementation and support of complex data engineering solutions for City agencies. This resource should demonstrate a solid understanding of industrystandard implementation methodologies using data engineering technologies tools and processes.
Support ODA implement a new MDM Business Domain that will integrate multiple sources of data and accompanying web services and APIs.
Develop architectural blueprints that leverage the MDM as a foundational service of MyCity that will among other things support the creation of unified profiles that can be used for such activities as linking business transactions relevant to a business owner.
With guidance from ODAs Technical Leads coordinate the work of seniorlevel data engineers tasked with building pipelines to the MDM and selected ODA data platforms.
Support the development of analytics tools that utilize the data pipeline to provide actionable insights into customer engagement and experience operational efficiency and other key business performance metrics;
Review Extraction Transformation Load strategies (ETL) for data from a wide variety of data sources using SQL cloud and big data technologies;
Create update and maintain system documentation;
Manage the development of APIs for data access or landing data as output for further downstream consumption in the appropriate target data store; Coordinate appropriate security scan accreditations.
Perform special projects and initiatives as assigned.

MANDATORY SKILLS/EXPERIENCE Note: Candidates who do not have the mandatory skills will not be considered
8 years managing the development and implementation of large technology projects with at least 3 years involving an MDM implementation.
8 years of experience in writing SQL;
8 years of experience in copying transferring manipulating and automating data operations that were manual processes;
Experience with tools and components of data architecture such as Informatica Power Center IICS SSIS or similar ETL tools;

Experience working with Amazon Web Services or Microsoft Azure cloud computing platform and services

Indepth knowledge of SQL and other database solutions; Knowledge of modeling database schemas for large datasets;
Experience developing cloudready applications;
Experience working with programming languages like Python Java and Perl
Prior exper 5 years handson experience in development with the suite of tools from Informatica PowerCenter and B2B Data Transformation; is must
Experience using Oracle 10g/11g SQL Server and/or a database appliance;
Knowledge of metadatadriven enterprise reporting platforms;

SPECIAL REQUIREMENTS:

Strong handson experience with a Master Data Management (MDM) implementation that serves a large enterprise.