IDMC Data Architect

Assist with requirement definition on data integration designs and take ownership to resolve JIRA tickets within Sprints with a high quality outcome.

Review, analyze, and where necessary author functional requirements and mapping documents.

Develop standard to complex ETL components such as connectors, mappings, sessions, and workflows based on the prepared low-level design requirements.

Be a steward of quality in your work by applying design patterns, use cases thinking, and validation of work through unit testing.

Debug mappings and identify errors and error rows so that they can be corrected and re-loaded into a target system.

Author and implement a performance tuning of mappings, processes, and load routines.

Assist with QA by acting as a peer reviewer and coaching more junior resources.

Act as an expert resource on IDMC application, repositories, dependencies, scheduling mechanism, object, and various dependencies within Andover s solution architecture to other members of the team.

Profile data to gain insights into Data Integration strategies, identify technical dependancies and design integration components.

Monitor IDMC environments and troubleshoot service and job related issues.

Assess ramification of issues and prioritize tasks based on business impact for operational and project support activities.

Provide reporting related to IDMC operational, job trending, and other resource utilization within the nightly batch schedule.

Provide guidance to the Cloud support team to improve monitoring, measuring and reporting system health, performance and uptime metrics.

Leverage IDMC existing and new features by evaluating/reviewing, installing and configuring new software releases, upgrades, and patches through planning and coordination with the larger team.

Maintain appropriate documentation of system infrastructure, data architecture, ETL processes, data modeling, and reporting capabilities providing oversight.

Lead Data Lifecycle Management processes and procedures related to change management.

Recommend updates to Data Lifecycle Management to improve efficiency and reduce risk related to changing our architecture, data models, and IDMC components

Other duties as assigned to support technical/operational activities.

The core competencies for a person to perform this job at a skilled level are:

Informatica development focused on Data Architecting and Integration.

Administration and management of the IDMC solution through a Data Management Lifecycle.

This job requires certain knowledge, skills, and abilities as follows:

DevOps methodologies and best practices.

Expert analytical skills to troubleshoot issues with system performance, connectivity to various data sources, space and system logging.

Experience in SOX requirements, Audit reports and DR/BC needs that are mandatory for running the data management platform.

Eligible candidate will be trained in the role of Advanced Data Architecting and Integration using IDMC.