Logo
Jobs via Dice

Actively looking for a Informatica MDM & ETL Lead (face to Face interview)

Jobs via Dice, Wilmington, Delaware, us, 19894

Save Job

Informatica MDM & ETL Lead (Face to face interview) Location: Wilmington, DE (Complete on site on Day one)

Job Title: Informatica MDM & ETL Lead (Face to face interview)

Job Description

Informatica Master Data Management (MDM) applications based on identified architecture and support implementation of design by resolving complex technical issues faced by the IT project team during development, deployment, and support.

Provide production system operations and maintenance (O&M) support for end-users, applications, infrastructure, or network services. Troubleshoot existing information systems, application, middleware, or networks to identify errors or deficiencies.

Make recommendations and influence long-term technology strategy and planning for multiple business units.

Assist in the development and analysis of source selection strategies. Serve as a consultant and escalation point for issues.

Provide technical analyses to help define, assess, and monitor the technical aspects of the program/project or service.

Design innovative solutions using new technologies.

Recommend short-term alternatives when appropriate.

Work with vendors during the problem-resolution process as needed. Provides technical expertise across business functions. Identify opportunities to improve business processes via new technologies.

Technical/Functional Skills

Informatica MDM Development

Architecting MDM Solutions

PL/SQL

Postgres SQL, Red shift and DynamoDB

AppDynamics and Kibana

Oracle DB

MDM HUB & SIF

Tools, Utilities & Methodology Service Now and Control-M. Service Oriented Modeling and Architecture, AGILE, Waterfall, Iterative, Object Oriented Analysis and Design.

Roles & Responsibilities

To uniquely identify master data and its relationships across distributed data sources and deliver unified views of Member, Provider, Reference Data while dynamically synchronizing master data changes throughout the enterprise.

To mitigate the risk of data corruption across different interfaces by implementing one master data source, thus maintaining data consistency.

Provides support Middleware team on the installations, code deployments, any configurations, any updates/patches that are needed, as well as any start/stops that are required on Stage and Production.

Need to understand generic wrapper to call the existing oracle user exists by new java APIs(Java SIF).

To support real time integration custom java application. Execute the upgrades for Hub Server, Cleanse Server, Master ORS, CMX ORS and JRE and Implement Business Entity using Provisioning Tool.

Writing complex SQL queries on Databases.

Hands on experience on Match & Merge, Hub Store, Metadata Manager, SAM, Batch Viewer, Cleansing, Load & Publish process.

To interact with the customer in real time providing the best of data there by gaining best customer experience.

Support Informatica MDM Batch Jobs: Ensure smooth operation of batch jobs in the production environment.

Enhancements: Implement minor enhancements to improve system functionality and bug fixes.

Tokenization Process: Monitor and support the tokenization process.

Data Management: Oversee the match and merge process for customer data. Identify old data and perform hard deletion of data using SIF mechanism.

Health Checks: Perform daily health & daily status checks on batch outputs and updates to business stakeholders.

Understand Support applications on AWS Services, AWS Lambda or other AWS native orchestration tooling and maintaining DynamoDB, Lambda, and SNS services in AWS.

Deep understanding on application and log level monitoring tools like AppDynamics ,Grafana and EFK( Kibana).

ITIL Process( Incident,Change,Problem & Release management).

Seniority level Mid-Senior level

Employment type Full-time

Job function Other

Industries Software Development

#J-18808-Ljbffr