Informatica Administrator (Local to OH)

Sonoma Consulting Inc.; Cincinnati (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

A consulting firm is seeking an experienced Informatica Administrator in Cincinnati, OH. This role involves providing administration support for the Informatica service offering, managing deployments, and ensuring data integrity. Candidates should have 5-10 years of experience with Informatica, solid ETL/database knowledge, and a proactive approach to problem-solving. The position offers opportunities to enhance your technical expertise in data integration technologies.

Qualifications

• 5 to 10+ years of experience with Informatica administration.
• Experience on Informatica high availability and Grid.
• Good understanding of Data Warehouse concepts.

Responsibilities

• Provide extensive administration support for Informatica domains.
• Manage deployments of code in production environments.
• Ensure data integrity and recommend actions for cleanup.

Skills

Project management

Analytical skills

Problem-solving

Scripting (PowerShell, REST, UC4)

Communication skills

Tools

Informatica

Hadoop

Red Hat Enterprise Linux

Job description

Halo Group is a premier provider of IT talent. We place technology experts within the teams of the world’s leading companies to help them build innovative businesses that keep them one step closer to their customers and one step ahead of the competition. We offer a meaningful work environment for employees, attractive and interesting engagements for consultants, and cutting‑edge digital innovation for our customers.

We delight in helping our customers execute their digital vision. Big projects or small, Halo Group knows that by combining the highest quality talent with our unwavering support, we will become an invaluable extension of the team. Halo Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all areas of product/project governance, UX/UI, multi-platform applications, quality assurance/testing, cloud computing, and data analytics.

Since its inception, Halo Group has been recognized for numerous awards, including:

• INC 5000
• Future 50
• 101 Best and Brightest
• Michigan 50 Companies to Watch
• Goldline Research – “Most Dependable Companies”
• Ernst & Young – “Entrepreneur of the Year” Finalist

Job Description

Responsibilities:

• Provide extensive administration support and technical leadership for all aspects of the Power Center, Test Data Management, Data Quality, B2B, DVO, and Big Data Management Informatica domains.
• Requirements gathering and analyze the requirements.
• Analyze the impacts on existing modules for the new enhancements. Serve as part of a highly‑skilled, high‑performing team, providing technical solutions to create valuable extensions and enhancements of our Informatica service offering.
• Manage deployments of code through the non‑production and production/disaster recovery environments.
• Monitor the stability of all environments including product performance and infrastructure utilization.
• Continued growth as a technical expert in data integration technologies and solutions.
• Ensure data integrity; recommend action to maintain data integrity; establish processes/procedures for ongoing data cleanup.
• Manage all backup, restore, and disaster recovery processes and procedures, including understanding how to execute all procedures and meet all related SLA s and/or RTO s.
• Provide security administration support with respect to users and privileges within all Informatica domains.

Qualifications

• 5 to 10+ years of experience with Informatica administration of the Power Center domain.
• 5 years of experience with Informatica administration of connectors, proactive monitoring, metadata manager, and Data Quality.
• Solid understanding of ETL/Database best practices and leading industry standards.
• Good understanding of Data Warehouse concepts and relational databases.
• Experience on Informatica high availability and Informatica Grid.
• Experience on any Data Quality and Data Validation tools.
• Knowledge of Data Integration with Hadoop and Informatica is a plus.
• Experience implementing automation capabilities and knowledge of DevOps methodologies and best practices.
• Comfortable working with the Red Hat Enterprise Linux operating system.
• Experience with scripting (PowerShell, REST, and UC4) for task automation.

Skills

• Persistently drive projects to successful completion.
• Ability to handle multiple tasks and projects simultaneously.
• Ability to manage time and work independently with minimal supervision.
• Ability to work in stressful situations and meet tight deadlines.
• Self‑motivated with the ability to complete objectives without requiring constant managerial oversight.
• Excellent analytical, problem‑solving, and troubleshooting skills.
• Strong verbal and written communication skills.
• Ability to work independently or collaboratively with other team members, peer groups, or business partners.