Senior Informatica Platform & Data Integration Lead

ASM Research, An Accenture Federal Services Company; Denver (CO); On-site; USD 110,000 - 183,000; Full time

Job summary

ASM Research, an Accenture Federal Services company, seeks an Informatica Administrator to install, configure, monitor, and optimize Informatica tools, ensuring reliability of data workflows for BI and analytics. The role entails CVE remediation, performance tuning, and collaboration with data teams across DEV/QA/PROD environments.

Candidates should have a strong background in PowerCenter, IICS, and Oracle/SQL Server databases, with Linux shell scripting and monitoring experience.

Qualifications

• Bachelor's degree or equivalent; Master’s degree preferred.
• 12+ years of experience with progressively more complex or large-scale databases.
• Dependent upon contract requirement.

Responsibilities

• Install and/or upgrade, and configure Informatica PowerCenter, Informatica Cloud Data Integration, and related components.
• Configure and maintain repository, domain, and services on Informatica server.
• Set up environment-specific configurations (DEV, QA, PROD) for Informatica services.
• Develop remediation steps for CVEs identified by security team and resolve them promptly.
• Monitor and fine-tune the performance of Informatica jobs and workflows.
• Work on optimizing server performance, including memory management, query performance, and job throughput.
• Identify, troubleshoot, and resolve issues related to Informatica sessions, workflows, and connectivity.
• Resolve system-level issues affecting Informatica services and tools.
• Perform regular system monitoring and ensure health and availability of the Informatica environment.
• Set up automated alerts for job failures, service downtimes, or performance issues.
• Evaluate new features and capabilities of Informatica products and propose strategies for leveraging them.
• Stay current with industry trends in data integration, cloud computing, and ETL technologies to influence data architectures.
• Implement and manage backup and disaster recovery procedures for Informatica repositories and configurations.
• Work with data engineers, developers, and IT teams to support data integration requirements.
• Provide support for troubleshooting and resolving Informatica issues.
• Maintain documentation for system configurations, procedures, and workflows.
• Generate reports on system performance and resource utilization.
• Collaborate with data architects to design scalable cloud-based data integration architectures using IICS.
• Evaluate and optimize current PowerCenter architectures for migration feasibility and potential redesigns.
• Align migration strategies with cloud adoption, data governance, and security policies.

Education

Bachelor's degree or equivalent

Master's degree preferred

Tools

Informatica PowerCenter

Informatica Cloud Data Integration

Oracle

SQL Server

PostgreSQL

Informatica Connectors

PowerExchange

S3

S3 Delta

Amazon RedShift

Oracle RAC

Data Guard

UNIX/Linux

Shell scripting

Job description

ASM Research, an Accenture Federal Services company, seeks an Informatica Administrator to install, configure, monitor, and optimize Informatica tools, ensuring reliability of data workflows for BI and analytics. The role entails CVE remediation, performance tuning, and collaboration with data teams across DEV/QA/PROD environments.

Candidates should have a strong background in PowerCenter, IICS, and Oracle/SQL Server databases, with Linux shell scripting and monitoring experience.