Informatica Database Administrator

Overview

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 Power Center, 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 Power Center 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.

• 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.

• Strong experience supporting Informatica Power Center, IICS, and other Informatica products.

• Hands-on experience with database management systems such as Oracle, SQL Server, or Postgre
  
  SQL.

• Hands-on experience with Informatica Connectors such as MySQL, Postgre
  
  SQL, JNDI, JMS, Power Exchange, S3, S3 Delta, or Amazon Red Shift.

• 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.

• Informatica certification (e.g., Informatica Power Center 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 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…