Informatica MDM & ETL Lead

Job Title :Informatica MDM & ETL Lead-Full time

Location : Wilmington, DE / Site DEWashington DC (Complete onsite on Day one)

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. In other words, any change needed for the infrastructure or code, the Middleware team will do.
• 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) .