Job Description :
Role: Informatica ILM MDM Admin Architect

Location: Indianapolis, IN

Contract – 6 + Months

Job Overview:

The Data practice is looking for Technical Architect filling the role of a strategic MDM Architect. Although the position with the client demands an Informatica MDM Architect, the practice is looking for a strategist with a focus on MDM, DQ, Data governance, and data management and would be able to articulate these capabilities to ANY client. Work within this type of roles requires you to work as an ETL Team Lead experienced in: managing at least 5+ individuals, performing code review, working with and reporting to a data governance delivering innovative, complex projects to the client, manage relationships, find new opportunities to grow within an account, and lead a team of developers, QA, and others.

Required Qualifications:

· Expert skill with Informatica development and ability to understand the Informatica landscape including IDQ, IMM, PowerCenter, and MDM (v9.5 and above)

· Expert in performance tuning of Informatica code with a solid understanding of Informatica partitioning and Database partitioning concepts

· Experience in performing Data analyst roles leading ETL teams

· Experience collecting, analyzing and documenting user requirements and closely working with BA on prototyping

· Create and manage Users, Security groups and understand User, System-defined roles

· Work with the Enterprise Data Manager (EDM)

· Work with the Informatica ILM Workbench

· Create application retirement entity in EDM

· Administer File Archiving Service

· Working knowledge on Data governance aspects and operations

· Strong experience in project estimation working with PM

· Operations support with a SOLID understanding of release, incident, and change management

· Strong understanding on QA concepts including Unit testing, regression, and black box

· Experience in building and executing production migration plans

· Strong background with data warehousing background with both Kimball and Inmon models

· Excellent communication, project management, and client facing skills

· Excellent MDM and DQ Architecture skills with a passion of getting hands on design once architected

· Strong understanding of audit process (such as ABC) for any ETL/MDM build

· Lead and guide development of an Informatica based ETL architecture

· Perform an active role in leading and shaping overall ETL Informatica practice

· Ability to work on delivering and leading multiple projects leading multiple teams with a penchant to deliver what is in scope at the right time

Preferred Qualifications:

· At least 10+ years of Informatica platform expertise including Powercenter, MDM, IDQ, Metadata Manager, and Web services Hub (Preferred to have up to v9.7 (although not required)

· At least 5+ years of using Informatica MDM Hub, IDD, and IDQ

· At least 5+ years of installing, configuring and upgrading Informatica MDM, PowerCenter (9.6.x) and other related components (like PowerExchange connectors, IDQ, IDD, Address Doctor etc on Linux/Unix environment

· At least 4+ years of configuring IDD for match/merge rules and UI configuration

· At least 4+ years of developing and configuring profiles, scorecards, and rules using IDQ

· At least 2+ years of using IDQ Address Doctor

· At least 2+ years of supporting pre-sales in SOW, RFP, and RFI, and resource estimation

· Preferred background with at least 5+ years of Healthcare

· At least 2+ years of design experience including Dimensional modeling, Star-Schema Modeling, Snow-flake Modeling, FACT and dimension tables, Logical / Physical designs ,Data Mart, ODS using tools such as ERWIN 4.2/4.0, Oracle Designer, Sybase Power Designer.

· At least 5+ years of working with relational DB’s including Oracle, Teradata, Netezza, and SQL Server

· Unix scripting experience (5+ years)

Preferred Education/Skills:

· Bachelor’s Degree in Computer Science, Information Systems, or other related disciplines

· Bonus of Master’s Degree in Computer Science or similar skillsets