Informatica Database Administrator

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

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

ASM Research, An Accenture Federal Services Company