Lead Informatica Administrator

Farm Bureau Financial Services; West Des Moines, Northern (IA, KY); On-site; USD 100,000 - 150,000; Full time

Job summary

Farm Bureau Financial Services is seeking a Lead Technical Administrator to oversee the daily operations of Informatica environments, both on-premises and in the cloud. You’ll ensure optimal performance, availability, and security while supporting staff with technical services and on-call coverage.

The role requires a MIS or CS degree with 7+ years of experience in ETL and enterprise infrastructure. You’ll manage upgrades, migrations, security, and governance, with readiness for some travel and

Qualifications

• College Degree (MIS or computer science) or equivalent plus seven years relevant experience required.
• ETL experience required.
• Must have in-depth skills supporting two or more of the following key enterprise infrastructure technology areas: data networks, application computing platforms, storage area networks, data-base system infrastructures, middleware technologies, security infrastructure technologies, and end user technologies.
• Strong analytical and problem-solving skills, logical information organization skills.
• Must have customer experience orientation, impact and influence, industry awareness, initiative, integrity, and relationship management.
• Must understand the inter-relationship between business and technology needs.
• Ability to conceptualize potential, new, or changed infrastructure solution designs to satisfy changing business requirements. Must have or attain a strong understanding of all entities of the FBL Financial Group.
• Must be able to work independently as well as in a team environment.
• Maintain knowledge and skills current in alignment with industry technology developments.
• On-call responsibility to support infrastructure 24/7.
• Some travel required.
• Ability to work from our office in West Des Moines, Iowa.

Responsibilities

• Install and configure Informatica products, including PowerCenter, Informatica Cloud (IICS), Data Quality (IDQ), MDM, and others, on both on-premises and cloud environments.
• Set up and manage environments for development, testing, and production.
• Monitor system health, performance, and resource utilization.
• Manage Informatica services, including upgrades, patches, and performance tuning.
• Automate administrative tasks such as backups, monitoring, and log management.
• Apply security patches and fixes to ensure the system complies with security standards.
• Manage user access, roles, and privileges in accordance with corporate policies.
• Implement and maintain security policies, including authentication (LDAP/AD) and encryption.
• Handle data security protocols, ensuring data privacy and compliance with regulations (GDPR, HIPAA, etc.).
• Monitor job schedules, log files, and error reports for potential issues.
• Troubleshoot and resolve any system issues, data load failures, or performance bottlenecks.
• Collaborate with support teams, Informatica support, and other vendors as needed to resolve complex issues.
• Accountable for assigned production systems and troubleshoot complex problems to ensure timely resolution.
• Manage and configure Informatica Intelligent Cloud Services (IICS), including data integration, application integration, and API management.
• Ensure the hybrid connectivity between on-premises and cloud platforms is operational and optimized.
• Provide guidance and best practices for cloud data integration, migration, and governance.
• Develop and maintain a robust backup and recovery strategy for Informatica environments.
• Test and verify the integrity of backups regularly.
• Restore systems and data as needed, ensuring minimal downtime.
• Monitor and tune the performance of ETL jobs, data loads, and data processing operations.
• Optimize server performance, memory usage, and system configurations to enhance efficiency.
• Analyze workflows and jobs for bottlenecks and implement performance improvements.
• Work closely with ETL developers, data architects, directors, and other IT teams to ensure seamless data integration processes.
• Provide technical support and training to users and teams working with Informatica platforms.
• Create and maintain documentation of environment configurations, procedures, and troubleshooting guidelines.
• Provide 24-hour on call support for infrastructure to support business service levels.
• Plan and execute upgrades of Informatica products (both on-prem and cloud versions).
• Manage the migration of on-prem Informatica environments to cloud platforms, ensuring data consistency and minimal disruption.
• Ensure compliance with corporate and regulatory requirements regarding data handling, privacy, and security.

Skills

ETL experience

Analytical skills

Team collaboration

Customer orientation

On-call support

Travel flexibility

Education

MIS or Computer Science degree

7+ years relevant experience

Tools

Informatica PowerCenter

Informatica Cloud (IICS)

Informatica IDQ

Informatica MDM

LDAP/AD

Job description

Lead Technical Administrator

Can you be responsible for the daily operations of supporting Informatica environments, both on premises and in the cloud. Do you have experience scheduling services and assisting staff with technical services? If so, this Lead Technical Administrator position could be a fit for you!

Who We Are:

With Farm Bureau Financial Services, our client/members can feel confident knowing their family, home, cars and other property are protected. We value a culture where integrity, teamwork, passion, service, leadership and accountability are at the heart of every decision we make and every action we take. We’re proud of our more than 80-year commitment to protecting the livelihoods and futures of our client/members and creating an atmosphere where our employees thrive.

What You’ll Do:

As a Lead Technical Administrator, you will ensure the platform’s optimal performance, availability, and security. Below is a detailed job description for an Informatica Admin managing both on-premises and cloud platforms:

• Installation & Configuration:
  • Install and configure Informatica products, including PowerCenter, Informatica Cloud (IICS), Data Quality (IDQ), MDM, and others, on both on-premises and cloud environments.
  • Set up and manage environments for development, testing, and production.
• Administration & Maintenance:
  • Monitor system health, performance, and resource utilization.
  • Manage Informatica services, including upgrades, patches, and performance tuning.
  • Automate administrative tasks such as backups, monitoring, and log management.
  • Apply security patches and fixes to ensure the system complies with security standards.
• User & Security Management:
  • Manage user access, roles, and privileges in accordance with corporate policies.
  • Implement and maintain security policies, including authentication (LDAP/AD) and encryption.
  • Handle data security protocols, ensuring data privacy and compliance with regulations (GDPR, HIPAA, etc.).
• Environment Monitoring & Troubleshooting:
  • Monitor job schedules, log files, and error reports for potential issues.
  • Troubleshoot and resolve any system issues, data load failures, or performance bottlenecks.
  • Collaborate with support teams, Informatica support, and other vendors as needed to resolve complex issues.
  • Accountable for assigned production systems and troubleshoot complex problems to ensure timely resolution.
• Cloud Platform Support:
  • Manage and configure Informatica Intelligent Cloud Services (IICS), including data integration, application integration, and API management.
  • Ensure the hybrid connectivity between on-premises and cloud platforms is operational and optimized.
  • Provide guidance and best practices for cloud data integration, migration, and governance.
• Backup & Recovery:
  • Develop and maintain a robust backup and recovery strategy for Informatica environments.
  • Test and verify the integrity of backups regularly.
  • Restore systems and data as needed, ensuring minimal downtime.
• Performance Tuning & Optimization:
  • Monitor and tune the performance of ETL jobs, data loads, and data processing operations.
  • Optimize server performance, memory usage, and system configurations to enhance efficiency.
  • Analyze workflows and jobs for bottlenecks and implement performance improvements.
• Collaboration & Support:
  • Work closely with ETL developers, data architects, directors, and other IT teams to ensure seamless data integration processes.
  • Provide technical support and training to users and teams working with Informatica platforms.
  • Create and maintain documentation of environment configurations, procedures, and troubleshooting guidelines.
  • Provide 24-hour on call support for infrastructure to support business service levels.
• Upgrades & Migration:
  • Plan and execute upgrades of Informatica products (both on-prem and cloud versions).
  • Manage the migration of on-prem Informatica environments to cloud platforms, ensuring data consistency and minimal disruption.
• Compliance & Reporting:
  • Ensure compliance with corporate and regulatory requirements regarding data handling, privacy, and security.

What It Takes to Join Our Team:

• College Degree (MIS or computer science) or equivalent plus seven years relevant experience required. Sr. Technical Administrator experience preferred.
• ETL Experience required.
• Must have in-depth skills supporting two or more of the following key enterprise infrastructure technology areas: data networks, application computing platforms, storage area networks, data-base system infrastructures, middleware technologies, security infrastructure technologies, and end user technologies.
• Strong analytical and problem-solving skills, logical information organization skills.
• Must have customer experience orientation, impact and influence, industry awareness, initiative, integrity, and relationship management.
• Must understand the inter-relationship between business and technology needs.
• Ability to conceptualize potential, new, or changed infrastructure solution designs to satisfy changing business requirements. Must have or attain a strong understanding of all entities of the FBL Financial Group.
• Must be able to work independently as well as in a team environment.
• Maintain knowledge and skills current in alignment with industry technology developments.
• On-call responsibility to support infrastructure 24/7.
• Some travel required.
• Ability to work from our office in West Des Moines, Iowa.

What We Offer You:

When you’re on our team, you get more than a great paycheck. You’ll hear about career development and educational opportunities. We offer an enhanced 401K with a match, low-cost health, dental, and vision benefits, and life and disability insurance options. We also offer paid time off, including holidays and volunteer time, and teams who know how to have fun. Add to that an onsite wellness facility with fitness classes and programs, a cafeteria, and for many positions, even consideration for a hybrid work arrangement. Farm Bureau....where the grass really IS greener!

Work Authorization/Sponsorship:

At this time, we are not considering candidates that need any type of immigration sponsorship now or in the future, such as additional or permanent work authorization. Applicants must be currently authorized to work in the United States on a full-time, permanent basis. We are not able to sponsor now or in the future, or take over sponsorship of, an employment visa or work authorization for this role. For example, we are not considering candidates with OPT status.