Informatica Administrator (IDMC) (On-site- Tallahassee, FL) Locals only

DMS Vision•Frisco, AL

13h•Onsite

About The Position

The Informatica Administrator (IDMC) administers and maintains Informatica IDMC services, including Administrator, Data Integration, Data Quality, Data Profiling, Application Integration, and API Center, supporting platform stability and configuration across projects. The role deploys, configures, upgrades, and monitors Secure Agents on Red Hat Enterprise Linux (RHEL), and manages agent failover, load balancing, secure communications, connections, credentials, and performance tuning. The position supports IDMC asset deployments through CI/CD pipelines, manages SAML-based single sign-on and user access, and coordinates with infrastructure, security, data, development, and business teams. It monitors environment performance, investigates failures and bottlenecks, conducts root-cause analysis, manages scheduling and notifications, and oversees platform metrics and service levels. The role also performs Secure Agent health checks, log rotation, integrations with enterprise tools, patching, and platform support for Cloud Data Integration, Cloud Application Integration, and Cloud Data Quality. The administrator works with data integration and warehousing technologies, including IDMC, Snowflake, relational databases, and Informatica on-premises products. The role includes analyzing transactional data stores, developing data warehouse models and BI reports or dashboards, maintaining warehouse metadata and administration practices, and recommending improvements to performance, automation, and scalability. The posting specifies an on-site role in Tallahassee, Florida, for local candidates, with a duration of 12+ months.

Requirements

At least 7 years of IT work experience using data management tools, business intelligence tools, and data warehousing.
Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
Strong experience with Informatica IDMC tools, including IDMC CDI, MI, and CAI.
Strong experience with ETL or ELT data integration tasks, including extraction, transformation, and loading.
Experience administering the IDMC platform, Secure Agent infrastructure, and Snowflake Data Cloud platform.
Knowledge of relational database platforms including DB2, SQL Server, Snowflake, and Oracle.
Experience with RHEL application administration, including security patching, disk filesystems, and wrapper and startup scripts.
Experience with IDMC connectors for change data capture, including PowerExchange, and connectors such as relational and ServiceNow.
Experience with IBM mainframe COBOL, JCL, and DB2 analysis.
Experience designing data models for BI tools such as Power BI and Cognos.
Development experience with Snowflake Data Cloud.
Experience with Informatica on-premises products, including PowerCenter and Data Quality.
Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration.
Experience with Informatica IDMC Cloud performance tuning and Snowflake Data Cloud performance tuning.
Local to Tallahassee, Florida, for the on-site role.

Nice To Haves

Extensive experience with Informatica PowerCenter and Snowflake.

Responsibilities

Administer and maintain Informatica IDMC services, including Administrator, Data Integration, Data Quality, Data Profiling, Application Integration, and API Center.
Deploy, configure, upgrade, and monitor Informatica Secure Agents on RHEL servers; implement failover and load balancing and manage secure communications.
Use CI/CD pipelines such as Git and Jenkins to deploy mappings, tasks, processes, and other assets across IDMC organizations.
Configure platform connections, secure credentials, and Secure Agent parameters for performance and resource utilization.
Administer SAML-based SSO, user access, roles, and security policies in accordance with organizational standards and data governance requirements.
Coordinate with infrastructure, security, data, development, and business teams on platform operations and pipeline and workflow development and deployment.
Monitor platform performance, troubleshoot failures with development teams, maintain logs, and perform root-cause analysis of errors and bottlenecks.
Manage scheduling, notifications, and platform performance metrics to proactively support SLAs.
Perform Secure Agent health checks, configure log rotation, integrate with enterprise tools, and manage patching using CLI and shell scripting on RHEL.
Provide platform support for Cloud Data Integration, Cloud Application Integration, and Cloud Data Quality, including agent upgrades, patches, and coordination with Informatica support.
Analyze transactional data stores and develop data warehouse models for reporting and analytics.
Develop and maintain methods and practices documentation.
Prototype, build, and test Power BI and Cognos reports and dashboards.
Ensure data warehouse metadata is collected and maintained.
Stay current with Informatica Cloud enhancements and industry practices and recommend improvements to infrastructure performance, automation, and scalability.