Informatica Database Administrator

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

The Informatica Administrator is responsible for the installation, configuration, monitoring, maintenance, and optimization of Informatica software tools used for data and application integration, transformation, and management. This role involves troubleshooting issues, ensuring performance, and maintaining data workflows to support business intelligence and analytics.

• 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 appropriate remediation steps for Common Vulnerabilities and Exposures (CVEs) identified by the security team and resolve them in a timely fashion.
• Monitor and fine-tune the performance of Informatica jobs and workflows.
• Work on optimizing the performance of the Informatica server, 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 the 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 the data architecture strategies.
• Implement and manage backup and disaster recovery procedures for Informatica repositories and configurations.
• Work closely with data engineers, developers, and other IT teams to support data integration requirements.
• Provide support for troubleshooting and resolving technical issues related to the Informatica platform.
• Maintain accurate documentation for system configurations, procedures, and workflows.
• Generate reports on system performance, resource utilization, and other metrics.
• Collaborate with data architects to design efficient, scalable cloud-based data integration architectures using IICS.
• Evaluate and optimize current PowerCenter architectures for migration feasibility, including redesigning workflows and processes where necessary.
• Align migration strategies with the organization’s cloud adoption, data governance, and security policies.

Minimum Qualifications

• Bachelor’s Degree required or equivalent relevant experience. Master’s Degree Preferred.
• Dependent upon contract requirement.
• 12+ years of experience working with progressively more complex or large-scale databases.

Other Job Specific Skills

• Strong experience supporting Informatica PowerCenter, IICS, and other Informatica products.
• Hands-on experience with database management systems such as Oracle, SQL Server, or PostgreSQL.
• Hands-on experience with Informatica Connectors such as MySQL, PostgreSQL, JNDI, JMS, PowerExchange, S3, S3 Delta, or Amazon RedShift.
• Experience managing Oracle RAC and Data Guard databases.
• Knowledge of UNIX/Linux commands and shell scripting.
• Experience with system monitoring tools and techniques.
• Proficiency in troubleshooting and resolving Informatica issues.
• Excellent communication and collaboration skills.

Preferred Skills

• Informatica certification (e.g., Informatica PowerCenter Administrator).
• Experience with cloud-based data integration tools e.g., Informatica Intelligent Cloud Services (IICS).
• Familiarity with ETL processes and data warehousing concepts.
• Hands-on experience with Oracle DBA functions in an enterprise environment.

Compensation Ranges

Compensation ranges for ASM Research positions vary depending on multiple factors; including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM’s overall compensation and benefits package for employees.

$120,100 – $183k

EEO Requirements

It is the policy of ASM that an individual’s race, color, religion, sex, disability, age, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.

All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, disability, or age. All decisions on employment are made to abide by the principle of equal employment.

Physical Requirements

The physical requirements described in “Knowledge, Skills and Abilities” above are representative of those which must be met by an employee to successfully perform the primary functions of this job. (For example, “light office duties” or “lifting up to 50 pounds” or “some travel” required.) Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions.

Disclaimer

The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

EEO Requirements

It is the policy of ASM that an individual’s race, color, religion, sex, disability, age, gender identity, veteran status, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.

All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, veteran status, disability, gender identity, or age. All decisions on employment are made to abide by the principle of equal employment.